View: PJI_AC_PLN_BY_RSRC_V

Product:	PJI - Project Intelligence
Description:	This view displays budgeted cost and revenue for PA and GL periods by task and resources. The view is used by external project management systems that import financial data from Oracle Projects.
Implementation/DBA Data:	APPS.PJI_AC_PLN_BY_RSRC_V

View Text

SELECT FACT.PROJECT_ID PROJECT_ID
, FACT.PROJECT_ELEMENT_ID TASK_ID
, 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
, SUM(FACT.REVENUE) REVENUE
, SUM(FACT.RAW_COST) RAW_COST
, SUM(FACT.CAPITALIZABLE_RAW_COST) CAPITAL_RAW_COST
, SUM(FACT.BRDN_COST) BURDENED_COST
, SUM(FACT.CAPITALIZABLE_BRDN_COST) CAPITAL_BURDENED_COST
, SUM(FACT.LABOR_HRS) QUANTITY
, SUM(FACT.BILL_LABOR_HRS) BILLABLE_QUANTITY
, SUM(FACT.LABOR_HRS) LABOR_HRS
, SUM(FACT.BILL_LABOR_HRS) BILL_LABOR_HRS
, SUM(FACT.BILL_LABOR_RAW_COST) BILL_LABOR_RAW_COST
, SUM(FACT.BILL_LABOR_BRDN_COST) BILL_LABOR_BRDN_COST
, SUM(FACT.EQUIPMENT_RAW_COST) EQUIPMENT_RAW_COST
, SUM(FACT.EQUIPMENT_BRDN_COST) EQUIPMENT_BRDN_COST
, SUM(FACT.LABOR_RAW_COST) LABOR_RAW_COST
, SUM(FACT.LABOR_BRDN_COST) LABOR_BRDN_COST
, SUM(FACT.LABOR_REVENUE) LABOR_REVENUE
, SUM(FACT.EQUIPMENT_HOURS) EQUIPMENT_HOURS
, SUM(FACT.BILLABLE_EQUIPMENT_HOURS) BILLABLE_EQUIPMENT_HOURS
, SUM(FACT.LABOR_HRS) CMT_QUANTITY
, SUM(FACT.SUP_INV_COMMITTED_COST) SUP_INV_COMMITTED_COST
, SUM(FACT.PO_COMMITTED_COST) PO_COMMITTED_COST
, SUM(FACT.PR_COMMITTED_COST) PR_COMMITTED_COST
, SUM(FACT.OTH_COMMITTED_COST) OTH_COMMITTED_COST
, SUM((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
, SUM (ACT_LABOR_HRS) ACT_LABOR_HRS
, SUM (ACT_EQUIP_HRS) ACT_EQUIP_HRS
, SUM (ACT_LABOR_BRDN_COST) ACT_LABOR_BRDN_COST
, SUM (ACT_EQUIP_BRDN_COST) ACT_EQUIP_BRDN_COST
, SUM (ACT_BRDN_COST) ACT_BRDN_COST
, SUM (ACT_RAW_COST) ACT_RAW_COST
, SUM (ACT_REVENUE) ACT_REVENUE
, SUM (ETC_LABOR_HRS) ETC_LABOR_HRS
, SUM (ETC_EQUIP_HRS) ETC_EQUIP_HRS
, SUM (ETC_LABOR_BRDN_COST) ETC_LABOR_BRDN_COST
, SUM (ETC_EQUIP_BRDN_COST) ETC_EQUIP_BRDN_COST
, SUM (ETC_BRDN_COST) ETC_BRDN_COST
, SUM (ETC_RAW_COST) ETC_RAW_COST
, SUM (ACT_LABOR_RAW_COST) ACT_LABOR_RAW_COST
, SUM (ACT_EQUIP_RAW_COST) ACT_EQUIP_RAW_COST
, SUM (ETC_LABOR_RAW_COST) ETC_LABOR_RAW_COST
, SUM (ETC_EQUIP_RAW_COST) ETC_EQUIP_RAW_COST
FROM PJI_FP_XBS_ACCUM_F FACT
, PA_PROJECTS_ALL PPA
WHERE FACT.TIME_ID = -1
AND FACT.PERIOD_TYPE_ID = 2048
AND FACT.CALENDAR_TYPE = 'A'
AND FACT.PRG_ROLLUP_FLAG = 'N'
AND FACT.CURRENCY_CODE = PPA.PROJFUNC_CURRENCY_CODE
AND FACT.PROJECT_ID = PPA.PROJECT_ID
AND FACT.PLAN_VERSION_ID > -1
AND FACT.PLAN_TYPE_ID > -1 GROUP BY FACT.PROJECT_ID
, FACT.PROJECT_ELEMENT_ID
, FACT.RBS_ELEMENT_ID
, FACT.RBS_VERSION_ID
, FACT.PLAN_TYPE_ID
, FACT.PLAN_VERSION_ID

Columns