Results for “immediate_parent_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASF_OPP_CHN_FRCST_MV is a materialized view owned by APPS within the ASF — Sales Online product family of Oracle E-Business Suite. It exists to expose opportunity forecast data at a channel level, combining leads, sales groups, product categorization, and credit-related identifiers into a single queryable structure. The object is documented in the ETRM physical schema for release 12.1.1, where it is recorded as consisting of seventeen columns. Notably, the implementation note states that the object is "not implemented in this database," indicating that it may only be instantiated conditionally — depending on the deployment of specific ASF Sales Online modules or patches — and that its presence in a given environment should not be assumed.

In Data Vault terms, the mined FK structure classifies this object heuristically as standalone. That classification suggests the object is best treated as a satellite-like or derived construct rather than as a true integrating hub or link: it does not act as the focal point of a star of foreign key dependencies in the mined graph. Practically, this means it should be consumed primarily as a reporting and aggregation surface rather than as a master entity for downstream relational modeling.

Key Information Stored

Because this is a materialized view rather than a base table, the column list reflects a projection over upstream transactional tables. The most significant columns documented are:

• LEAD_ID — the principal business identifier linking the forecast row back to the originating lead record. It participates in a foreign key relationship to AS_LEADS_ALL and is the natural join key for most reporting queries.
• LEADS — a denormalized or descriptive lead attribute, likely a concatenated or derived lead label, supporting user-facing list displays without an additional join.
• CHANNEL_CODE — identifies the sales channel through which the opportunity or lead originated, enabling channel-level forecast rollups.
• BUDGET — the forecasted or budgeted monetary amount associated with the opportunity.
• CURRENCY_CODE — the currency in which the BUDGET value is denominated; critical for multi-currency consolidation.
• CONVERSION_STATUS_FLAG — indicates whether the underlying lead has been converted, a common filter predicate in funnel reporting.
• SALES_GROUP_ID and SALESFORCE_ID — organizational dimensions identifying the responsible sales group and the individual salesperson record (with SALESFORCE_ID carrying a foreign key to AS_SALESFORCE).
• CREDIT_TYPE_ID — credit classification, with a foreign key to IGS_FI_CR_TYPES_ALL, linking forecast data to credit type definitions.
• PARENT_GROUP_ID and IMMEDIATE_PARENT_FLAG — together supporting hierarchical rollup of forecast values through the sales organization tree.
• PRODUCT_CATEGORY_ID and PRODUCT_CAT_SET_ID — product categorization dimensions used to slice forecasts by offering.
• PERIOD_NAME — the accounting or forecast period to which the row belongs, the primary time dimension.
• WIN_LOSS_INDICATOR, OPP_OPEN_STATUS_FLAG, and FORECAST_ROLLUP_FLAG — status and behavioral flags governing how the row is interpreted in pipeline, win/loss, and rollup analytics.

The metadata does not document a single-column surrogate primary key or unique index for this object, which is consistent with its nature as a materialized view. BUSINESS key candidates, to the extent they are required, would be composite — typically LEAD_ID combined with PERIOD_NAME and the relevant organizational or product dimensions.

Common Use Cases and Queries

The primary use cases center on channel forecast reporting, pipeline analysis, and sales organization rollups. A typical aggregation query groups forecast budgets by period and channel:

• SELECT PERIOD_NAME, CHANNEL_CODE, SUM(BUDGET) FROM ASF_OPP_CHN_FRCST_MV WHERE CONVERSION_STATUS_FLAG = 'Y' GROUP BY PERIOD_NAME, CHANNEL_CODE;
• Win/loss analysis using WIN_LOSS_INDICATOR alongside OPP_OPEN_STATUS_FLAG to distinguish closed-won from open pipeline.
• Organizational rollup constrained by IMMEDIATE_PARENT_FLAG = 'Y' to avoid double-counting parent and child group rows.
• Product-category forecasting joined to product master data via PRODUCT_CATEGORY_ID and PRODUCT_CAT_SET_ID.

Because the object is a materialized view, report authors should confirm refresh frequency and staleness characteristics before using it for time-sensitive pipeline reporting.

Related Objects

The documented foreign key relationships identify the most significant associated objects:

• AS_LEADS_ALL — joined on ASF_OPP_CHN_FRCST_MV.LEAD_ID = AS_LEADS_ALL.LEAD_ID; the primary upstream source of lead and opportunity data.
• IGS_FI_CR_TYPES_ALL — joined on CREDIT_TYPE_ID; supplies credit type descriptions and classifications.
• AS_SALESFORCE — joined on SALESFORCE_ID; provides the salesperson or sales resource dimension.

Beyond these FK-documented relationships, the sales group, parent group, and product category columns imply dependencies on the ASF sales organization hierarchy and product category definition tables, which are the natural targets for the organizational and product rollup use cases described above.