Search Results warehouse_pk_key




Overview
Explore in AI Chat

Overview

The view EDW_PMI_PMIL_PWHS_LTC_IV belongs to the Process Manufacturing Intelligence (PMI) product family within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is an interface view ("_IV") that exposes warehouse-level reference data in a denormalized form suitable for consumption by the Enterprise Data Warehouse (EDW) and downstream analytical or integration processes. The view is derived directly from the base object EDW_PMI_PMIL_PWHS_LTC, reorganizing and renaming selected columns to provide stable, reporting-friendly identifiers.

Per the documented metadata, this view is not implemented in this database, meaning it is a seeded definition that may remain dormant until a PMI/EDW implementation activates the relevant process manufacturing schemas. Its principal role is to publish warehouse master data—organization context, warehouse identifiers, descriptive attributes, and surrogate keys—for extraction by external reporting layers.

Underlying Base Objects

The view is defined exclusively over EDW_PMI_PMIL_PWHS_LTC. No other referenced base tables or objects are documented in the ETRM metadata. The relationship is a straightforward projection: every column in the view originates from the base object, with two notable derivations:

Because the view is not materialized and introduces no joins, it inherits the row cardinality and organizational partitioning of the base object. Deployments relying on this view should confirm that the underlying _LTC object has been populated by the relevant PMI load before querying.

Key Columns

The view exposes sixteen columns. The most significant, particularly given the search term ORGANIZATION_FK_KEY, are described below:

  • ORGANIZATION_FK — Foreign key to the operating unit or organization, typically matching ORG_ID semantics.
  • ORGANIZATION_FK_KEY — The surrogate/warehouse key generated for the organization foreign key, used for dimensional joins in the EDW star schema.
  • WAREHOUSE_PK and WAREHOUSE_PK_KEY — The warehouse primary key and its corresponding generated surrogate key.
  • WAREHOUSE, NAME, DESCRIPTION, INSTANCE_CODE — Descriptive warehouse and instance attributes.
  • USER_ATTRIBUTE1 through USER_ATTRIBUTE5 — Flexible descriptor columns; the fifth is repurposed as OPERATION_CODE.
  • WAREHOUSE_DP — Warehouse data-processing or descriptive-purpose indicator.
  • ROW_ID — Row identifier derived from WAREHOUSE_PK_ROWID, useful for incremental extraction.

Common Use Cases and Queries

The view is typically queried to load warehouse dimensions into an EDW, to reconcile organization-to-warehouse relationships, or to join surrogate keys against fact tables. A representative query isolating the organization surrogate key is:

  • SELECT ORGANIZATION_FK, ORGANIZATION_FK_KEY, WAREHOUSE, NAME FROM EDW_PMI_PMIL_PWHS_LTC_IV WHERE ORGANIZATION_FK = :p_org_id;
  • SELECT ORGANIZATION_FK_KEY, WAREHOUSE_PK_KEY, OPERATION_CODE FROM EDW_PMI_PMIL_PWHS_LTC_IV ORDER BY ORGANIZATION_FK_KEY;
  • Incremental extraction via ROW_ID: SELECT * FROM EDW_PMI_PMIL_PWHS_LTC_IV WHERE ROW_ID > :last_rowid;

These patterns support ETL staging, dimensional loading, and cross-validation of warehouse hierarchies across the process manufacturing landscape.