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_MO_ADMIN_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 527: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

523: IF ( l_wms_org_flag ) THEN
524: Begin
525: select 1
526: into l_loaded_lpn_exists
527: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
528: where mmtt.transaction_temp_id = wdt.transaction_temp_id
529: and wdt.status = 4
530: and mmtt.transfer_lpn_id is not null
531: and mmtt.move_order_line_id = l_line_id

Line 740: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

736:
737: BEGIN
738: select 1
739: into l_loaded_lpn_exists
740: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
741: where mmtt.transaction_temp_id = wdt.transaction_temp_id
742: and wdt.status = 4
743: and mmtt.transfer_lpn_id is not null
744: and mmtt.move_order_line_id = l_line_id

Line 767: Delete MTL_MATERIAL_TRANSACTIONS_TEMP

763: where line_id = l_line_id;
764:
765: else /*bug fix3524130 ends*/
766: Begin
767: Delete MTL_MATERIAL_TRANSACTIONS_TEMP
768: Where
769: Move_Order_Line_Id = l_line_id;
770: Exception
771: when NO_DATA_FOUND then