VIEW: APPS.PA_OLAP_STAGE_V

Source

View Text - Preformatted

SELECT OLAP_GROUP, PROJECT_ID, decode(PROJECT_ELEMENT_ID,-1,-1, -1*PROJECT_ELEMENT_ID) PROJECT_ELEMENT_ID , TIME_ID, CALENDAR_TYPE, CURRENCY_CODE, decode(RBS_ELEMENT_ID,-1,-1,-1*RBS_ELEMENT_ID) RBS_ELEMENT_ID, RBS_VERSION_ID, PLAN_VERSION_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, SUP_INV_COMMITTED_COST, PO_COMMITTED_COST, PR_COMMITTED_COST, OTH_COMMITTED_COST, CUSTOM1, CUSTOM2, CUSTOM3, CUSTOM4, CUSTOM5, CUSTOM6, CUSTOM7, CUSTOM8, CUSTOM9, CUSTOM10, CUSTOM11, CUSTOM12, CUSTOM13, CUSTOM14, CUSTOM15, ACT_LABOR_HRS, ACT_EQUIP_HRS, ACT_LABOR_BRDN_COST, ACT_EQUIP_BRDN_COST, ACT_BRDN_COST, ACT_RAW_COST, ACT_REVENUE, ETC_LABOR_HRS, ETC_EQUIP_HRS, ETC_LABOR_BRDN_COST, ETC_EQUIP_BRDN_COST, ETC_BRDN_COST, ETC_RAW_COST, ACT_LABOR_RAW_COST, ACT_EQUIP_RAW_COST, ETC_LABOR_RAW_COST, ETC_EQUIP_RAW_COST, CBS_VERSION_ID, decode(CBS_ELEMENT_ID,-1,-1,-1*cbs_element_id ) cbs_element_id from pa_olap_stage

View Text - HTML Formatted

SELECT OLAP_GROUP
, PROJECT_ID
, DECODE(PROJECT_ELEMENT_ID
, -1
, -1
, -1*PROJECT_ELEMENT_ID) PROJECT_ELEMENT_ID
, TIME_ID
, CALENDAR_TYPE
, CURRENCY_CODE
, DECODE(RBS_ELEMENT_ID
, -1
, -1
, -1*RBS_ELEMENT_ID) RBS_ELEMENT_ID
, RBS_VERSION_ID
, PLAN_VERSION_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
, SUP_INV_COMMITTED_COST
, PO_COMMITTED_COST
, PR_COMMITTED_COST
, OTH_COMMITTED_COST
, CUSTOM1
, CUSTOM2
, CUSTOM3
, CUSTOM4
, CUSTOM5
, CUSTOM6
, CUSTOM7
, CUSTOM8
, CUSTOM9
, CUSTOM10
, CUSTOM11
, CUSTOM12
, CUSTOM13
, CUSTOM14
, CUSTOM15
, ACT_LABOR_HRS
, ACT_EQUIP_HRS
, ACT_LABOR_BRDN_COST
, ACT_EQUIP_BRDN_COST
, ACT_BRDN_COST
, ACT_RAW_COST
, ACT_REVENUE
, ETC_LABOR_HRS
, ETC_EQUIP_HRS
, ETC_LABOR_BRDN_COST
, ETC_EQUIP_BRDN_COST
, ETC_BRDN_COST
, ETC_RAW_COST
, ACT_LABOR_RAW_COST
, ACT_EQUIP_RAW_COST
, ETC_LABOR_RAW_COST
, ETC_EQUIP_RAW_COST
, CBS_VERSION_ID
, DECODE(CBS_ELEMENT_ID
, -1
, -1
, -1*CBS_ELEMENT_ID ) CBS_ELEMENT_ID
FROM PA_OLAP_STAGE