View: PJI_PRD_PLN_BY_TASK_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	PJI_PRD_PLN_BY_TASK_V is a view that displays budget cost and revenue totals for PA, and GL periods by task. The view is mainly used by external project management systems that import actuals from Oracle Projects.
Implementation/DBA Data:	APPS.PJI_PRD_PLN_BY_TASK_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.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.RBS_AGGR_LEVEL = 'T'
AND FACT.RBS_VERSION_ID = -1
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.PLAN_TYPE_ID
, FACT. PLAN_VERSION_ID

Columns