DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_PVT dependencies on WMS_DISPATCHED_TASKS

Line 5101: FROM wms_dispatched_tasks wdt

5097: INTO l_loaded
5098: FROM dual
5099: WHERE exists
5100: (SELECT 1
5101: FROM wms_dispatched_tasks wdt
5102: , mtl_material_transactions_temp mmtt
5103: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5104: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5105: AND wdt.status IN (3, 4) -- dispached or loaded

Line 5507: FROM wms_dispatched_tasks wdt

5503: INTO l_loaded
5504: FROM dual
5505: WHERE exists
5506: (SELECT 1
5507: FROM wms_dispatched_tasks wdt
5508: , mtl_material_transactions_temp mmtt
5509: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
5510: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
5511: AND wdt.status IN (3, 4) -- dispached or loaded

Line 7338: FROM wms_dispatched_tasks wdt

7334: INTO l_loaded
7335: FROM dual
7336: WHERE exists
7337: (SELECT 1
7338: FROM wms_dispatched_tasks wdt
7339: , mtl_material_transactions_temp mmtt
7340: WHERE mmtt.move_order_line_id = l_transfer_mol_rec.line_id
7341: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
7342: AND wdt.status IN (3, 4) -- dispached or loaded

Line 29183: WMS_DISPATCHED_TASKS WDT,

29179: IS
29180: SELECT
29181: 1
29182: FROM
29183: WMS_DISPATCHED_TASKS WDT,
29184: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
29185: WHERE
29186: NVL(MMTT.content_lpn_id, MMTT.lpn_id) = p_lpn_id
29187: AND MMTT.transaction_temp_id = WDT.transaction_temp_id