DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 876: FROM mtl_transaction_lot_numbers

872: WHERE transaction_set_id = p_set_id;
873:
874: CURSOR mtln(p_set_id NUMBER) IS
875: SELECT *
876: FROM mtl_transaction_lot_numbers
877: WHERE transaction_id IN(SELECT transaction_id
878: FROM mtl_material_transactions
879: WHERE transaction_set_id = p_set_id);
880:

Line 892: FROM mtl_transaction_lot_numbers

888: CURSOR mut2(p_set_id NUMBER) IS
889: SELECT *
890: FROM mtl_unit_transactions
891: WHERE transaction_id IN(SELECT serial_transaction_id
892: FROM mtl_transaction_lot_numbers
893: WHERE transaction_id IN(SELECT transaction_id
894: FROM mtl_material_transactions
895: WHERE transaction_set_id = p_set_id));
896: