Results for “plant_ind”

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

Overview

PMIFV_ORGANIZATION_V is a read-only view owned by the APPS schema in Oracle E-Business Suite. It belongs to the PMI – Process Manufacturing Intelligence product family, a module that is now marked Obsolete in Release 12.1.1 and 12.2.2. The view is documented in ETRM with a status of VALID and is described simply as "Process Manufacturing Organizations." Its purpose is to expose the master list of process manufacturing organizations defined in the legacy SY_ORGN_MST organization master, together with selected parent-organization attributes, in a form suitable for reporting and integration consumers.

In practical terms, PMIFV_ORGANIZATION_V acts as a denormalized, filtered access layer over the organization master. It does not present inventory organization data from the standard HR/INV tables; instead it reflects the process manufacturing organization model once used by the PMI/OPM stack. The POC_IND column the searcher referenced is one of the process-organization control indicators exposed here and is central to identifying which organizations are flagged for process manufacturing operations.

Underlying Base Objects

The view text references a single documented base object, SY_ORGN_MST, which is accessed in the APPS schema through a synonym. The FROM clause lists SY_ORGN_MST twice, aliased as ORGMASTER and PARENTORG, joined on the condition that ORGMASTER.ORGN_CODE equals PARENTORG.ORGN_CODE.

Because both aliases point at the same physical table and are joined on the same column, this is effectively a self-join that returns the parent organization name (PARENTORG.ORGN_NAME) alongside the organization row. The WHERE clause applies DELETE_MARK = 0 to both aliases, excluding logically deleted organization records. The definition ends with WITH READ ONLY, so no DML is possible through the view. Consumers should treat PMIFV_ORGANIZATION_V strictly as a query surface over SY_ORGN_MST rather than as an independent data store.

Key Columns

• ORGN_CODE – The organization code that uniquely identifies a process manufacturing organization and serves as the self-join key.
• ORGN_NAME – The descriptive name of the organization.
• PLANT_IND – Indicator of whether the organization represents a plant.
• POC_IND – The process organization control indicator. This column is likely the object of the "poc_ind" search and is used to determine whether the organization participates in process manufacturing functionality.
• TAXLOC_CODE – Tax location code associated with the organization.
• PARENT_ORGN_CODE – The code of the parent organization in the hierarchy.
• PARENT_ORGN_NAME – The parent organization name, sourced from the PARENTORG alias.
• CO_CODE – Company code linkage.
• ADDR_ID – Address identifier for the organization location.
• ORGANIZATION_ID – The organization identifier, which can be used to join to other EBS organization-related data.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY – Standard audit columns reflecting record creation and last modification.

Common Use Cases and Queries

The view is primarily used for reporting and integration that requires a list of active process manufacturing organizations and their parent hierarchy. Because POC_IND is exposed, a frequent pattern is filtering to organizations flagged for process operations.

To list active process organizations and their parents:

SELECT organization_id,
       orgn_code,
       orgn_name,
       poc_ind,
       parent_orgn_code,
       parent_orgn_name
FROM   apps.pmifv_organization_v
WHERE  poc_ind = 'Y'
ORDER  BY orgn_name;

To examine the hierarchy for a specific plant:

SELECT orgn_code, orgn_name, plant_ind, parent_orgn_name
FROM   apps.pmifv_organization_v
WHERE  plant_ind = 'Y';

To enumerate all organizations with audit information for reconciliation:

SELECT orgn_code, orgn_name, co_code, addr_id,
       last_update_date, last_updated_by
FROM   apps.pmifv_organization_v;

Because the object is READ ONLY and PMI is obsolete, new development should migrate toward the supported inventory organization views; existing PMI reports and interfaces continue to rely on PMIFV_ORGANIZATION_V for organization lookups and process-plant reporting.