PA Refresh Project Summary Amounts

➜ Back to Library
Description
Categories: BI Publisher
Application: Projects
Source: PRC: Refresh Project Summary Amounts (XML)
Short Name: PAXACRPT_XML
DB package: PA_PAXACRPT_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 
 
 Char
To Project Number 
 
 Char
Project Type 
 
 LOV Oracle
Through Date 
 
 Date
Download
 
Related Blitz Reports
PA Update Project Summary Amounts for a Single Project PA Update Project Summary Amounts ECC Projects, Projects Costing: PSI Summary ECC Project Manufacturing, Projects GL Account Analysis (Drilldown) GL Account Analysis PA Refresh Transaction Summary Amounts ECC Projects, Projects Costing: Transactions, SQL1 ECC Project Procurement, Procurement Plan
Blitz Report™

Blitz Report™ provides multiple benefits: