Search Results igc_cc_state




Overview
Explore in AI Chat

Overview

APPS.IGC_CC_ROUTING_CTRLS_V is a reporting and integration view in the Oracle E-Business Suite IGC (Contracts) module. It exposes the routing control configuration for Contract Commitment (CC) approval processing, resolving the internal code values stored in the base table into their user-facing lookup meanings. In Oracle EBS 12.1.1 and 12.2.2, this view is deployed under the APPS schema and is typically consumed by forms, concurrent programs, and external integrations that must determine which approval path, workflow process, and preparation privileges apply to a given combination of contract commitment type and commitment state.

The view is of particular interest to developers investigating the IGC_CC_STATE lookup, since it joins the base routing control row to FND_LOOKUPS twice — once for the commitment type and once for the commitment state — thereby surfacing the descriptive meaning of CC_STATE alongside the code itself. It is a read-only view; all maintenance is performed against the underlying table through the standard Contracts setup forms.

Underlying Base Objects

The view is defined over three referenced base objects documented in the ETRM metadata: the synonym IGC_CC_ROUTING_CTRLS, and two instances of the FND_LOOKUPS view, aliased F1 and F2. A fourth object, the package FND_GLOBAL, is referenced through the view's dependency chain and supplies the runtime organization context (ORG_ID) used by multi-org enabled queries.

  • IGC_CC_ROUTING_CTRLS — the driving table holding one row per organization, commitment type, and commitment state, with the approval routing configuration and auditable WHO columns.
  • FND_LOOKUPS (F1) — joined on LOOKUP_TYPE = 'IGC_CC_TYPE' and LOOKUP_CODE = ICRC.CC_TYPE, supplying the commitment type meaning.
  • FND_LOOKUPS (F2) — joined on LOOKUP_TYPE = 'IGC_CC_STATE' and LOOKUP_CODE = ICRC.CC_STATE, supplying the commitment state meaning.

Because both joins are inner joins on FND_LOOKUPS, a routing control row is returned only when valid, enabled lookup values exist for both its commitment type and its commitment state. Rows referencing obsolete or disabled lookup codes are therefore filtered out of the view.

Key Columns

  • ROWID — the physical row identifier of the base table row, allowing the view to be used in update-capable block contexts.
  • ORG_ID — the operating unit or organization identifier, enabling multi-org filtering.
  • CC_TYPE and its MEANING — the commitment type code and its decoded description from the IGC_CC_TYPE lookup.
  • CC_STATE and its MEANING — the commitment state code and its decoded description from the IGC_CC_STATE lookup, the column most commonly targeted when searching for commitment lifecycle status.
  • CC_CAN_PRPR_APPRV_FLAG — indicates whether the preparer may also act as approver for commitments in this state.
  • CC_CAN_PRPR_ENCMBR_FLAG — indicates whether the preparer may encumber commitments in this state.
  • WF_APPROVAL_ITEMTYPE and WF_APPROVAL_PROCESS — the Oracle Workflow item type and process invoked for approval routing.
  • DEFAULT_APPROVAL_PATH_ID — the default approval path definition applied to this type/state combination.
  • LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATION_DATE, LAST_UPDATED_BY, CREATED_BY — standard WHO audit columns.

Common Use Cases and Queries

Typical uses include validating the approval configuration for a commitment state, diagnosing why an approval workflow did not launch, and reporting on which commitment types permit preparer self-approval.

  • Listing all configured routing controls with decoded type and state meanings: 
    SELECT cc_type, meaning_type, cc_state, meaning_state,
       cc_can_prpr_apprv_flag, wf_approval_process
FROM   apps.igc_cc_routing_ctrls_v
WHERE  org_id = :p_org_id;
  • Filtering by a specific commitment state code: 
    SELECT cc_type, meaning_type, wf_approval_itemtype, wf_approval_process
FROM   apps.igc_cc_routing_ctrls_v
WHERE  cc_state = 'ACTIVE';
  • Identifying configurations that permit preparer approval: 
    SELECT org_id, cc_type, cc_state
FROM   apps.igc_cc_routing_ctrls_v
WHERE  cc_can_prpr_apprv_flag = 'Y';

All queries should apply an ORG_ID predicate when operating in a multi-org environment, consistent with the view's exposure of ORG_ID from the base routing control table.