Results for “schedule_revision”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The CHV_AUTHORIZATION_HEADERS_V view is an APPS-owned database object within the Oracle E-Business Suite CHV – Supplier Scheduling module. Its documented status is VALID, and its primary ETRM description is recorded simply as "Retrofitted," indicating that the object was carried forward from an earlier release and reconciled against the 12.1.1 / 12.2.2 code line without substantive functional change. The view consolidates authorization header information for supplier scheduling, surfacing cumulative authorization records that govern how released schedule quantities are approved against an authorized ceiling. It joins authorization data to schedule headers and schedule items, and it resolves the authorization code to a human-readable value through the purchasing lookup infrastructure.

Because the view flattens several Supplier Scheduling and Purchasing constructs into a single row set, it is well suited to reporting, inquiry forms, and integration extracts that need to present a supplier's authorized schedule horizon alongside the quantities already consumed by authorizations. The inclusion of PURCHASING_UNIT_OF_MEASURE makes it particularly relevant to searches concerned with the unit of measure applied at the authorization level, since the UOM shown here is the purchasing UOM for the referenced schedule quantity rather than an inventory or primary UOM.

Underlying Base Objects

The documented base objects underlying the view are CHV_AUTHORIZATIONS (SYNONYM), CHV_SCHEDULE_HEADERS (SYNONYM), CHV_SCHEDULE_ITEMS (SYNONYM), FND_GLOBAL (PACKAGE), and PO_LOOKUP_CODES (VIEW). The view is defined as a join across these objects, driving the authorization spine from CHV_AUTHORIZATIONS (aliased CA) and linking to schedule headers (CSH) and schedule items (CSI) through the HIGH_AUTH_SCHEDULE_ITEM_ID and SCHEDULE_ID relationships. The AUTHORIZATION_CODE is resolved against PO_LOOKUP_CODES where LOOKUP_TYPE = 'AUTHORIZATION_TYPE', exposing the DISPLAYED_FIELD as the readable authorization description. Although FND_GLOBAL is documented as a referenced object, the visible view text does not expose a direct call to it; it is typically relied upon in dependent or wrapper logic rather than in this column projection. The join is further constrained to REFERENCE_TYPE = 'CUM_PERIODS', so the view returns authorization records tied to cumulative period references.

Key Columns

• REFERENCE_ID / REFERENCE_TYPE — Identifies the source authorization reference; the view filters on the cumulative periods reference type.
• AUTHORIZATION_CODE — The lookup code from the AUTHORIZATION_TYPE lookup, joined to PO_LOOKUP_CODES.
• DISPLAYED_FIELD — The human-readable description of the authorization code.
• SCHEDULE_QUANTITY — The schedule quantity associated with the authorization.
• PURCHASING_UNIT_OF_MEASURE — The purchasing UOM for the referenced quantity; central to UOM-specific reporting.
• HIGH_AUTH_QUANTITY — The highest authorized quantity recorded for the schedule item.
• HIGH_AUTH_SCHEDULE_ITEM_ID — The schedule item identifier that the authorization caps.
• SCHEDULE_NUM / SCHEDULE_REVISION — The schedule header number and revision.
• SCHEDULE_HORIZON_START — The start of the schedule planning horizon.

Common Use Cases and Queries

Typical uses include reviewing authorized quantities per schedule and confirming the purchasing UOM applied to each authorization. A representative query follows:

• SELECT schedule_num, schedule_revision, authorization_code, displayed_field, schedule_quantity, purchasing_unit_of_measure, high_auth_quantity FROM chv_authorization_headers_v WHERE schedule_num = :p_schedule;
• SELECT schedule_num, purchasing_unit_of_measure, SUM(high_auth_quantity) FROM chv_authorization_headers_v GROUP BY schedule_num, purchasing_unit_of_measure;
• SELECT DISTINCT purchasing_unit_of_measure FROM chv_authorization_headers_v ORDER BY 1;

These queries support supplier schedule validation, UOM reconciliation, and authorized-quantity exception reporting.