Search Results pa_per




Overview
Explore in AI Chat

Overview

APPS.PA_STATUS_TASK_EI_BASE_V is a database view in the Oracle E-Business Suite Projects (PA) module. Its name encodes its function: it returns expenditure item level detail for a specified project and task, scoped by the current session context established through the PA_STATUS package (Project Status Inquiry, or PSI). The view is therefore not a general-purpose reporting object but a base view used by Oracle's Project Status Inquiry infrastructure.

The design is significant because it relies entirely on PA_STATUS global variables — GetProjID, GetTaskID, GetRsrcMemberID, GetStartDate, and GetEndDate — rather than bind parameters. The view returns data only for the project and task currently being interrogated by the PSI session, and only for the resource member 0. This makes it a context-driven, single-project view rather than a broad reporting source.

Underlying Base Objects

The view is a UNION ALL of two branches, each reading transactional accumulation data from the PA_TXN_ACCUM and PA_TXN_ACCUM_DETAILS tables. The first branch joins cost distribution lines from PA_COST_DISTRIBUTION_LINES_ALL on EXPENDITURE_ITEM_ID and LINE_NUM, restricted to TAD.LINE_TYPE = 'C' (cost). The second branch joins revenue distribution lines from PA_CUST_REV_DIST_LINES_ALL, restricted to TAD.LINE_TYPE = 'R' (revenue). Both branches join PA_PERIODS on PA_PERIOD to obtain period start and end dates, filtered against the GetStartDate and GetEndDate globals. The PA_STATUS package supplies the session context. All base tables are referenced through APPS synonyms.

Key Columns

Common Use Cases and Queries

The view is used internally by Project Status Inquiry to present task-level cost and revenue detail. Direct SQL requires that PA_STATUS context be initialized beforehand via PA_STATUS.SETPROJID, SETTASKID, and the date range setters; otherwise no rows are returned. A typical query takes the form:

  • SELECT project_id, task_id, pa_period, expenditure_item_id, amount, burdened_cost FROM apps.pa_status_task_ei_base_v WHERE project_id = :p_project_id;
  • SELECT pa_period, SUM(NVL(billable_burdened_cost,0)) FROM apps.pa_status_task_ei_base_v GROUP BY pa_period;

Because the view depends on session package state, it is best invoked through the PSI forms or PL/SQL blocks that set PA_STATUS context, rather than as a standalone reporting extract.