VIEW: APPS.PJI_XBS_PLANS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')