VIEW: APPS.PJI_AC_ACT_CMT_BY_RSRC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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