VIEW: APPS.PA_PLAN_ACTUALS_FACT_V

Source

View Text - Preformatted

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, -1 cbs_element_id , -1 cbs_version_id FROM PJI_FP_XBS_ACCUM_F

View Text - HTML Formatted

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
, -1 CBS_ELEMENT_ID
, -1 CBS_VERSION_ID
FROM PJI_FP_XBS_ACCUM_F