Product: | PJI - Project Intelligence(Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PJI_XBS_PLANS_V |
SELECT FACT.PROJECT_ID
, FACT.PLAN_VERSION_ID
, HEAD.WBS_VERSION_ID
, FACT.PROJECT_ELEMENT_ID
, DECODE(HEAD.WP_FLAG
, 'Y'
, 'WORKPLAN'
, 'FINANCIAL')
, SUM(NVL(FACT.LABOR_HRS
, 0))
, SUM(NVL(FACT.EQUIPMENT_HOURS
, 0))
, SUM(NVL(FACT.RAW_COST
, 0))
, SUM(NVL(FACT.BRDN_COST
, 0))
, SUM(NVL(FACT.REVENUE
, 0))
, SUM(NVL(FACT.LABOR_RAW_COST
, 0))
, SUM(NVL(FACT.LABOR_BRDN_COST
, 0))
, SUM(NVL(FACT.LABOR_REVENUE
, 0))
, SUM(NVL(FACT.EQUIPMENT_HOURS
, 0))
, SUM(NVL(FACT.ACT_LABOR_HRS
, 0))
, SUM(NVL(FACT.ACT_EQUIP_HRS
, 0))
, SUM(NVL(FACT.ACT_LABOR_BRDN_COST
, 0))
, SUM(NVL(FACT.ACT_EQUIP_BRDN_COST
, 0))
, SUM(NVL(FACT.ACT_BRDN_COST
, 0))
, SUM(NVL(FACT.ACT_RAW_COST
, 0))
, SUM(NVL(FACT.ACT_REVENUE
, 0))
, SUM(NVL(FACT.ETC_LABOR_HRS
, 0))
, SUM(NVL(FACT.ETC_EQUIP_HRS
, 0))
, SUM(NVL(FACT.ETC_LABOR_BRDN_COST
, 0))
, SUM(NVL(FACT.ETC_EQUIP_BRDN_COST
, 0))
, SUM(NVL(FACT.ETC_BRDN_COST
, 0))
, SUM(NVL(FACT.ETC_RAW_COST
, 0))
, SUM(NVL(FACT.ACT_LABOR_RAW_COST
, 0))
, SUM(NVL(FACT.ACT_EQUIP_RAW_COST
, 0))
, SUM(NVL(FACT.ETC_LABOR_RAW_COST
, 0))
, SUM(NVL(FACT.ETC_EQUIP_RAW_COST
, 0))
FROM PJI_FP_XBS_ACCUM_F FACT
, PJI_PJP_WBS_HEADER HEAD
WHERE FACT.PROJECT_ID = HEAD.PROJECT_ID
AND FACT.PLAN_VERSION_ID = HEAD.PLAN_VERSION_ID
AND FACT.CALENDAR_TYPE = 'A'
AND FACT.PERIOD_TYPE_ID = 2048
AND FACT.TIME_ID = -1
AND BITAND(FACT.CURR_RECORD_TYPE_ID
, 8) = 8
AND FACT.RBS_AGGR_LEVEL = 'T'
AND FACT.PLAN_VERSION_ID > 0 GROUP BY FACT.PROJECT_ID
, FACT.PLAN_VERSION_ID
, HEAD.WBS_VERSION_ID
, FACT.PROJECT_ELEMENT_ID
, DECODE(HEAD.WP_FLAG
, 'Y'
, 'WORKPLAN'
, 'FINANCIAL')