Search Results primary_cst_mthd




Overview
Explore in AI Chat

Overview

APPS.EDW_MTL_ILDM_OU_LCV is a reporting-layer view within the Oracle E-Business Suite (EBS) Enterprise Data Warehouse (EDW) schema. In the 12.1.1 and 12.2.2 releases it forms part of the Material/Inventory subject-area data model, delivering a denormalized list of operating units together with the attributes required to distinguish internal from external organizations. The "LCV" suffix denotes a "List of Values" or "Logical Conformed View" construct, indicating that the object is intended to expose a clean, conformed set of operating unit records for downstream OBIEE, EDW, or custom reporting consumers rather than for transactional use. Because it is defined in the APPS schema, it inherits standard EBS security and can be queried by any responsibility with select privileges on the view and its underlying objects.

The view is one of a family of EDW_MTL_ILDM objects that feed the Inventory and Order Management conformed dimensions. The user search term "int_ext_flag" maps directly to the INT_EXT_FLAG column, which is the most frequently used discriminator when reporting must isolate internal operating units from external (supplier, customer, or third-party) organizations in inventory and order sourcing reports.

Underlying Base Objects

According to the ETRM metadata, the view is defined as a thin projection with no joins of its own. The complete view text is:

Consequently the only documented base object is EDW_ORGA_OPER_UNIT_LCV. No further base tables are documented in the ETRM record, so lineage beyond this single EDW view is not exposed in the metadata. The view effectively renames or aliases the parent structure while inserting a literal 'ALL' column, most likely to represent the "all organizations" pseudo-member used in EDW dimensions for drill-down hierarchies. The duplicate reference to LAST_UPDATE_DATE in the select list is a metadata artifact and does not create a functional difference.

Key Columns

  • OPERATING_UNIT_PK — Surrogate primary key for the operating unit in the EDW dimension; used for joins to fact tables.
  • OPERATING_UNIT_DP — Descriptive attribute or display value for the operating unit.
  • NAME — Operating unit name as reported in LOVs and reports.
  • BUSINESS_GROUP — Human resources business group to which the operating unit belongs.
  • DATE_FROM / DATE_TO — Effective dating window, enabling type-2 slowly changing dimension queries.
  • INT_EXT_FLAG — Internal versus external organization flag; the column most commonly filtered or grouped in sourcing and inventory reporting.
  • ORG_TYPE / ORG_CODE — Classification of the organization (for example inventory organization, operating unit) and its short code.
  • PRIMARY_CST_MTHD — Primary costing method (Standard, Average, FIFO, etc.) associated with the organization.
  • INSTANCE — Source EBS instance identifier, supporting multi-instance EDW consolidation.
  • USER_ATTRIBUTE1–5 — Descriptive flexfield or extensibility attributes for client-specific reporting needs.
  • LAST_UPDATE_DATE — Timestamp used for incremental extract and change-data detection.

Common Use Cases and Queries

Typical usage includes source-system identification of operating units, filtering of internal versus external organizations for intercompany reporting, and population of LOVs in EDW dashboards.

  • List all internal operating units:
    SELECT NAME, ORG_CODE, PRIMARY_CST_MTHD FROM APPS.EDW_MTL_ILDM_OU_LCV WHERE INT_EXT_FLAG = 'I';
  • Retrieve current operating units by business group:
    SELECT BUSINESS_GROUP, NAME, DATE_FROM, DATE_TO FROM APPS.EDW_MTL_ILDM_OU_LCV WHERE SYSDATE BETWEEN DATE_FROM AND NVL(DATE_TO, SYSDATE);
  • Incremental extraction of changed records:
    SELECT OPERATING_UNIT_PK, INT_EXT_FLAG, LAST_UPDATE_DATE FROM APPS.EDW_MTL_ILDM_OU_LCV WHERE LAST_UPDATE_DATE >= :last_run;
  • Distinguish internal from external organizations for sourcing analysis:
    SELECT ORG_TYPE, INT_EXT_FLAG, COUNT(*) FROM APPS.EDW_MTL_ILDM_OU_LCV GROUP BY ORG_TYPE, INT_EXT_FLAG;

Because the view exposes surrogate keys and effective dates, it is well suited to star-schema joins in the EDW layer, while its INT_EXT_FLAG makes it the reference object of choice whenever the search term "int_ext_flag" is used in inventory and order management reporting.