Search Results contract_version_number




Overview
Explore in AI Chat

Overview

The APPS.IGCBV_MC_CONTRACT_COMMITMENTS view belongs to the IGC (Contract Commitment) product family within Oracle E-Business Suite, and is delivered in the APPS schema with a status of VALID. It functions as a reporting and integration surface for multi-currency contract commitment data, joining the contract header, the multi-currency header extensions, and the General Ledger sets of books definition. Rather than exposing the underlying transactional tables directly, the view presents a denormalized, read-only projection that resolves the numeric foreign keys into business-meaningful identifiers such as the contract commitment number, the contract version number, and the set of books name. This makes it suitable for concurrent program output, Discoverer workbooks, OBIEE/BI Publisher data models, and custom interfaces that must reconcile commitments against a specific ledger. The view is defined with a WITH READ ONLY clause, confirming it is intended strictly for query access. Note that the inherent filter '_SEC:IGC_CCH.ORG_ID' IS NOT NULL enforces multi-org security (MOAC) at the row level, so the operating unit context must be correctly initialized before querying.

Underlying Base Objects

The documented view text and ETRM metadata identify the following base objects:

Cardinality is one row per contract commitment header per set of books. Joins are equi-joins on IGC_CC_MC_HEADERS.CC_HEADER_ID = IGC_CCH.CC_HEADER_ID and IGC_CC_MC_HEADERS.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID.

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying the latest version of a commitment, reporting commitments by ledger, and validating conversion setup prior to posting. A representative query is:

  • SELECT contract_commitment_number, contract_version_number, sets_of_books_name, currency_conversion_rate FROM apps.igcbv_mc_contract_commitments WHERE contract_commitment_number = :cc_num ORDER BY contract_version_number DESC;
  • SELECT contract_commitment_number, contract_version_number, set_of_books_id FROM apps.igcbv_mc_contract_commitments WHERE organization_id = :org_id;

Because the view is read-only and secured by MOAC, it should be queried after the operating unit context is established; it is not available for DML.