Results for “igcfv_mc_release_account_lines”

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

Overview

IGCFV_MC_RELEASE_ACCOUNT_LINES is a read-only view owned by the APPS schema within the IGC – Contract Commitment product family. It exposes the accounting distribution lines associated with contract releases (change orders, commitments, and release documents) that have been created against a parent contract commitment. In Oracle EBS 12.1.1 and 12.2.2, this view is one of several "IGCFV_" reporting views built on top of the IGC core tables to simplify retrieval of commitment accounting data for reporting, reconciliation, and downstream integration.

The view is defined with the WITH READ ONLY clause, meaning it cannot be used for inserts, updates, or deletes; it is strictly a query surface. It joins the multi-currency accounting line table (IGC_CC_MC_ACCT_LINES) to the standard accounting line table (IGC_CC_ACCT_LINES) and links each release line back to its parent account line and parent contract header. This parent/release relationship is the central purpose of the view: it lets reporting tools walk from a release accounting line to the corresponding parent commitment and set of books in a single query.

Underlying Base Objects

The view references the following underlying objects (documented in ETRM 12.2.2, exposed through APPS synonyms):

• IGC_CC_MC_ACCT_LINES — multi-currency accounting lines; source of functional and encumbrance amounts, conversion type/date/rate, and the account line ID.
• IGC_CC_ACCT_LINES (aliased IGCCAL for the release, IGCCALP for the parent) — core commitment accounting lines; provides line numbers and the parent linkage keys.
• IGC_CC_HEADERS_ALL (aliased IGC_CCH for the release, IGC_CCHP for the parent) — commitment headers; supplies contract numbers.
• GL_SETS_OF_BOOKS_11I — provides the set of books name and short name.

The join conditions enforce that each multi-currency line matches its accounting line, that both map to a valid set of books, that the release header and parent header resolve correctly, and that only headers with CC_TYPE = 'R' (releases) are returned.

Key Columns

• RELEASE_ACCOUNT_LINE_NUMBER — accounting line number of the release distribution.
• RELEASE_ACCT_FUNCTIONAL_AMOUNT / REL_ACCT_ENCUMBRANCE_AMOUNT — functional and encumbrance amounts for the release line.
• CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE — currency conversion attributes applied to the line.
• SETS_OF_BOOKS_NAME / SETS_OF_BOOKS_SHORT_NAME — the ledger the line belongs to.
• PARENT_ACCOUNT_LINE_NUMBER, PARENT_CONTRACT_NUMBER, RELEASE_CONTRACT_NUMBER — human-readable identifiers for the parent and release.
• PARENT_CONTRACT_COMMITMENT_ID, PARENT_ACCOUNT_LINE_ID, RELEASE_CONTRACT_COMMITMENT_ID, RELEASE_ACCOUNT_LINE_ID, SET_OF_BOOKS_ID — surrogate keys used for joins and drill-down.

Common Use Cases and Queries

Typical scenarios include reconciling release amounts against parent commitments, auditing currency conversion on release lines, and feeding downstream financial reporting with release-level accounting data.

SELECT release_contract_number,
       release_account_line_number,
       release_acct_functional_amount,
       rel_acct_encumbrance_amount,
       sets_of_books_short_name
FROM   apps.igcfv_mc_release_account_lines
WHERE  parent_contract_number = :p_contract_number;

SELECT release_account_line_id,
       release_account_line_number,
       currency_conversion_rate,
       currency_conversion_date
FROM   apps.igcfv_mc_release_account_lines
WHERE  set_of_books_id = :p_sob_id
AND    release_account_line_number = :p_line_num;

Because the view is read-only and already joins the parent, release, and ledger context, it is preferred over hand-built joins to the underlying IGC tables for most reporting and reconciliation requirements.