VIEW: PA.PA_PJT_RBS_CBS_FACT#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, RBS_AGGR_LEVEL RBS_AGGR_LEVEL, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG, CURRENCY_CODE CURRENCY_CODE, PLAN_VERSION_ID PLAN_VERSION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RAW_COST RAW_COST, BRDN_COST BRDN_COST, REVENUE REVENUE, BILL_RAW_COST BILL_RAW_COST, BILL_BRDN_COST BILL_BRDN_COST, BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST, BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST, BILL_LABOR_HRS BILL_LABOR_HRS, EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST, CAPITALIZABLE_RAW_COST CAPITALIZABLE_RAW_COST, CAPITALIZABLE_BRDN_COST CAPITALIZABLE_BRDN_COST, LABOR_RAW_COST LABOR_RAW_COST, LABOR_BRDN_COST LABOR_BRDN_COST, LABOR_HRS LABOR_HRS, LABOR_REVENUE LABOR_REVENUE, EQUIPMENT_HOURS EQUIPMENT_HOURS, BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS, SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST, PO_COMMITTED_COST PO_COMMITTED_COST, PR_COMMITTED_COST PR_COMMITTED_COST, OTH_COMMITTED_COST OTH_COMMITTED_COST, CUSTOM1 CUSTOM1, CUSTOM2 CUSTOM2, CUSTOM3 CUSTOM3, CUSTOM4 CUSTOM4, CUSTOM5 CUSTOM5, CUSTOM6 CUSTOM6, CUSTOM7 CUSTOM7, CUSTOM8 CUSTOM8, CUSTOM9 CUSTOM9, CUSTOM10 CUSTOM10, CUSTOM11 CUSTOM11, CUSTOM12 CUSTOM12, CUSTOM13 CUSTOM13, CUSTOM14 CUSTOM14, CUSTOM15 CUSTOM15, ACT_LABOR_HRS ACT_LABOR_HRS, ACT_EQUIP_HRS ACT_EQUIP_HRS, ACT_LABOR_BRDN_COST ACT_LABOR_BRDN_COST, ACT_EQUIP_BRDN_COST ACT_EQUIP_BRDN_COST, ACT_BRDN_COST ACT_BRDN_COST, ACT_RAW_COST ACT_RAW_COST, ACT_REVENUE ACT_REVENUE, ETC_LABOR_HRS ETC_LABOR_HRS, ETC_EQUIP_HRS ETC_EQUIP_HRS, ETC_LABOR_BRDN_COST ETC_LABOR_BRDN_COST, ETC_EQUIP_BRDN_COST ETC_EQUIP_BRDN_COST, ETC_BRDN_COST ETC_BRDN_COST, ETC_RAW_COST ETC_RAW_COST, ACT_LABOR_RAW_COST ACT_LABOR_RAW_COST, ACT_EQUIP_RAW_COST ACT_EQUIP_RAW_COST, ETC_LABOR_RAW_COST ETC_LABOR_RAW_COST, ETC_EQUIP_RAW_COST ETC_EQUIP_RAW_COST, RBS_CBS_ELEMENT_ID RBS_CBS_ELEMENT_ID, RBS_CBS_VERSION_ID RBS_CBS_VERSION_ID, ROLLUP_TYPE ROLLUP_TYPE from "PA"."PA_PJT_RBS_CBS_FACT"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, RBS_AGGR_LEVEL RBS_AGGR_LEVEL
, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG
, CURRENCY_CODE CURRENCY_CODE
, PLAN_VERSION_ID PLAN_VERSION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RAW_COST RAW_COST
, BRDN_COST BRDN_COST
, REVENUE REVENUE
, BILL_RAW_COST BILL_RAW_COST
, BILL_BRDN_COST BILL_BRDN_COST
, BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST
, BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST
, BILL_LABOR_HRS BILL_LABOR_HRS
, EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST
, EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST
, CAPITALIZABLE_RAW_COST CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_BRDN_COST CAPITALIZABLE_BRDN_COST
, LABOR_RAW_COST LABOR_RAW_COST
, LABOR_BRDN_COST LABOR_BRDN_COST
, LABOR_HRS LABOR_HRS
, LABOR_REVENUE LABOR_REVENUE
, EQUIPMENT_HOURS EQUIPMENT_HOURS
, BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS
, SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST
, PO_COMMITTED_COST PO_COMMITTED_COST
, PR_COMMITTED_COST PR_COMMITTED_COST
, OTH_COMMITTED_COST OTH_COMMITTED_COST
, CUSTOM1 CUSTOM1
, CUSTOM2 CUSTOM2
, CUSTOM3 CUSTOM3
, CUSTOM4 CUSTOM4
, CUSTOM5 CUSTOM5
, CUSTOM6 CUSTOM6
, CUSTOM7 CUSTOM7
, CUSTOM8 CUSTOM8
, CUSTOM9 CUSTOM9
, CUSTOM10 CUSTOM10
, CUSTOM11 CUSTOM11
, CUSTOM12 CUSTOM12
, CUSTOM13 CUSTOM13
, CUSTOM14 CUSTOM14
, CUSTOM15 CUSTOM15
, ACT_LABOR_HRS ACT_LABOR_HRS
, ACT_EQUIP_HRS ACT_EQUIP_HRS
, ACT_LABOR_BRDN_COST ACT_LABOR_BRDN_COST
, ACT_EQUIP_BRDN_COST ACT_EQUIP_BRDN_COST
, ACT_BRDN_COST ACT_BRDN_COST
, ACT_RAW_COST ACT_RAW_COST
, ACT_REVENUE ACT_REVENUE
, ETC_LABOR_HRS ETC_LABOR_HRS
, ETC_EQUIP_HRS ETC_EQUIP_HRS
, ETC_LABOR_BRDN_COST ETC_LABOR_BRDN_COST
, ETC_EQUIP_BRDN_COST ETC_EQUIP_BRDN_COST
, ETC_BRDN_COST ETC_BRDN_COST
, ETC_RAW_COST ETC_RAW_COST
, ACT_LABOR_RAW_COST ACT_LABOR_RAW_COST
, ACT_EQUIP_RAW_COST ACT_EQUIP_RAW_COST
, ETC_LABOR_RAW_COST ETC_LABOR_RAW_COST
, ETC_EQUIP_RAW_COST ETC_EQUIP_RAW_COST
, RBS_CBS_ELEMENT_ID RBS_CBS_ELEMENT_ID
, RBS_CBS_VERSION_ID RBS_CBS_VERSION_ID
, ROLLUP_TYPE ROLLUP_TYPE
FROM "PA"."PA_PJT_RBS_CBS_FACT"