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 3052: FROM wms_dispatched_tasks wdt

3048: OR (mmtt.transaction_source_type_id = 12 AND mmtt.transaction_action_id = 27)
3049: OR (mmtt.transaction_source_type_id = 13 AND mmtt.transaction_action_id = 12)
3050: OR (mmtt.transaction_source_type_id = 4 AND mmtt.transaction_action_id = 27))
3051: AND NOT exists (SELECT 1
3052: FROM wms_dispatched_tasks wdt
3053: WHERE wdt.transaction_temp_id = mmtt.transaction_temp_id
3054: AND wdt.status IN (3, 4) -- dispached or loaded
3055: AND wdt.task_type = 2 -- putaway
3056: )

Line 3128: FROM wms_dispatched_tasks wdt

3124: INTO l_dummy
3125: FROM dual
3126: WHERE exists
3127: (SELECT 1
3128: FROM wms_dispatched_tasks wdt
3129: , mtl_material_transactions_temp mmtt
3130: WHERE mmtt.move_order_line_id = l_mol_rec.line_id
3131: AND ((transaction_source_type_id = 1 AND transaction_action_id = 27)
3132: OR (transaction_source_type_id = 7 AND transaction_action_id = 12)