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_LICENSE_PLATE_NUMBERS

Line 336: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

332: --get the delivery_id
333: -- After staging and before Truck Load, there might not be any delivery attached to the LPN
334: begin
335: select distinct wda.delivery_id INTO l_delivery_id
336: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
337: wsh_delivery_details wdd2
338: where lpn.outermost_lpn_id = p_lpn_id
339: and wdd2.lpn_id = lpn.lpn_id
340: and wdd2.lpn_id is not null

Line 385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,

381: --check whether all the lines in the delivery are loaded
382: begin
383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
384: ( select wlpn.license_plate_number --distinct wlpn.license_plate_number
385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn
387: where wdd2.delivery_detail_id = wda.parent_delivery_detail_id
388: and wdd.delivery_detail_id = wda.delivery_detail_id
389: and wdd2.lpn_id is not null

Line 386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn

382: begin
383: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
384: ( select wlpn.license_plate_number --distinct wlpn.license_plate_number
385: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wms_license_plate_numbers lpn,
386: wsh_delivery_details wdd2,wms_license_plate_numbers wlpn
387: where wdd2.delivery_detail_id = wda.parent_delivery_detail_id
388: and wdd.delivery_detail_id = wda.delivery_detail_id
389: and wdd2.lpn_id is not null
390: and wdd2.lpn_id = lpn.lpn_id

Line 423: wms_license_plate_numbers lpn,

419: SELECT -1 INTO x_is_last_lpn FROM dual WHERE exists
420: (
421: select wlpn.license_plate_number --distinct wlpn.license_plate_number
422: from
423: wms_license_plate_numbers lpn,
424: wms_license_plate_numbers wlpn,
425: wsh_new_deliveries wnd,
426: wsh_delivery_legs wdl,
427: wsh_delivery_details wdd,

Line 424: wms_license_plate_numbers wlpn,

420: (
421: select wlpn.license_plate_number --distinct wlpn.license_plate_number
422: from
423: wms_license_plate_numbers lpn,
424: wms_license_plate_numbers wlpn,
425: wsh_new_deliveries wnd,
426: wsh_delivery_legs wdl,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,

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 1905: FROM wms_license_plate_numbers wlpn,

1901:
1902: BEGIN
1903: SELECT wlpn.lpn_id,wlpn.lpn_context,outermost_lpn_id INTO
1904: x_pallet_lpn_id,x_pallet_lpn_context,l_outermost_lpn_id
1905: FROM wms_license_plate_numbers wlpn,
1906: wms_epc we
1907: WHERE we.lpn_id = wlpn.lpn_id
1908: AND we.cross_ref_type =1 --LPN-EPC type
1909: AND we.epc = x_tag_info(1).tag_id

Line 1938: FROM wms_license_plate_numbers wlpn

1934:
1935: BEGIN
1936: SELECT wlpn.lpn_id,wlpn.lpn_context,wlpn.outermost_lpn_id INTO
1937: x_pallet_lpn_id,x_pallet_lpn_context,l_outermost_lpn_id
1938: FROM wms_license_plate_numbers wlpn
1939: WHERE wlpn.license_plate_number = x_tag_info(1).tag_id
1940: AND ((wlpn.parent_lpn_id = wlpn.outermost_lpn_id AND wlpn.parent_lpn_id IS NOT null) OR
1941: ( wlpn.parent_lpn_id IS NULL AND wlpn.lpn_id = wlpn.outermost_lpn_id ));
1942:

Line 2076: FROM wms_license_plate_numbers wlpn

2072: -- This will match only for pallets and cases
2073:
2074: SELECT wlpn.parent_lpn_id, wlpn.LPN_CONTEXT INTO
2075: l_parent_lpn_id,l_PALLET_LPN_CONTEXT
2076: FROM wms_license_plate_numbers wlpn
2077: WHERE wlpn.lpn_id = L_LPN_ID
2078: AND ((wlpn.parent_lpn_id = wlpn.outermost_lpn_id AND
2079: wlpn.parent_lpn_id IS NOT null)
2080: OR

Line 2145: WMS_LICENSE_PLATE_NUMBERS wlpn

2141: BEGIN
2142: select MSN.LPN_ID,WLPN.outermost_LPN_ID
2143: INTO l_lpn_id, l_serial_pallet_id
2144: from mtl_serial_numbers MSN,
2145: WMS_LICENSE_PLATE_NUMBERS wlpn
2146: WHERE MSN.inventory_item_id = l_item_id
2147: AND MSN.serial_number = l_SERIAL_NUMBER
2148: AND MSN.lpn_id = WLPN.LPN_ID;
2149: EXCEPTION

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

Line 2554: FROM wms_license_plate_numbers wlpn

2550: trace('l_load_verify_threshold :'||l_load_verify_threshold);
2551: END IF;
2552:
2553: SELECT COUNT(1) INTO l_expected_case_cnt
2554: FROM wms_license_plate_numbers wlpn
2555: WHERE parent_lpn_id = p_pallet_lpn_id
2556: AND wlpn.parent_lpn_id = wlpn.outermost_lpn_id
2557: AND wlpn.parent_lpn_id IS NOT NULL;
2558:

Line 2561: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn

2557: AND wlpn.parent_lpn_id IS NOT NULL;
2558:
2559:
2560: SELECT COUNT(1) INTO l_expected_ser_cnt
2561: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn
2562: WHERE msn.lpn_id = wlpn.lpn_id
2563: and wlpn.outermost_lpn_id = p_pallet_lpn_id;
2564:
2565: IF (l_debug = 1) THEN

Line 3283: rcv_shipment_headers rsh ,wms_license_plate_numbers wlpn where wlpn.lpn_id = l_lpn_id

3279: --receiving
3280: l_progress := '40';
3281: BEGIN
3282: select rsh.shipment_header_id into l_shipment_header_id from
3283: rcv_shipment_headers rsh ,wms_license_plate_numbers wlpn where wlpn.lpn_id = l_lpn_id
3284: and wlpn.lpn_context IN (6,7) --for ASN 7, blocked for ASN in patch set J
3285: and (rsh.shipment_num = Nvl(wlpn.source_name,'@#$@')
3286: or rsh.shipment_header_id = Nvl(wlpn.source_header_id, -1));
3287: