Search Results cc_pf_id

Overview

IGC_CC_CLOSED_CANC_HDRS_V is an APPS-owned database view in the Oracle E-Business Suite IGC (Grants/Contracts) module. It exposes a filtered list of award or contract headers that have reached a terminal state — specifically, records whose Credit Card (CC) header state is either "Closed" (CL) or "Cancelled" (CT) and whose approval status is "Approved" (AP). The view surfaces the credit card number alongside related accounting and payment/detail lines, together with the most recent activity date recorded against each header.

Because it narrowly filters on terminal states and approval status, the view is intended for reporting and reconciliation use rather than as a transactional data source. It is commonly referenced in audit queries, period-close reports, and integration extracts that need to enumerate completed awards or cancelled contracts with their associated line-level detail.

Underlying Base Objects

The view is defined over four documented objects:

• IGC_CC_HEADERS (SYNONYM) — the primary header table, aliased ICH. Provides cc_header_id, cc_num, cc_state, and cc_apprvl_status.
• IGC_CC_HDRS_MAX_DATES_V (VIEW) — aliased DATE_V; supplies the maximum activity date (max_activity_date) per header and the cc_hdr_id join key.
• IGC_CC_ACCT_LINES (SYNONYM) — aliased ICAL; the accounting line table, providing cc_acct_line_id and linking back to the header.
• IGC_CC_DET_PF (SYNONYM) — aliased ICDP; the detail/payment-format line table, providing cc_det_pf_line_id.

The join path is ICH → DATE_V on cc_header_id, DATE_V → ICAL on cc_header_id, and ICAL → ICDP on cc_acct_line_id. Only headers meeting the state and approval filters survive, and each qualifying header fans out across its accounting and detail lines.

Key Columns

• CC_HD_ID (from ICH.cc_header_id / DATE_V.cc_hdr_id) — the unique header identifier.
• CC_NUM_VAL (from ICH.cc_num) — the credit card or award number, exposed under the alias matching the user search term "cc_num_val".
• CC_ACT_ID (from ICAL.cc_acct_line_id) — the accounting line identifier associated with the header.
• CC_PF_ID (from ICDP.cc_det_pf_line_id) — the detail payment-format line identifier.
• MAX_DT (from DATE_V.max_activity_date) — the most recent activity date recorded for the header, useful for ageing and recency analysis.

Common Use Cases and Queries

Typical scenarios include auditing all approved, closed or cancelled awards within a date range, and reconciling credit card numbers against their accounting and payment-format lines.

Sample query to list closed/cancelled approved headers with their maximum activity date:

SELECT cc_hd_id,
       cc_num_val,
       cc_act_id,
       cc_pf_id,
       max_dt
FROM   apps.igc_cc_closed_canc_hdrs_v
WHERE  max_dt >= :p_from_date
ORDER  BY max_dt DESC;

To locate a specific card by number:

SELECT cc_hd_id, cc_num_val, max_dt
FROM   apps.igc_cc_closed_canc_hdrs_v
WHERE  cc_num_val = :p_cc_num;

Because the view performs inner joins across header, accounting, and detail lines, consumers should apply the appropriate ORG_ID and security predicates and expect multiple rows per header when multiple lines exist.