Search Results parent_org_name




Overview
Explore in AI Chat

Overview

APPS.PA_PROJ_ORG_STRUCTURES_V is a supplementary Oracle EBS view in the Projects (PA) module that flattens the hierarchical relationship between organizations assigned within a project organization structure. Its primary purpose is to simplify Forms coding by exposing parent-child organization relationships in a single denormalized result set, avoiding the multi-table joins that would otherwise be required against the HR organization tables and the project organization structure elements table. The view is owned by APPS and carries FND Design Data reference PA.PA_PROJ_ORG_STRUCTURES_V. Its status is VALID in 12.1.1 and 12.2.2.

Oracle explicitly warns that this is a supplementary view intended for internal Forms use and does not recommend querying or altering data through it, because its definition may change dramatically in subsequent minor or major releases. Report developers who depend on it should be aware of this stability caveat. The view is not referenced by any other database object, confirming its role as a terminal presentation layer rather than a reusable dependency.

Underlying Base Objects

The view draws from a combination of HR and PA objects. The HR side supplies organization identity and hierarchy: HR_ALL_ORGANIZATION_UNITS_TL (an APPS synonym providing translated organization names), HR_ORGANIZATION_UNITS and HR_ORG_UNITS_NO_JOIN (views), and HR_ORGANIZATION_INFORMATION (synonym) for organization classifications and attributes. Hierarchy composition is resolved through PER_ORG_STRUCTURE_ELEMENTS, which stores the parent-child edges of an organization hierarchy version. Project context is supplied by PA_IMPLEMENTATIONS, used to scope the query to the correct operating unit and business group. Two packaged PL/SQL objects, HR_GENERAL and HR_SECURITY, are invoked to apply organization and security resolution rules. DUAL is used structurally within the query. Names of organizations are resolved through the translated table via the HR_ALL_ORGANIZATION_UNITS_TL synonym, which is why the view returns a ready-to-display ORGANIZATION_NAME rather than requiring a separate lookup.

Key Columns

  • ORG_ID (NUMBER 15): The operating unit / organization identifier that scopes the row.
  • BUSINESS_GROUP_ID (NUMBER 15): The HR business group to which the organization belongs.
  • ORGANIZATION_ID (NUMBER 15): The child organization in the structure.
  • PARENT_ORG_ID (NUMBER 15): The parent organization identifier for the child row. This is the column most commonly targeted by users searching for "parent_org_id" in the context of project organization hierarchies.
  • ORGANIZATION_NAME (VARCHAR2 240): Translated display name of the child organization.
  • PARENT_ORG_NAME (VARCHAR2 240): Translated display name of the parent organization.
  • ORG_STRUCTURE_VERSION_ID (NUMBER): Identifies the specific hierarchy version the relationship belongs to, allowing the same organization to appear under different parents across versions.
  • PROJECT_ORG_FLAG (CHAR): Indicator distinguishing project organizations from other organization types returned by the underlying HR structure.

Common Use Cases and Queries

Typical usage includes reporting on the reporting lines between project organizations, rendering hierarchy trees in custom Forms or OAF pages, and validating that a specific child organization has the expected parent before applying project setup or security assignments. Because PARENT_ORG_ID and ORGANIZATION_ID reference HR organization units, it is often joined to HR_ORGANIZATION_UNITS or to project setup tables such as PA_PROJECTS_ALL for downstream reporting. A basic query returns all organization pairs for a given operating unit:

SELECT organization_id, parent_org_id, organization_name, parent_org_name, org_structure_version_id, project_org_flag FROM apps.pa_proj_org_structures_v WHERE org_id = :p_org_id ORDER BY parent_org_id, organization_id;

To find the parent of a specific organization:

SELECT organization_id, parent_org_id, parent_org_name FROM apps.pa_proj_org_structures_v WHERE organization_id = :p_organization_id AND org_structure_version_id = :p_version;

To list only the top-level project organizations (those with no parent in the structure):

SELECT organization_id, organization_name FROM apps.pa_proj_org_structures_v WHERE parent_org_id IS NULL AND project_org_flag = 'Y';

Given the documented warning and the dependency on internal packages HR_GENERAL and HR_SECURITY, custom code should treat this view as a read-only convenience layer and consider rebuilding the equivalent query against the documented HR and PA base tables where long-term stability is required.