eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PA_RPT_CUST_SUMMARY_BASE_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_RPT_CUST_SUMMARY_BASE_V

View Text

SELECT PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, RAW_COST_ITD
, RAW_COST_YTD
, RAW_COST_PTD
, BILLABLE_RAW_COST_ITD
, BILLABLE_RAW_COST_YTD
, BILLABLE_RAW_COST_PTD
, BURDENED_COST_ITD
, BURDENED_COST_YTD
, BURDENED_COST_PTD
, BILLABLE_BURDENED_COST_ITD
, BILLABLE_BURDENED_COST_YTD
, BILLABLE_BURDENED_COST_PTD
, REVENUE_ITD
, REVENUE_YTD
, REVENUE_PTD
, LABOR_HOURS_ITD
, LABOR_HOURS_YTD
, LABOR_HOURS_PTD
, BILLABLE_LABOR_HOURS_ITD
, BILLABLE_LABOR_HOURS_YTD
, BILLABLE_LABOR_HOURS_PTD
, B1.BUDGET_TYPE_CODE
, B1.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B2.BUDGET_TYPE_CODE
, B2.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B3.BUDGET_TYPE_CODE
, B3.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B4.BUDGET_TYPE_CODE
, B4.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_RPT_CUST_ACT_SUMMARY
, PA_BUDGET_TYPES B1
, PA_BUDGET_TYPES B2
, PA_BUDGET_TYPES B3
, PA_BUDGET_TYPES B4
WHERE B1.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 1)
AND B2.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 2)
AND B3.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 1)
AND B4.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 2) UNION ALL SELECT /* ONLY BUDGET TYPE 1 */ PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B.BUDGET_TYPE_CODE
, B.BUDGET_TYPE
, BASE_RAW_COST_ITD
, BASE_RAW_COST_YTD
, BASE_RAW_COST_PTD
, BASE_RAW_COST_TOT
, ORIG_RAW_COST_ITD
, ORIG_RAW_COST_YTD
, ORIG_RAW_COST_PTD
, ORIG_RAW_COST_TOT
, BASE_BURDENED_COST_ITD
, BASE_BURDENED_COST_YTD
, BASE_BURDENED_COST_PTD
, BASE_BURDENED_COST_TOT
, ORIG_BURDENED_COST_ITD
, ORIG_BURDENED_COST_YTD
, ORIG_BURDENED_COST_PTD
, ORIG_BURDENED_COST_TOT
, ORIG_LABOR_HOURS_ITD
, ORIG_LABOR_HOURS_YTD
, ORIG_LABOR_HOURS_PTD
, ORIG_LABOR_HOURS_TOT
, BASE_LABOR_HOURS_ITD
, BASE_LABOR_HOURS_YTD
, BASE_LABOR_HOURS_PTD
, BASE_LABOR_HOURS_TOT
, B2.BUDGET_TYPE_CODE
, B2.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B3.BUDGET_TYPE_CODE
, B3.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B4.BUDGET_TYPE_CODE
, B4.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_RPT_CUST_BGT_SUMMARY B
, PA_BUDGET_TYPES B2
, PA_BUDGET_TYPES B3
, PA_BUDGET_TYPES B4
WHERE B2.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 2)
AND B3.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 1)
AND B4.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 2)
AND B.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 1) UNION ALL SELECT /* ONLY BUDGET TYPE 2 */ PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B1.BUDGET_TYPE_CODE
, B1.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B.BUDGET_TYPE_CODE
, B.BUDGET_TYPE
, BASE_RAW_COST_ITD
, BASE_RAW_COST_YTD
, BASE_RAW_COST_PTD
, BASE_RAW_COST_TOT
, ORIG_RAW_COST_ITD
, ORIG_RAW_COST_YTD
, ORIG_RAW_COST_PTD
, ORIG_RAW_COST_TOT
, BASE_BURDENED_COST_ITD
, BASE_BURDENED_COST_YTD
, BASE_BURDENED_COST_PTD
, BASE_BURDENED_COST_TOT
, ORIG_BURDENED_COST_ITD
, ORIG_BURDENED_COST_YTD
, ORIG_BURDENED_COST_PTD
, ORIG_BURDENED_COST_TOT
, ORIG_LABOR_HOURS_ITD
, ORIG_LABOR_HOURS_YTD
, ORIG_LABOR_HOURS_PTD
, ORIG_LABOR_HOURS_TOT
, BASE_LABOR_HOURS_ITD
, BASE_LABOR_HOURS_YTD
, BASE_LABOR_HOURS_PTD
, BASE_LABOR_HOURS_TOT
, B3.BUDGET_TYPE_CODE
, B3.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B4.BUDGET_TYPE_CODE
, B4.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_RPT_CUST_BGT_SUMMARY B
, PA_BUDGET_TYPES B1
, PA_BUDGET_TYPES B3
, PA_BUDGET_TYPES B4
WHERE B1.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 1)
AND B3.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 1)
AND B4.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 2)
AND B.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 2) UNION ALL SELECT /* ONLY BUDGET TYPE 3 */ PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B1.BUDGET_TYPE_CODE
, B1.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B2.BUDGET_TYPE_CODE
, B2.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B.BUDGET_TYPE_CODE
, B.BUDGET_TYPE
, BASE_REVENUE_ITD
, BASE_REVENUE_YTD
, BASE_REVENUE_PTD
, BASE_REVENUE_TOT
, ORIG_REVENUE_ITD
, ORIG_REVENUE_YTD
, ORIG_REVENUE_PTD
, ORIG_REVENUE_TOT
, ORIG_LABOR_HOURS_ITD
, ORIG_LABOR_HOURS_YTD
, ORIG_LABOR_HOURS_PTD
, ORIG_LABOR_HOURS_TOT
, BASE_LABOR_HOURS_ITD
, BASE_LABOR_HOURS_YTD
, BASE_LABOR_HOURS_PTD
, BASE_LABOR_HOURS_TOT
, B4.BUDGET_TYPE_CODE
, B4.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
FROM PA_RPT_CUST_BGT_SUMMARY B
, PA_BUDGET_TYPES B1
, PA_BUDGET_TYPES B2
, PA_BUDGET_TYPES B4
WHERE B1.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 1)
AND B2.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 2)
AND B4.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 2)
AND B.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 1) UNION ALL SELECT /* ONLY BUDGET TYPE 4 */ PROJECT_ID
, PROJECT_ACCUM_ID
, ACCUM_PERIOD
, CUSTOMER_ID
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B1.BUDGET_TYPE_CODE
, B1.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B2.BUDGET_TYPE_CODE
, B2.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B3.BUDGET_TYPE_CODE
, B3.BUDGET_TYPE
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, B.BUDGET_TYPE_CODE
, B.BUDGET_TYPE
, BASE_REVENUE_ITD
, BASE_REVENUE_YTD
, BASE_REVENUE_PTD
, BASE_REVENUE_TOT
, ORIG_REVENUE_ITD
, ORIG_REVENUE_YTD
, ORIG_REVENUE_PTD
, ORIG_REVENUE_TOT
, ORIG_LABOR_HOURS_ITD
, ORIG_LABOR_HOURS_YTD
, ORIG_LABOR_HOURS_PTD
, ORIG_LABOR_HOURS_TOT
, BASE_LABOR_HOURS_ITD
, BASE_LABOR_HOURS_YTD
, BASE_LABOR_HOURS_PTD
, BASE_LABOR_HOURS_TOT
FROM PA_RPT_CUST_BGT_SUMMARY B
, PA_BUDGET_TYPES B1
, PA_BUDGET_TYPES B2
, PA_BUDGET_TYPES B3
WHERE B1.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 1)
AND B2.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('C'
, 2)
AND B3.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 1)
AND B.BUDGET_TYPE_CODE = PA_RPT_UTILS.GET_RPT_BUDGET_TYPE('R'
, 2)

