VIEW: PA.PA_PROJECT_ACCUM_BUDGETS#

Source

View Text - Preformatted

select PROJECT_ACCUM_ID PROJECT_ACCUM_ID, BUDGET_TYPE_CODE BUDGET_TYPE_CODE, BASE_RAW_COST_ITD BASE_RAW_COST_ITD, BASE_RAW_COST_YTD BASE_RAW_COST_YTD, BASE_RAW_COST_PP BASE_RAW_COST_PP, BASE_RAW_COST_PTD BASE_RAW_COST_PTD, BASE_BURDENED_COST_ITD BASE_BURDENED_COST_ITD, BASE_BURDENED_COST_YTD BASE_BURDENED_COST_YTD, BASE_BURDENED_COST_PP BASE_BURDENED_COST_PP, BASE_BURDENED_COST_PTD BASE_BURDENED_COST_PTD, ORIG_RAW_COST_ITD ORIG_RAW_COST_ITD, ORIG_RAW_COST_YTD ORIG_RAW_COST_YTD, ORIG_RAW_COST_PP ORIG_RAW_COST_PP, ORIG_RAW_COST_PTD ORIG_RAW_COST_PTD, ORIG_BURDENED_COST_ITD ORIG_BURDENED_COST_ITD, ORIG_BURDENED_COST_YTD ORIG_BURDENED_COST_YTD, ORIG_BURDENED_COST_PP ORIG_BURDENED_COST_PP, ORIG_BURDENED_COST_PTD ORIG_BURDENED_COST_PTD, BASE_REVENUE_ITD BASE_REVENUE_ITD, BASE_REVENUE_YTD BASE_REVENUE_YTD, BASE_REVENUE_PP BASE_REVENUE_PP, BASE_REVENUE_PTD BASE_REVENUE_PTD, ORIG_REVENUE_ITD ORIG_REVENUE_ITD, ORIG_REVENUE_YTD ORIG_REVENUE_YTD, ORIG_REVENUE_PP ORIG_REVENUE_PP, ORIG_REVENUE_PTD ORIG_REVENUE_PTD, ORIG_LABOR_HOURS_ITD ORIG_LABOR_HOURS_ITD, ORIG_LABOR_HOURS_YTD ORIG_LABOR_HOURS_YTD, ORIG_LABOR_HOURS_PP ORIG_LABOR_HOURS_PP, ORIG_LABOR_HOURS_PTD ORIG_LABOR_HOURS_PTD, BASE_LABOR_HOURS_ITD BASE_LABOR_HOURS_ITD, BASE_LABOR_HOURS_YTD BASE_LABOR_HOURS_YTD, BASE_LABOR_HOURS_PP BASE_LABOR_HOURS_PP, BASE_LABOR_HOURS_PTD BASE_LABOR_HOURS_PTD, ORIG_QUANTITY_YTD ORIG_QUANTITY_YTD, ORIG_QUANTITY_ITD ORIG_QUANTITY_ITD, ORIG_QUANTITY_PP ORIG_QUANTITY_PP, ORIG_QUANTITY_PTD ORIG_QUANTITY_PTD, BASE_QUANTITY_YTD BASE_QUANTITY_YTD, BASE_QUANTITY_ITD BASE_QUANTITY_ITD, BASE_QUANTITY_PP BASE_QUANTITY_PP, BASE_QUANTITY_PTD BASE_QUANTITY_PTD, ORIG_LABOR_HOURS_TOT ORIG_LABOR_HOURS_TOT, BASE_LABOR_HOURS_TOT BASE_LABOR_HOURS_TOT, ORIG_QUANTITY_TOT ORIG_QUANTITY_TOT, BASE_QUANTITY_TOT BASE_QUANTITY_TOT, BASE_RAW_COST_TOT BASE_RAW_COST_TOT, BASE_BURDENED_COST_TOT BASE_BURDENED_COST_TOT, ORIG_RAW_COST_TOT ORIG_RAW_COST_TOT, ORIG_BURDENED_COST_TOT ORIG_BURDENED_COST_TOT, BASE_REVENUE_TOT BASE_REVENUE_TOT, ORIG_REVENUE_TOT ORIG_REVENUE_TOT, BASE_UNIT_OF_MEASURE BASE_UNIT_OF_MEASURE, ORIG_UNIT_OF_MEASURE ORIG_UNIT_OF_MEASURE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID from "PA"."PA_PROJECT_ACCUM_BUDGETS"

View Text - HTML Formatted

