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 WMS_LICENSE_PLATE_NUMBERS

Line 2411: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc

2407: SELECT mln.lot_number
2408: , mln.description
2409: , mln.expiration_date
2410: , mmst.status_code
2411: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2412: WHERE wlpn.license_plate_number = p_lpn
2413: AND wlc.parent_lpn_id = wlpn.lpn_id
2414: AND mln.lot_number = wlc.lot_number
2415: AND mln.organization_id = p_organization_id

Line 2455: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc

2451: SELECT mln.lot_number
2452: , mln.description
2453: , mln.expiration_date
2454: , mmst.status_code
2455: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2456: WHERE wlpn.license_plate_number = p_lpn
2457: AND wlc.parent_lpn_id = wlpn.lpn_id
2458: AND mln.lot_number = wlc.lot_number
2459: AND mln.organization_id = p_organization_id