Search Results chv_cum_items_v




Overview
Explore in AI Chat

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

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.