Search Results preparer_user_id




Overview
Explore in AI Chat

Overview

IGCBV_CC_CONTRACT_COMMITMENTS is a read-only view owned by the APPS schema within the IGC (Contract Commitment) product family of Oracle E-Business Suite, and is available in both the 12.1.1 and 12.2.2 releases. The view exposes header-level information about contract commitments — the agreements through which expenditures are reserved or encumbered against funds — and is intended to serve as a stable, business-friendly presentation layer for reporting, integration, and inquiry purposes. Rather than requiring developers to join and decode raw base tables, the view surfaces descriptive attributes alongside foreign keys to vendors, sites, locations, operating units, and sets of books, and applies security and lookup translation directives directly in its defining SQL.

Underlying Base Objects

Per the documented metadata, the view is defined over the base object referenced as IGC_CC_HEADERS_ALL (exposed through its synonym), with the actual select text drawing from IGC_CC_HEADERS, aliased as IGC_CCH. All columns are sourced from this single header table; the view does not join to lines, distributions, or other commitment detail tables. The view text embeds three Oracle EBS framework directives: an organization security predicate ("_SEC:IGC_CCH.ORG_ID") that restricts returned rows to the operating units the querying responsibility is authorized to access; a set of lookup translation expressions ("_LA:...:FND_LOOKUPS:...:MEANING") that resolve stored lookup codes into their display meanings for approval status, control status, encumbrance status, state, and type; and a WITH READ ONLY clause that explicitly prevents DML through the view. Because it resolves lookup meanings rather than exposing raw codes for those five attributes, the view is optimized for display and reporting rather than for programmatic code comparison.

Key Columns

Common Use Cases and Queries

Typical uses include commitment registers, expiry and renewal tracking, approval-status monitoring, and vendor-facing analysis. Because security is enforced inside the view, queries return only the operating units the responsibility can access, and results can be joined to PO, supplier, or GL objects through the exposed identifiers. A representative query filtering on the end date is:

  • SELECT contract_commitment_number, description, vendor_id, start_effective_date, end_effective_date, currency_code FROM igcbv_cc_contract_commitments WHERE end_effective_date BETWEEN :p_from AND :p_to AND organization_id = :p_org_id ORDER BY end_effective_date;

A count of commitments by translated state illustrates the lookup columns:

  • SELECT "_LA:STATE", COUNT(*) FROM igcbv_cc_contract_commitments GROUP BY "_LA:STATE";

Note that the lookup-referencing columns must be quoted exactly as listed when selected, and that no insert, update, or delete is permitted against this view.