View: PJI_XTD_PLN_BY_RSRC_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	PJI_XTD_PLN_BY_RSRC_V is a view that displays budget cost and revenue totals for PTD, QTD, YTD, and ITD by task, and resource. The view is mainly used by external project management systems that import actuals from Oracle Projects.
Implementation/DBA Data:	APPS.PJI_XTD_PLN_BY_RSRC_V

View Text

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

Columns