VIEW: PJI.PJI_FM_EXTR_PLAN_LINES_DEBUG#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, STRUCT_VER_ID STRUCT_VER_ID, PERIOD_NAME PERIOD_NAME, CALENDAR_TYPE CALENDAR_TYPE, START_DATE START_DATE, END_DATE END_DATE, RBS_ELEMENT_ID RBS_ELEMENT_ID, RBS_VERSION_ID RBS_VERSION_ID, PLAN_VERSION_ID PLAN_VERSION_ID, PLAN_TYPE_ID PLAN_TYPE_ID, WP_VERSION_FLAG WP_VERSION_FLAG, ROLLUP_TYPE ROLLUP_TYPE, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_RAW_COST TXN_RAW_COST, TXN_BURDENED_COST TXN_BURDENED_COST, TXN_REVENUE TXN_REVENUE, PRJ_CURRENCY_CODE PRJ_CURRENCY_CODE, PRJ_RAW_COST PRJ_RAW_COST, PRJ_BURDENED_COST PRJ_BURDENED_COST, PRJ_REVENUE PRJ_REVENUE, PFC_CURRENCY_CODE PFC_CURRENCY_CODE, PFC_RAW_COST PFC_RAW_COST, PFC_BURDENED_COST PFC_BURDENED_COST, PFC_REVENUE PFC_REVENUE, QUANTITY QUANTITY, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, RATE_BASED_FLAG RATE_BASED_FLAG, ACT_QUANTITY ACT_QUANTITY, ACT_TXN_BURDENED_COST ACT_TXN_BURDENED_COST, ACT_PRJ_BURDENED_COST ACT_PRJ_BURDENED_COST, ACT_PFC_BURDENED_COST ACT_PFC_BURDENED_COST, ACT_TXN_RAW_COST ACT_TXN_RAW_COST, ACT_PRJ_RAW_COST ACT_PRJ_RAW_COST, ACT_PFC_RAW_COST ACT_PFC_RAW_COST, ACT_TXN_REVENUE ACT_TXN_REVENUE, ACT_PRJ_REVENUE ACT_PRJ_REVENUE, ACT_PFC_REVENUE ACT_PFC_REVENUE, ETC_QUANTITY ETC_QUANTITY, ETC_TXN_BURDENED_COST ETC_TXN_BURDENED_COST, ETC_PRJ_BURDENED_COST ETC_PRJ_BURDENED_COST, ETC_PFC_BURDENED_COST ETC_PFC_BURDENED_COST, ETC_TXN_RAW_COST ETC_TXN_RAW_COST, ETC_PRJ_RAW_COST ETC_PRJ_RAW_COST, ETC_PFC_RAW_COST ETC_PFC_RAW_COST, CREATION_DATE CREATION_DATE from "PJI"."PJI_FM_EXTR_PLAN_LINES_DEBUG"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID
, STRUCT_VER_ID STRUCT_VER_ID
, PERIOD_NAME PERIOD_NAME
, CALENDAR_TYPE CALENDAR_TYPE
, START_DATE START_DATE
, END_DATE END_DATE
, RBS_ELEMENT_ID RBS_ELEMENT_ID
, RBS_VERSION_ID RBS_VERSION_ID
, PLAN_VERSION_ID PLAN_VERSION_ID
, PLAN_TYPE_ID PLAN_TYPE_ID
, WP_VERSION_FLAG WP_VERSION_FLAG
, ROLLUP_TYPE ROLLUP_TYPE
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BURDENED_COST TXN_BURDENED_COST
, TXN_REVENUE TXN_REVENUE
, PRJ_CURRENCY_CODE PRJ_CURRENCY_CODE
, PRJ_RAW_COST PRJ_RAW_COST
, PRJ_BURDENED_COST PRJ_BURDENED_COST
, PRJ_REVENUE PRJ_REVENUE
, PFC_CURRENCY_CODE PFC_CURRENCY_CODE
, PFC_RAW_COST PFC_RAW_COST
, PFC_BURDENED_COST PFC_BURDENED_COST
, PFC_REVENUE PFC_REVENUE
, QUANTITY QUANTITY
, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, RATE_BASED_FLAG RATE_BASED_FLAG
, ACT_QUANTITY ACT_QUANTITY
, ACT_TXN_BURDENED_COST ACT_TXN_BURDENED_COST
, ACT_PRJ_BURDENED_COST ACT_PRJ_BURDENED_COST
, ACT_PFC_BURDENED_COST ACT_PFC_BURDENED_COST
, ACT_TXN_RAW_COST ACT_TXN_RAW_COST
, ACT_PRJ_RAW_COST ACT_PRJ_RAW_COST
, ACT_PFC_RAW_COST ACT_PFC_RAW_COST
, ACT_TXN_REVENUE ACT_TXN_REVENUE
, ACT_PRJ_REVENUE ACT_PRJ_REVENUE
, ACT_PFC_REVENUE ACT_PFC_REVENUE
, ETC_QUANTITY ETC_QUANTITY
, ETC_TXN_BURDENED_COST ETC_TXN_BURDENED_COST
, ETC_PRJ_BURDENED_COST ETC_PRJ_BURDENED_COST
, ETC_PFC_BURDENED_COST ETC_PFC_BURDENED_COST
, ETC_TXN_RAW_COST ETC_TXN_RAW_COST
, ETC_PRJ_RAW_COST ETC_PRJ_RAW_COST
, ETC_PFC_RAW_COST ETC_PFC_RAW_COST
, CREATION_DATE CREATION_DATE
FROM "PJI"."PJI_FM_EXTR_PLAN_LINES_DEBUG"