Search Results pa_tasks_v




Overview
Explore in AI Chat

Overview

PA_TASKS_V is an Oracle EBS Projects (PA) view owned by the APPS schema. It is documented in ETRM as "10Sc only," indicating that it is intended primarily for Oracle Projects 10SC (a former public-sector/contracts-specific variant) rather than as a general-purpose 11i/R12 development interface. The view presents a denormalized, reportable representation of project task (WBS element) records. Its role is to expose the core task attributes from PA_TASKS together with the descriptive values that reporting and integration consumers typically require, such as organization name, task manager name, service type meaning, and structured address information. Because it joins lookup and HR/HZ descriptive data at the database level, it removes the need for consumers to reproduce those joins themselves.

Underlying Base Objects

The view text selects primarily from PA_TASKS (referenced as the TASK alias). Descriptive data is joined from several supporting objects:

Key Columns

The view exposes the full set of task attributes from PA_TASKS, including:

Common Use Cases and Queries

The view is typically used to build task-level reports and to feed downstream processes that need task names, manager names, and organization names in a single query.

List tasks for a project:

  • SELECT task_id, task_number, task_name, wbs_level, organization_name, task_manager_name, ready_to_bill_flag FROM pa_tasks_v WHERE project_id = :project_id ORDER BY task_number;

Identify billable vs chargeable tasks:

  • SELECT task_number, task_name, service_type_m, chargeable_flag, billable_flag FROM pa_tasks_v WHERE project_id = :project_id AND ready_to_bill_flag = 'Y';

Because the view is documented as 10Sc-specific, developers should verify its availability and column set in 12.1.1 and 12.2.2 before relying on it, and prefer supported PA APIs or PA_TASKS-based queries where portability is required.