Results for “authorization_type”

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

Overview

APPS.POS_CHV_AUTHORIZATIONS_V is a reporting view in the Oracle E-Business Suite Procurement module that exposes supplier scheduling authorization data. It flattens the authorization records held in the CHV_AUTHORIZATIONS base table and joins them to the PO_LOOKUP_CODES view so that each authorization code is presented alongside its human-readable display value. The view is restricted to records where the reference type is SCHEDULE_ITEMS and where the joined lookup code belongs to the AUTHORIZATION_TYPE lookup type.

Because the view resolves the AUTHORIZATION_TYPE lookup internally, consumers do not need to know the internal lookup code identifiers or join to the lookup tables themselves. This makes it a convenient source for concurrent programs, OBIEE or Discoverer reports, and custom integrations that must display or exchange supplier scheduling authorization information. The view also carries the standard EBS WHO columns and concurrent program context columns, allowing report developers to trace which program last modified a given authorization row.

Underlying Base Objects

The view is defined over three documented objects:

• CHV_AUTHORIZATIONS (referenced through a synonym) — the primary table holding supplier scheduling authorization records. It supplies the reference, authorization code, sequence, unit of measure, quantity, time fence, cutoff date, descriptive flexfield attributes, and WHO/audit columns.
• PO_LOOKUP_CODES (view) — supplies DISPLAYED_FIELD, the meaning shown to users for a given authorization code.
• FND_GLOBAL (package) — the standard EBS context package referenced in the view's dependency chain, typically for WHO and session context resolution.

The join between CHV_AUTHORIZATIONS and PO_LOOKUP_CODES is driven by two predicates: CAU.AUTHORIZATION_CODE = PLC.LOOKUP_CODE and the constant PLC.LOOKUP_TYPE = 'AUTHORIZATION_TYPE'. The first predicate links each authorization to its lookup, and the second constrains the join to the correct lookup category so that codes from other lookup types are not incorrectly matched. A third predicate, CAU.REFERENCE_TYPE = 'SCHEDULE_ITEMS', limits the result set to authorizations attached to schedule items.

Key Columns

• REFERENCE_ID — identifies the schedule item to which the authorization applies.
• AUTHORIZATION_CODE — the internal lookup code for the authorization type.
• DISPLAYED_FIELD — the user-facing meaning of the authorization code, sourced from PO_LOOKUP_CODES.
• AUTHORIZATION_SEQUENCE — the ordering sequence in which authorizations are evaluated or applied.
• PRIMARY_UNIT_OF_MEASURE / PURCHASING_UNIT_OF_MEASURE — the units associated with the authorization quantities.
• SCHEDULE_QUANTITY_PRIMARY / SCHEDULE_QUANTITY — the authorized quantities expressed in the respective units of measure.
• TIMEFENCE_DAYS / CUTOFF_DATE — the time fence, in days, and the associated cutoff date governing the authorization horizon.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield context and segments.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context identifying the process that last updated the row.
• ROWID — the physical row identifier, exposed for update-capable or row-targeted logic.

Common Use Cases and Queries

Typical use cases include reporting all authorizations for a schedule item, resolving authorization codes to their displayed meanings, and auditing which concurrent program created or modified authorization data.

To retrieve authorizations for a specific schedule item, ordered by sequence:

• SELECT reference_id, authorization_code, displayed_field, authorization_sequence, schedule_quantity, cutoff_date FROM apps.pos_chv_authorizations_v WHERE reference_id = :p_reference_id ORDER BY authorization_sequence;

To produce a listing grouped by displayed authorization type:

• SELECT displayed_field, COUNT(*) FROM apps.pos_chv_authorizations_v GROUP BY displayed_field ORDER BY displayed_field;

To identify rows recently modified and the responsible program:

• SELECT reference_id, authorization_code, last_update_date, last_updated_by, program_id FROM apps.pos_chv_authorizations_v WHERE last_update_date >= SYSDATE - 7;

Because the view filters to REFERENCE_TYPE = 'SCHEDULE_ITEMS' and to the AUTHORIZATION_TYPE lookup, queries against POS_CHV_AUTHORIZATIONS_V return only supplier scheduling authorizations, which makes it a focused and reliable source for reporting without additional filtering.