View: PJI_PRD_PLN_BY_RSRC_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	This new PSI view is to provide PSI functionality using new summarization model.Full Description :PJI_PRD_PLN_BY_RSRC_V is a view that displays budget costand revenue totals for PA, and GL periods by task, and resources. The view is mainly
Implementation/DBA Data:	APPS.PJI_PRD_PLN_BY_RSRC_V

View Text

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
, 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
, PJI_TIME_CAL_PERIOD_V TIME
, PA_PROJECTS_ALL PPA
WHERE FACT.TIME_ID = TIME.CAL_PERIOD_ID
AND FACT.PERIOD_TYPE_ID = 32
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 FACT.PROJECT_ID
, FACT.PROJECT_ELEMENT_ID
, FACT.CALENDAR_TYPE
, TIME.CALENDAR_ID
, TIME.NAME
, TIME.START_DATE
, TIME.END_DATE
, FACT.RBS_ELEMENT_ID
, FACT.RBS_VERSION_ID
, FACT.PLAN_TYPE_ID
, FACT.PLAN_VERSION_ID

Columns