Search Results capital_raw_cost_ptd




Overview
Explore in AI Chat

Overview

APPS.PA_STATUS_PROJ_V is a supplementary Oracle E-Business Suite view owned by the APPS schema and registered in Oracle's design data as PA.PA_STATUS_PROJ_V. It is classified as a view type expressly intended to simplify forms coding, and Oracle's standard warning applies: the view should not be queried or modified directly as a data source, because its definition may change significantly between minor or major releases. Its status is VALID in both the 12.1.1 and 12.2.2 releases.

Functionally, the view presents a consolidated, project-level snapshot of status-related amounts and quantities. It is designed to surface periodic actual and budget figures for a project in one row, combining actual cost accumulation, commitment accumulation, and budget comparison data. It is not a general-purpose reporting table; it exists primarily so that Project Status Inquiry-style forms and related Project Accounting screens can retrieve period-to-date (PTD), year-to-date (YTD), inception-to-date (ITD), and prior-period (PP) balances without joining multiple accumulation tables themselves. For customers searching the term capital_raw_cost_ptd, the view is the relevant object because it exposes CAPITAL_RAW_COST_PTD as a dedicated column, sourced from accumulation data maintained by the PA_STATUS package and the underlying accum tables.

Underlying Base Objects

The documented referenced base objects for PA_STATUS_PROJ_V are PA_PROJECTS (synonym), PA_PROJECT_ACCUM_ACTUALS (synonym), PA_PROJECT_ACCUM_COMMITMENTS (synonym), and PA_PROJECT_ACCUM_HEADERS (synonym), together with the PA_STATUS package and the views PA_STATUS_PROJ_BGT_COST_V and PA_STATUS_PROJ_BGT_REV_V. PA_PROJECTS supplies the project identity columns — PROJECT_ID, PROJECT_NUMBER, and PROJECT_NAME. PA_PROJECT_ACCUM_ACTUALS supplies the actual cost, burdened cost, and labor-hour accumulations, including the capital-classified amounts. PA_PROJECT_ACCUM_COMMITMENTS supplies the commitment figures exposed through the CMT_* columns, while PA_PROJECT_ACCUM_HEADERS provides the header-level context for the accumulation period. The two subordinate views contribute budget type codes and baseline figures. The PA_STATUS package is the procedural layer that maintains and derives status balances, which is why the view is treated as a forms-supporting construct rather than a stable public interface.

Key Columns

  • PROJECT_ID, PROJECT_NUMBER, PROJECT_NAME — the project key and descriptive identifiers, populated from PA_PROJECTS.
  • COST_BUDGET_TYPE_CODE, REV_BUDGET_TYPE_CODE — budget type indicators for cost and revenue comparison.
  • RAW_COST_ITD / _YTD / _PP / _PTD — unbilled raw cost across the four time bases.
  • CAPITAL_RAW_COST_PTD — raw cost for the current period, restricted to capital-classified expenditure. The same series is available as ITD, YTD, and PP.
  • BILLABLE_RAW_COST_* — raw cost restricted to billable expenditure.
  • BURDENED_COST_* and CAPITAL_BURDENED_COST_* — burdened equivalents of the raw cost series.
  • ACTUALS_LABOR_HOURS_* and BILLABLE_LABOR_HOURS_* — labor hour quantities by period basis.
  • REVENUE_ITD / _YTD / _PP / _PTD — revenue figures for the project.
  • CMT_RAW_COST_* and CMT_BURDENED_COST_* — commitment amounts from PA_PROJECT_ACCUM_COMMITMENTS.
  • BASELINE_RAW_COST_* and BASELINE_BURDENED_COST_* — baseline cost comparison values.

Common Use Cases and Queries

The principal use case is period-based project cost review, particularly where capital versus billable versus total raw cost must be distinguished. Typical queries join back to PA_PROJECTS for filtering and select only the period columns of interest. For example:

  • SELECT project_number, project_name, capital_raw_cost_ptd FROM apps.pa_status_proj_v WHERE project_id = :p_project_id;
  • SELECT project_number, raw_cost_ptd, capital_raw_cost_ptd, billable_raw_cost_ptd FROM apps.pa_status_proj_v WHERE cost_budget_type_code IS NOT NULL ORDER BY project_number;
  • SELECT project_id, raw_cost_itd, raw_cost_ytd, raw_cost_pp, raw_cost_ptd FROM apps.pa_status_proj_v WHERE project_number = :p_number;

Because the view is documented as a forms-supporting supplementary view, production use should be limited to inquiry and diagnostic purposes. Persistent reporting requirements should be redirected to the underlying accumulation tables or to Oracle's supported Project Accounting reporting interfaces.