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 MTL_SYSTEM_ITEMS

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