Search Results cc_acct_version_num




Overview
Explore in AI Chat

Overview

IGC_CC_ACCT_LINE_VERSION_V is an APPS-owned reporting view within the Oracle E-Business Suite Grants / Contracts (IGC) accounting subsystem. It exposes version-aware accounting distribution lines for burden and cost-code processing. Its central purpose is to resolve which accounting line rows are "current" at the version requested by the calling session, rather than always returning the newest or the oldest stored row. That resolution logic is driven by the packaged function IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM, which supplies the version number the view compares against.

The view takes a UNION of two sources: rows from the live accounting lines table that have no qualifying history entry, and rows from the history table that represent the earliest version at or above the requested version. The result is a single, logically deduplicated set of accounting lines keyed by CC_ACCT_LINE_ID, each presented with the column set expected by the IGC accounting forms and reports. Because the version threshold comes from a package function rather than a bind variable, callers must set the package-level version context before querying the view.

Underlying Base Objects

The view is defined over three documented objects:

  • IGC_CC_ACCT_LINES (synonym) — the live, current accounting line records.
  • IGC_CC_ACCT_LINE_HISTORY (synonym) — retained prior versions of the same accounting lines, each identified by CC_ACCT_LINE_ID plus CC_ACCT_VERSION_NUM.
  • IGC_CC_VERSION_VIEW_PKG (package) — provides GET_VERSION_NUM, the function that establishes the version threshold used in the MIN(CC_ACCT_VERSION_NUM) subquery predicate.

Conceptually the view performs a set difference (live rows not present in history) unioned with history rows whose version equals the minimum version at or above the requested threshold. The first branch therefore reflects rows that have never been versioned; the second reflects the correct historical snapshot for the active version context.

Key Columns

The projected column list carries the accounting distribution detail and audit metadata:

Common Use Cases and Queries

Typical uses include versioned inquiry of burden accounting lines from IGC forms, reconciliation of live versus historical distributions, and feeds into cost reporting extract programs. The version threshold must be set before querying:

  • Retrieve current-version lines for a header: SELECT cc_acct_line_id, cc_acct_line_num, cc_acct_func_amt FROM apps.igc_cc_acct_line_version_v WHERE cc_header_id = :header_id;
  • Join to expenditure context to summarize by project and task: SELECT project_id, task_id, SUM(cc_acct_func_amt) FROM apps.igc_cc_acct_line_version_v GROUP BY project_id, task_id;
  • Inspect encumbrance state for a distribution: SELECT cc_acct_line_id, cc_acct_encmbrnc_status, cc_acct_encmbrnc_amt FROM apps.igc_cc_acct_line_version_v WHERE cc_acct_encmbrnc_status IS NOT NULL;

Because the version selection is internally tied to IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM, results reflect the version context established by the calling process; the same query may return different rows across version contexts. Queries should therefore set the package version context explicitly and avoid assuming the view always returns the latest values.