Results for “child_organization_id”

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

Overview

PA_REP_ALL_REP_ORG_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) module. As its description states, the view lists the full reporting hierarchy for an operating unit (OU). It exposes the parent-child relationships defined within the reporting organization structure so that the hierarchy can be queried directly in a flattened, denormalized form rather than being reconstructed by consumers through recursive logic.

The view is especially relevant to users searching for parent_org_name, since one of its exposed columns, PARENT_ORG_NAME, surfaces the descriptive name of the parent organization in the reporting hierarchy. This allows reporting tools, concurrent programs, and integration interfaces to resolve an organization's position in the hierarchy and display meaningful names without manually joining the HR organization tables. Because the view is filtered to the reporting use type and constrained to the implementation's active organization structure version, it presents exactly the hierarchy applicable to the OU's current reporting configuration.

Underlying Base Objects

The view text is defined over four referenced objects. PA_ORG_HIERARCHY_DENORM (referenced through the synonym) supplies the denormalized parent and child organization identifiers and the organization use type. PA_IMPLEMENTATIONS provides the operating unit context and the organization structure version identifier that ties the hierarchy to the OU's active implementation. HR_ALL_ORGANIZATION_UNITS_TL is joined twice — once as HR1 to resolve the parent organization name and once as HR2 to resolve the child organization name — with each join restricted by LANGUAGE = USERENV('LANG') so that names are returned in the session's language.

The joins enforce several key conditions: PA_ORG_USE_TYPE = 'REPORTING' restricts the output to reporting hierarchies; POHD.ORG_ID = IMP.ORG_ID scopes the rows to the correct operating unit; and POHD.ORG_HIERARCHY_VERSION_ID = IMP.ORG_STRUCTURE_VERSION_ID ensures the hierarchy version matches the implementation's active structure version. Collectively, these filters guarantee that consumers see only the valid, current reporting hierarchy for the OU.

Key Columns

• PARENT_ORGANIZATION_ID — The unique identifier of the parent organization unit in the reporting hierarchy.
• PARENT_ORG_NAME — The descriptive name of the parent organization, sourced from HR_ALL_ORGANIZATION_UNITS_TL. This is the column most relevant to searches for parent_org_name and provides the human-readable label for the parent node.
• CHILD_ORGANIZATION_ID — The unique identifier of the child organization unit subordinate to the parent in the hierarchy.
• CHILD_ORG_NAME — The descriptive name of the child organization, likewise resolved from HR_ALL_ORGANIZATION_UNITS_TL.

Together these columns form a flat representation of each parent-to-child relationship within the reporting structure.

Common Use Cases and Queries

Typical use cases include reporting on organizational roll-ups, driving approval routing, validating hierarchy assignments, and populating custom reports or extracts that require organization names rather than IDs. A simple query to list the entire reporting hierarchy for the current OU is:

• SELECT parent_org_name, child_org_name FROM apps.pa_rep_all_rep_org_v;
• SELECT parent_organization_id, parent_org_name FROM apps.pa_rep_all_rep_org_v WHERE child_org_name = :child_name;
• SELECT child_org_name FROM apps.pa_rep_all_rep_org_v WHERE parent_org_name = :parent_name;

The first query returns the full parent-child pairing of the reporting hierarchy. The second identifies the parent of a given child organization. The third lists all children under a specified parent, which is useful for drill-down reports. Because the view isolates the reporting use type and the active structure version, these queries require no additional filtering to obtain the correct hierarchy for the operating unit.