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_UI_PROJECT_LOVS dependencies on WMS_LPN_CONTENTS

Line 257: FROM wms_lpn_contents wlc

253: AND rsl.shipment_header_id = p_shipment_header_id
254: AND ( (p_lpn_id IS NULL) OR
255: (p_lpn_id IS NOT NULL AND EXISTS
256: ( SELECT wlc.inventory_item_id
257: FROM wms_lpn_contents wlc
258: WHERE wlc.inventory_item_id = rsl.item_id
259: AND wlc.parent_lpn_id IN
260: ( SELECT lpn_id
261: FROM wms_license_plate_numbers

Line 285: FROM wms_lpn_contents wlc

281: AND rsl.shipment_header_id = p_shipment_header_id
282: AND ( (p_lpn_id IS NULL) OR
283: (p_lpn_id IS NOT NULL AND EXISTS
284: ( SELECT wlc.inventory_item_id
285: FROM wms_lpn_contents wlc
286: WHERE wlc.inventory_item_id = rsl.item_id
287: AND wlc.parent_lpn_id IN
288: ( SELECT lpn_id
289: FROM wms_license_plate_numbers

Line 310: FROM wms_lpn_contents wlc

306: AND rsl.shipment_header_id = p_shipment_header_id
307: AND ( (p_lpn_id IS NULL) OR
308: (p_lpn_id IS NOT NULL AND EXISTS
309: ( SELECT wlc.inventory_item_id
310: FROM wms_lpn_contents wlc
311: WHERE wlc.inventory_item_id = rsl.item_id
312: AND wlc.parent_lpn_id IN
313: ( SELECT lpn_id
314: FROM wms_license_plate_numbers

Line 365: FROM wms_lpn_contents wlc

361: OR prl.item_id = p_item_id )
362: AND ( (p_lpn_id IS NULL) OR
363: (p_lpn_id IS NOT NULL AND EXISTS
364: ( SELECT wlc.inventory_item_id
365: FROM wms_lpn_contents wlc
366: WHERE wlc.inventory_item_id = prl.item_id
367: AND wlc.parent_lpn_id IN
368: ( SELECT lpn_id
369: FROM wms_license_plate_numbers

Line 394: FROM wms_lpn_contents wlc

390: OR prl.item_id = p_item_id )
391: AND ( (p_lpn_id IS NULL) OR
392: (p_lpn_id IS NOT NULL AND EXISTS
393: ( SELECT wlc.inventory_item_id
394: FROM wms_lpn_contents wlc
395: WHERE wlc.inventory_item_id = prl.item_id
396: AND wlc.parent_lpn_id IN
397: ( SELECT lpn_id
398: FROM wms_license_plate_numbers

Line 420: FROM wms_lpn_contents wlc

416: OR prl.item_id = p_item_id )
417: AND ( (p_lpn_id IS NULL) OR
418: (p_lpn_id IS NOT NULL AND EXISTS
419: ( SELECT wlc.inventory_item_id
420: FROM wms_lpn_contents wlc
421: WHERE wlc.inventory_item_id = prl.item_id
422: AND wlc.parent_lpn_id IN
423: ( SELECT lpn_id
424: FROM wms_license_plate_numbers