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 2159: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl

2155: SELECT DISTINCT mln.lot_number
2156: , mln.description
2157: , mln.expiration_date
2158: , mstl.status_code
2159: FROM mtl_lot_numbers mln, wms_lpn_contents wlpnc, mtl_material_statuses_b mstb, mtl_material_statuses_tl mstl
2160: WHERE wlpnc.parent_lpn_id = p_lpn_id
2161: AND wlpnc.organization_id = p_org_id
2162: AND wlpnc.inventory_item_id = p_item_id
2163: AND ((wlpnc.revision = p_revision