eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_CAPITAL_PROJECTS_WBS_V

Source

View Text - Preformatted


SELECT tasks.PROJECT_ID, tasks.TASK_ID, 'X' TASK_NUMBER, 'X' TASK_NAME, 0 PARENT_TASK_ID, 0 WBS_LEVEL, 0 CAPITALIZED_COST, 0 RETIRED_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'N', DECODE(ptype.capital_cost_type_code,'R',NVL(accum.TOT_BILLABLE_RAW_COST,0) + NVL(accum.I_TOT_BILLABLE_RAW_COST,0), 'B',NVL(accum.TOT_BILLABLE_BURDENED_COST,0)+ NVL(accum.I_TOT_BILLABLE_BURDENED_COST,0)), 0)) CAPITALIZABLE_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'Y' , DECODE(ptype.capital_cost_type_code,'R',NVL(accum.TOT_BILLABLE_RAW_COST,0) + NVL(accum.I_TOT_BILLABLE_RAW_COST,0), 'B',NVL(accum.TOT_BILLABLE_BURDENED_COST,0) + NVL(accum.I_TOT_BILLABLE_BURDENED_COST,0)), 0)) RETIRABLE_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'N', DECODE(ptype.capital_cost_type_code,'R',NVL(accum.TOT_RAW_COST,0) + NVL(accum.I_TOT_RAW_COST,0), 'B',NVL(accum.TOT_BURDENED_COST,0) + NVL(accum.I_TOT_BURDENED_COST,0)), 0)) TOTAL_CAP_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'Y', DECODE(ptype.capital_cost_type_code,'R',NVL(accum.TOT_RAW_COST,0) + NVL(accum.I_TOT_RAW_COST,0), 'B',NVL(accum.TOT_BURDENED_COST,0) + NVL(accum.I_TOT_BURDENED_COST,0)), 0)) TOTAL_RET_COST FROM pa_txn_accum accum, pa_tasks tasks, pa_projects_all proj, pa_project_types_all ptype WHERE accum.task_id = tasks.task_id AND tasks.project_id = accum.project_id AND proj.PROJECT_ID = accum.PROJECT_ID AND proj.PJI_SOURCE_FLAG IS NULL AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE AND proj.TEMPLATE_FLAG <> 'Y' AND ptype.PROJECT_TYPE_CLASS_CODE = 'CAPITAL' AND ptype.org_id = proj.org_id UNION ALL SELECT tasks.PROJECT_ID, tasks.TASK_ID, 'X' TASK_NUMBER, 'X' TASK_NAME, 0 PARENT_TASK_ID, 0 WBS_LEVEL, 0 CAPITALIZED_COST, 0 RETIRED_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'N', DECODE(ptype.capital_cost_type_code,'R',NVL(fact.CAPITALIZABLE_RAW_COST,0), 'B',NVL(fact.CAPITALIZABLE_BRDN_COST,0)), 0)) CAPITALIZABLE_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'Y' , DECODE(ptype.capital_cost_type_code,'R',NVL(fact.BILL_RAW_COST,0), 'B',NVL(fact.BILL_BRDN_COST,0)), 0)) RETIRABLE_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'N', DECODE(ptype.capital_cost_type_code,'R',NVL(fact.RAW_COST,0), 'B',NVL(fact.BRDN_COST,0)), 0)) TOTAL_CAP_COST, (DECODE(NVL(tasks.RETIREMENT_COST_FLAG, 'N'),'Y', DECODE(ptype.capital_cost_type_code,'R',NVL(fact.RAW_COST,0), 'B',NVL(fact.BRDN_COST,0)), 0)) TOTAL_RET_COST FROM pji_fp_xbs_accum_f fact, pa_tasks tasks, pa_projects_all proj, pa_project_types_all ptype WHERE fact.PROJECT_ELEMENT_ID = tasks.TASK_ID AND proj.PROJECT_ID = fact.PROJECT_ID AND proj.PJI_SOURCE_FLAG = 'Y' AND fact.CALENDAR_TYPE = 'A' AND fact.PERIOD_TYPE_ID = 2048 AND fact.TIME_ID = -1 AND fact.PRG_ROLLUP_FLAG = 'N' AND fact.wbs_rollup_flag = 'N' AND BITAND(fact.CURR_RECORD_TYPE_ID,8) = 8 AND fact.RBS_AGGR_LEVEL = 'T' AND fact.PLAN_VERSION_ID = -1 AND proj.PROJECT_TYPE = ptype.PROJECT_TYPE AND proj.TEMPLATE_FLAG <> 'Y' AND ptype.PROJECT_TYPE_CLASS_CODE = 'CAPITAL' AND ptype.org_id = proj.org_id

View Text - HTML Formatted

