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

Line 1830: FROM mtl_transaction_lot_numbers mtln,

1826: SELECT 1
1827: FROM dual
1828: WHERE EXISTS
1829: (SELECT mtln.transaction_id
1830: FROM mtl_transaction_lot_numbers mtln,
1831: mtl_material_transactions mmt
1832: WHERE mtln.transaction_id = mmt.transaction_id
1833: AND mmt.inventory_item_id = p_item_id
1834: AND mmt.organization_id = p_org_id

Line 1853: mtl_transaction_lot_numbers l

1849: t.opm_costed_flag
1850: FROM gme_batch_header b,
1851: gme_material_details d,
1852: mtl_material_transactions t,
1853: mtl_transaction_lot_numbers l
1854: WHERE t.inventory_item_id = p_item_id
1855: AND t.organization_id = p_org_id
1856: AND T.TRANSACTION_SOURCE_TYPE_ID = 5
1857: AND NOT EXISTS

Line 1897: mtl_transaction_lot_numbers mtln

1893: IS
1894: SELECT SUM(mtln.primary_quantity),
1895: SUM(mtln.secondary_transaction_quantity)
1896: FROM mtl_material_transactions mmt ,
1897: mtl_transaction_lot_numbers mtln
1898: WHERE mmt.transaction_source_id = L_BATCH_ID
1899: AND mmt.transaction_source_type_id = 5
1900: AND NOT EXISTS
1901: (SELECT transaction_id1