VIEW: APPS.PJI_XTD_PLN_BY_RSRC_V

Source

View Text - Preformatted

SELECT PROJECT_ID, TASK_ID, CALENDAR_TYPE, CALENDAR_ID, PERIOD_NAME, PERIOD_START_DATE , PERIOD_END_DATE, RBS_VERSION_ID, RBS_ELEMENT_ID , PLAN_TYPE_ID, PLAN_VERSION_ID, SUM(REVENUE * PTD_MASK) REVENUE_PTD, SUM(RAW_COST * PTD_MASK) RAW_COST_PTD, SUM(BURDENED_COST * PTD_MASK) BURDENED_COST_PTD, SUM(BILLABLE_RAW_COST * PTD_MASK) BILLABLE_RAW_COST_PTD, SUM(BILLABLE_BURDENED_COST * PTD_MASK) BILLABLE_BURDENED_COST_PTD, SUM(BILL_LABOR_RAW_COST * PTD_MASK) BILL_LABOR_RAW_COST_PTD, SUM(BILL_LABOR_BRDN_COST * PTD_MASK) BILL_LABOR_BRDN_COST_PTD, SUM(BILL_LABOR_HRS * PTD_MASK) BILL_LABOR_HRS_PTD, SUM(EQUIPMENT_RAW_COST * PTD_MASK) EQUIPMENT_RAW_COST_PTD , SUM(EQUIPMENT_BRDN_COST * PTD_MASK) EQUIPMENT_BRDN_COST_PTD, SUM(CAPITAL_RAW_COST * PTD_MASK) CAPITAL_RAW_COST_PTD, SUM(CAPITAL_BURDENED_COST * PTD_MASK) CAPITAL_BURDENED_COST_PTD, SUM(LABOR_RAW_COST * PTD_MASK) LABOR_RAW_COST_PTD, SUM(LABOR_BRDN_COST * PTD_MASK) LABOR_BRDN_COST_PTD, SUM(LABOR_HRS * PTD_MASK) LABOR_HOURS_PTD, SUM(LABOR_REVENUE * PTD_MASK) LABOR_REVENUE_PTD, SUM(EQUIPMENT_HOURS * PTD_MASK) EQUIPMENT_HOURS_PTD, SUM(BILLABLE_EQUIPMENT_HOURS * PTD_MASK) BILLABLE_EQUIPMENT_HOURS_PTD, SUM(SUP_INV_COMMITTED_COST * PTD_MASK) SUP_INV_COMMITTED_COST_PTD , SUM(PO_COMMITTED_COST * PTD_MASK) PO_COMMITTED_COST_PTD , SUM(PR_COMMITTED_COST * PTD_MASK) PR_COMMITTED_COST_PTD , SUM(OTH_COMMITTED_COST * PTD_MASK) OTH_COMMITTED_COST_PTD, SUM(CMT_BURDENED_COST * PTD_MASK) CMT_BURDENED_COST_PTD, SUM(BILL_LABOR_HRS * PTD_MASK) BILLABLE_QUANTITY_PTD, SUM(BILL_LABOR_HRS * PTD_MASK) BILLABLE_LABOR_HOURS_PTD, SUM(LABOR_HRS * PTD_MASK) CMT_QUANTITY_PTD, SUM(LABOR_HRS * PTD_MASK) LABOR_HRS_PTD , SUM(LABOR_HRS * PTD_MASK) QUANTITY_PTD, SUM (ACT_LABOR_HRS * PTD_MASK) ACT_LABOR_HRS_PTD, SUM (ACT_EQUIP_HRS * PTD_MASK) ACT_EQUIP_HRS_PTD, SUM (ACT_LABOR_BRDN_COST * PTD_MASK) ACT_LABOR_BRDN_COST_PTD, SUM (ACT_EQUIP_BRDN_COST * PTD_MASK) ACT_EQUIP_BRDN_COST_PTD, SUM (ACT_BRDN_COST * PTD_MASK) ACT_BRDN_COST_PTD , SUM (ACT_RAW_COST * PTD_MASK) ACT_RAW_COST_PTD, SUM (ACT_REVENUE * PTD_MASK) ACT_REVENUE_PTD , SUM (ETC_LABOR_HRS * PTD_MASK) ETC_LABOR_HRS_PTD , SUM (ETC_EQUIP_HRS * PTD_MASK) ETC_EQUIP_HRS_PTD , SUM (ETC_LABOR_BRDN_COST * PTD_MASK) ETC_LABOR_BRDN_COST_PTD , SUM (ETC_EQUIP_BRDN_COST * PTD_MASK) ETC_EQUIP_BRDN_COST_PTD , SUM (ETC_BRDN_COST * PTD_MASK) ETC_BRDN_COST_PTD, SUM (ETC_RAW_COST * PTD_MASK) ETC_RAW_COST_PTD, SUM (ACT_LABOR_RAW_COST * PTD_MASK) ACT_LABOR_RAW_COST_PTD, SUM (ACT_EQUIP_RAW_COST * PTD_MASK) ACT_EQUIP_RAW_COST_PTD , SUM (ETC_LABOR_RAW_COST * PTD_MASK) ETC_LABOR_RAW_COST_PTD, SUM (ETC_EQUIP_RAW_COST * PTD_MASK) ETC_EQUIP_RAW_COST_PTD, SUM(REVENUE * QTD_MASK) REVENUE_QTD, SUM(RAW_COST * QTD_MASK) RAW_COST_QTD, SUM(BURDENED_COST * QTD_MASK) BURDENED_COST_QTD, SUM(BILLABLE_RAW_COST * QTD_MASK) BILLABLE_RAW_COST_QTD, SUM(BILLABLE_BURDENED_COST * QTD_MASK) BILLABLE_BURDENED_COST_QTD, SUM(BILL_LABOR_RAW_COST * QTD_MASK) BILL_LABOR_RAW_COST_QTD, SUM(BILL_LABOR_BRDN_COST * QTD_MASK) BILL_LABOR_BRDN_COST_QTD, SUM(BILL_LABOR_HRS * QTD_MASK) BILL_LABOR_HRS_QTD, SUM(EQUIPMENT_RAW_COST * QTD_MASK) EQUIPMENT_RAW_COST_QTD , SUM(EQUIPMENT_BRDN_COST * QTD_MASK) EQUIPMENT_BRDN_COST_QTD, SUM(CAPITAL_RAW_COST * QTD_MASK) CAPITAL_RAW_COST_QTD, SUM(CAPITAL_BURDENED_COST * QTD_MASK) CAPITAL_BURDENED_COST_QTD, SUM(LABOR_RAW_COST * QTD_MASK) LABOR_RAW_COST_QTD, SUM(LABOR_BRDN_COST * QTD_MASK) LABOR_BRDN_COST_QTD, SUM(LABOR_HRS * QTD_MASK) LABOR_HOURS_QTD, SUM(LABOR_REVENUE * QTD_MASK) LABOR_REVENUE_QTD, SUM(EQUIPMENT_HOURS * QTD_MASK) EQUIPMENT_HOURS_QTD, SUM(BILLABLE_EQUIPMENT_HOURS * QTD_MASK) BILLABLE_EQUIPMENT_HOURS_QTD, SUM(SUP_INV_COMMITTED_COST * QTD_MASK) SUP_INV_COMMITTED_COST_QTD , SUM(PO_COMMITTED_COST * QTD_MASK) PO_COMMITTED_COST_QTD , SUM(PR_COMMITTED_COST * QTD_MASK) PR_COMMITTED_COST_QTD , SUM(OTH_COMMITTED_COST * QTD_MASK) OTH_COMMITTED_COST_QTD, SUM(CMT_BURDENED_COST * QTD_MASK) CMT_BURDENED_COST_QTD, SUM(BILL_LABOR_HRS * QTD_MASK) BILLABLE_QUANTITY_QTD, SUM(BILL_LABOR_HRS * QTD_MASK) BILLABLE_LABOR_HOURS_QTD, SUM(LABOR_HRS * QTD_MASK) CMT_QUANTITY_QTD, SUM(LABOR_HRS * QTD_MASK) LABOR_HRS_QTD , SUM(LABOR_HRS * QTD_MASK) QUANTITY_QTD, SUM (ACT_LABOR_HRS * QTD_MASK) ACT_LABOR_HRS_QTD, SUM (ACT_EQUIP_HRS * QTD_MASK) ACT_EQUIP_HRS_QTD, SUM (ACT_LABOR_BRDN_COST * QTD_MASK) ACT_LABOR_BRDN_COST_QTD, SUM (ACT_EQUIP_BRDN_COST * QTD_MASK) ACT_EQUIP_BRDN_COST_QTD, SUM (ACT_BRDN_COST * QTD_MASK) ACT_BRDN_COST_QTD , SUM (ACT_RAW_COST * QTD_MASK) ACT_RAW_COST_QTD, SUM (ACT_REVENUE * QTD_MASK) ACT_REVENUE_QTD , SUM (ETC_LABOR_HRS * QTD_MASK) ETC_LABOR_HRS_QTD , SUM (ETC_EQUIP_HRS * QTD_MASK) ETC_EQUIP_HRS_QTD , SUM (ETC_LABOR_BRDN_COST * QTD_MASK) ETC_LABOR_BRDN_COST_QTD , SUM (ETC_EQUIP_BRDN_COST * QTD_MASK) ETC_EQUIP_BRDN_COST_QTD , SUM (ETC_BRDN_COST * QTD_MASK) ETC_BRDN_COST_QTD, SUM (ETC_RAW_COST * QTD_MASK) ETC_RAW_COST_QTD, SUM (ACT_LABOR_RAW_COST * QTD_MASK) ACT_LABOR_RAW_COST_QTD, SUM (ACT_EQUIP_RAW_COST * QTD_MASK) ACT_EQUIP_RAW_COST_QTD , SUM (ETC_LABOR_RAW_COST * QTD_MASK) ETC_LABOR_RAW_COST_QTD, SUM (ETC_EQUIP_RAW_COST * QTD_MASK) ETC_EQUIP_RAW_COST_QTD, SUM(REVENUE * YTD_MASK) REVENUE_YTD, SUM(RAW_COST * YTD_MASK) RAW_COST_YTD, SUM(BURDENED_COST * YTD_MASK) BURDENED_COST_YTD, SUM(BILLABLE_RAW_COST * YTD_MASK) BILLABLE_RAW_COST_YTD, SUM(BILLABLE_BURDENED_COST * YTD_MASK) BILLABLE_BURDENED_COST_YTD, SUM(BILL_LABOR_RAW_COST * YTD_MASK) BILL_LABOR_RAW_COST_YTD, SUM(BILL_LABOR_BRDN_COST * YTD_MASK) BILL_LABOR_BRDN_COST_YTD, SUM(BILL_LABOR_HRS * YTD_MASK) BILL_LABOR_HRS_YTD, SUM(EQUIPMENT_RAW_COST * YTD_MASK) EQUIPMENT_RAW_COST_YTD , SUM(EQUIPMENT_BRDN_COST * YTD_MASK) EQUIPMENT_BRDN_COST_YTD, SUM(CAPITAL_RAW_COST * YTD_MASK) CAPITAL_RAW_COST_YTD, SUM(CAPITAL_BURDENED_COST * YTD_MASK) CAPITAL_BURDENED_COST_YTD, SUM(LABOR_RAW_COST * YTD_MASK) LABOR_RAW_COST_YTD, SUM(LABOR_BRDN_COST * YTD_MASK) LABOR_BRDN_COST_YTD, SUM(LABOR_HRS * YTD_MASK) LABOR_HOURS_YTD, SUM(LABOR_REVENUE * YTD_MASK) LABOR_REVENUE_YTD, SUM(EQUIPMENT_HOURS * YTD_MASK) EQUIPMENT_HOURS_YTD, SUM(BILLABLE_EQUIPMENT_HOURS * YTD_MASK) BILLABLE_EQUIPMENT_HOURS_YTD, SUM(SUP_INV_COMMITTED_COST * YTD_MASK) SUP_INV_COMMITTED_COST_YTD , SUM(PO_COMMITTED_COST * YTD_MASK) PO_COMMITTED_COST_YTD , SUM(PR_COMMITTED_COST * YTD_MASK) PR_COMMITTED_COST_YTD , SUM(OTH_COMMITTED_COST * YTD_MASK) OTH_COMMITTED_COST_YTD, SUM(CMT_BURDENED_COST * YTD_MASK) CMT_BURDENED_COST_YTD, SUM(BILL_LABOR_HRS * YTD_MASK) BILLABLE_QUANTITY_YTD, SUM(BILL_LABOR_HRS * YTD_MASK) BILLABLE_LABOR_HOURS_YTD, SUM(LABOR_HRS * YTD_MASK) CMT_QUANTITY_YTD, SUM(LABOR_HRS * YTD_MASK) LABOR_HRS_YTD , SUM(LABOR_HRS * YTD_MASK) QUANTITY_YTD, SUM (ACT_LABOR_HRS * YTD_MASK) ACT_LABOR_HRS_YTD, SUM (ACT_EQUIP_HRS * YTD_MASK) ACT_EQUIP_HRS_YTD, SUM (ACT_LABOR_BRDN_COST * YTD_MASK) ACT_LABOR_BRDN_COST_YTD, SUM (ACT_EQUIP_BRDN_COST * YTD_MASK) ACT_EQUIP_BRDN_COST_YTD, SUM (ACT_BRDN_COST * YTD_MASK) ACT_BRDN_COST_YTD , SUM (ACT_RAW_COST * YTD_MASK) ACT_RAW_COST_YTD, SUM (ACT_REVENUE * YTD_MASK) ACT_REVENUE_YTD , SUM (ETC_LABOR_HRS * YTD_MASK) ETC_LABOR_HRS_YTD , SUM (ETC_EQUIP_HRS * YTD_MASK) ETC_EQUIP_HRS_YTD , SUM (ETC_LABOR_BRDN_COST * YTD_MASK) ETC_LABOR_BRDN_COST_YTD , SUM (ETC_EQUIP_BRDN_COST * YTD_MASK) ETC_EQUIP_BRDN_COST_YTD , SUM (ETC_BRDN_COST * YTD_MASK) ETC_BRDN_COST_YTD, SUM (ETC_RAW_COST * YTD_MASK) ETC_RAW_COST_YTD, SUM (ACT_LABOR_RAW_COST * YTD_MASK) ACT_LABOR_RAW_COST_YTD, SUM (ACT_EQUIP_RAW_COST * YTD_MASK) ACT_EQUIP_RAW_COST_YTD , SUM (ETC_LABOR_RAW_COST * YTD_MASK) ETC_LABOR_RAW_COST_YTD, SUM (ETC_EQUIP_RAW_COST * YTD_MASK) ETC_EQUIP_RAW_COST_YTD, SUM(REVENUE * ITD_MASK) REVENUE_ITD, SUM(RAW_COST * ITD_MASK) RAW_COST_ITD, SUM(BURDENED_COST * ITD_MASK) BURDENED_COST_ITD, SUM(BILLABLE_RAW_COST * ITD_MASK) BILLABLE_RAW_COST_ITD, SUM(BILLABLE_BURDENED_COST * ITD_MASK) BILLABLE_BURDENED_COST_ITD, SUM(BILL_LABOR_RAW_COST * ITD_MASK) BILL_LABOR_RAW_COST_ITD, SUM(BILL_LABOR_BRDN_COST * ITD_MASK) BILL_LABOR_BRDN_COST_ITD, SUM(BILL_LABOR_HRS * ITD_MASK) BILL_LABOR_HRS_ITD, SUM(EQUIPMENT_RAW_COST * ITD_MASK) EQUIPMENT_RAW_COST_ITD , SUM(EQUIPMENT_BRDN_COST * ITD_MASK) EQUIPMENT_BRDN_COST_ITD, SUM(CAPITAL_RAW_COST * ITD_MASK) CAPITAL_RAW_COST_ITD, SUM(CAPITAL_BURDENED_COST * ITD_MASK) CAPITAL_BURDENED_COST_ITD, SUM(LABOR_RAW_COST * ITD_MASK) LABOR_RAW_COST_ITD, SUM(LABOR_BRDN_COST * ITD_MASK) LABOR_BRDN_COST_ITD, SUM(LABOR_HRS * ITD_MASK) LABOR_HOURS_ITD, SUM(LABOR_REVENUE * ITD_MASK) LABOR_REVENUE_ITD, SUM(EQUIPMENT_HOURS * ITD_MASK) EQUIPMENT_HOURS_ITD, SUM(BILLABLE_EQUIPMENT_HOURS * ITD_MASK) BILLABLE_EQUIPMENT_HOURS_ITD, SUM(SUP_INV_COMMITTED_COST * ITD_MASK) SUP_INV_COMMITTED_COST_ITD , SUM(PO_COMMITTED_COST * ITD_MASK) PO_COMMITTED_COST_ITD , SUM(PR_COMMITTED_COST * ITD_MASK) PR_COMMITTED_COST_ITD , SUM(OTH_COMMITTED_COST * ITD_MASK) OTH_COMMITTED_COST_ITD, SUM(CMT_BURDENED_COST * ITD_MASK) CMT_BURDENED_COST_ITD, SUM(BILL_LABOR_HRS * ITD_MASK) BILLABLE_QUANTITY_ITD, SUM(BILL_LABOR_HRS * ITD_MASK) BILLABLE_LABOR_HOURS_ITD, SUM(LABOR_HRS * ITD_MASK) CMT_QUANTITY_ITD, SUM(LABOR_HRS * ITD_MASK) LABOR_HRS_ITD , SUM(LABOR_HRS * ITD_MASK) QUANTITY_ITD, SUM (ACT_LABOR_HRS * ITD_MASK) ACT_LABOR_HRS_ITD, SUM (ACT_EQUIP_HRS * ITD_MASK) ACT_EQUIP_HRS_ITD, SUM (ACT_LABOR_BRDN_COST * ITD_MASK) ACT_LABOR_BRDN_COST_ITD, SUM (ACT_EQUIP_BRDN_COST * ITD_MASK) ACT_EQUIP_BRDN_COST_ITD, SUM (ACT_BRDN_COST * ITD_MASK) ACT_BRDN_COST_ITD , SUM (ACT_RAW_COST * ITD_MASK) ACT_RAW_COST_ITD, SUM (ACT_REVENUE * ITD_MASK) ACT_REVENUE_ITD , SUM (ETC_LABOR_HRS * ITD_MASK) ETC_LABOR_HRS_ITD , SUM (ETC_EQUIP_HRS * ITD_MASK) ETC_EQUIP_HRS_ITD , SUM (ETC_LABOR_BRDN_COST * ITD_MASK) ETC_LABOR_BRDN_COST_ITD , SUM (ETC_EQUIP_BRDN_COST * ITD_MASK) ETC_EQUIP_BRDN_COST_ITD , SUM (ETC_BRDN_COST * ITD_MASK) ETC_BRDN_COST_ITD, SUM (ETC_RAW_COST * ITD_MASK) ETC_RAW_COST_ITD, SUM (ACT_LABOR_RAW_COST * ITD_MASK) ACT_LABOR_RAW_COST_ITD, SUM (ACT_EQUIP_RAW_COST * ITD_MASK) ACT_EQUIP_RAW_COST_ITD , SUM (ETC_LABOR_RAW_COST * ITD_MASK) ETC_LABOR_RAW_COST_ITD, SUM (ETC_EQUIP_RAW_COST * ITD_MASK) ETC_EQUIP_RAW_COST_ITD FROM (SELECT FACT.PROJECT_ID PROJECT_ID, FACT.PROJECT_ELEMENT_ID TASK_ID, FACT.CALENDAR_TYPE CALENDAR_TYPE, TIME.CALENDAR_ID CALENDAR_ID, TIME.NAME PERIOD_NAME, TIME.START_DATE PERIOD_START_DATE, TIME.END_DATE PERIOD_END_DATE, FACT.RBS_ELEMENT_ID RBS_ELEMENT_ID, FACT.RBS_VERSION_ID RBS_VERSION_ID, FACT.PLAN_TYPE_ID PLAN_TYPE_ID, FACT.PLAN_VERSION_ID PLAN_VERSION_ID, FACT.REVENUE REVENUE, FACT.RAW_COST RAW_COST, FACT.BRDN_COST BURDENED_COST, FACT.BILL_RAW_COST BILLABLE_RAW_COST, FACT.BILL_BRDN_COST BILLABLE_BURDENED_COST, FACT.BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST, FACT.BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST, FACT.BILL_LABOR_HRS BILL_LABOR_HRS, FACT.EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST , FACT.EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST, FACT.CAPITALIZABLE_RAW_COST CAPITAL_RAW_COST, FACT.CAPITALIZABLE_BRDN_COST CAPITAL_BURDENED_COST, FACT.LABOR_RAW_COST LABOR_RAW_COST, FACT.LABOR_BRDN_COST LABOR_BRDN_COST, FACT.LABOR_HRS LABOR_HOURS, FACT.LABOR_REVENUE LABOR_REVENUE, FACT.EQUIPMENT_HOURS EQUIPMENT_HOURS, FACT.BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS, FACT.SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST , FACT.PO_COMMITTED_COST PO_COMMITTED_COST , FACT.PR_COMMITTED_COST PR_COMMITTED_COST , FACT.OTH_COMMITTED_COST OTH_COMMITTED_COST, (NVL(FACT.SUP_INV_COMMITTED_COST, 0) + NVL(FACT.PO_COMMITTED_COST, 0) + NVL(FACT.PR_COMMITTED_COST, 0) + NVL(FACT.OTH_COMMITTED_COST, 0) ) CMT_BURDENED_COST, FACT.BILL_LABOR_HRS BILLABLE_QUANTITY, FACT.BILL_LABOR_HRS BILLABLE_LABOR_HOURS, FACT.LABOR_HRS QUANTITY, FACT.LABOR_HRS LABOR_HRS , FACT.LABOR_HRS CMT_QUANTITY, FACT.ACT_LABOR_HRS ACT_LABOR_HRS, FACT.ACT_EQUIP_HRS ACT_EQUIP_HRS, FACT.ACT_LABOR_BRDN_COST ACT_LABOR_BRDN_COST, FACT.ACT_EQUIP_BRDN_COST ACT_EQUIP_BRDN_COST, FACT.ACT_BRDN_COST ACT_BRDN_COST , FACT.ACT_RAW_COST ACT_RAW_COST, FACT.ACT_REVENUE ACT_REVENUE , FACT.ETC_LABOR_HRS ETC_LABOR_HRS , FACT.ETC_EQUIP_HRS ETC_EQUIP_HRS , FACT.ETC_LABOR_BRDN_COST ETC_LABOR_BRDN_COST , FACT.ETC_EQUIP_BRDN_COST ETC_EQUIP_BRDN_COST , FACT.ETC_BRDN_COST ETC_BRDN_COST, FACT.ETC_RAW_COST ETC_RAW_COST, FACT.ACT_LABOR_RAW_COST ACT_LABOR_RAW_COST, FACT.ACT_EQUIP_RAW_COST ACT_EQUIP_RAW_COST , FACT.ETC_LABOR_RAW_COST ETC_LABOR_RAW_COST, FACT.ETC_EQUIP_RAW_COST ETC_EQUIP_RAW_COST, SIGN(BITAND(XTD.RECORD_TYPE_ID,256)) PTD_MASK, SIGN(BITAND(XTD.RECORD_TYPE_ID,288)) QTD_MASK, SIGN(BITAND(XTD.RECORD_TYPE_ID,352)) YTD_MASK, SIGN(BITAND(XTD.RECORD_TYPE_ID,1376)) ITD_MASK FROM PJI_FP_XBS_ACCUM_F FACT, PJI_TIME_CAL_RPT_STRUCT_V XTD, PJI_TIME_CAL_PERIOD_V TIME, PA_PROJECTS_ALL PPA, PJI_ORG_EXTR_INFO EXTR WHERE PPA.ORG_ID = EXTR.ORG_ID AND ((FACT.CALENDAR_TYPE = 'G' AND XTD.CALENDAR_ID = EXTR.GL_CALENDAR_ID) OR (FACT.CALENDAR_TYPE = 'P' AND XTD.CALENDAR_ID = EXTR.PA_CALENDAR_ID)) AND FACT.TIME_ID = XTD.TIME_ID AND TIME.START_DATE = XTD.REPORT_DATE AND TIME.CALENDAR_ID = XTD.CALENDAR_ID AND FACT.PRG_ROLLUP_FLAG = 'N' AND FACT.CURRENCY_CODE = PPA.PROJFUNC_CURRENCY_CODE AND bitand(FACT.CURR_RECORD_TYPE_ID, 4) = 4 AND FACT.PROJECT_ID = PPA.PROJECT_ID AND FACT.PLAN_VERSION_ID > -1 AND FACT.PLAN_TYPE_ID > -1 ) GROUP BY PROJECT_ID, TASK_ID, CALENDAR_TYPE, CALENDAR_ID, PERIOD_NAME, PERIOD_START_DATE , PERIOD_END_DATE, RBS_VERSION_ID, RBS_ELEMENT_ID, PLAN_TYPE_ID, PLAN_VERSION_ID