SELECT TASKS.PROJECT_ID
, TASKS.TASK_ID
, 'X' TASK_NUMBER
, 'X' TASK_NAME
, 0 PARENT_TASK_ID
, 0 WBS_LEVEL
, 0 CAPITALIZED_COST
, 0 RETIRED_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'N'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(ACCUM.TOT_BILLABLE_RAW_COST
, 0) + NVL(ACCUM.I_TOT_BILLABLE_RAW_COST
, 0)
, 'B'
, NVL(ACCUM.TOT_BILLABLE_BURDENED_COST
, 0)+ NVL(ACCUM.I_TOT_BILLABLE_BURDENED_COST
, 0))
, 0)) CAPITALIZABLE_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'Y'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(ACCUM.TOT_BILLABLE_RAW_COST
, 0) + NVL(ACCUM.I_TOT_BILLABLE_RAW_COST
, 0)
, 'B'
, NVL(ACCUM.TOT_BILLABLE_BURDENED_COST
, 0) + NVL(ACCUM.I_TOT_BILLABLE_BURDENED_COST
, 0))
, 0)) RETIRABLE_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'N'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(ACCUM.TOT_RAW_COST
, 0) + NVL(ACCUM.I_TOT_RAW_COST
, 0)
, 'B'
, NVL(ACCUM.TOT_BURDENED_COST
, 0) + NVL(ACCUM.I_TOT_BURDENED_COST
, 0))
, 0)) TOTAL_CAP_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'Y'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(ACCUM.TOT_RAW_COST
, 0) + NVL(ACCUM.I_TOT_RAW_COST
, 0)
, 'B'
, NVL(ACCUM.TOT_BURDENED_COST
, 0) + NVL(ACCUM.I_TOT_BURDENED_COST
, 0))
, 0)) TOTAL_RET_COST
FROM PA_TXN_ACCUM ACCUM
, PA_TASKS TASKS
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_TYPES_ALL PTYPE
WHERE ACCUM.TASK_ID = TASKS.TASK_ID
AND TASKS.PROJECT_ID = ACCUM.PROJECT_ID
AND PROJ.PROJECT_ID = ACCUM.PROJECT_ID
AND PROJ.PJI_SOURCE_FLAG IS NULL
AND PROJ.PROJECT_TYPE = PTYPE.PROJECT_TYPE
AND PROJ.TEMPLATE_FLAG <> 'Y'
AND PTYPE.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND PTYPE.ORG_ID = PROJ.ORG_ID UNION ALL SELECT TASKS.PROJECT_ID
, TASKS.TASK_ID
, 'X' TASK_NUMBER
, 'X' TASK_NAME
, 0 PARENT_TASK_ID
, 0 WBS_LEVEL
, 0 CAPITALIZED_COST
, 0 RETIRED_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'N'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(FACT.CAPITALIZABLE_RAW_COST
, 0)
, 'B'
, NVL(FACT.CAPITALIZABLE_BRDN_COST
, 0))
, 0)) CAPITALIZABLE_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'Y'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(FACT.BILL_RAW_COST
, 0)
, 'B'
, NVL(FACT.BILL_BRDN_COST
, 0))
, 0)) RETIRABLE_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'N'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(FACT.RAW_COST
, 0)
, 'B'
, NVL(FACT.BRDN_COST
, 0))
, 0)) TOTAL_CAP_COST
, (DECODE(NVL(TASKS.RETIREMENT_COST_FLAG
, 'N')
, 'Y'
, DECODE(PTYPE.CAPITAL_COST_TYPE_CODE
, 'R'
, NVL(FACT.RAW_COST
, 0)
, 'B'
, NVL(FACT.BRDN_COST
, 0))
, 0)) TOTAL_RET_COST
FROM PJI_FP_XBS_ACCUM_F FACT
, PA_TASKS TASKS
, PA_PROJECTS_ALL PROJ
, PA_PROJECT_TYPES_ALL PTYPE
WHERE FACT.PROJECT_ELEMENT_ID = TASKS.TASK_ID
AND PROJ.PROJECT_ID = FACT.PROJECT_ID
AND PROJ.PJI_SOURCE_FLAG = 'Y'
AND FACT.CALENDAR_TYPE = 'A'
AND FACT.PERIOD_TYPE_ID = 2048
AND FACT.TIME_ID = -1
AND FACT.PRG_ROLLUP_FLAG = 'N'
AND FACT.WBS_ROLLUP_FLAG = 'N'
AND BITAND(FACT.CURR_RECORD_TYPE_ID
, 8) = 8
AND FACT.RBS_AGGR_LEVEL = 'T'
AND FACT.PLAN_VERSION_ID = -1
AND PROJ.PROJECT_TYPE = PTYPE.PROJECT_TYPE
AND PROJ.TEMPLATE_FLAG <> 'Y'
AND PTYPE.PROJECT_TYPE_CLASS_CODE = 'CAPITAL'
AND PTYPE.ORG_ID = PROJ.ORG_ID