VIEW: PA.PA_PRJ_ACCUM_ACTUALS_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_RELEASE PURGE_RELEASE, PURGE_PROJECT_ID PURGE_PROJECT_ID, LABOR_HOURS_YTD LABOR_HOURS_YTD, LABOR_HOURS_PP LABOR_HOURS_PP, LABOR_HOURS_PTD LABOR_HOURS_PTD, BILLABLE_QUANTITY_ITD BILLABLE_QUANTITY_ITD, BILLABLE_QUANTITY_YTD BILLABLE_QUANTITY_YTD, BILLABLE_QUANTITY_PP BILLABLE_QUANTITY_PP, BILLABLE_QUANTITY_PTD BILLABLE_QUANTITY_PTD, BILLABLE_LABOR_HOURS_ITD BILLABLE_LABOR_HOURS_ITD, BILLABLE_LABOR_HOURS_YTD BILLABLE_LABOR_HOURS_YTD, BILLABLE_LABOR_HOURS_PP BILLABLE_LABOR_HOURS_PP, BILLABLE_LABOR_HOURS_PTD BILLABLE_LABOR_HOURS_PTD, REVENUE_ITD REVENUE_ITD, REVENUE_YTD REVENUE_YTD, REVENUE_PP REVENUE_PP, REVENUE_PTD REVENUE_PTD, TXN_UNIT_OF_MEASURE TXN_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, PROJECT_ACCUM_ID PROJECT_ACCUM_ID, RAW_COST_ITD RAW_COST_ITD, RAW_COST_YTD RAW_COST_YTD, RAW_COST_PP RAW_COST_PP, RAW_COST_PTD RAW_COST_PTD, BILLABLE_RAW_COST_ITD BILLABLE_RAW_COST_ITD, BILLABLE_RAW_COST_YTD BILLABLE_RAW_COST_YTD, BILLABLE_RAW_COST_PP BILLABLE_RAW_COST_PP, BILLABLE_RAW_COST_PTD BILLABLE_RAW_COST_PTD, BURDENED_COST_ITD BURDENED_COST_ITD, BURDENED_COST_YTD BURDENED_COST_YTD, BURDENED_COST_PP BURDENED_COST_PP, BURDENED_COST_PTD BURDENED_COST_PTD, BILLABLE_BURDENED_COST_ITD BILLABLE_BURDENED_COST_ITD, BILLABLE_BURDENED_COST_YTD BILLABLE_BURDENED_COST_YTD, BILLABLE_BURDENED_COST_PP BILLABLE_BURDENED_COST_PP, BILLABLE_BURDENED_COST_PTD BILLABLE_BURDENED_COST_PTD, QUANTITY_ITD QUANTITY_ITD, QUANTITY_YTD QUANTITY_YTD, QUANTITY_PP QUANTITY_PP, QUANTITY_PTD QUANTITY_PTD, LABOR_HOURS_ITD LABOR_HOURS_ITD from "PA"."PA_PRJ_ACCUM_ACTUALS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_RELEASE PURGE_RELEASE
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, LABOR_HOURS_YTD LABOR_HOURS_YTD
, LABOR_HOURS_PP LABOR_HOURS_PP
, LABOR_HOURS_PTD LABOR_HOURS_PTD
, BILLABLE_QUANTITY_ITD BILLABLE_QUANTITY_ITD
, BILLABLE_QUANTITY_YTD BILLABLE_QUANTITY_YTD
, BILLABLE_QUANTITY_PP BILLABLE_QUANTITY_PP
, BILLABLE_QUANTITY_PTD BILLABLE_QUANTITY_PTD
, BILLABLE_LABOR_HOURS_ITD BILLABLE_LABOR_HOURS_ITD
, BILLABLE_LABOR_HOURS_YTD BILLABLE_LABOR_HOURS_YTD
, BILLABLE_LABOR_HOURS_PP BILLABLE_LABOR_HOURS_PP
, BILLABLE_LABOR_HOURS_PTD BILLABLE_LABOR_HOURS_PTD
, REVENUE_ITD REVENUE_ITD
, REVENUE_YTD REVENUE_YTD
, REVENUE_PP REVENUE_PP
, REVENUE_PTD REVENUE_PTD
, TXN_UNIT_OF_MEASURE TXN_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
, PROJECT_ACCUM_ID PROJECT_ACCUM_ID
, RAW_COST_ITD RAW_COST_ITD
, RAW_COST_YTD RAW_COST_YTD
, RAW_COST_PP RAW_COST_PP
, RAW_COST_PTD RAW_COST_PTD
, BILLABLE_RAW_COST_ITD BILLABLE_RAW_COST_ITD
, BILLABLE_RAW_COST_YTD BILLABLE_RAW_COST_YTD
, BILLABLE_RAW_COST_PP BILLABLE_RAW_COST_PP
, BILLABLE_RAW_COST_PTD BILLABLE_RAW_COST_PTD
, BURDENED_COST_ITD BURDENED_COST_ITD
, BURDENED_COST_YTD BURDENED_COST_YTD
, BURDENED_COST_PP BURDENED_COST_PP
, BURDENED_COST_PTD BURDENED_COST_PTD
, BILLABLE_BURDENED_COST_ITD BILLABLE_BURDENED_COST_ITD
, BILLABLE_BURDENED_COST_YTD BILLABLE_BURDENED_COST_YTD
, BILLABLE_BURDENED_COST_PP BILLABLE_BURDENED_COST_PP
, BILLABLE_BURDENED_COST_PTD BILLABLE_BURDENED_COST_PTD
, QUANTITY_ITD QUANTITY_ITD
, QUANTITY_YTD QUANTITY_YTD
, QUANTITY_PP QUANTITY_PP
, QUANTITY_PTD QUANTITY_PTD
, LABOR_HOURS_ITD LABOR_HOURS_ITD
FROM "PA"."PA_PRJ_ACCUM_ACTUALS_AR"