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

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

Line 1939: FROM wms_license_plate_numbers wlpn

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

Line 2077: FROM wms_license_plate_numbers wlpn

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

Line 2146: WMS_LICENSE_PLATE_NUMBERS wlpn

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

Line 2395: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

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

Line 2555: FROM wms_license_plate_numbers wlpn

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

Line 2562: FROM mtl_serial_numbers msn, wms_license_plate_numbers wlpn

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

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

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