Search Results vendor_contacts_last_name




Overview
Explore in AI Chat

Overview

IGCFV_CC_CONTRACT_COMMITMENTS is an APPS-owned reporting view in the Oracle E-Business Suite IGC (Contract Commitment) module. It presents a denormalized, human-readable projection of contract commitment header data, joining the core commitment records in IGC_CC_HEADERS with the descriptive attributes that users expect to see on a commitment summary screen or report: vendor details, payment terms, ledger, currency, conversion type, operating unit, and owning/preparer users. Rather than forcing report authors and integrators to join a dozen base objects manually, the view assembles them into a single flat structure keyed on the contract commitment header.

The view is significant because it is the primary public surface for contract commitment reporting in IGC. It exposes translated lookups (approval status, control status, encumbrance status, state, and type) indirectly, and it carries a dual maintenance of surrogate keys and descriptive columns, allowing consumers to filter by ID (TERM_ID, VENDOR_ID, ORG_ID) while displaying labels such as TERMS_NAME, VENDOR_NAME, and ORGANIZATION_NAME. The user search term "terms_name" maps directly to the AP_TERMS_TL.NAME column surfaced by this view, reflecting the common need to report commitments alongside their negotiated payment terms.

Underlying Base Objects

The view text is anchored on IGC_CC_HEADERS (aliased IGC_CCH, referenced in the documented metadata as IGC_CC_HEADERS_ALL). The documented referenced base objects are:

In effect, the view consolidates supplier master data (PO_VENDORS family), financial setup (ledger, currency, conversion type), HR organization and location data, and the IGC commitment header into one row per commitment version.

Key Columns

The view exposes both descriptive labels and their backing identifiers. Important columns include:

Common Use Cases and Queries

Typical uses include commitment reporting by supplier, listing commitments for a ledger and currency, and resolving commitments to their payment terms. A representative query searching on the terms name is:

  • SELECT contract_commitment_number, terms_name, vendor_name, currency_code FROM igcfv_cc_contract_commitments WHERE terms_name = :p_terms_name;
  • SELECT contract_commitment_number, terms_name, vendor_name, sets_of_books_short_name FROM igcfv_cc_contract_commitments WHERE organization_id = :p_org_id AND vendor_id = :p_vendor_id;
  • SELECT contract_commitment_number, terms_name, start_effective_date, end_effective_date FROM igcfv_cc_contract_commitments WHERE start_effective_date >= :p_from_date;

Because the view already resolves translated names, it is well suited to BI Publisher reports, ad hoc discoverer queries, and integration extracts where commitment data must be presented without further lookup joins.