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 2447: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc

2443: SELECT mln.lot_number
2444: , mln.description
2445: , mln.expiration_date
2446: , mmst.status_code
2447: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2448: WHERE wlpn.license_plate_number = p_lpn
2449: AND wlc.parent_lpn_id = wlpn.lpn_id
2450: AND mln.lot_number = wlc.lot_number
2451: AND mln.organization_id = p_organization_id

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

2493: SELECT mln.lot_number
2494: , mln.description
2495: , mln.expiration_date
2496: , mmst.status_code
2497: FROM mtl_lot_numbers mln, mtl_material_statuses_tl mmst , wms_license_plate_numbers wlpn , wms_lpn_contents wlc
2498: WHERE wlpn.license_plate_number = p_lpn
2499: AND wlc.parent_lpn_id = wlpn.lpn_id
2500: AND mln.lot_number = wlc.lot_number
2501: AND mln.organization_id = p_organization_id