Results for “igcbv_cc_account_lines”

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

Overview

The APPS.IGCBV_CC_ACCOUNT_LINES view is a reporting and integration layer for the Oracle E-Business Suite Contract Commitment (IGC) module. It exposes the account-level line details of contract commitments, translating the underlying storage columns into business-friendly names such as CONTRACT_COMMITMENT_ID, CHARGE_CODE_COMBINATION_ID, and ACCOUNT_FUNCTIONAL_AMOUNT. Because the view is defined with a WITH READ ONLY clause, it is intended strictly for query, reporting, and downstream integration; it cannot be used for DML against the commitment data.

A distinguishing characteristic of this view is its enforced row-level data security. The defining query includes the predicate WHERE '_SEC:IGCCAL.EXPENDITURE_ORG_ID' IS NOT NULL, a secured-substitution construct that binds the view to Oracle's organization-level security model. This means the rows returned are implicitly filtered based on the set of EXPENDITURE_ORG_ID values accessible to the querying user's security profile. Consequently, EXPENDITURE_ORG_ID is not merely a projected attribute; it is the governing key of the view's access control, which is precisely why users searching for "expenditure_org_id" in connection with IGCBV_CC_ACCOUNT_LINES are typically investigating why specific account lines do or do not appear in their reports.

Underlying Base Objects

The ETRM metadata records a single referenced base object: the synonym IGC_CC_ACCT_LINES, which resolves to the base table APPS.IGC_CC_ACCT_LINES in the IGC schema. The view is essentially a projection over this table, aliased as IGCCAL in the view text. No joins to other tables are present in the defining query; lookups and meaning resolutions (for example, for taxable flag and encumbrance status) are deferred to Oracle Forms LOV and FND_LOOKUPS constructs rather than being materialized in the view definition. This keeps the view lightweight and preserves the direct relationship between a commitment account line and its originating row.

Key Columns

• ACCOUNT_LINE_ID — Primary identifier for the account line.
• CONTRACT_COMMITMENT_ID — Foreign key to the parent contract commitment header.
• EXPENDITURE_ORG_ID — The expenditure organization that governs row-level security; only lines for accessible organizations are returned.
• PROJECT_ID and TASK_ID — Project and task references for the expenditure.
• EXPENDITURE_TYPE and EXPENDITURE_ITEM_DATE — Classification and date of the expenditure item.
• CHARGE_CODE_COMBINATION_ID and BUDGET_CODE_COMBINATION_ID — Accounting flexfield combinations for charges and budget.
• ACCOUNT_ENTERED_AMOUNT and ACCOUNT_FUNCTIONAL_AMOUNT — Amounts in entered and functional currency.
• ACCOUNT_BILLED_AMOUNT, ACCOUNT_UNBILLED_AMOUNT — Billed and unbilled portions.
• ACCOUNT_ENCUMBRANCE_AMOUNT and ACCOUNT_ENCUMBRANCE_DATE — Encumbrance value and date.
• TAX_ID — Tax identifier associated with the line.
• DESCRIPTION — Free-text description of the account line.

Common Use Cases and Queries

This view is commonly used in contract commitment reporting, commitment-versus-actual reconciliations, and integrations that must respect organization security. A typical query listing account lines for accessible expenditure organizations is:

• SELECT CONTRACT_COMMITMENT_ID, ACCOUNT_LINE_ID, EXPENDITURE_ORG_ID, PROJECT_ID, TASK_ID, ACCOUNT_FUNCTIONAL_AMOUNT, ACCOUNT_ENCUMBRANCE_AMOUNT FROM APPS.IGCBV_CC_ACCOUNT_LINES WHERE CONTRACT_COMMITMENT_ID = :p_cc_id;
• Encumbrance review: SELECT ACCOUNT_LINE_ID, ACCOUNT_ENCUMBRANCE_AMOUNT, ACCOUNT_ENCUMBRANCE_DATE FROM APPS.IGCBV_CC_ACCOUNT_LINES WHERE ACCOUNT_ENCUMBRANCE_AMOUNT > 0;
• Organization-level analysis: filter or group by EXPENDITURE_ORG_ID to summarize committed functional amounts by organization, remembering that only permitted organizations are visible.