Search Results schedule_items




Overview
Explore in AI Chat

Overview

APPS.CHV_AUTHORIZATIONS_V is a reporting view within the Oracle E-Business Suite procurement family, exposed under the APPS schema and available in both 12.1.1 and 12.2.2. It presents the subset of authorization records in the sourcing/scheduling domain that pertain specifically to scheduled items — that is, releases and schedules created against approved blanket purchase agreements and similar authorizations.

The view exists to support reporting and integration scenarios where consumers need authorization-level attributes (quantities, units of measure, time fences, cutoff dates) joined to a human-readable authorization type description, without having to replicate the reference-type filter or the lookup join themselves. Because the filter to REFERENCE_TYPE = 'SCHEDULE_ITEMS' is hard-coded in the view definition, any query against APPS.CHV_AUTHORIZATIONS_V returns only schedule-item authorizations, which makes it a convenient and self-documenting source for purchasing schedules and release reporting.

Underlying Base Objects

The view is defined over three documented objects:

  • CHV_AUTHORIZATIONS (SYNONYM) — the primary authorizations table, aliased CAU. This table stores authorization scheduling and sourcing records, including the reference identifier, authorization code, sequence, quantities, time fence, and cutoff date.
  • PO_LOOKUP_CODES (VIEW) — aliased PLC, a purchasing lookup view used to resolve the authorization code to a displayed description. The join is on CAU.AUTHORIZATION_CODE = PLC.LOOKUP_CODE with PLC.LOOKUP_TYPE = 'AUTHORIZATION_TYPE'.
  • FND_GLOBAL (PACKAGE) — the standard EBS concurrent/global context package. Although not referenced in the visible SELECT list, it is part of the documented base object set and is typically invoked by the WHO columns and security predicates that EBS views rely on for organization and responsibility context.

The join between CHV_AUTHORIZATIONS and PO_LOOKUP_CODES is effectively an inner join, so an authorization code with no corresponding AUTHORIZATION_TYPE lookup row will not appear in the view.

Key Columns

The view exposes the ROWID of CHV_AUTHORIZATIONS along with the following significant attributes:

Common Use Cases and Queries

Typical uses include reporting scheduled releases against blanket agreements, reconciling schedule quantities by authorization type, and integrating schedule-item authorizations into external systems. A representative query follows:

  • SELECT reference_id, authorization_code, displayed_field, schedule_quantity, schedule_quantity_primary, timefence_days, cutoff_date FROM apps.chv_authorizations_v WHERE cutoff_date < SYSDATE;
  • SELECT displayed_field, SUM(schedule_quantity) FROM apps.chv_authorizations_v GROUP BY displayed_field ORDER BY displayed_field;
  • SELECT reference_id, authorization_sequence, primary_unit_of_measure, purchasing_unit_of_measure FROM apps.chv_authorizations_v WHERE reference_id = :reference_id ORDER BY authorization_sequence;