Search Results demand_class_id




Overview
Explore in AI Chat

Overview

APPS.EDW_DEMAND_CLASS_FKV is a public Oracle E-Business Suite view owned by the APPS schema that exposes foreign key values for the Demand Class dimension. Its FND Design Data registration (ISC.EDW_DEMAND_CLASS_FKV, MRP.EDW_DEMAND_CLASS_FKV) places it within the Enterprise Data Warehouse (EDW) staging layer used by Oracle's supply chain and order management analytics. The view is documented as VALID in ETRM 12.2.2 and is available across the 12.1.1 and 12.2.2 releases.

The view presents demand class codes as a lookup-based dimension rather than sourcing them from the full transactional Demand Class table. Demand class values originate from the DEMAND_CLASS lookup type, which is maintained through Oracle Application Object Library (FND) lookup codes. As a result, EDW_DEMAND_CLASS_FKV acts as a lightweight, denormalized reference for reporting tools that need to join demand class identifiers to fact tables without traversing the underlying lookup machinery. It is most commonly consumed by Oracle Business Intelligence (OBIEE) and custom ETL processes that populate demand-class dimensions.

Underlying Base Objects

The view is defined over two documented dependencies: APPS.EDW_LOCAL_INSTANCE and APPS.FND_LOOKUP_VALUES. EDW_LOCAL_INSTANCE provides the local instance context used by the EDW views to resolve organization-specific lookup values. FND_LOOKUP_VALUES supplies the actual DEMAND_CLASS lookup codes and their descriptions from the lookup_type = 'DEMAND_CLASS' rows, filtered by the appropriate language and view_application_id.

Because the foreign keys are derived from lookup codes rather than the MTL_DEMAND_CLASS table, the view remains consistent with the FND_DEMAND_CLASS lookup set. The ETRM dependency notes confirm that EDW_DEMAND_CLASS_FKV is not referenced by any other database object; it is a terminal reporting view intended for direct query by external tools.

Key Columns

  • DEMAND_CLASS_FK (VARCHAR2, 61) — The Demand Class foreign key. This value is constructed from lookup code values found in the DEMAND_CLASS lookup type and is the column typically joined to demand class foreign keys stored in EDW fact tables.
  • DEMAND_CLASS_ID (VARCHAR2, 30) — The Demand Class Id. Exposed as a character column so that lookup codes of varying length can be represented uniformly; this differs from the numeric DEMAND_CLASS_ID stored in MTL_DEMAND_CLASS, so implicit data-type conversions should be avoided in joins.

Neither column is documented as mandatory. Consumers should expect the possibility of null or unmapped lookup values where the DEMAND_CLASS lookup set is incomplete for the local instance.

Common Use Cases and Queries

The view is typically used to build or validate a demand class dimension in the EDW, to translate demand class foreign keys on planning or order fact tables into readable labels, and to reconcile the DEMAND_CLASS lookup set against transactional demand class usage.

The simplest usage retrieves the entire documented result set:

SELECT DEMAND_CLASS_FK
     , DEMAND_CLASS_ID
FROM   APPS.EDW_DEMAND_CLASS_FKV;

A reporting query that enriches a demand class dimension for a dashboard might join the view to a fact staging table on DEMAND_CLASS_FK, restricting results to codes present in the current instance. Analysts verifying configuration can compare DISTINCT DEMAND_CLASS_ID values returned here against MTL_DEMAND_CLASS to confirm that every configured demand class has a corresponding lookup code. Because the view is a terminal object with no downstream dependencies, it can be queried freely without impacting concurrent EBS transactions.