VIEW: APPS.PA_RPT_PRJ_ACT_SUMMARY

Source

View Text - Preformatted

SELECT pah.PROJECT_ACCUM_ID , pah.accum_period , paa.RAW_COST_ITD, paa.RAW_COST_YTD , paa.RAW_COST_PP, paa.RAW_COST_PTD , paa.BILLABLE_RAW_COST_ITD , paa.BILLABLE_RAW_COST_YTD , paa.BILLABLE_RAW_COST_PP , paa.BILLABLE_RAW_COST_PTD , paa.BURDENED_COST_ITD , paa.BURDENED_COST_YTD , paa.BURDENED_COST_PP , paa.BURDENED_COST_PTD , paa.BILLABLE_BURDENED_COST_ITD , paa.BILLABLE_BURDENED_COST_YTD , paa.BILLABLE_BURDENED_COST_PP , paa.BILLABLE_BURDENED_COST_PTD , paa.LABOR_HOURS_ITD , paa.LABOR_HOURS_YTD , paa.LABOR_HOURS_PP , paa.LABOR_HOURS_PTD , paa.BILLABLE_LABOR_HOURS_ITD , paa.BILLABLE_LABOR_HOURS_YTD , paa.BILLABLE_LABOR_HOURS_PP, paa.BILLABLE_LABOR_HOURS_PTD , paa.REVENUE_ITD , paa.REVENUE_YTD , paa.REVENUE_PP , paa.REVENUE_PTD , pah.project_id FROM pa_project_accum_actuals paa , pa_project_accum_headers pah , pa_projects ppa WHERE paa.project_accum_id = pah.project_accum_id AND pah.resource_list_member_id = 0 AND pah.project_id = ppa.project_id AND pah.task_id = 0

View Text - HTML Formatted

SELECT PAH.PROJECT_ACCUM_ID
, PAH.ACCUM_PERIOD
, PAA.RAW_COST_ITD
, PAA.RAW_COST_YTD
, PAA.RAW_COST_PP
, PAA.RAW_COST_PTD
, PAA.BILLABLE_RAW_COST_ITD
, PAA.BILLABLE_RAW_COST_YTD
, PAA.BILLABLE_RAW_COST_PP
, PAA.BILLABLE_RAW_COST_PTD
, PAA.BURDENED_COST_ITD
, PAA.BURDENED_COST_YTD
, PAA.BURDENED_COST_PP
, PAA.BURDENED_COST_PTD
, PAA.BILLABLE_BURDENED_COST_ITD
, PAA.BILLABLE_BURDENED_COST_YTD
, PAA.BILLABLE_BURDENED_COST_PP
, PAA.BILLABLE_BURDENED_COST_PTD
, PAA.LABOR_HOURS_ITD
, PAA.LABOR_HOURS_YTD
, PAA.LABOR_HOURS_PP
, PAA.LABOR_HOURS_PTD
, PAA.BILLABLE_LABOR_HOURS_ITD
, PAA.BILLABLE_LABOR_HOURS_YTD
, PAA.BILLABLE_LABOR_HOURS_PP
, PAA.BILLABLE_LABOR_HOURS_PTD
, PAA.REVENUE_ITD
, PAA.REVENUE_YTD
, PAA.REVENUE_PP
, PAA.REVENUE_PTD
, PAH.PROJECT_ID
FROM PA_PROJECT_ACCUM_ACTUALS PAA
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECTS PPA
WHERE PAA.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND PAH.TASK_ID = 0