Results for “purchasing_unit_of_measure”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
CHV_CUM_ITEMS_V is an APPS-owned database view in Oracle E-Business Suite, belonging to the CHV – Supplier Scheduling product family. Its name reflects its function: it consolidates cumulative (CUM) period information for items that participate in supplier scheduling arrangements, joining each cumulative period record to the item it covers, the vendor and vendor site associated with the approved supplier list entry for that item, and the inventory organization in which the period is tracked. This view therefore exposes a single denormalized result set describing "who supplies which item, to which organization, over which CUM period window."
The object is catalogued as VALID in both ETRM 12.1.1 and 12.2.2, and its documentation is marked "Retrofitted," indicating it was reconstructed into the ETRM documentation set rather than authored natively. It is a reporting and integration surface: supplier scheduling and CUM management processes, plus downstream extracts feeding supplier portals or planning systems, read from it instead of reimplementing the multi-table join logic themselves.
Underlying Base Objects
The view definition joins six primary objects in the FROM clause, with one additional object referenced in the WHERE clause. The core driver is CHV_CUM_PERIODS (accessed via synonym), which supplies the cumulative period identifier, name, and start/end dates. MTL_SYSTEM_ITEMS_KFV (synonym) supplies item attributes from the key-flexfield-enabled item view, including the concatenated segment string and primary unit of measure. PO_VENDORS (view) and PO_VENDOR_SITES (view) supply vendor name and site code. ORG_ORGANIZATION_DEFINITIONS (view) supplies organization code and name. PO_ASL_ATTRIBUTES (synonym) provides the approved supplier list linkage — vendor, vendor site, and item — and optionally a purchasing unit of measure that overrides the item's primary UOM.
The WHERE clause ties the CUM period's organization to both the inventory organization and the item, and correlates the ASL attribute row to the vendor and vendor site. A critical filter is applied through the CHV_INQ_SV package function GET_ASL_ORG, which resolves the correct ASL using organization for the combination of organization, vendor, vendor site, and item, restricting results to ASL entries valid for the requested context. The recorded dependency list further notes FND_GLOBAL, HR_GENERAL, and HR_SECURITY packages, which Oracle views of this class typically invoke for organizational or security context resolution.
Key Columns
- CUM_PERIOD_ID, CUM_PERIOD_NAME, CUM_PERIOD_START_DATE, CUM_PERIOD_END_DATE — identity and validity window of the cumulative period.
- INVENTORY_ITEM_ID, ITEM_NUM, ITEM_DESCRIPTION — item surrogate key, concatenated flexfield segments (CONCATENATED_SEGMENTS), and description.
- PURCHASING_UNIT_OF_MEASURE — derived via NVL from the ASL attribute UOM, falling back to the item's primary UOM.
- VENDOR_ID, VENDOR_NAME, VENDOR_SITE_ID, VENDOR_SITE_CODE — the supplier and ship-to/purchasing site on the ASL.
- ORGANIZATION_ID, ORGANIZATION_CODE, NAME — the inventory/operating organization context.
Common Use Cases and Queries
Typical uses include CUM period reporting for supplier schedules, item-level ASL validation, and feeds into supplier collaboration extracts. A representative query lists all CUM items for one organization and vendor:
SELECT cum_period_name, item_num, item_description, purchasing_unit_of_measure, vendor_name, vendor_site_code, cum_period_start_date, cum_period_end_date FROM chv_cum_items_v WHERE organization_code = :org AND vendor_id = :vendor ORDER BY item_num, cum_period_start_date;- A period-window lookup:
SELECT item_num, vendor_name, cum_period_start_date, cum_period_end_date FROM chv_cum_items_v WHERE cum_period_end_date >= TRUNC(SYSDATE) AND organization_id = :org_id; - A join to cumulative quantity balances:
SELECT v.item_num, v.vendor_name, v.cum_period_name, c.cum_quantity FROM chv_cum_items_v v, chv_cum_quantities c WHERE v.cum_period_id = c.cum_period_id;
Because the view resolves ASL context through CHV_INQ_SV, query performance depends on the volume of CUM periods and ASL attribute rows; filtering by ORGANIZATION_ID and VENDOR_ID is advisable in high-volume environments.
-
View: CHV_CUM_ITEMS_V 12.1.1
- Retrofitted
APPS.CHV_CUM_ITEMS_V·↳ CHV_CUM_PERIODS·↳ CHV_INQ_SV·↳ HR_GENERAL·Explore CHV module →
-
- Retrofitted
APPS.CHV_AUTHORIZATION_HEADERS_V·↳ CHV_AUTHORIZATIONS·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore CHV module →
-
- Retrofitted
APPS.CHV_AUTHORIZATION_HEADERS_V·↳ CHV_AUTHORIZATIONS·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore CHV module →
-
APPS.MRPBV_PLAN_ITEM_SUPPLIERS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·Explore MRP module →
-
APPS.CHV_CUM_ITEMS_HISTORY_V·↳ CHV_CUM_PERIODS·↳ CHV_INQ_SV2·↳ FND_PROFILE·Explore CHV module →
-
View: MRP_PO_SUPPLIERS_V 12.1.1
Supplier item view
APPS.MRP_PO_SUPPLIERS_V·↳ MRP_PLAN_ORGANIZATIONS_V·↳ MRP_SYSTEM_ITEMS·↳ PO_APPROVED_SUPPLIER_LIS_VAL_V·Explore MRP module →
-
View: CHV_CUM_ITEMS_V 12.2.2
- Retrofitted
APPS.CHV_CUM_ITEMS_V·↳ CHV_CUM_PERIODS·↳ CHV_INQ_SV·↳ FND_GLOBAL·Explore CHV module →
-
View: MRP_PO_SUPPLIERS_V 12.2.2
Supplier item view
APPS.MRP_PO_SUPPLIERS_V·↳ MRP_PLAN_ORGANIZATIONS_V·↳ MRP_SYSTEM_ITEMS·↳ PO_APPROVED_SUPPLIER_LIS_VAL_V·Explore MRP module →
-
APPS.MRPFV_PLAN_ITEM_SUPPLIERS·↳ FND_GLOBAL·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·Explore MRP module →
-
APPS.MRPBV_PLAN_ITEM_SUPPLIERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →
-
APPS.MRPFV_PLAN_ITEM_SUPPLIERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ MRP_PLANS·↳ MRP_PLAN_ORGANIZATIONS·Explore MRP module →
-
APPS.CHV_CUM_ITEMS_HISTORY_V·↳ CHV_CUM_PERIODS·↳ CHV_INQ_SV2·↳ FND_GLOBAL·Explore CHV module →
-
View: CHV_AUTHORIZATIONS_V 12.2.2
- Retrofitted
APPS.CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore CHV module →
-
APPS.POS_CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore PO module →
-
CUM adjustments table
-
CUM adjustments table
-
View: ICX_CHV_ITEM_ORDERS_V 12.1.1
APPS.ICX_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore ICX module →
-
APPS.POS_ASL_ORDER_MODIFIERS_V·↳ PO_ASL_ATTRIBUTES·Explore ICX module →
-
APPS.POS_ASL_ORDER_MODIFIERS_V·↳ PO_ASL_ATTRIBUTES·Explore ICX module →
-
View: CHV_AUTHORIZATIONS_V 12.1.1
- Retrofitted
APPS.CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore CHV module →
-
Item orders table
-
Item orders table
-
Authorizations table
-
Authorizations table
-
View: POS_CHV_ITEM_ORDERS_V 12.1.1
APPS.POS_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore PO module →
-
Obsolete
APPS.ICX_CHV_SCHEDULE_LINES_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore ICX module →
-
View: POS_CHV_ITEM_ORDERS_V 12.2.2
used to select the item orders details info
APPS.POS_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore POS module →
-
- Retrofitted
APPS.POBV_APPROVED_SUPPLIER_LISTS·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·↳ PO_ASL_STATUSES·Explore PO module →
-
View: POS_CHV_ITEM_ORDERS_V 12.2.2
APPS.POS_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore PO module →
-
Schedule items table
-
Schedule items table
-
View: CHV_ITEM_ORDERS_V 12.2.2
- Retrofitted
APPS.CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore CHV module →
-
View: ICX_CHV_ITEM_ORDERS_V 12.2.2
APPS.ICX_CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore ICX module →
-
used to select the detailed info related to authorization
APPS.POS_CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore POS module →
-
APPS.POS_CHV_AUTHORIZATIONS_V·↳ CHV_AUTHORIZATIONS·↳ FND_GLOBAL·↳ PO_LOOKUP_CODES·Explore PO module →
-
Approved supplier list attributes
-
Table: CHV_AUTHORIZATIONS_GT 12.2.2
-
is one of the views used to select schedule related info
APPS.POS_CHV_SCHEDULE_ITEMS_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore POS module →
-
APPS.PO_ASL_ATTRIBUTES_VAL_V·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·Explore PO module →
-
- Retrofitted
APPS.POBV_APPROVED_SUPPLIER_LISTS·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·↳ PO_ASL_STATUSES·Explore PO module →
-
View: CHV_ITEM_ORDERS_V 12.1.1
- Retrofitted
APPS.CHV_ITEM_ORDERS_V·↳ CHV_ITEM_ORDERS·↳ CHV_SCHEDULE_ITEMS·↳ FND_GLOBAL·Explore CHV module →
-
View: POS_ORD_MODIFIERS_V 12.2.2
APPS.POS_ORD_MODIFIERS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PLANNERS·↳ MTL_SYSTEM_ITEMS_KFV·Explore PO module →
-
View: POS_ORD_MODIFIERS_V 12.2.2
Fetches the items from approved supplier lists
APPS.POS_ORD_MODIFIERS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ MTL_PLANNERS·↳ MTL_SYSTEM_ITEMS_KFV·Explore POS module →
-
The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS.
-
The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS.
-
APPS.PO_ASL_ATTRIBUTES_VAL_V·↳ PO_APPROVED_SUPPLIER_LIST·↳ PO_ASL_ATTRIBUTES·Explore PO module →
-
View: CHV_SCHEDULE_ITEMS_V 12.1.1
- Retrofitted
APPS.CHV_SCHEDULE_ITEMS_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore CHV module →
-
View: CHV_SCHEDULE_ITEMS_V 12.2.2
- Retrofitted
APPS.CHV_SCHEDULE_ITEMS_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore CHV module →
-
- Retrofitted
APPS.POFV_APPROVED_SUPPLIER_LISTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·↳ HR_PERSON_NAME·Explore PO module →
-
Schedule Lines View
APPS.ICX_CHV_SCHEDULE_ITEMS_V·↳ CHV_INQ_SV·↳ CHV_SCHEDULE_HEADERS·↳ CHV_SCHEDULE_ITEMS·Explore ICX module →