Search Results parent_project_id




Overview
Explore in AI Chat

Overview

APPS.PA_FIN_STRUCTURES_LINKS_V is a read-only view owned by the APPS schema that exposes the hierarchical relationships defined between financial structure elements in Oracle Projects. Its principal function is to resolve and flatten the parent-child linkages that exist between a parent project (and, optionally, a parent task) and a sub-project within the Project Financial Structures model. The view returns one row per object relationship, denormalising the identifiers and descriptive attributes of both sides of the link into a single, reportable record.

Within Oracle EBS 12.1.1 and 12.2.2 this view plays a supporting role in integrations and reporting, particularly in flows that need to trace the funding or deliverable lineage between lower-level sub-projects and the parent structures that own them. The dependency list shows that the view is referenced by several Oracle Service (OKE) private APIs, including OKE_ALLOCATION_PVT, OKE_CLE_PVT, OKE_DELIVERABLE_PVT, and OKE_FUNDSOURCE_PVT, confirming its use as a lookup source for cross-module relationship resolution. The metadata carries the standard Oracle Internal Use Only warning: direct access is unsupported outside standard Oracle Applications programs.

Underlying Base Objects

The view is defined over the following documented objects:

The view therefore joins relationship metadata to the project and structure dimension tables, yielding a self-describing record of each parent/sub-project linkage.

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying all sub-projects beneath a given parent, resolving the parent of a known sub-project, and feeding relationship data into allocation, deliverable, or funding-source processing.

SELECT sub_project_id,
       sub_project_number,
       relationship_type
FROM   apps.pa_fin_structures_links_v
WHERE  parent_project_id = :p_parent_project_id;

SELECT parent_project_id,
       parent_project_number,
       parent_task_number
FROM   apps.pa_fin_structures_links_v
WHERE  sub_project_id = :p_sub_project_id;

Because the object is unsupported for direct access, custom reporting should be limited to controlled read-only queries and reviewed against Oracle's support policy before deployment.