VIEW: PA.PA_FP_MERGED_CTRL_ITEMS#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, PLAN_VERSION_ID PLAN_VERSION_ID, CI_ID CI_ID, CI_PLAN_VERSION_ID CI_PLAN_VERSION_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, INCLUSION_METHOD_CODE INCLUSION_METHOD_CODE, INCLUDED_BY_PERSON_ID INCLUDED_BY_PERSON_ID, VERSION_TYPE VERSION_TYPE, IMPL_PROJ_FUNC_RAW_COST IMPL_PROJ_FUNC_RAW_COST, IMPL_PROJ_FUNC_BURDENED_COST IMPL_PROJ_FUNC_BURDENED_COST, IMPL_PROJ_FUNC_REVENUE IMPL_PROJ_FUNC_REVENUE, IMPL_PROJ_RAW_COST IMPL_PROJ_RAW_COST, IMPL_PROJ_BURDENED_COST IMPL_PROJ_BURDENED_COST, IMPL_PROJ_REVENUE IMPL_PROJ_REVENUE, IMPL_QUANTITY IMPL_QUANTITY, IMPL_EQUIPMENT_QUANTITY IMPL_EQUIPMENT_QUANTITY, IMPL_AGR_REVENUE IMPL_AGR_REVENUE from "PA"."PA_FP_MERGED_CTRL_ITEMS"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, PLAN_VERSION_ID PLAN_VERSION_ID
, CI_ID CI_ID
, CI_PLAN_VERSION_ID CI_PLAN_VERSION_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, INCLUSION_METHOD_CODE INCLUSION_METHOD_CODE
, INCLUDED_BY_PERSON_ID INCLUDED_BY_PERSON_ID
, VERSION_TYPE VERSION_TYPE
, IMPL_PROJ_FUNC_RAW_COST IMPL_PROJ_FUNC_RAW_COST
, IMPL_PROJ_FUNC_BURDENED_COST IMPL_PROJ_FUNC_BURDENED_COST
, IMPL_PROJ_FUNC_REVENUE IMPL_PROJ_FUNC_REVENUE
, IMPL_PROJ_RAW_COST IMPL_PROJ_RAW_COST
, IMPL_PROJ_BURDENED_COST IMPL_PROJ_BURDENED_COST
, IMPL_PROJ_REVENUE IMPL_PROJ_REVENUE
, IMPL_QUANTITY IMPL_QUANTITY
, IMPL_EQUIPMENT_QUANTITY IMPL_EQUIPMENT_QUANTITY
, IMPL_AGR_REVENUE IMPL_AGR_REVENUE
FROM "PA"."PA_FP_MERGED_CTRL_ITEMS"