Search Results child_org_name




Overview
Explore in AI Chat

Overview

APPS.PA_REP_ORG_UTIL_V is a reporting utility view in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and registered in the application design data as PA.PA_REP_ORG_UTIL_V. It presents a flattened, denormalized representation of the reporting organization hierarchy, exposing parent and child organization identifiers and names in a single row-per-relationship structure. The view has a status of VALID in both release 12.1.1 and 12.2.2 and is classified as an internal view type.

The object is explicitly marked "Oracle Internal Use Only." Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. It functions as a supporting component for Project Management reporting and security-driven organization listings rather than as a public integration interface. The column CHILD_ORG_NAME, which this object was searched against, is one of the primary name attributes surfaced by the view, making it the natural point of discovery for users attempting to resolve child organization names within the reporting hierarchy.

Underlying Base Objects

The view is defined over a combination of four base objects and one built-in row source. The documented dependencies are:

  • PA_ORG_HIERARCHY_DENORM (synonym) — the denormalized organization hierarchy that supplies the parent and child organization identifier pairs.
  • PA_SECURITY_PVT (package) — the Projects security package that enforces organization-level access for the current user.
  • PA_EXPENDITURES_UTILS (package) — the Projects expenditure utility package, referenced by the view definition.
  • FND_GRANTS and FND_OBJECTS (synonyms) — Oracle Application Object Library objects used to evaluate function and object grants that govern visibility of reporting organizations.
  • DUAL (synonym) — the standard single-row source used in scalar subqueries and inline lookups.

The combination of PA_SECURITY_PVT and the FND_GRANTS/FND_OBJECTS pair indicates that row visibility is filtered by the responsibility and user grants in effect at query time. The view therefore returns only the parent-child organization combinations that the calling session is authorized to see. In turn, PA_REP_ORG_UTIL_V is referenced by the APPS.PA_REPORT_UTIL package, which uses it as a building block for higher-level Projects reporting and organization selection logic.

Key Columns

The view exposes four columns in a fixed order, as documented in the ETRM metadata:

  • PARENT_ORGANIZATION_ID (NUMBER) — the internal identifier of the parent organization in the reporting hierarchy.
  • PARENT_ORG_NAME (VARCHAR2(4000)) — the display name of the parent organization.
  • CHILD_ORGANIZATION_ID (NUMBER) — the internal identifier of the child organization.
  • CHILD_ORG_NAME (VARCHAR2(4000)) — the display name of the child organization. This is the column most frequently used to resolve or display child organization names in reporting output.

Both name columns are declared at 4000 characters, which accommodates concatenated or flexfield-derived naming values rather than a simple fixed-width organization name.

Common Use Cases and Queries

Typical usage centers on listing or filtering reporting organizations by name and on resolving the children of a given parent, always subject to the security grants applied by the underlying packages. A basic query returning all visible parent-child combinations is:

SELECT PARENT_ORGANIZATION_ID, PARENT_ORG_NAME, CHILD_ORGANIZATION_ID, CHILD_ORG_NAME FROM APPS.PA_REP_ORG_UTIL_V;

To locate a specific child organization by name, the CHILD_ORG_NAME column can be filtered directly:

SELECT PARENT_ORG_NAME, CHILD_ORG_NAME FROM APPS.PA_REP_ORG_UTIL_V WHERE CHILD_ORG_NAME = :p_name;

To enumerate the children of a known parent, the parent identifier is supplied as a bind variable and the result set is restricted accordingly. Because access is governed by PA_SECURITY_PVT, FND_GRANTS, and FND_OBJECTS, results may differ by responsibility and user. Any direct query should be treated as diagnostic or read-only; production reporting should continue to rely on the standard Oracle Applications programs that consume this view through PA_REPORT_UTIL.

  • VIEW: APPS.PA_REP_ORG_UTIL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_UTIL_V,  object_name:PA_REP_ORG_UTIL_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_REP_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_REP_ORG_V,  object_name:PA_REP_ALL_REP_ORG_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ORG_UTIL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_UTIL_V,  object_name:PA_REP_ORG_UTIL_V,  status:VALID, 

  • VIEW: APPS.PA_REP_FORECAST_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_FORECAST_ORG_V,  object_name:PA_REP_FORECAST_ORG_V,  status:VALID, 

  • VIEW: APPS.PA_REP_ALL_REP_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_REP_ORG_V,  object_name:PA_REP_ALL_REP_ORG_V,  status:VALID, 

  • VIEW: APPS.PA_REP_FORECAST_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_FORECAST_ORG_V,  object_name:PA_REP_FORECAST_ORG_V,  status:VALID, 

  • View: PA_REP_ALL_REP_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_REP_ORG_V,  object_name:PA_REP_ALL_REP_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_REP_ORG_V is a view that lists all reporting Hierarchy for and OU ,  implementation_dba_data: APPS.PA_REP_ALL_REP_ORG_V , 

  • View: PA_REP_FORECAST_ORG_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_FORECAST_ORG_V,  object_name:PA_REP_FORECAST_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_FORECAST_ORG_V is a view that lists all child organizations for a given application user who has forecast authority ,  implementation_dba_data: APPS.PA_REP_FORECAST_ORG_V , 

  • View: PA_REP_ALL_REP_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ALL_REP_ORG_V,  object_name:PA_REP_ALL_REP_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ALL_REP_ORG_V is a view that lists all reporting Hierarchy for and OU ,  implementation_dba_data: APPS.PA_REP_ALL_REP_ORG_V , 

  • View: PA_REP_ORG_UTIL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_UTIL_V,  object_name:PA_REP_ORG_UTIL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_UTIL_V is a view that lists all child organizations for a given application user who has utilization authority ,  implementation_dba_data: APPS.PA_REP_ORG_UTIL_V , 

  • View: PA_REP_ORG_UTIL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_ORG_UTIL_V,  object_name:PA_REP_ORG_UTIL_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_ORG_UTIL_V is a view that lists all child organizations for a given application user who has utilization authority ,  implementation_dba_data: APPS.PA_REP_ORG_UTIL_V , 

  • View: PA_REP_FORECAST_ORG_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_REP_FORECAST_ORG_V,  object_name:PA_REP_FORECAST_ORG_V,  status:VALID,  product: PA - Projects ,  description: PA_REP_FORECAST_ORG_V is a view that lists all child organizations for a given application user who has forecast authority ,  implementation_dba_data: APPS.PA_REP_FORECAST_ORG_V , 

  • eTRM - PA Tables and Views 12.1.1

  • eTRM - PA Tables and Views 12.2.2