Search Results parent_account_line_number




Overview
Explore in AI Chat

Overview

IGCFV_CC_REL_DET_PAY_FORECASTS is a read-only Oracle EBS view owned by the APPS schema that exposes the relationship between detail-level payment forecasts (pay forecasts) and their parent records within the Oracle Project Contracts (IGC) subsystem. The view is part of the Contracts Core module, which supports billing, revenue, and payment forecasting for contract lines and their associated account hierarchies. Its purpose is to flatten the parent-child linkage between a detail pay forecast and the corresponding parent account line and parent detail pay forecast, making it possible to report on release-level forecasts alongside their parent context without repeatedly joining the underlying tables.

The view predates the newer Project Contracts table structures and is preserved across both 12.1.1 and 12.2.2 for backward compatibility with existing reports, extracts, and integrations. It returns only rows where both PARENT_ACCT_LINE_ID and PARENT_DET_PF_LINE_ID are populated, meaning it effectively filters to forecast records that have a defined parent — typically generated through the pay forecast generation and parent roll-up processes.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through APPS synonyms:

  • IGC_CC_DET_PF — the detail pay forecast table, aliased as CCDPF for the release row and CCDPFP for the parent row.
  • IGC_CC_ACCT_LINES — the contract account lines table, aliased as IGCCAL for the release account line and IGCCALP for the parent account line.

The join logic links each detail pay forecast to its account line via CC_ACCT_LINE_ID, and self-joins to the parent record through PARENT_ACCT_LINE_ID = IGCCALP.CC_ACCT_LINE_ID and PARENT_DET_PF_LINE_ID = CCDPFP.CC_DET_PF_LINE_ID. The WITH READ ONLY clause the view carries confirms it is intended strictly for query access rather than DML.

Key Columns

The view surfaces identifiers, amounts, dates, and audit columns. Notable columns include:

Common Use Cases and Queries

Typical uses include reporting on parent-child pay forecast hierarchies, reconciling billed versus unbilled amounts across contract levels, and validating that parent account lines are correctly assigned. A representative query:

  • SELECT release_detail_pf_line_number, parent_account_line_number, rel_det_pf_functional_amount FROM apps.igcfv_cc_rel_det_pay_forecasts WHERE release_account_line_number = :line_num;
  • SELECT parent_account_line_number, SUM(rel_det_pf_billed_amount) FROM apps.igcfv_cc_rel_det_pay_forecasts GROUP BY parent_account_line_number;

Because the view is read-only and pre-joined, it is suitable for ad hoc SQL and custom concurrent program extracts without additional join logic.