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

Line 848: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi

844: --"Serials at SO issue
845: begin
846: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists
847: (SELECT wlpn.lpn_id
848: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi
849: WHERE wlpn.lpn_id = wlc.parent_lpn_id
850: AND msi.inventory_item_id = wlc.inventory_item_id
851: AND msi.organization_id = wlc.organization_id
852: and wlc.organization_id = p_org_id

Line 1168: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi

1164: --"Serials at SO issue
1165: begin
1166: SELECT 1 INTO l_serial_at_issue FROM dual WHERE exists
1167: (SELECT wlpn.lpn_id
1168: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn, mtl_system_items msi
1169: WHERE wlpn.lpn_id = wlc.parent_lpn_id
1170: AND msi.inventory_item_id = wlc.inventory_item_id
1171: AND msi.organization_id = wlc.organization_id
1172: and wlc.organization_id = p_org_id

Line 2394: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

2390: --See if the PALLET lpn has single item
2391: BEGIN
2392: SELECT SUM(WLC.primary_quantity),wlc.inventory_item_id
2393: INTO l_total_lpn_qty, l_lpn_item_id
2394: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
2395: WHERE wlpn.outermost_lpn_id = p_pallet_lpn_id
2396: AND wlpn.lpn_id = wlc.parent_lpn_id
2397: --AND wlc.organization_id = p_org_id
2398: AND wlc.organization_id = wlpn.organization_id