View: PJI_ACT_CMT_BY_PERIOD_V

Product:	PJI - Project Intelligence(Obsolete)
Description:	PJI_ACT_CMT_BY_PERIOD_V is a view that displays actual cost, revenue totals, and commitment for lowest level tasks and resources by PA, and GL periods. The view is mainly used by external project management systems that import actuals from
Implementation/DBA Data:	APPS.PJI_ACT_CMT_BY_PERIOD_V

View Text

SELECT PABR.PROJECT_ID PROJECT_ID
, PABR.TASK_ID TASK_ID
, PABR.PERIOD_NAME PERIOD_NAME
, PABR.PERIOD_START_DATE PERIOD_START_DATE
, PABR.PERIOD_END_DATE PERIOD_END_DATE
, PABR.REVENUE REVENUE
, PABR.RAW_COST RAW_COST
, PABR.CAPITAL_RAW_COST CAPITAL_RAW_COST
, PABR.BURDENED_COST BURDENED_COST
, PABR.CAPITAL_BURDENED_COST CAPITAL_BURDENED_COST
, PABR.RBS_ELEMENT_ID RBS_ELEMENT_ID
, PABR.RBS_VERSION_ID RBS_VERSION_ID
, PABR.CALENDAR_TYPE CALENDAR_TYPE
, PABR.QUANTITY QUANTITY
, PABR.BILLABLE_QUANTITY BILLABLE_QUANTITY
, PABR.LABOR_HRS LABOR_HRS
, PABR.BILL_LABOR_HRS BILL_LABOR_HRS
, PABR.BILL_LABOR_RAW_COST BILL_LABOR_RAW_COST
, PABR.BILL_LABOR_BRDN_COST BILL_LABOR_BRDN_COST
, PABR.EQUIPMENT_RAW_COST EQUIPMENT_RAW_COST
, PABR.EQUIPMENT_BRDN_COST EQUIPMENT_BRDN_COST
, PABR.LABOR_RAW_COST LABOR_RAW_COST
, PABR.LABOR_BRDN_COST LABOR_BRDN_COST
, PABR.LABOR_REVENUE LABOR_REVENUE
, PABR.EQUIPMENT_HOURS EQUIPMENT_HOURS
, PABR.BILLABLE_EQUIPMENT_HOURS BILLABLE_EQUIPMENT_HOURS
, PABR.CMT_QUANTITY CMT_QUANTITY
, PABR.SUP_INV_COMMITTED_COST SUP_INV_COMMITTED_COST
, PABR.PO_COMMITTED_COST PO_COMMITTED_COST
, PABR.PR_COMMITTED_COST PR_COMMITTED_COST
, PABR.OTH_COMMITTED_COST OTH_COMMITTED_COST
, PABR.CMT_BURDENED_COST CMT_BURDENED_COST
FROM PJI_PRD_ACT_CMT_BY_RSRC_V PABR

Columns