View Text - HTML Formatted

SELECT PROJECT_ID
, TASK_ID
, CALENDAR_TYPE
, CALENDAR_ID
, PERIOD_NAME
, PERIOD_START_DATE
, PERIOD_END_DATE
, RBS_VERSION_ID
, RBS_ELEMENT_ID
, PLAN_TYPE_ID
, PLAN_VERSION_ID
, SUM(REVENUE * PTD_MASK) REVENUE_PTD
, SUM(RAW_COST * PTD_MASK) RAW_COST_PTD
, SUM(BURDENED_COST * PTD_MASK) BURDENED_COST_PTD
, SUM(BILLABLE_RAW_COST * PTD_MASK) BILLABLE_RAW_COST_PTD
, SUM(BILLABLE_BURDENED_COST * PTD_MASK) BILLABLE_BURDENED_COST_PTD
, SUM(BILL_LABOR_RAW_COST * PTD_MASK) BILL_LABOR_RAW_COST_PTD
, SUM(BILL_LABOR_BRDN_COST * PTD_MASK) BILL_LABOR_BRDN_COST_PTD
, SUM(BILL_LABOR_HRS * PTD_MASK) BILL_LABOR_HRS_PTD
, SUM(EQUIPMENT_RAW_COST * PTD_MASK) EQUIPMENT_RAW_COST_PTD
, SUM(EQUIPMENT_BRDN_COST * PTD_MASK) EQUIPMENT_BRDN_COST_PTD
, SUM(CAPITAL_RAW_COST * PTD_MASK) CAPITAL_RAW_COST_PTD
, SUM(CAPITAL_BURDENED_COST * PTD_MASK) CAPITAL_BURDENED_COST_PTD
, SUM(LABOR_RAW_COST * PTD_MASK) LABOR_RAW_COST_PTD
, SUM(LABOR_BRDN_COST * PTD_MASK) LABOR_BRDN_COST_PTD
, SUM(LABOR_HRS * PTD_MASK) LABOR_HOURS_PTD
, SUM(LABOR_REVENUE * PTD_MASK) LABOR_REVENUE_PTD
, SUM(EQUIPMENT_HOURS * PTD_MASK) EQUIPMENT_HOURS_PTD
, SUM(BILLABLE_EQUIPMENT_HOURS * PTD_MASK) BILLABLE_EQUIPMENT_HOURS_PTD
, SUM(SUP_INV_COMMITTED_COST * PTD_MASK) SUP_INV_COMMITTED_COST_PTD
, SUM(PO_COMMITTED_COST * PTD_MASK) PO_COMMITTED_COST_PTD
, SUM(PR_COMMITTED_COST * PTD_MASK) PR_COMMITTED_COST_PTD
, SUM(OTH_COMMITTED_COST * PTD_MASK) OTH_COMMITTED_COST_PTD
, SUM(CMT_BURDENED_COST * PTD_MASK) CMT_BURDENED_COST_PTD
, SUM(BILL_LABOR_HRS * PTD_MASK) BILLABLE_QUANTITY_PTD
, SUM(BILL_LABOR_HRS * PTD_MASK) BILLABLE_LABOR_HOURS_PTD
, SUM(LABOR_HRS * PTD_MASK) CMT_QUANTITY_PTD
, SUM(LABOR_HRS * PTD_MASK) LABOR_HRS_PTD
, SUM(LABOR_HRS * PTD_MASK) QUANTITY_PTD
, SUM (ACT_LABOR_HRS * PTD_MASK) ACT_LABOR_HRS_PTD
, SUM (ACT_EQUIP_HRS * PTD_MASK) ACT_EQUIP_HRS_PTD
, SUM (ACT_LABOR_BRDN_COST * PTD_MASK) ACT_LABOR_BRDN_COST_PTD
, SUM (ACT_EQUIP_BRDN_COST * PTD_MASK) ACT_EQUIP_BRDN_COST_PTD
, SUM (ACT_BRDN_COST * PTD_MASK) ACT_BRDN_COST_PTD
, SUM (ACT_RAW_COST * PTD_MASK) ACT_RAW_COST_PTD
, SUM (ACT_REVENUE * PTD_MASK) ACT_REVENUE_PTD
, SUM (ETC_LABOR_HRS * PTD_MASK) ETC_LABOR_HRS_PTD
, SUM (ETC_EQUIP_HRS * PTD_MASK) ETC_EQUIP_HRS_PTD
, SUM (ETC_LABOR_BRDN_COST * PTD_MASK) ETC_LABOR_BRDN_COST_PTD
, SUM (ETC_EQUIP_BRDN_COST * PTD_MASK) ETC_EQUIP_BRDN_COST_PTD
, SUM (ETC_BRDN_COST * PTD_MASK) ETC_BRDN_COST_PTD
, SUM (ETC_RAW_COST * PTD_MASK) ETC_RAW_COST_PTD
, SUM (ACT_LABOR_RAW_COST * PTD_MASK) ACT_LABOR_RAW_COST_PTD
, SUM (ACT_EQUIP_RAW_COST * PTD_MASK) ACT_EQUIP_RAW_COST_PTD
, SUM (ETC_LABOR_RAW_COST * PTD_MASK) ETC_LABOR_RAW_COST_PTD
, SUM (ETC_EQUIP_RAW_COST * PTD_MASK) ETC_EQUIP_RAW_COST_PTD
, SUM(REVENUE * QTD_MASK) REVENUE_QTD
, SUM(RAW_COST * QTD_MASK) RAW_COST_QTD
, SUM(BURDENED_COST * QTD_MASK) BURDENED_COST_QTD
, SUM(BILLABLE_RAW_COST * QTD_MASK) BILLABLE_RAW_COST_QTD
, SUM(BILLABLE_BURDENED_COST * QTD_MASK) BILLABLE_BURDENED_COST_QTD
, SUM(BILL_LABOR_RAW_COST * QTD_MASK) BILL_LABOR_RAW_COST_QTD
, SUM(BILL_LABOR_BRDN_COST * QTD_MASK) BILL_LABOR_BRDN_COST_QTD
, SUM(BILL_LABOR_HRS * QTD_MASK) BILL_LABOR_HRS_QTD
, SUM(EQUIPMENT_RAW_COST * QTD_MASK) EQUIPMENT_RAW_COST_QTD
, SUM(EQUIPMENT_BRDN_COST * QTD_MASK) EQUIPMENT_BRDN_COST_QTD
, SUM(CAPITAL_RAW_COST * QTD_MASK) CAPITAL_RAW_COST_QTD
, SUM(CAPITAL_BURDENED_COST * QTD_MASK) CAPITAL_BURDENED_COST_QTD
, SUM(LABOR_RAW_COST * QTD_MASK) LABOR_RAW_COST_QTD
, SUM(LABOR_BRDN_COST * QTD_MASK) LABOR_BRDN_COST_QTD
, SUM(LABOR_HRS * QTD_MASK) LABOR_HOURS_QTD
, SUM(LABOR_REVENUE * QTD_MASK) LABOR_REVENUE_QTD
, SUM(EQUIPMENT_HOURS * QTD_MASK) EQUIPMENT_HOURS_QTD
, SUM(BILLABLE_EQUIPMENT_HOURS * QTD_MASK) BILLABLE_EQUIPMENT_HOURS_QTD
, SUM(SUP_INV_COMMITTED_COST * QTD_MASK) SUP_INV_COMMITTED_COST_QTD
, SUM(PO_COMMITTED_COST * QTD_MASK) PO_COMMITTED_COST_QTD
, SUM(PR_COMMITTED_COST * QTD_MASK) PR_COMMITTED_COST_QTD
, SUM(OTH_COMMITTED_COST * QTD_MASK) OTH_COMMITTED_COST_QTD
, SUM(CMT_BURDENED_COST * QTD_MASK) CMT_BURDENED_COST_QTD
, SUM(BILL_LABOR_HRS * QTD_MASK) BILLABLE_QUANTITY_QTD
, SUM(BILL_LABOR_HRS * QTD_MASK) BILLABLE_LABOR_HOURS_QTD
, SUM(LABOR_HRS * QTD_MASK) CMT_QUANTITY_QTD
, SUM(LABOR_HRS * QTD_MASK) LABOR_HRS_QTD
, SUM(LABOR_HRS * QTD_MASK) QUANTITY_QTD
, SUM (ACT_LABOR_HRS * QTD_MASK) ACT_LABOR_HRS_QTD
, SUM (ACT_EQUIP_HRS * QTD_MASK) ACT_EQUIP_HRS_QTD
, SUM (ACT_LABOR_BRDN_COST * QTD_MASK) ACT_LABOR_BRDN_COST_QTD
, SUM (ACT_EQUIP_BRDN_COST * QTD_MASK) ACT_EQUIP_BRDN_COST_QTD
, SUM (ACT_BRDN_COST * QTD_MASK) ACT_BRDN_COST_QTD
, SUM (ACT_RAW_COST * QTD_MASK) ACT_RAW_COST_QTD
, SUM (ACT_REVENUE * QTD_MASK) ACT_REVENUE_QTD
, SUM (ETC_LABOR_HRS * QTD_MASK) ETC_LABOR_HRS_QTD
, SUM (ETC_EQUIP_HRS * QTD_MASK) ETC_EQUIP_HRS_QTD
, SUM (ETC_LABOR_BRDN_COST * QTD_MASK) ETC_LABOR_BRDN_COST_QTD
, SUM (ETC_EQUIP_BRDN_COST * QTD_MASK) ETC_EQUIP_BRDN_COST_QTD
, SUM (ETC_BRDN_COST * QTD_MASK) ETC_BRDN_COST_QTD
, SUM (ETC_RAW_COST * QTD_MASK) ETC_RAW_COST_QTD
, SUM (ACT_LABOR_RAW_COST * QTD_MASK) ACT_LABOR_RAW_COST_QTD
, SUM (ACT_EQUIP_RAW_COST * QTD_MASK) ACT_EQUIP_RAW_COST_QTD
, SUM (ETC_LABOR_RAW_COST * QTD_MASK) ETC_LABOR_RAW_COST_QTD
, SUM (ETC_EQUIP_RAW_COST * QTD_MASK) ETC_EQUIP_RAW_COST_QTD
, SUM(REVENUE * YTD_MASK) REVENUE_YTD
, SUM(RAW_COST * YTD_MASK) RAW_COST_YTD
, SUM(BURDENED_COST * YTD_MASK) BURDENED_COST_YTD
, SUM(BILLABLE_RAW_COST * YTD_MASK) BILLABLE_RAW_COST_YTD
, SUM(BILLABLE_BURDENED_COST * YTD_MASK) BILLABLE_BURDENED_COST_YTD
, SUM(BILL_LABOR_RAW_COST * YTD_MASK) BILL_LABOR_RAW_COST_YTD
, SUM(BILL_LABOR_BRDN_COST * YTD_MASK) BILL_LABOR_BRDN_COST_YTD
, SUM(BILL_LABOR_HRS * YTD_MASK) BILL_LABOR_HRS_YTD
, SUM(EQUIPMENT_RAW_COST * YTD_MASK) EQUIPMENT_RAW_COST_YTD
, SUM(EQUIPMENT_BRDN_COST * YTD_MASK) EQUIPMENT_BRDN_COST_YTD
, SUM(CAPITAL_RAW_COST * YTD_MASK) CAPITAL_RAW_COST_YTD
, SUM(CAPITAL_BURDENED_COST * YTD_MASK) CAPITAL_BURDENED_COST_YTD
, SUM(LABOR_RAW_COST * YTD_MASK) LABOR_RAW_COST_YTD
, SUM(LABOR_BRDN_COST * YTD_MASK) LABOR_BRDN_COST_YTD
, SUM(LABOR_HRS * YTD_MASK) LABOR_HOURS_YTD
, SUM(LABOR_REVENUE * YTD_MASK) LABOR_REVENUE_YTD
, SUM(EQUIPMENT_HOURS * YTD_MASK) EQUIPMENT_HOURS_YTD
, SUM(BILLABLE_EQUIPMENT_HOURS * YTD_MASK) BILLABLE_EQUIPMENT_HOURS_YTD
, SUM(SUP_INV_COMMITTED_COST * YTD_MASK) SUP_INV_COMMITTED_COST_YTD
, SUM(PO_COMMITTED_COST * YTD_MASK) PO_COMMITTED_COST_YTD
, SUM(PR_COMMITTED_COST * YTD_MASK) PR_COMMITTED_COST_YTD
, SUM(OTH_COMMITTED_COST * YTD_MASK) OTH_COMMITTED_COST_YTD
, SUM(CMT_BURDENED_COST * YTD_MASK) CMT_BURDENED_COST_YTD
, SUM(BILL_LABOR_HRS * YTD_MASK) BILLABLE_QUANTITY_YTD
, SUM(BILL_LABOR_HRS * YTD_MASK) BILLABLE_LABOR_HOURS_YTD
, SUM(LABOR_HRS * YTD_MASK) CMT_QUANTITY_YTD
, SUM(LABOR_HRS * YTD_MASK) LABOR_HRS_YTD
, SUM(LABOR_HRS * YTD_MASK) QUANTITY_YTD
, SUM (ACT_LABOR_HRS * YTD_MASK) ACT_LABOR_HRS_YTD
, SUM (ACT_EQUIP_HRS * YTD_MASK) ACT_EQUIP_HRS_YTD
, SUM (ACT_LABOR_BRDN_COST * YTD_MASK) ACT_LABOR_BRDN_COST_YTD
, SUM (ACT_EQUIP_BRDN_COST * YTD_MASK) ACT_EQUIP_BRDN_COST_YTD
, SUM (ACT_BRDN_COST * YTD_MASK) ACT_BRDN_COST_YTD
, SUM (ACT_RAW_COST * YTD_MASK) ACT_RAW_COST_YTD
, SUM (ACT_REVENUE * YTD_MASK) ACT_REVENUE_YTD
, SUM (ETC_LABOR_HRS * YTD_MASK) ETC_LABOR_HRS_YTD
, SUM (ETC_EQUIP_HRS * YTD_MASK) ETC_EQUIP_HRS_YTD
, SUM (ETC_LABOR_BRDN_COST * YTD_MASK) ETC_LABOR_BRDN_COST_YTD
, SUM (ETC_EQUIP_BRDN_COST * YTD_MASK) ETC_EQUIP_BRDN_COST_YTD
, SUM (ETC_BRDN_COST * YTD_MASK) ETC_BRDN_COST_YTD
, SUM (ETC_RAW_COST * YTD_MASK) ETC_RAW_COST_YTD
, SUM (ACT_LABOR_RAW_COST * YTD_MASK) ACT_LABOR_RAW_COST_YTD
, SUM (ACT_EQUIP_RAW_COST * YTD_MASK) ACT_EQUIP_RAW_COST_YTD
, SUM (ETC_LABOR_RAW_COST * YTD_MASK) ETC_LABOR_RAW_COST_YTD
, SUM (ETC_EQUIP_RAW_COST * YTD_MASK) ETC_EQUIP_RAW_COST_YTD
, SUM(REVENUE * ITD_MASK) REVENUE_ITD
, SUM(RAW_COST * ITD_MASK) RAW_COST_ITD
, SUM(BURDENED_COST * ITD_MASK) BURDENED_COST_ITD
, SUM(BILLABLE_RAW_COST * ITD_MASK) BILLABLE_RAW_COST_ITD
, SUM(BILLABLE_BURDENED_COST * ITD_MASK) BILLABLE_BURDENED_COST_ITD
, SUM(BILL_LABOR_RAW_COST * ITD_MASK) BILL_LABOR_RAW_COST_ITD
, SUM(BILL_LABOR_BRDN_COST * ITD_MASK) BILL_LABOR_BRDN_COST_ITD
, SUM(BILL_LABOR_HRS * ITD_MASK) BILL_LABOR_HRS_ITD
, SUM(EQUIPMENT_RAW_COST * ITD_MASK) EQUIPMENT_RAW_COST_ITD
, SUM(EQUIPMENT_BRDN_COST * ITD_MASK) EQUIPMENT_BRDN_COST_ITD
, SUM(CAPITAL_RAW_COST * ITD_MASK) CAPITAL_RAW_COST_ITD
, SUM(CAPITAL_BURDENED_COST * ITD_MASK) CAPITAL_BURDENED_COST_ITD
, SUM(LABOR_RAW_COST * ITD_MASK) LABOR_RAW_COST_ITD
, SUM(LABOR_BRDN_COST * ITD_MASK) LABOR_BRDN_COST_ITD
, SUM(LABOR_HRS * ITD_MASK) LABOR_HOURS_ITD
, SUM(LABOR_REVENUE * ITD_MASK) LABOR_REVENUE_ITD
, SUM(EQUIPMENT_HOURS * ITD_MASK) EQUIPMENT_HOURS_ITD
, SUM(BILLABLE_EQUIPMENT_HOURS * ITD_MASK) BILLABLE_EQUIPMENT_HOURS_ITD
, SUM(SUP_INV_COMMITTED_COST * ITD_MASK) SUP_INV_COMMITTED_COST_ITD
, SUM(PO_COMMITTED_COST * ITD_MASK) PO_COMMITTED_COST_ITD
, SUM(PR_COMMITTED_COST * ITD_MASK) PR_COMMITTED_COST_ITD
, SUM(OTH_COMMITTED_COST * ITD_MASK) OTH_COMMITTED_COST_ITD
, SUM(CMT_BURDENED_COST * ITD_MASK) CMT_BURDENED_COST_ITD
, SUM(BILL_LABOR_HRS * ITD_MASK) BILLABLE_QUANTITY_ITD
, SUM(BILL_LABOR_HRS * ITD_MASK) BILLABLE_LABOR_HOURS_ITD
, SUM(LABOR_HRS * ITD_MASK) CMT_QUANTITY_ITD
, SUM(LABOR_HRS * ITD_MASK) LABOR_HRS_ITD
, SUM(LABOR_HRS * ITD_MASK) QUANTITY_ITD
, SUM (ACT_LABOR_HRS * ITD_MASK) ACT_LABOR_HRS_ITD
, SUM (ACT_EQUIP_HRS * ITD_MASK) ACT_EQUIP_HRS_ITD
, SUM (ACT_LABOR_BRDN_COST * ITD_MASK) ACT_LABOR_BRDN_COST_ITD
, SUM (ACT_EQUIP_BRDN_COST * ITD_MASK) ACT_EQUIP_BRDN_COST_ITD
, SUM (ACT_BRDN_COST * ITD_MASK) ACT_BRDN_COST_ITD
, SUM (ACT_RAW_COST * ITD_MASK) ACT_RAW_COST_ITD
, SUM (ACT_REVENUE * ITD_MASK) ACT_REVENUE_ITD
, SUM (ETC_LABOR_HRS * ITD_MASK) ETC_LABOR_HRS_ITD
, SUM (ETC_EQUIP_HRS * ITD_MASK) ETC_EQUIP_HRS_ITD
, SUM (ETC_LABOR_BRDN_COST * ITD_MASK) ETC_LABOR_BRDN_COST_ITD
, SUM (ETC_EQUIP_BRDN_COST * ITD_MASK) ETC_EQUIP_BRDN_COST_ITD
, SUM (ETC_BRDN_COST * ITD_MASK) ETC_BRDN_COST_ITD
, SUM (ETC_RAW_COST * ITD_MASK) ETC_RAW_COST_ITD
, SUM (ACT_LABOR_RAW_COST * ITD_MASK) ACT_LABOR_RAW_COST_ITD
, SUM (ACT_EQUIP_RAW_COST * ITD_MASK) ACT_EQUIP_RAW_COST_ITD
, SUM (ETC_LABOR_RAW_COST * ITD_MASK) ETC_LABOR_RAW_COST_ITD
, SUM (ETC_EQUIP_RAW_COST * ITD_MASK) ETC_EQUIP_RAW_COST_ITD
FROM (SELECT FACT.PROJECT_ID PROJECT_ID
, FACT.PROJECT_ELEMENT_ID TASK_ID
, FACT.CALENDAR_TYPE CALENDAR_TYPE
, TIME.CALENDAR_ID CALENDAR_ID
, TIME.NAME PERIOD_NAME
, TIME.START_DATE PERIOD_START_DATE
, TIME.END_DATE PERIOD_END_DATE
, FACT.RBS_ELEMENT_ID RBS_ELEMENT_ID
, FACT.RBS_VERSION_ID RBS_VERSION_ID
, FACT.PLAN_TYPE_ID PLAN_TYPE_ID
, FACT.PLAN_VERSION_ID PLAN_VERSION_ID
, FACT.REVENUE REVENUE
, FACT.RAW_COST RAW_COST
, FACT.BRDN_COST BURDENED_COST
, FACT.BILL_RAW_COST BILLABLE_RAW_COST
, FACT.BILL_BRDN_COST BILLABLE_BURDENED_COST
, FACT.BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST
, FACT.BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST
, FACT.BILL_LABOR_HRS BILL_LABOR_HRS
, FACT.EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST
, FACT.EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST
, FACT.CAPITALIZABLE_RAW_COST CAPITAL_RAW_COST
, FACT.CAPITALIZABLE_BRDN_COST CAPITAL_BURDENED_COST
, FACT.LABOR_RAW_COST LABOR_RAW_COST
, FACT.LABOR_BRDN_COST LABOR_BRDN_COST
, FACT.LABOR_HRS LABOR_HOURS
, FACT.LABOR_REVENUE LABOR_REVENUE
, FACT.EQUIPMENT_HOURS EQUIPMENT_HOURS
, FACT.BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS
, FACT.SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST
, FACT.PO_COMMITTED_COST PO_COMMITTED_COST
, FACT.PR_COMMITTED_COST PR_COMMITTED_COST
, FACT.OTH_COMMITTED_COST OTH_COMMITTED_COST
, (NVL(FACT.SUP_INV_COMMITTED_COST
, 0) + NVL(FACT.PO_COMMITTED_COST
, 0) + NVL(FACT.PR_COMMITTED_COST
, 0) + NVL(FACT.OTH_COMMITTED_COST
, 0) ) CMT_BURDENED_COST
, FACT.BILL_LABOR_HRS BILLABLE_QUANTITY
, FACT.BILL_LABOR_HRS BILLABLE_LABOR_HOURS
, FACT.LABOR_HRS QUANTITY
, FACT.LABOR_HRS LABOR_HRS
, FACT.LABOR_HRS CMT_QUANTITY
, FACT.ACT_LABOR_HRS ACT_LABOR_HRS
, FACT.ACT_EQUIP_HRS ACT_EQUIP_HRS
, FACT.ACT_LABOR_BRDN_COST ACT_LABOR_BRDN_COST
, FACT.ACT_EQUIP_BRDN_COST ACT_EQUIP_BRDN_COST
, FACT.ACT_BRDN_COST ACT_BRDN_COST
, FACT.ACT_RAW_COST ACT_RAW_COST
, FACT.ACT_REVENUE ACT_REVENUE
, FACT.ETC_LABOR_HRS ETC_LABOR_HRS
, FACT.ETC_EQUIP_HRS ETC_EQUIP_HRS
, FACT.ETC_LABOR_BRDN_COST ETC_LABOR_BRDN_COST
, FACT.ETC_EQUIP_BRDN_COST ETC_EQUIP_BRDN_COST
, FACT.ETC_BRDN_COST ETC_BRDN_COST
, FACT.ETC_RAW_COST ETC_RAW_COST
, FACT.ACT_LABOR_RAW_COST ACT_LABOR_RAW_COST
, FACT.ACT_EQUIP_RAW_COST ACT_EQUIP_RAW_COST
, FACT.ETC_LABOR_RAW_COST ETC_LABOR_RAW_COST
, FACT.ETC_EQUIP_RAW_COST ETC_EQUIP_RAW_COST
, SIGN(BITAND(XTD.RECORD_TYPE_ID
, 256)) PTD_MASK
, SIGN(BITAND(XTD.RECORD_TYPE_ID
, 288)) QTD_MASK
, SIGN(BITAND(XTD.RECORD_TYPE_ID
, 352)) YTD_MASK
, SIGN(BITAND(XTD.RECORD_TYPE_ID
, 1376)) ITD_MASK
FROM PJI_FP_XBS_ACCUM_F FACT
, PJI_TIME_CAL_RPT_STRUCT_V XTD
, PJI_TIME_CAL_PERIOD_V TIME
, PA_PROJECTS_ALL PPA
, PJI_ORG_EXTR_INFO EXTR
WHERE PPA.ORG_ID = EXTR.ORG_ID
AND ((FACT.CALENDAR_TYPE = 'G'
AND XTD.CALENDAR_ID = EXTR.GL_CALENDAR_ID) OR (FACT.CALENDAR_TYPE = 'P'
AND XTD.CALENDAR_ID = EXTR.PA_CALENDAR_ID))
AND FACT.TIME_ID = XTD.TIME_ID
AND TIME.START_DATE = XTD.REPORT_DATE
AND TIME.CALENDAR_ID = XTD.CALENDAR_ID
AND FACT.PRG_ROLLUP_FLAG = 'N'
AND FACT.CURRENCY_CODE = PPA.PROJFUNC_CURRENCY_CODE
AND BITAND(FACT.CURR_RECORD_TYPE_ID
, 4) = 4
AND FACT.PROJECT_ID = PPA.PROJECT_ID
AND FACT.PLAN_VERSION_ID > -1
AND FACT.PLAN_TYPE_ID > -1 ) GROUP BY PROJECT_ID
, TASK_ID
, CALENDAR_TYPE
, CALENDAR_ID
, PERIOD_NAME
, PERIOD_START_DATE
, PERIOD_END_DATE
, RBS_VERSION_ID
, RBS_ELEMENT_ID
, PLAN_TYPE_ID
, PLAN_VERSION_ID