Results for “co_code”

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

Overview

PMIBV_ORGANIZATION_V is an APPS-owned read-only view within the Oracle E-Business Suite, classified under the Process Manufacturing Intelligence (PMI) product module, which is marked as obsolete in the ETRM 12.2.2 documentation. The view exposes Process Manufacturing organization records, presenting a filtered and denormalized read interface over the underlying organization master data. It is a Business View (indicated by the "BV" segment in its name) and carries VALID status in the ETRM metadata registry.

Because it is a database view rather than a table, PMIBV_ORGANIZATION_V holds no data of its own; it presents rows sourced from SY_ORGN_MST. Its principal role is to provide reporting and integration consumers with a clean, restricted projection of Process Manufacturing organizations without exposing the full column set or row population of the base master table. The view is defined with a WITH READ ONLY clause, ensuring that no DML can be issued against it and that all access is strictly query-only.

Underlying Base Objects

The view is defined over a single documented base object: SY_ORGN_MST, referenced in the view text through the alias ORGMASTER and exposed to the APPS schema as a synonym. The definition applies one filtering predicate, ORGMASTER.DELETE_MARK = 0, which excludes soft-deleted organization records from the result set. This deletion-marker filter is the only row-level restriction in the view text; no joins, unions, or aggregate operations are documented.

Column-level projection maps directly from SY_ORGN_MST to the view without transformation or expression-based derivation. As a synonym-backed reference, SY_ORGN_MST remains the authoritative source of truth, and any change to the base table's data is immediately reflected in query results from PMIBV_ORGANIZATION_V.

Key Columns

• ORGN_CODE — The organization code, the primary business identifier for a Process Manufacturing organization.
• ORGN_NAME — The descriptive name of the organization.
• PARENT_ORGN_CODE — The organization code of the parent organization, establishing the organizational hierarchy. This is the column most frequently referenced in user searches, including the query "parent_orgn_code".
• PLANT_IND — Indicator denoting whether the organization functions as a plant.
• POC_IND — Process Organization Code indicator, distinguishing Process Manufacturing organizations.
• CO_CODE — The company code associated with the organization.
• TAXLOC_CODE — The tax location code applicable to the organization.
• ADDR_ID — Foreign key to the organization's address record.
• ORGANIZATION_ID — The internal numeric identifier of the organization, typically the join key to Inventory Organization and other EBS entities.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard EBS audit columns recording record creation and last modification.

Common Use Cases and Queries

The view is most commonly used to resolve Process Manufacturing organizational hierarchies and to identify parent-child relationships between organizations. A frequent pattern is a self-join on PARENT_ORGN_CODE to ORGN_CODE to flatten the hierarchy for reporting.

Retrieve all active Process Manufacturing organizations:

SELECT orgn_code, orgn_name, parent_orgn_code, plant_ind
FROM   apps.pmibv_organization_v
ORDER BY orgn_code;

Resolve parent organization names for each child organization:

SELECT child.orgn_code, child.orgn_name,
       child.parent_orgn_code, parent.orgn_name AS parent_orgn_name
FROM   apps.pmibv_organization_v child,
       apps.pmibv_organization_v parent
WHERE  child.parent_orgn_code = parent.orgn_code(+);

Locate organizations belonging to a specific company and tax location:

SELECT orgn_code, orgn_name, organization_id
FROM   apps.pmibv_organization_v
WHERE  co_code = :company_code
AND    taxloc_code = :tax_location;

Given the module's obsolete status, consumers migrating off PMI functionality should validate whether equivalent organization data is available from current Process Manufacturing or Inventory organization views before building new dependencies on PMIBV_ORGANIZATION_V.