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.PA_PROJECT_ACCUM_BUDGETS_EFC#

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, 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, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CREATION_DATE CREATION_DATE from "PA"."PA_PROJECT_ACCUM_BUDGETS_EFC"

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
, 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
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CREATION_DATE CREATION_DATE
FROM "PA"."PA_PROJECT_ACCUM_BUDGETS_EFC"