Search Results opm_company_code

Overview

EDW_MTL_ILDM_PCMP_LCV is an Oracle EBS 12.1.1 / 12.2.2 view owned by the APPS schema in the OPI (Operations Intelligence) product family. It serves as the source view for the Inventory Organization Parent Group level of the Inventory Locator dimension. In ETRM terminology, "PCMP" denotes the parent company (organization parent group) level, while "ILDM" identifies the Inventory Locator dimension. The view materializes a conformed parent-group identifier (OPM_COMPANY_PK) used by Oracle's embedded data warehouse and Operations Intelligence reporting to consolidate inventory data across operating units and inventory organizations.

The view is central to users searching on OPERATING_UNIT_FK, because it deliberately exposes that column to link each parent-group record back to the operating unit context from which it originated. This makes it the natural bridging object between operating-unit-scoped inventory reporting and organization-level parent group dimension reporting.

Underlying Base Objects

Despite ETRM documenting no referenced base objects, the view text reveals a UNION ALL-style definition joining three named sources:

• SY_ORGN_MST (alias O): the master organization/company source providing ORGN_CODE, ORGN_NAME, and audit columns.
• GL_PLCY_MST (alias PM): a policy master joined on CO_CODE to resolve ORG_ID used in the OPERATING_UNIT_FK DECODE.
• EDW_LOCAL_INSTANCE (alias I): supplies INSTANCE_CODE to build the instance-qualified keys.
• EDW_MTL_ILDM_OU_LCV (alias O, second branch): supplies operating-unit rows, reusing user attribute and audit columns and appending the '-OU' suffix to the primary key.

The first branch yields OPM company-level rows (with OPERATING_UNIT_FK derived via the DECODE on PM.ORG_ID), while the second yields operating-unit rows from the OU level of the same locator dimension.

Key Columns

• OPM_COMPANY_PK: concatenation of organization code, instance code, and a literal, uniquely identifying a parent group or OU record.
• INSTANCE_CODE: the EDW instance qualifier for multi-instance warehouses.
• OPERATING_UNIT_FK: the operating unit foreign key; the primary target of the user's search and the join key to operating-unit dimensions.
• OPM_COMPANY_CODE / OPM_COMPANY_NAME / DESCRIPTION: business identifiers and descriptive text.
• OPM_COMPANY_DP: dimension description label, e.g., "INVENTORY ORGANIZATION PARENT GROUP" or "ALL INVENTORY ORGANIZATION PARENT GROUPS."
• NAME: display name for the parent group record.
• CREATION_DATE / LAST_UPDATE_DATE: audit columns for incremental extraction.
• USER_ATTRIBUTE1..5: reserved flexible attribute slots, null in the company branch and populated from the OU-level view in the second branch.

Common Use Cases and Queries

This view is typically queried during EDW dimension loading, in Operations Intelligence dashboards, and in ad hoc reconciliation of operating units to parent groups. Common patterns include:

• Resolving OPERATING_UNIT_FK for a given organization code.
• Enumerating all parent groups within a specific instance.
• Joining to fact tables such as inventory locator facts on OPM_COMPANY_PK.

Sample query:

SELECT opm_company_pk,
       operating_unit_fk,
       opm_company_code,
       opm_company_name,
       opm_company_dp
  FROM apps.edw_mtl_ildm_pcmp_lcv
 WHERE instance_code = :instance
   AND operating_unit_fk = :org_id;

For incremental extraction, filter on last_update_date > :last_run. Because the second UNION branch derives rows from EDW_MTL_ILDM_OU_LCV, callers must deduplicate or filter by OPM_COMPANY_DP when only true parent-group rows are required.