View: PJI_AC_ACT_CMT_BY_RSRC_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	This view displays actual costs, revenue, and commitments 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_ACT_CMT_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
, 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
, 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

Columns