Search Results cc_version_num




Overview
Explore in AI Chat

Overview

APPS.IGC_CC_HEADER_VERSION_V is a version-aware view over the commitment control (CC) header data model in Oracle E-Business Suite. It presents the current effective version of each commitment control document together with its historical versions, resolving version selection through the IGC_CC_VERSION_VIEW_PKG package. In Oracle EBS 12.1.1 and 12.2.2, this view serves as the reporting and integration surface for commitment control headers, allowing external reports, forms, and interfaces to obtain a consistent, version-qualified snapshot of a CC document without directly navigating the header and header-history tables.

The view is owned by APPS and is commonly accessed through a synonym or direct APPS qualification. Its principal identifier is CC_HEADER_ID, the column most frequently referenced in lookups, joins, and API calls against commitment control documents.

Underlying Base Objects

The view is defined over the following documented base objects:

The view text performs a UNION between current headers and historical headers. The current branch selects rows whose CC_HEADER_ID appears in IGC_CC_HEADERS_ALL with CC_VERSION_NUM at or above the version returned by IGC_CC_VERSION_VIEW_PKG.GET_VERSION_NUM, minus those whose minimum qualifying history version would duplicate them. The history branch contributes the corresponding historical rows from IGC_CC_HEADER_HISTORY_ALL. Outer joins to FND_USER and HR_EMPLOYEES (aliased fndu/hr and ofndu/ohr) resolve the preparer and owner person names.

Key Columns

Common Use Cases and Queries

Typical usage includes commitment control reporting, version history review, workflow status monitoring, and integration lookups keyed by CC_HEADER_ID. A representative query retrieves the current version for a given document:

  • SELECT cc_header_id, cc_num, cc_version_num, cc_state, cc_apprvl_status FROM apps.igc_cc_header_version_v WHERE cc_header_id = :p_cc_header_id;
  • SELECT cc_header_id, cc_num, cc_version_num, cc_owner_user_id FROM apps.igc_cc_header_version_v WHERE org_id = :p_org_id AND cc_state = 'APPROVED';
  • SELECT v.cc_header_id, v.cc_version_num, v.cc_ctrl_status FROM apps.igc_cc_header_version_v v WHERE v.cc_header_id IN (SELECT cc_header_id FROM apps.igc_cc_lines WHERE cc_line_id = :p_line_id);

Because the view combines live and historical records and applies version filtering via IGC_CC_VERSION_VIEW_PKG, queries should always constrain on CC_HEADER_ID or another selective predicate and consider ORG_ID for multi-org environments to ensure correct results.