VIEW: PA.PA_PROJECT_ACCUM_COMMITMENTS#

Source

View Text - Preformatted

select PROJECT_ACCUM_ID PROJECT_ACCUM_ID, CMT_RAW_COST_ITD CMT_RAW_COST_ITD, CMT_RAW_COST_YTD CMT_RAW_COST_YTD, CMT_RAW_COST_PP CMT_RAW_COST_PP, CMT_RAW_COST_PTD CMT_RAW_COST_PTD, CMT_BURDENED_COST_ITD CMT_BURDENED_COST_ITD, CMT_BURDENED_COST_YTD CMT_BURDENED_COST_YTD, CMT_BURDENED_COST_PP CMT_BURDENED_COST_PP, CMT_BURDENED_COST_PTD CMT_BURDENED_COST_PTD, CMT_QUANTITY_ITD CMT_QUANTITY_ITD, CMT_QUANTITY_YTD CMT_QUANTITY_YTD, CMT_QUANTITY_PP CMT_QUANTITY_PP, CMT_QUANTITY_PTD CMT_QUANTITY_PTD, CMT_UNIT_OF_MEASURE CMT_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 from "PA"."PA_PROJECT_ACCUM_COMMITMENTS"

View Text - HTML Formatted

SELECT PROJECT_ACCUM_ID PROJECT_ACCUM_ID
, CMT_RAW_COST_ITD CMT_RAW_COST_ITD
, CMT_RAW_COST_YTD CMT_RAW_COST_YTD
, CMT_RAW_COST_PP CMT_RAW_COST_PP
, CMT_RAW_COST_PTD CMT_RAW_COST_PTD
, CMT_BURDENED_COST_ITD CMT_BURDENED_COST_ITD
, CMT_BURDENED_COST_YTD CMT_BURDENED_COST_YTD
, CMT_BURDENED_COST_PP CMT_BURDENED_COST_PP
, CMT_BURDENED_COST_PTD CMT_BURDENED_COST_PTD
, CMT_QUANTITY_ITD CMT_QUANTITY_ITD
, CMT_QUANTITY_YTD CMT_QUANTITY_YTD
, CMT_QUANTITY_PP CMT_QUANTITY_PP
, CMT_QUANTITY_PTD CMT_QUANTITY_PTD
, CMT_UNIT_OF_MEASURE CMT_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
FROM "PA"."PA_PROJECT_ACCUM_COMMITMENTS"