SELECT PROJECT_ACCUM_ID PROJECT_ACCUM_ID
, BUDGET_TYPE_CODE BUDGET_TYPE_CODE
, BASE_RAW_COST_ITD BASE_RAW_COST_ITD
, BASE_RAW_COST_YTD BASE_RAW_COST_YTD
, BASE_RAW_COST_PP BASE_RAW_COST_PP
, BASE_RAW_COST_PTD BASE_RAW_COST_PTD
, BASE_BURDENED_COST_ITD BASE_BURDENED_COST_ITD
, BASE_BURDENED_COST_YTD BASE_BURDENED_COST_YTD
, BASE_BURDENED_COST_PP BASE_BURDENED_COST_PP
, BASE_BURDENED_COST_PTD BASE_BURDENED_COST_PTD
, ORIG_RAW_COST_ITD ORIG_RAW_COST_ITD
, ORIG_RAW_COST_YTD ORIG_RAW_COST_YTD
, ORIG_RAW_COST_PP ORIG_RAW_COST_PP
, ORIG_RAW_COST_PTD ORIG_RAW_COST_PTD
, ORIG_BURDENED_COST_ITD ORIG_BURDENED_COST_ITD
, ORIG_BURDENED_COST_YTD ORIG_BURDENED_COST_YTD
, ORIG_BURDENED_COST_PP ORIG_BURDENED_COST_PP
, ORIG_BURDENED_COST_PTD ORIG_BURDENED_COST_PTD
, BASE_REVENUE_ITD BASE_REVENUE_ITD
, BASE_REVENUE_YTD BASE_REVENUE_YTD
, BASE_REVENUE_PP BASE_REVENUE_PP
, BASE_REVENUE_PTD BASE_REVENUE_PTD
, ORIG_REVENUE_ITD ORIG_REVENUE_ITD
, ORIG_REVENUE_YTD ORIG_REVENUE_YTD
, ORIG_REVENUE_PP ORIG_REVENUE_PP
, ORIG_REVENUE_PTD ORIG_REVENUE_PTD
, ORIG_LABOR_HOURS_ITD ORIG_LABOR_HOURS_ITD
, ORIG_LABOR_HOURS_YTD ORIG_LABOR_HOURS_YTD
, ORIG_LABOR_HOURS_PP ORIG_LABOR_HOURS_PP
, ORIG_LABOR_HOURS_PTD ORIG_LABOR_HOURS_PTD
, BASE_LABOR_HOURS_ITD BASE_LABOR_HOURS_ITD
, BASE_LABOR_HOURS_YTD BASE_LABOR_HOURS_YTD
, BASE_LABOR_HOURS_PP BASE_LABOR_HOURS_PP
, BASE_LABOR_HOURS_PTD BASE_LABOR_HOURS_PTD
, ORIG_QUANTITY_YTD ORIG_QUANTITY_YTD
, ORIG_QUANTITY_ITD ORIG_QUANTITY_ITD
, ORIG_QUANTITY_PP ORIG_QUANTITY_PP
, ORIG_QUANTITY_PTD ORIG_QUANTITY_PTD
, BASE_QUANTITY_YTD BASE_QUANTITY_YTD
, BASE_QUANTITY_ITD BASE_QUANTITY_ITD
, BASE_QUANTITY_PP BASE_QUANTITY_PP
, BASE_QUANTITY_PTD BASE_QUANTITY_PTD
, ORIG_LABOR_HOURS_TOT ORIG_LABOR_HOURS_TOT
, BASE_LABOR_HOURS_TOT BASE_LABOR_HOURS_TOT
, ORIG_QUANTITY_TOT ORIG_QUANTITY_TOT
, BASE_QUANTITY_TOT BASE_QUANTITY_TOT
, BASE_RAW_COST_TOT BASE_RAW_COST_TOT
, BASE_BURDENED_COST_TOT BASE_BURDENED_COST_TOT
, ORIG_RAW_COST_TOT ORIG_RAW_COST_TOT
, ORIG_BURDENED_COST_TOT ORIG_BURDENED_COST_TOT
, BASE_REVENUE_TOT BASE_REVENUE_TOT
, ORIG_REVENUE_TOT ORIG_REVENUE_TOT
, BASE_UNIT_OF_MEASURE BASE_UNIT_OF_MEASURE
, ORIG_UNIT_OF_MEASURE ORIG_UNIT_OF_MEASURE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FIN_PLAN_TYPE_ID FIN_PLAN_TYPE_ID
FROM "PA"."PA_PROJECT_ACCUM_BUDGETS"