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

Line 807: , mtl_material_transactions_temp b

803: BEGIN
804: SELECT 1
805: INTO l_exists
806: FROM mtl_transaction_lots_temp a
807: , mtl_material_transactions_temp b
808: WHERE b.inventory_item_id = p_item_id
809: AND a.lot_number = p_lot_number
810: AND a.transaction_temp_id = b.transaction_temp_id
811: AND rownum = 1

Line 818: FROM mtl_material_transactions_temp mtl

814: WHEN no_data_found THEN
815: BEGIN
816: SELECT 1
817: INTO l_exists
818: FROM mtl_material_transactions_temp mtl
819: WHERE mtl.inventory_item_id <> p_item_id
820: AND mtl.lot_number = p_lot_number
821: AND mtl.organization_id = p_org_id
822: AND rownum = 1;