DBA Data[Home] [Help]

APPS.WSMPINVL dependencies on WSM_SM_RESULTING_LOTS

Line 849: wsm_sm_resulting_lots wsrl

845: wsrl.lot_number parent_lot_number,
846: wsrl.inventory_item_id parent_inventory_item_id,
847: wsrl.organization_id parent_organization_id
848: FROM wsm_sm_starting_lots wssl,
849: wsm_sm_resulting_lots wsrl
850: WHERE wssl.transaction_id = wsrl.transaction_id --p_transaction_id
851: -- To avoid MERGE JOIN CARTESIAN
852: AND wsrl.transaction_id = p_transaction_id;
853:

Line 5153: INSERT INTO wsm_sm_resulting_lots

5149:
5150:
5151: l_stmt_num :=40;
5152:
5153: INSERT INTO wsm_sm_resulting_lots
5154: (
5155: transaction_id,
5156: lot_number,
5157: inventory_item_id,