Columns

Name
PROJECT_ID
PROJECT_ACCUM_ID
ACCUM_PERIOD
CUSTOMER_ID
RAW_COST_ITD
RAW_COST_YTD
RAW_COST_PTD
BILLABLE_RAW_COST_ITD
BILLABLE_RAW_COST_YTD
BILLABLE_RAW_COST_PTD
BURDENED_COST_ITD
BURDENED_COST_YTD
BURDENED_COST_PTD
BILLABLE_BURDENED_COST_ITD
BILLABLE_BURDENED_COST_YTD
BILLABLE_BURDENED_COST_PTD
REVENUE_ITD
REVENUE_YTD
REVENUE_PTD
LABOR_HOURS_ITD
LABOR_HOURS_YTD
LABOR_HOURS_PTD
BILLABLE_LABOR_HOURS_ITD
BILLABLE_LABOR_HOURS_YTD
BILLABLE_LABOR_HOURS_PTD
BUDGET_TYPE_CODE1
BUDGET_TYPE1
BASE_RAW_COST_ITD1
BASE_RAW_COST_YTD1
BASE_RAW_COST_PTD1
BASE_RAW_COST_TOT1
ORIG_RAW_COST_ITD1
ORIG_RAW_COST_YTD1
ORIG_RAW_COST_PTD1
ORIG_RAW_COST_TOT1
BASE_BURDENED_COST_ITD1
BASE_BURDENED_COST_YTD1
BASE_BURDENED_COST_PTD1
BASE_BURDENED_COST_TOT1
ORIG_BURDENED_COST_ITD1
ORIG_BURDENED_COST_YTD1
ORIG_BURDENED_COST_PTD1
ORIG_BURDENED_COST_TOT1
ORIG_LABOR_HOURS_ITD1
ORIG_LABOR_HOURS_YTD1
ORIG_LABOR_HOURS_PTD1
ORIG_LABOR_HOURS_TOT1
BASE_LABOR_HOURS_ITD1
BASE_LABOR_HOURS_YTD1
BASE_LABOR_HOURS_PTD1
BASE_LABOR_HOURS_TOT1
BUDGET_TYPE_CODE2
BUDGET_TYPE2
BASE_RAW_COST_ITD2
BASE_RAW_COST_YTD2
BASE_RAW_COST_PTD2
BASE_RAW_COST_TOT2
ORIG_RAW_COST_ITD2
ORIG_RAW_COST_YTD2
ORIG_RAW_COST_PTD2
ORIG_RAW_COST_TOT2
BASE_BURDENED_COST_ITD2
BASE_BURDENED_COST_YTD2
BASE_BURDENED_COST_PTD2
BASE_BURDENED_COST_TOT2
ORIG_BURDENED_COST_ITD2
ORIG_BURDENED_COST_YTD2
ORIG_BURDENED_COST_PTD2
ORIG_BURDENED_COST_TOT2
ORIG_LABOR_HOURS_ITD2
ORIG_LABOR_HOURS_YTD2
ORIG_LABOR_HOURS_PTD2
ORIG_LABOR_HOURS_TOT2
BASE_LABOR_HOURS_ITD2
BASE_LABOR_HOURS_YTD2
BASE_LABOR_HOURS_PTD2
BASE_LABOR_HOURS_TOT2
BUDGET_TYPE_CODE3
BUDGET_TYPE3
BASE_REVENUE_ITD3
BASE_REVENUE_YTD3
BASE_REVENUE_PTD3
BASE_REVENUE_TOT3
ORIG_REVENUE_ITD3
ORIG_REVENUE_YTD3
ORIG_REVENUE_PTD3
ORIG_REVENUE_TOT3
ORIG_LABOR_HOURS_ITD3
ORIG_LABOR_HOURS_YTD3
ORIG_LABOR_HOURS_PTD3
ORIG_LABOR_HOURS_TOT3
BASE_LABOR_HOURS_ITD3
BASE_LABOR_HOURS_YTD3
BASE_LABOR_HOURS_PTD3
BASE_LABOR_HOURS_TOT3
BUDGET_TYPE_CODE4
BUDGET_TYPE4
BASE_REVENUE_ITD4
BASE_REVENUE_YTD4
BASE_REVENUE_PTD4
BASE_REVENUE_TOT4
ORIG_REVENUE_ITD4
ORIG_REVENUE_YTD4
ORIG_REVENUE_PTD4
ORIG_REVENUE_TOT4
ORIG_LABOR_HOURS_ITD4
ORIG_LABOR_HOURS_YTD4
ORIG_LABOR_HOURS_PTD4
ORIG_LABOR_HOURS_TOT4
BASE_LABOR_HOURS_ITD4
BASE_LABOR_HOURS_YTD4
BASE_LABOR_HOURS_PTD4
BASE_LABOR_HOURS_TOT4