View: PA_RPT_CUST_ACT_SUMMARY

Product:	PA - Projects
Description:	Reporting view which displays project level actuals by customers.
Implementation/DBA Data:	APPS.PA_RPT_CUST_ACT_SUMMARY

View Text

SELECT PAH.PROJECT_ACCUM_ID
, PAH.ACCUM_PERIOD
, PC.CUSTOMER_ID
, PC.CUSTOMER_BILL_SPLIT
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.RAW_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.RAW_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.RAW_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.RAW_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_RAW_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_RAW_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_RAW_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_RAW_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BURDENED_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BURDENED_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BURDENED_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BURDENED_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_BURDENED_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_BURDENED_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_BURDENED_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_BURDENED_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.LABOR_HOURS_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.LABOR_HOURS_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.LABOR_HOURS_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.LABOR_HOURS_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_LABOR_HOURS_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_LABOR_HOURS_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_LABOR_HOURS_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.BILLABLE_LABOR_HOURS_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.REVENUE_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.REVENUE_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.REVENUE_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAA.REVENUE_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, PAH.PROJECT_ID
FROM PA_PROJECT_ACCUM_ACTUALS PAA
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_CUSTOMERS PC
, PA_PROJECTS PPA
, PA_PROJECT_TYPES PPT
WHERE PAA.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PAH.TASK_ID = 0
AND PC.PROJECT_ID = PPA.PROJECT_ID
AND PPT.PROJECT_TYPE_CLASS_CODE = 'CONTRACT'

Columns