PA Refresh Project Summary Amounts

Description
Categories: BI Publisher
Columns: Project Accum Id2, Budget Type, Base Raw Cost Itd, Base Raw Cost Ytd, Base Raw Cost Pp, Base Raw Cost Ptd, Base Burdened Cost Itd, Base Burdened Cost Ytd, Base Burdened Cost Pp, Base Burdened Cost Ptd ...
Application: Projects
Source: PRC: Refresh Project Summary Amounts (XML)
Short Name: PAXACRPT_XML
DB package: PA_PAXACRPT_XMLP_PKG
SELECT
     PAH.PROJECT_ACCUM_ID PROJECT_ACCUM_ID2,
     PBT.BUDGET_TYPE,
     BASE_RAW_COST_ITD,
     BASE_RAW_COST_YTD,
     BASE_RAW_COST_PP,
     BASE_RAW_COST_PTD,
     BASE_BURDENED_COST_ITD,
     BASE_BURDENED_COST_YTD,
     BASE_BURDENED_COST_PP,
     BASE_BURDENED_COST_PTD,
     ORIG_RAW_COST_ITD,
     ORIG_RAW_COST_YTD,
     ORIG_RAW_COST_PP,
     ORIG_RAW_COST_PTD,
     ORIG_BURDENED_COST_ITD,
     ORIG_BURDENED_COST_YTD,
     ORIG_BURDENED_COST_PP,
     ORIG_BURDENED_COST_PTD,
     BASE_REVENUE_ITD,
     BASE_REVENUE_YTD,
     BASE_REVENUE_PP,
     BASE_REVENUE_PTD,
     ORIG_REVENUE_ITD,
     ORIG_REVENUE_YTD,
     ORIG_REVENUE_PP,
     ORIG_REVENUE_PTD,
     ORIG_LABOR_HOURS_ITD,
     ORIG_LABOR_HOURS_YTD,
     ORIG_LABOR_HOURS_PP,
     ORIG_LABOR_HOURS_PTD,
     BASE_LABOR_HOURS_ITD,
     BASE_LABOR_HOURS_YTD,
     BASE_LABOR_HOURS_PP,
     BASE_LABOR_HOURS_PTD,
     ORIG_QUANTITY_YTD,
     ORIG_QUANTITY_ITD,
     ORIG_QUANTITY_PP,
     ORIG_QUANTITY_PTD,
     BASE_QUANTITY_YTD,
     BASE_QUANTITY_ITD,
     BASE_QUANTITY_PP,
     BASE_QUANTITY_PTD,
     ORIG_LABOR_HOURS_TOT,
     BASE_LABOR_HOURS_TOT,
     ORIG_QUANTITY_TOT,
    BASE_QUANTITY_TOT,
     BASE_RAW_COST_TOT,
     BASE_BURDENED_COST_TOT,
     ORIG_RAW_COST_TOT,
     ORIG_BURDENED_COST_TOT,
     BASE_REVENUE_TOT,
     ORIG_REVENUE_TOT,
     BASE_UNIT_OF_MEASURE,
     ORIG_UNIT_OF_MEASURE
FROM
     PA_BUDGET_TYPES PBT,
     PA_PROJECT_ACCUM_HEADERS PAH,
     PA_PROJECT_ACCUM_BUDGETS PAB
 WHERE
     PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
    AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
    and pab.fin_plan_type_id is NULL
union
SELECT
     PAH.PROJECT_ACCUM_ID,
     PBT.BUDGET_TYPE,
     BASE_RAW_COST_ITD,
     BASE_RAW_COST_YTD,
     BASE_RAW_COST_PP,
     BASE_RAW_COST_PTD,
     BASE_BURDENED_COST_ITD,
     BASE_BURDENED_COST_YTD,
     BASE_BURDENED_COST_PP,
     BASE_BURDENED_COST_PTD,
     ORIG_RAW_COST_ITD,
     ORIG_RAW_COST_YTD,
     ORIG_RAW_COST_PP,
     ORIG_RAW_COST_PTD,
     ORIG_BURDENED_COST_ITD,
     ORIG_BURDENED_COST_YTD,
     ORIG_BURDENED_COST_PP,
     ORIG_BURDENED_COST_PTD,
     BASE_REVENUE_ITD,
     BASE_REVENUE_YTD,
     BASE_REVENUE_PP,
     BASE_REVENUE_PTD,
     ORIG_REVENUE_ITD,
     ORIG_REVENUE_YTD,
     ORIG_REVENUE_PP,
     ORIG_REVENUE_PTD,
     ORIG_LABOR_HOURS_ITD,
     ORIG_LABOR_HOURS_YTD,
     ORIG_LABOR_HOURS_PP,
     ORIG_LABOR_HOURS_PTD,
     BASE_LABOR_HOURS_ITD,
     BASE_LABOR_HOURS_YTD,
     BASE_LABOR_HOURS_PP,
     BASE_LABOR_HOURS_PTD,
     ORIG_QUANTITY_YTD,
     ORIG_QUANTITY_ITD,
     ORIG_QUANTITY_PP,
     ORIG_QUANTITY_PTD,
     BASE_QUANTITY_YTD,
     BASE_QUANTITY_ITD,
     BASE_QUANTITY_PP,
     BASE_QUANTITY_PTD,
     ORIG_LABOR_HOURS_TOT,
     BASE_LABOR_HOURS_TOT,
     ORIG_QUANTITY_TOT,
    BASE_QUANTITY_TOT,
     BASE_RAW_COST_TOT,
     BASE_BURDENED_COST_TOT,
     ORIG_RAW_COST_TOT,
     ORIG_BURDENED_COST_TOT,
     BASE_REVENUE_TOT,
     ORIG_REVENUE_TOT,
     BASE_UNIT_OF_MEASURE,
     ORIG_UNIT_OF_MEASURE
 FROM
     PA_BUDGET_TYPES PBT,
     PA_PROJECT_ACCUM_HEADERS PAH,
     PA_PROJECT_ACCUM_BUDGETS PAB
 WHERE
     PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
    AND PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
    and pab.fin_plan_type_id is NULL
union all
SELECT
     PAH.PROJECT_ACCUM_ID,
     substr(tl.name,1,30)         BUDGET_TYPE,
     BASE_RAW_COST_ITD,
     BASE_RAW_COST_YTD,
     BASE_RAW_COST_PP,
     BASE_RAW_COST_PTD,
     BASE_BURDENED_COST_ITD,
     BASE_BURDENED_COST_YTD,
     BASE_BURDENED_COST_PP,
     BASE_BURDENED_COST_PTD,
     ORIG_RAW_COST_ITD,
     ORIG_RAW_COST_YTD,
     ORIG_RAW_COST_PP,
     ORIG_RAW_COST_PTD,
     ORIG_BURDENED_COST_ITD,
     ORIG_BURDENED_COST_YTD,
     ORIG_BURDENED_COST_PP,
     ORIG_BURDENED_COST_PTD,
     BASE_REVENUE_ITD,
     BASE_REVENUE_YTD,
     BASE_REVENUE_PP,
     BASE_REVENUE_PTD,
     ORIG_REVENUE_ITD,
     ORIG_REVENUE_YTD,
     ORIG_REVENUE_PP,
     ORIG_REVENUE_PTD,
     ORIG_LABOR_HOURS_ITD,
    ORIG_LABOR_HOURS_YTD,
     ORIG_LABOR_HOURS_PP,
     ORIG_LABOR_HOURS_PTD,
     BASE_LABOR_HOURS_ITD,
     BASE_LABOR_HOURS_YTD,
     BASE_LABOR_HOURS_PP,
     BASE_LABOR_HOURS_PTD,
     ORIG_QUANTITY_YTD,
     ORIG_QUANTITY_ITD,
     ORIG_QUANTITY_PP,
     ORIG_QUANTITY_PTD,
     BASE_QUANTITY_YTD,
     BASE_QUANTITY_ITD,
     BASE_QUANTITY_PP,
     BASE_QUANTITY_PTD,
     ORIG_LABOR_HOURS_TOT,
    BASE_LABOR_HOURS_TOT,
     ORIG_QUANTITY_TOT,
     BASE_QUANTITY_TOT,
     BASE_RAW_COST_TOT,
     BASE_BURDENED_COST_TOT,
     ORIG_RAW_COST_TOT,
     ORIG_BURDENED_COST_TOT,
     BASE_REVENUE_TOT,
     ORIG_REVENUE_TOT,
     BASE_UNIT_OF_MEASURE,
     ORIG_UNIT_OF_MEASURE
 FROM
     pa_fin_plan_types_tl tl,
     PA_PROJECT_ACCUM_HEADERS PAH,
     PA_PROJECT_ACCUM_BUDGETS PAB
 WHERE
    PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID
    and tl.LANGUAGE = USERENV('LANG')
 and PAH.PROJECT_ACCUM_ID=:PROJECT_ACCUM_ID
Parameter Name SQL text Validation
From Project Number
 
To Project Number
 
Project Type
 
LOV Oracle
Through Date
 
Date