Results for “parent_organization_name”

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

Overview

PA_REP_COMP_REP_ORG_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) product family. Its documented purpose is to expose the reporting organization List of Values (LOV) used within competence reports. In Oracle EBS 12.1.1 and 12.2.2, competence reporting relies on the reporting hierarchy defined for an operating unit, and this view distills that hierarchy into a flattened, ready-to-query form for reporting organization selection and display.

The view returns parent and child organization identifiers together with their translated names, plus a flag indicating whether child (sub) organizations should be included. Because it resolves translated organization names at query time, it is well suited to LOV construction and concurrent report extraction, where users expect to see human-readable organization names rather than internal numeric identifiers. The object is registered as VALID in the ETRM metadata, confirming it is a supported, compiled view rather than a standalone table.

Underlying Base Objects

The view is defined over three documented referenced objects:

• PA_ORG_HIERARCHY_DENORM (synonym) — the denormalized reporting hierarchy source that supplies parent and child organization relationships, the reporting use type, the org identifier, and the hierarchy version.
• PA_IMPLEMENTATIONS (synonym) — supplies the current implementation's ORG_ID and ORG_STRUCTURE_VERSION_ID, binding the hierarchy rows to the active organization structure version.
• PA_EXPENDITURES_UTILS (package) — a PL/SQL utility package whose GETORGTLNAME function resolves organization names in the current language, providing the translated PARENT_ORGANIZATION_NAME and CHILD_ORGANIZATION_NAME columns.

The join logic filters rows to those where PA_ORG_USE_TYPE equals 'REPORTING', matches the hierarchy's ORG_ID to the implementation ORG_ID using NVL handling for nulls, and constrains ORG_HIERARCHY_VERSION_ID to the implementation's ORG_STRUCTURE_VERSION_ID. This ensures only the active reporting hierarchy for the current operating unit is surfaced.

Key Columns

• PARENT_ORGANIZATION_ID — identifier of the parent reporting organization.
• PARENT_ORGANIZATION_NAME — translated name of the parent organization, resolved via PA_EXPENDITURES_UTILS.GETORGTLNAME.
• CHILD_ORGANIZATION_ID — identifier of the child (sub) organization; this is the column users search for as "child_organization_name" context.
• CHILD_ORGANIZATION_NAME — translated name of the child organization, also resolved through GETORGTLNAME.
• INCLUDE_SUB_ORGANIZATIONS — a DECODE-derived flag returning 'N' when the parent and child organization identifiers are equal (the organization maps to itself), and 'Y' otherwise, indicating that subordinate organizations are in scope.

Common Use Cases and Queries

The view is typically consumed to populate a reporting organization LOV in competence report parameters, to display organization names on report output, and to determine whether a selected organization should expand to include its subordinates. A representative query retrieving child organizations and their inclusion flag is:

• SELECT child_organization_id, child_organization_name, include_sub_organizations FROM pa_rep_comp_rep_org_v;
• SELECT parent_organization_name, child_organization_name FROM pa_rep_comp_rep_org_v WHERE include_sub_organizations = 'Y';
• SELECT child_organization_name FROM pa_rep_comp_rep_org_v WHERE child_organization_id = :p_org_id;

Because organization names are resolved through a PL/SQL function call, queries returning large result sets can incur per-row function overhead; filtering on organization identifiers or the inclusion flag before name retrieval typically improves performance. Access is granted through the APPS schema, and standard EBS security and MOAC (Multi-Org Access Control) considerations apply, as the view honors the implementation's ORG_ID binding.