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.GMD_DISP_PUB dependencies on WMS_LPN_CONTENTS

Line 249: wms_lpn_contents wlc

245:
246: CURSOR c_item_lpn_id IS
247: SELECT distinct wlpn.lpn_id, wlpn.license_plate_number
248: FROM wms_license_plate_numbers wlpn,
249: wms_lpn_contents wlc
250: WHERE wlpn.lpn_id = wlc.parent_lpn_id
251: AND wlpn.organization_id = p_organization_id
252: AND wlpn.parent_lpn_id is null
253: AND wlc.inventory_item_id = p_inventory_item_id

Line 260: wms_lpn_contents wlc

256:
257: CURSOR c_item_lpn IS
258: SELECT distinct wlpn.lpn_id, wlpn.license_plate_number
259: FROM wms_license_plate_numbers wlpn,
260: wms_lpn_contents wlc
261: WHERE wlpn.lpn_id = wlc.parent_lpn_id
262: AND wlpn.organization_id = p_organization_id
263: AND wlpn.parent_lpn_id is null
264: AND wlc.inventory_item_id = p_inventory_item_id