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 703: from wms_lpn_contents wlc

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

Line 805: from wms_lpn_contents wlc

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

Line 833: from wms_lpn_contents wlc

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

Line 863: from wms_lpn_contents wlc

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