SELECT PROJECT_ID, PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID, TIME_ID, PERIOD_TYPE_ID, CALENDAR_TYPE, RBS_AGGR_LEVEL, WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID, CURRENCY_CODE, RBS_ELEMENT_ID, RBS_VERSION_ID, PLAN_VERSION_ID, PLAN_TYPE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, RAW_COST, BRDN_COST, REVENUE, BILL_RAW_COST, BILL_BRDN_COST, BILL_LABOR_RAW_COST, BILL_LABOR_BRDN_COST, BILL_LABOR_HRS, EQUIPMENT_RAW_COST, EQUIPMENT_BRDN_COST, CAPITALIZABLE_RAW_COST, CAPITALIZABLE_BRDN_COST, LABOR_RAW_COST, LABOR_BRDN_COST, LABOR_HRS, LABOR_REVENUE, EQUIPMENT_HOURS, BILLABLE_EQUIPMENT_HOURS, NVL(SUP_INV_COMMITTED_COST,0) SUP_INV_COMMITTED_COST, NVL(PO_COMMITTED_COST,0) PO_COMMITTED_COST, NVL(PR_COMMITTED_COST,0) PR_COMMITTED_COST, NVL(OTH_COMMITTED_COST,0) OTH_COMMITTED_COST, PLAN_TYPE_CODE, CUSTOM1, CUSTOM2, CUSTOM3, CUSTOM4, CUSTOM5, CUSTOM6, CUSTOM7, CUSTOM8, CUSTOM9, CUSTOM10, CUSTOM11, CUSTOM12, CUSTOM13, CUSTOM14, CUSTOM15, CAST(NULL AS NUMBER) CUSTOM16, CAST(NULL AS NUMBER) CUSTOM17, CAST(NULL AS NUMBER) CUSTOM18, CAST(NULL AS NUMBER) CUSTOM19, CAST(NULL AS NUMBER) CUSTOM20, CAST(NULL AS NUMBER) CUSTOM21, CAST(NULL AS NUMBER) CUSTOM22, CAST(NULL AS NUMBER) CUSTOM23, CAST(NULL AS NUMBER) CUSTOM24, CAST(NULL AS NUMBER) CUSTOM25, CAST(NULL AS NUMBER) CUSTOM26, CAST(NULL AS NUMBER) CUSTOM27, CAST(NULL AS NUMBER) CUSTOM28, CAST(NULL AS NUMBER) CUSTOM29, CAST(NULL AS NUMBER) CUSTOM30 FROM PJI_FP_XBS_ACCUM_F
SELECT PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID
, TIME_ID
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, RBS_AGGR_LEVEL
, WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID
, CURRENCY_CODE
, RBS_ELEMENT_ID
, RBS_VERSION_ID
, PLAN_VERSION_ID
, PLAN_TYPE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, RAW_COST
, BRDN_COST
, REVENUE
, BILL_RAW_COST
, BILL_BRDN_COST
, BILL_LABOR_RAW_COST
, BILL_LABOR_BRDN_COST
, BILL_LABOR_HRS
, EQUIPMENT_RAW_COST
, EQUIPMENT_BRDN_COST
, CAPITALIZABLE_RAW_COST
, CAPITALIZABLE_BRDN_COST
, LABOR_RAW_COST
, LABOR_BRDN_COST
, LABOR_HRS
, LABOR_REVENUE
, EQUIPMENT_HOURS
, BILLABLE_EQUIPMENT_HOURS
, NVL(SUP_INV_COMMITTED_COST
, 0) SUP_INV_COMMITTED_COST
, NVL(PO_COMMITTED_COST
, 0) PO_COMMITTED_COST
, NVL(PR_COMMITTED_COST
, 0) PR_COMMITTED_COST
, NVL(OTH_COMMITTED_COST
, 0) OTH_COMMITTED_COST
, PLAN_TYPE_CODE
, CUSTOM1
, CUSTOM2
, CUSTOM3
, CUSTOM4
, CUSTOM5
, CUSTOM6
, CUSTOM7
, CUSTOM8
, CUSTOM9
, CUSTOM10
, CUSTOM11
, CUSTOM12
, CUSTOM13
, CUSTOM14
, CUSTOM15
, CAST(NULL AS NUMBER) CUSTOM16
, CAST(NULL AS NUMBER) CUSTOM17
, CAST(NULL AS NUMBER) CUSTOM18
, CAST(NULL AS NUMBER) CUSTOM19
, CAST(NULL AS NUMBER) CUSTOM20
, CAST(NULL AS NUMBER) CUSTOM21
, CAST(NULL AS NUMBER) CUSTOM22
, CAST(NULL AS NUMBER) CUSTOM23
, CAST(NULL AS NUMBER) CUSTOM24
, CAST(NULL AS NUMBER) CUSTOM25
, CAST(NULL AS NUMBER) CUSTOM26
, CAST(NULL AS NUMBER) CUSTOM27
, CAST(NULL AS NUMBER) CUSTOM28
, CAST(NULL AS NUMBER) CUSTOM29
, CAST(NULL AS NUMBER) CUSTOM30
FROM PJI_FP_XBS_ACCUM_F
|
|
|