Search Results task_org_name




Overview
Explore in AI Chat

Overview

APPS.PA_ALLOC_TARGET_LINES_V is a supplementary view in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema and registered under FND Design Data as PA.PA_ALLOC_TARGET_LINES_V. Its documented status is VALID. Per the ETRM metadata, the view type is described as a supplementary view used to simplify Oracle Forms coding. Oracle explicitly warns that this view is not intended for direct query or data manipulation by end users; its structure may change substantially in subsequent minor or major releases.

The view belongs to the allocation functionality of Oracle Projects, exposing the target lines of an allocation rule — the projects, tasks, and organizations against which allocated amounts are distributed. The presence of an overriding PROJECT_ORG_NAME column (length 240) makes the view directly responsive to the search term project_org_name, since that column resolves the owning organization of each target line without requiring a separate join to organization tables.

Underlying Base Objects

The documented dependency list identifies the following referenced objects:

The view is not referenced by any other database object, confirming its role as a terminal, form-facing construct rather than a component of further dependency chains.

Key Columns

Common Use Cases and Queries

Typical usage is investigative or form-driven: validating allocation rule targets, confirming which project organizations are secured for the current responsibility, and reconciling target percentages across a rule. A representative query retrieving target lines by rule, including the project organization name, follows:

SELECT rule_id, line_num, project_number, project_name, project_org_name, task_number, task_name, line_percent, exclude_flag, billable_only_flag FROM apps.pa_alloc_target_lines_v WHERE rule_id = :rule_id ORDER BY line_num;

Because the view is not supported for external querying, consumers requiring stable interfaces should query the underlying PA_ALLOC_TARGET_LINES table joined to HR organization units directly, rather than relying on this form-support view.