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_EPC_PVT dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 156: FROM wms_license_plate_numbers wlpn

152:
153: BEGIN
154: SELECT wlpn.parent_lpn_id, wlpn.outermost_lpn_id
155: INTO l_parent_lpn_id, l_outermost_lpn_id
156: FROM wms_license_plate_numbers wlpn
157: WHERE wlpn.lpn_id = p_lpn_id;
158:
159: EXCEPTION
160: WHEN no_data_found THEN

Line 177: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

173: BEGIN
174:
175: SELECT DISTINCT wlc.inventory_item_id,wlc.uom_code,wlc.revision,1
176: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard
177: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
178: WHERE wlpn.outermost_lpn_id = p_lpn_id
179: AND wlpn.lpn_id = wlc.parent_lpn_id
180: AND wlc.organization_id = wlpn.organization_id;
181:

Line 246: from wms_license_plate_numbers wlpn

242: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard
243: from WMS_LPN_CONTENTS WLC
244: where WLC.parent_lpn_id in (
245: select wlpn.lpn_id
246: from wms_license_plate_numbers wlpn
247: WHERE WLPN.PARENT_LPN_ID is NOT NULL
248: START WITH LPN_ID = p_lpn_id
249: CONNECT BY WLPN.PARENT_LPN_ID = PRIOR LPN_ID)
250: GROUP BY WLC.inventory_item_id,wlc.uom_code,wlc.revision;

Line 664: wms_license_plate_numbers wlpn

660: BEGIN
661: SELECT DISTINCT mmtt.inventory_item_id, SUM(mmtt.primary_quantity), mmtt.revision
662: INTO l_lpn_item_id,l_total_qty,l_rev
663: FROM mtl_material_transactions_temp mmtt,
664: wms_license_plate_numbers wlpn
665: WHERE Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id) = p_lpn_id
666: AND mmtt.organization_id = p_org_id
667: AND wlpn.lpn_id = Nvl(mmtt.transfer_lpn_id,mmtt.content_lpn_id)
668: AND wlpn.lpn_context = wms_container_pub.LPN_CONTEXT_PACKING

Line 761: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

757: SELECT SUM(wlc.primary_quantity),wlc.inventory_item_id,wlc.uom_code,wlc.revision --UOM CODE TO AVOID FUTURE
758: --support OF HAVING multiple lines FOR same lpn based ON ui UOM
759: --IT SHOULD FAIL TO USE GTIN FOR EPC GENERATION FOR MULTIPLE GTIN IN LPN
760: INTO l_total_qty, l_lpn_item_id, l_uom_code,L_rev
761: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
762: WHERE wlpn.outermost_lpn_id = p_lpn_id
763: AND wlpn.lpn_id = wlc.parent_lpn_id
764: AND wlc.organization_id = p_org_id
765: AND wlc.organization_id = wlpn.organization_id

Line 807: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2

803:
804:
805: SELECT SUM(wlc.primary_quantity),wlc.inventory_item_id,wlc.uom_code,wlc.revision
806: INTO l_total_qty,l_lpn_item_id,l_uom_code,l_rev
807: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn1, wms_license_plate_numbers wlpn2
808: WHERE wlpn1.lpn_id = p_lpn_id
809: and wlpn1.parent_lpn_id = wlpn2.outermost_lpn_id
810: AND wlpn2.lpn_id = wlc.parent_lpn_id
811: AND wlpn2.lpn_id <> wlpn1.parent_lpn_id --to avoid content of Pallet

Line 868: FROM wms_license_plate_numbers wlpn,

864:
865: BEGIN
866: SELECT DISTINCT wlc.inventory_item_id, SUM(wlc.primary_quantity),wlc.uom_code,wlc.revision
867: INTO l_lpn_item_id,l_total_qty,l_uom_code,l_rev
868: FROM wms_license_plate_numbers wlpn,
869: wms_lpn_contents wlc
870: WHERE wlc.parent_lpn_id = p_lpn_id
871: AND wlc.organization_id = p_org_id
872: AND wlpn.lpn_id = wlc.parent_lpn_id

Line 924: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn

920: SELECT SUM(wlc.primary_quantity),wlc.inventory_item_id,wlc.uom_code,wlc.revision --UOM CODE TO AVOID FUTURE
921: --support OF HAVING multiple lines FOR same lpn based ON ui UOM
922: --IT SHOULD FAIL TO USE GTIN FOR EPC GENERATION FOR MULTIPLE GTIN IN LPN
923: INTO l_total_qty, l_lpn_item_id, l_uom_code,L_rev
924: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
925: WHERE wlpn.outermost_lpn_id = p_lpn_id
926: AND wlpn.lpn_id = wlc.parent_lpn_id
927: AND wlc.organization_id = p_org_id
928: AND wlc.organization_id = wlpn.organization_id

Line 969: from wms_license_plate_numbers wlpn

965: INTO l_total_qty, l_lpn_item_id, l_uom_code,l_rev
966: from WMS_LPN_CONTENTS WLC
967: where WLC.parent_lpn_id in (
968: select wlpn.lpn_id
969: from wms_license_plate_numbers wlpn
970: where WLPN.PARENT_LPN_ID is NOT NULL
971: START WITH LPN_ID = p_lpn_id
972: CONNECT BY WLPN.PARENT_LPN_ID = PRIOR LPN_ID)
973: GROUP BY WLC.inventory_item_id,wlc.uom_code,wlc.revision;

Line 1283: SELECT license_plate_number INTO l_sscc FROM wms_license_plate_numbers

1279: END IF;
1280:
1281: --See if SSCC can be used
1282: --make sure numeric only
1283: SELECT license_plate_number INTO l_sscc FROM wms_license_plate_numbers
1284: WHERE lpn_id = p_lpn_id
1285: AND organization_id = p_org_id;
1286:
1287: BEGIN

Line 2384: FROM wms_license_plate_numbers wlpn, wms_epc we

2380:
2381: BEGIN
2382: SELECT wlpn.parent_lpn_id, wlpn.outermost_lpn_id, we.epc
2383: INTO l_parent_lpn_id, l_outermost_lpn_id, l_epc
2384: FROM wms_license_plate_numbers wlpn, wms_epc we
2385: WHERE wlpn.lpn_id = l_lpn_id
2386: AND wlpn.lpn_id = we.lpn_id(+)
2387: AND ((we.epc is NOT NULL and Nvl(we.cross_ref_type,1) = 1)
2388: or (we.epc is NULL )) ;