VIEW: APPS.PJI_PRD_PLN_BY_RSRC_V

Source

View Text - Preformatted

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.RBS_ELEMENT_ID RBS_ELEMENT_ID, FACT.RBS_VERSION_ID RBS_VERSION_ID, 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.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.RBS_ELEMENT_ID, FACT.RBS_VERSION_ID, FACT.PLAN_TYPE_ID, FACT.PLAN_VERSION_ID

View Text - HTML Formatted

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.RBS_ELEMENT_ID RBS_ELEMENT_ID
, FACT.RBS_VERSION_ID RBS_VERSION_ID
, 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.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.RBS_ELEMENT_ID
, FACT.RBS_VERSION_ID
, FACT.PLAN_TYPE_ID
, FACT.PLAN_VERSION_ID