DBA Data[Home] [Help]

APPS.WMS_TASK_UTILS_PVT dependencies on MTL_UNIT_TRANSACTIONS

Line 883: FROM mtl_unit_transactions

879: WHERE transaction_set_id = p_set_id);
880:
881: CURSOR mut1(p_set_id NUMBER) IS
882: SELECT *
883: FROM mtl_unit_transactions
884: WHERE transaction_id IN(SELECT transaction_id
885: FROM mtl_material_transactions
886: WHERE transaction_set_id = p_set_id);
887:

Line 890: FROM mtl_unit_transactions

886: WHERE transaction_set_id = p_set_id);
887:
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