APPS.WMS_EPC_PVT dependencies on WMS_LPN_CONTENTS

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 243: from WMS_LPN_CONTENTS WLC

239: --CASE label. so CASE might have nested lpns within it.
240:
241: select wlc.inventory_item_id,wlc.uom_code,wlc.revision,1
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

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 869: wms_lpn_contents wlc

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
873: AND wlpn.LPN_CONTEXT = wms_container_pub.LPN_CONTEXT_WIP

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 966: from WMS_LPN_CONTENTS WLC

962: --tested in logutr12 with case lpn_id=25341 (LPN2148A) --SOLUTION OF BUG 4355961
963:
964: select sum(wlc.primary_quantity), wlc.inventory_item_id,wlc.uom_code, WLC.revision
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