DBA Data[Home] [Help]

APPS.PJM_UNIT_EFF dependencies on MTL_UNIT_TRANSACTIONS

Line 953: FROM mtl_unit_transactions

949: SET end_item_unit_number =
950: DECODE(L_direction, 1, L_unit_number, NULL)
951: WHERE (inventory_item_id, serial_number) in (
952: SELECT inventory_item_id, serial_number
953: FROM mtl_unit_transactions
954: WHERE transaction_id = X_transaction_id
955: UNION ALL /*Bug 7207502 (FP of 6391634): Added union part to select serial when assembly is lot serial controlled.*/
956: SELECT mut.inventory_item_id, mut.serial_number
957: FROM mtl_transaction_lot_numbers mtln, mtl_unit_transactions mut

Line 957: FROM mtl_transaction_lot_numbers mtln, mtl_unit_transactions mut

953: FROM mtl_unit_transactions
954: WHERE transaction_id = X_transaction_id
955: UNION ALL /*Bug 7207502 (FP of 6391634): Added union part to select serial when assembly is lot serial controlled.*/
956: SELECT mut.inventory_item_id, mut.serial_number
957: FROM mtl_transaction_lot_numbers mtln, mtl_unit_transactions mut
958: WHERE mtln.transaction_id = X_transaction_id
959: AND mtln.serial_transaction_id = mut.transaction_id
960: );
961: