eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_RESERVATION_UTIL dependencies on WMS_DISPATCHED_TASKS

Line 2846: FROM wms_dispatched_tasks wdt

2842: OR (mmtt.transaction_source_type_id = 12 AND mmtt.transaction_action_id = 27)
2843: OR (mmtt.transaction_source_type_id = 13 AND mmtt.transaction_action_id = 12)
2844: OR (mmtt.transaction_source_type_id = 4 AND mmtt.transaction_action_id = 27))
2845: AND NOT exists (SELECT 1
2846: FROM wms_dispatched_tasks wdt
2847: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
2848: AND wdt.status IN (3, 4) -- dispached or loaded
2849: AND wdt.task_type = 2 -- putaway
2850: )

Line 2922: FROM wms_dispatched_tasks wdt

2918: INTO l_dummy
2919: FROM dual
2920: WHERE exists
2921: (SELECT 1
2922: FROM wms_dispatched_tasks wdt
2923: , mtl_material_transactions_temp mmtt
2924: WHERE mmtt.move_order_line_id = l_mol_rec.line_id
2925: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
2926: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)