APPS.WMS_PARAMETER_EXT dependencies on WMS_LPN_CONTENTS

Line 576: from wms_lpn_contents wlc

572:
573: -- @@@ Get the records in WLC in the prim uom of the item.
574: cursor c_get_wlc_quantity is
575: select sum(wlc.quantity) summed_quantity, uom_code
576: from wms_lpn_contents wlc
577: where wlc.parent_lpn_id = p_lpn_id
578: and wlc.inventory_item_id = p_inventory_item_id
579: and wlc.organization_id = p_organization_id
580: and nvl(wlc.revision, '@@@') = nvl(p_revision, nvl(wlc.revision, '@@@'))

Line 701: from wms_lpn_contents wlc

697:
698: -- @@@ Check to see if the record in WLC is in the prim uom of the item.
699: cursor c_get_wlc_quantity is
700: select sum(wlc.quantity) summed_quantity, uom_code
701: from wms_lpn_contents wlc
702: where wlc.parent_lpn_id = p_lpn_id
703: and wlc.inventory_item_id = p_inventory_item_id
704: and wlc.organization_id = p_organization_id
705: group by uom_code;

Line 803: from wms_lpn_contents wlc

799: end if;
800:
801: select count(distinct(wlc.inventory_item_id))
802: into l_return_value
803: from wms_lpn_contents wlc
804: where wlc.parent_lpn_id = p_lpn_id
805: and wlc.organization_id = p_organization_id;
806:
807: return l_return_value;

Line 831: from wms_lpn_contents wlc

827: end if;
828:
829: select count(distinct(wlc.revision))
830: into l_return_value
831: from wms_lpn_contents wlc
832: where wlc.parent_lpn_id = p_lpn_id
833: and wlc.inventory_item_id = p_inventory_item_id
834: and wlc.organization_id = p_organization_id;
835:

Line 861: from wms_lpn_contents wlc

857: end if;
858:
859: select count(distinct(wlc.lot_number))
860: into l_return_value
861: from wms_lpn_contents wlc
862: where wlc.parent_lpn_id = p_lpn_id
863: and wlc.inventory_item_id = p_inventory_item_id
864: and wlc.organization_id = p_organization_id;
865: