Search Results cc_ref_num

Overview

IGC_CC_HEADERS_V is a reporting view owned by the APPS schema within the IGC – Contract Commitment module of Oracle E-Business Suite. It presents a denormalized, user-facing representation of contract commitment headers held in the base table IGC_CC_HEADERS. The view joins the header record to lookup tables, supplier tables, human resources tables, and workflow context so that a single query returns descriptive values rather than raw coded identifiers. This design makes the view suitable for concurrent program extracts, Oracle Discoverer/BI Publisher datasets, OAF page regions, and ad hoc reporting where the underlying codes must be resolved to meanings.

The view is marked VALID and is referenced in the ETRM 12.2.2 metadata. Because it exposes both the internal primary key CC_HEADER_ID and the business key CC_NUM, it serves as a bridge between transactional processing logic and downstream reporting. One important behavioral characteristic is the inclusion of a security function: the column derived from IGC_CC_ACCESS_PKG.GET_ACCESS_LEVEL restricts visibility according to the preparer/owner relationship and the current FND_GLOBAL.USER_ID, so the same rowset can differ between users.

Underlying Base Objects

The primary driver table is IGC_CC_HEADERS (aliased CCHD), accessed through the IGC_CC_HEADERS and IGC_CC_HEADERS_ALL synonyms. Lookup meanings are resolved against FND_LOOKUPS four times (aliased L, SL, ASL, CSL, and EL) to decode the commitment type, currency, approval status, control status, and encumbrance status respectively. Supplier data is drawn from PO_VENDORS, PO_VENDOR_SITES_ALL, and PO_VENDOR_CONTACTS.

User and personnel information is obtained from FND_USER joined to HR_EMPLOYEES for the preparer, owner, and current user, with PER_PEOPLE_F, PER_ASSIGNMENTS_F, and PER_ASSIGNMENT_STATUS_TYPES supporting the HR_GENERAL, HR_PERSON_NAME, and HR_SECURITY packages referenced by the view. Additional joins include AP_TERMS (ATP) for payment terms, HR_LOCATIONS (HRL) for the location code, GL_SETS_OF_BOOKS (SOB) for the ledger, and a self-join to IGC_CC_HEADERS (PCCHD) to expose the parent commitment number. Only the GL_SETS_OF_BOOKS join is outer (+); the remaining joins are inner joins, which means a missing lookup or supplier row can eliminate a header from the result set.

Key Columns

• CC_HEADER_ID – surrogate primary key of the commitment header.
• CC_NUM, CC_REF_NUM, CC_VERSION_NUM – commitment number, reference number, and version.
• CC_TYPE, MEANING (L) – coded type and its lookup description.
• CC_STATE, CC_APPRVL_STATUS, CC_CTRL_STATUS, CC_ENCMBRNC_STATUS – lifecycle and status columns.
• CURRENCY_CODE, SL.MEANING – transaction currency.
• VENDOR_NAME, SEGMENT1, VENDOR_SITE_CODE – supplier name, number, and site.
• VENDOR_CONTACT_ID – decoded as LAST_NAME || ', ' || FIRST_NAME.
• CC_ACCT_DATE, CC_START_DATE, CC_END_DATE – accounting, start, and end dates. CC_END_DATE defines the expiration of the commitment and drives expiration reports, and is the column explicitly requested by the search term.
• CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE – currency conversion attributes.
• PARENT_HEADER_ID, PCCHD.CC_NUM – parent/child hierarchy linkage.
• TERM_ID, ATP.NAME; LOCATION_ID, HRL.LOCATION_CODE – payment terms and location.
• Access-level column – first character returned by IGC_CC_ACCESS_PKG.GET_ACCESS_LEVEL.
• WF_ITEM_TYPE, WF_ITEM_KEY – workflow correlation.
• ATTRIBUTE1–15, CONTEXT – descriptive flexfield segments.
• ORG_ID – multi-org operating unit discriminator.

Common Use Cases and Queries

Typical scenarios include commitments expiring within a period, commitments awaiting approval, supplier-level commitment exposure, and owner workload analysis. Each query should respect ORG_ID for multi-org security and rely on the access-level column for user-level filtering.

Expiring commitments (using CC_END_DATE):

SELECT cc_num, vendor_name, currency_code, cc_end_date, cc_state
FROM apps.igc_cc_headers_v
WHERE org_id = :p_org_id
AND cc_end_date BETWEEN :p_from_date AND :p_to_date
AND cc_state = 'ACTIVE';

Approval status summary:

SELECT cc_type, cc_apprvl_status, COUNT(*) cc_count
FROM apps.igc_cc_headers_v
WHERE org_id = :p_org_id
GROUP BY cc_type, cc_apprvl_status;

Supplier exposure by currency:

SELECT vendor_name, vendor_site_code, currency_code, cc_num, cc_start_date, cc_end_date
FROM apps.igc_cc_headers_v
WHERE vendor_id = :p_vendor_id
AND cc_state <> 'CANCELLED';

Because several joins are inner joins and the view invokes FND_GLOBAL and IGC_CC_ACCESS_PKG, query performance is best served by filtering on ORG_ID, CC_STATE, and CC_END_DATE, and by initializing the FND session correctly before execution.