Express Move - Component Lot Selection

This client extension provides the ability to derive the component lot number when using the Express Transact Components page during a move transaction. If the program does not return a value, the logic derives the lot number.

A PL/SQL package: WIP_WS_CUSTOM, contains the custom programming instructions invoked.

Procedure: LOT_HOOK

Parameter IN/OUT Type Description
org_id IN NUMBER Identification of the organization.
wip_entity_id IN NUMBER WIP entity identification of the job.
operation_seq_num IN NUMBER Operation sequence number of the operation.
repetitive_schedule_id IN NUMBER Identification of the repetitive schedule.
inventory_item_id IN NUMBER Identification of the component.
supply_subinv IN VARCHAR2 Supply subinventory.
supply_locator_id IN NUMBER Supply locator.
revision IN VARCHAR2 Revision of the assembly.
primary_qty IN NUMBER Quantity moved.
lot_number IN OUT VARCHAR2 Lot number derived by the program.
return_status OUT VARCHAR2 Value indicating performance status, choices are:
  • E: Error

  • S: Success

return_message OUT VARCHAR2 Error string the program returns.

Related Topics