VIEW: APPS.PA_RPT_CUST_BGT_SUMMARY

Source

View Text - Preformatted

SELECT pah.PROJECT_ACCUM_ID , pab.BUDGET_TYPE_CODE , pah.accum_period , pc.customer_id, pc.customer_bill_split, decode(pc.customer_bill_split,0,0,pab.BASE_RAW_COST_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_RAW_COST_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_RAW_COST_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_RAW_COST_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_BURDENED_COST_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_BURDENED_COST_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_BURDENED_COST_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_BURDENED_COST_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_RAW_COST_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_RAW_COST_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_RAW_COST_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_RAW_COST_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_BURDENED_COST_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_BURDENED_COST_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_BURDENED_COST_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_BURDENED_COST_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_REVENUE_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_REVENUE_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_REVENUE_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_REVENUE_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_REVENUE_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_REVENUE_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_REVENUE_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_REVENUE_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_LABOR_HOURS_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_LABOR_HOURS_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_LABOR_HOURS_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_LABOR_HOURS_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_LABOR_HOURS_ITD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_LABOR_HOURS_YTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_LABOR_HOURS_PP*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_LABOR_HOURS_PTD*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_LABOR_HOURS_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_LABOR_HOURS_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_RAW_COST_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_BURDENED_COST_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_RAW_COST_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_BURDENED_COST_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.BASE_REVENUE_TOT*pc.customer_bill_split/100) , decode(pc.customer_bill_split,0,0,pab.ORIG_REVENUE_TOT*pc.customer_bill_split/100) , pah.project_id , pbt.budget_amount_code, pbt.budget_type, ppt.org_id FROM pa_project_accum_budgets pab , pa_project_accum_headers pah , pa_project_customers pc, pa_projects_all ppa, pa_budget_types pbt, pa_project_types ppt WHERE pab.project_accum_id = pah.project_accum_id AND pah.resource_list_member_id = 0 AND pab.budget_type_code = pbt.budget_type_code AND pah.task_id = 0 AND pah.project_id = ppa.project_id AND ppa.project_type = ppt.project_type AND pc.project_id = ppa.project_id AND ppt.project_type_class_code = 'CONTRACT'

View Text - HTML Formatted

SELECT PAH.PROJECT_ACCUM_ID
, PAB.BUDGET_TYPE_CODE
, PAH.ACCUM_PERIOD
, PC.CUSTOMER_ID
, PC.CUSTOMER_BILL_SPLIT
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_RAW_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_RAW_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_RAW_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_RAW_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_BURDENED_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_BURDENED_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_BURDENED_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_BURDENED_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_RAW_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_RAW_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_RAW_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_RAW_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_BURDENED_COST_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_BURDENED_COST_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_BURDENED_COST_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_BURDENED_COST_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_REVENUE_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_REVENUE_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_REVENUE_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_REVENUE_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_REVENUE_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_REVENUE_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_REVENUE_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_REVENUE_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_LABOR_HOURS_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_LABOR_HOURS_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_LABOR_HOURS_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_LABOR_HOURS_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_LABOR_HOURS_ITD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_LABOR_HOURS_YTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_LABOR_HOURS_PP*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_LABOR_HOURS_PTD*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_LABOR_HOURS_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_LABOR_HOURS_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_RAW_COST_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_BURDENED_COST_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_RAW_COST_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_BURDENED_COST_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.BASE_REVENUE_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, DECODE(PC.CUSTOMER_BILL_SPLIT
, 0
, 0
, PAB.ORIG_REVENUE_TOT*PC.CUSTOMER_BILL_SPLIT/100)
, PAH.PROJECT_ID
, PBT.BUDGET_AMOUNT_CODE
, PBT.BUDGET_TYPE
, PPT.ORG_ID
FROM PA_PROJECT_ACCUM_BUDGETS PAB
, PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_CUSTOMERS PC
, PA_PROJECTS_ALL PPA
, PA_BUDGET_TYPES PBT
, PA_PROJECT_TYPES PPT
WHERE PAB.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PAH.TASK_ID = 0
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PC.PROJECT_ID = PPA.PROJECT_ID
AND PPT.PROJECT_TYPE_CLASS_CODE = 'CONTRACT'