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_MATERIAL_STATUS_GRP dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 2342: FROM mtl_transaction_lot_numbers mtln,

2338:
2339: select X.status_id
2340: into l_default_status_id from
2341: (SELECT mtln.transaction_id, mtln.status_id
2342: FROM mtl_transaction_lot_numbers mtln,
2343: mtl_material_transactions mmt,
2344: rcv_shipment_lines rsl
2345: WHERE mmt.transaction_id = mtln.transaction_id
2346: AND mtln.inventory_item_id = p_inventory_item_id

Line 2388: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

2384:
2385: select X.status_id
2386: into l_default_status_id from
2387: (SELECT mtln.transaction_id, mtln.status_id
2388: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
2389: WHERE mmt.transaction_id = mtln.transaction_id
2390: AND mtln.inventory_item_id = p_inventory_item_id
2391: AND mtln.organization_id = p_organization_id
2392: AND mtln.transaction_source_id = p_txn_source_id