VIEW: PJI.PJI_FP_AGGR_PJP1#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, RECORD_TYPE RECORD_TYPE, PRG_LEVEL PRG_LEVEL, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, RBS_AGGR_LEVEL RBS_AGGR_LEVEL, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID, CURRENCY_CODE CURRENCY_CODE, RBS_ELEMENT_ID RBS_ELEMENT_ID, RBS_VERSION_ID RBS_VERSION_ID, PLAN_VERSION_ID PLAN_VERSION_ID, PLAN_TYPE_ID PLAN_TYPE_ID, 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, LINE_TYPE LINE_TYPE, RATE_DANGLING_FLAG RATE_DANGLING_FLAG, TIME_DANGLING_FLAG TIME_DANGLING_FLAG, START_DATE START_DATE, END_DATE END_DATE, 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, PLAN_TYPE_CODE PLAN_TYPE_CODE from "PJI"."PJI_FP_AGGR_PJP1"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, RECORD_TYPE RECORD_TYPE
, PRG_LEVEL PRG_LEVEL
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID
, TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, RBS_AGGR_LEVEL RBS_AGGR_LEVEL
, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID
, CURRENCY_CODE CURRENCY_CODE
, RBS_ELEMENT_ID RBS_ELEMENT_ID
, RBS_VERSION_ID RBS_VERSION_ID
, PLAN_VERSION_ID PLAN_VERSION_ID
, PLAN_TYPE_ID PLAN_TYPE_ID
, 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
, LINE_TYPE LINE_TYPE
, RATE_DANGLING_FLAG RATE_DANGLING_FLAG
, TIME_DANGLING_FLAG TIME_DANGLING_FLAG
, START_DATE START_DATE
, END_DATE END_DATE
, 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
, PLAN_TYPE_CODE PLAN_TYPE_CODE
FROM "PJI"."PJI_FP_AGGR_PJP1"