View: PJI_PRD_ACT_CMT_PG_TASK_V

Product:	PJI - Project Intelligence
Description:	PJI_PRD_ACT_CMT_PG_TASK_V is a view that displays actual cost, revenue totals, and commitments for PA, and GL periods by task at Program Level. The view is mainly used by external project management systems that import actuals from Oracle P
Implementation/DBA Data:	APPS.PJI_PRD_ACT_CMT_PG_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
, 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
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.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

Columns