[Home] [Help] [Dependency Information]

VIEW: APPS.PA_STATUS_PROJ_V

Object Details

Object Name:	PA_STATUS_PROJ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_STATUS_PROJ_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      COST_BUDGET_TYPE_CODE
,      REV_BUDGET_TYPE_CODE
,      RAW_COST_ITD
,      RAW_COST_YTD
,      RAW_COST_PP
,      RAW_COST_PTD
,      BILLABLE_RAW_COST_ITD
,      BILLABLE_RAW_COST_YTD
,      BILLABLE_RAW_COST_PP
,      BILLABLE_RAW_COST_PTD
,      CAPITAL_RAW_COST_ITD
,      CAPITAL_RAW_COST_YTD
,      CAPITAL_RAW_COST_PP
,      CAPITAL_RAW_COST_PTD
,      BURDENED_COST_ITD
,      BURDENED_COST_YTD
,      BURDENED_COST_PP
,      BURDENED_COST_PTD
,      BILLABLE_BURDENED_COST_ITD
,      BILLABLE_BURDENED_COST_YTD
,      BILLABLE_BURDENED_COST_PP
,      BILLABLE_BURDENED_COST_PTD
,      CAPITAL_BURDENED_COST_ITD
,      CAPITAL_BURDENED_COST_YTD
,      CAPITAL_BURDENED_COST_PP
,      CAPITAL_BURDENED_COST_PTD
,      ACTUALS_LABOR_HOURS_ITD
,      ACTUALS_LABOR_HOURS_YTD
,      ACTUALS_LABOR_HOURS_PP
,      ACTUALS_LABOR_HOURS_PTD
,      BILLABLE_LABOR_HOURS_ITD
,      BILLABLE_LABOR_HOURS_YTD
,      BILLABLE_LABOR_HOURS_PP
,      BILLABLE_LABOR_HOURS_PTD
,      REVENUE_ITD
,      REVENUE_YTD
,      REVENUE_PP
,      REVENUE_PTD
,      CMT_RAW_COST_ITD
,      CMT_RAW_COST_YTD
,      CMT_RAW_COST_PP
,      CMT_RAW_COST_PTD
,      CMT_BURDENED_COST_ITD
,      CMT_BURDENED_COST_YTD
,      CMT_BURDENED_COST_PP
,      CMT_BURDENED_COST_PTD
,      BASELINE_RAW_COST_ITD
,      BASELINE_RAW_COST_YTD
,      BASELINE_RAW_COST_PP
,      BASELINE_RAW_COST_PTD
,      BASELINE_BURDENED_COST_ITD
,      BASELINE_BURDENED_COST_YTD
,      BASELINE_BURDENED_COST_PP
,      BASELINE_BURDENED_COST_PTD
,      ORIGINAL_RAW_COST_ITD
,      ORIGINAL_RAW_COST_YTD
,      ORIGINAL_RAW_COST_PP
,      ORIGINAL_RAW_COST_PTD
,      ORIGINAL_BURDENED_COST_ITD
,      ORIGINAL_BURDENED_COST_YTD
,      ORIGINAL_BURDENED_COST_PP
,      ORIGINAL_BURDENED_COST_PTD
,      ORIGINAL_COST_LABOR_HOURS_ITD
,      ORIGINAL_COST_LABOR_HOURS_YTD
,      ORIGINAL_COST_LABOR_HOURS_PP
,      ORIGINAL_COST_LABOR_HOURS_PTD
,      BASELINE_COST_LABOR_HOURS_ITD
,      BASELINE_COST_LABOR_HOURS_YTD
,      BASELINE_COST_LABOR_HOURS_PP
,      BASELINE_COST_LABOR_HOURS_PTD
,      BASELINE_RAW_COST_TOT
,      BASELINE_BURDENED_COST_TOT
,      ORIGINAL_RAW_COST_TOT
,      ORIGINAL_BURDENED_COST_TOT
,      ORIGINAL_COST_LABOR_HOURS_TOT
,      BASELINE_COST_LABOR_HOURS_TOT
,      BASELINE_REVENUE_ITD
,      BASELINE_REVENUE_YTD
,      BASELINE_REVENUE_PP
,      BASELINE_REVENUE_PTD
,      ORIGINAL_REVENUE_ITD
,      ORIGINAL_REVENUE_YTD
,      ORIGINAL_REVENUE_PP
,      ORIGINAL_REVENUE_PTD
,      ORIGINAL_REV_LABOR_HOURS_ITD
,      ORIGINAL_REV_LABOR_HOURS_YTD
,      ORIGINAL_REV_LABOR_HOURS_PP
,      ORIGINAL_REV_LABOR_HOURS_PTD
,      BASELINE_REV_LABOR_HOURS_ITD
,      BASELINE_REV_LABOR_HOURS_YTD
,      BASELINE_REV_LABOR_HOURS_PP
,      BASELINE_REV_LABOR_HOURS_PTD
,      BASELINE_REVENUE_TOT
,      ORIGINAL_REVENUE_TOT
,      ORIGINAL_REV_LABOR_HOURS_TOT
,      BASELINE_REV_LABOR_HOURS_TOT
FROM APPS.PA_STATUS_PROJ_V;

Dependencies

[top of page]

APPS

PA_PROJECTS

PA_PROJECT_ACCUM_ACTUALS

PA_PROJECT_ACCUM_COMMITMENTS

PA_PROJECT_ACCUM_HEADERS

PA_STATUS - show dependent code

PA_STATUS_PROJ_BGT_COST_V

PA_STATUS_PROJ_BGT_REV_V

APPS

PA_CLIENT_EXTN_STATUS - show dependent code