DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_DISPATCHED_TASKS

Line 5012: FROM wms_dispatched_tasks wdt

5008: INTO l_loaded
5009: FROM dual
5010: WHERE exists
5011: (SELECT 1
5012: FROM wms_dispatched_tasks wdt
5013: , mtl_material_transactions_temp mmtt
5014: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5015: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5016: AND wdt.status IN (3, 4) -- dispached or loaded

Line 5413: FROM wms_dispatched_tasks wdt

5409: INTO l_loaded
5410: FROM dual
5411: WHERE exists
5412: (SELECT 1
5413: FROM wms_dispatched_tasks wdt
5414: , mtl_material_transactions_temp mmtt
5415: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5416: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5417: AND wdt.status IN (3, 4) -- dispached or loaded

Line 7160: FROM wms_dispatched_tasks wdt

7156: INTO l_loaded
7157: FROM dual
7158: WHERE exists
7159: (SELECT 1
7160: FROM wms_dispatched_tasks wdt
7161: , mtl_material_transactions_temp mmtt
7162: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
7163: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
7164: AND wdt.status IN (3, 4) -- dispached or loaded