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_INV_LOVS dependencies on MTL_MATERIAL_STATUSES_B

Line 2189: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl

2185: SELECT DISTINCT mln.lot_number
2186: , mln.description
2187: , mln.expiration_date
2188: , mstl.status_code
2189: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl
2190: WHERE wlpnc.parent_lpn_id = p_lpn_id
2191: AND wlpnc.organization_id = p_org_id
2192: AND wlpnc.inventory_item_id = p_item_id
2193: AND ((wlpnc.revision = p_revision