[Home] [Help]
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:
5317:
5318:
5319: l_stmt_num :=40;
5320:
5321: INSERT INTO wsm_sm_resulting_lots
5322: (
5323: transaction_id,
5324: lot_number,
5325: inventory_item_id,