VIEW: APPS.PA_RETIREMENT_COSTS_V

Source

View Text - Preformatted

SELECT PP.PROJECT_ID , PP.NAME , PP.SEGMENT1 , t.task_id , DECODE(PPT.CAPITAL_COST_TYPE_CODE, 'R', A.RAW_COST_ITD, 'B', A.BURDENED_COST_ITD) retirable_cost , 0 ,pp.project_type ,pp.carrying_out_organization_id FROM PA_PROJECT_ACCUM_HEADERS H, PA_PROJECT_ACCUM_ACTUALS A, PA_PROJECTS_ALL PP, PA_PROJECT_TYPES_ALL PPT, PA_TASKS T WHERE H.RESOURCE_ID = 0 AND H.PROJECT_ACCUM_ID = A.PROJECT_ACCUM_ID AND H.TASK_ID = T.TASK_ID AND H.PROJECT_ID = PP.PROJECT_ID AND PP.PROJECT_ID = T.PROJECT_ID AND nvl(T.RETIREMENT_COST_FLAG, 'N') = 'Y' AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE AND (pp.org_id is null or pp.org_id =ppt.org_id) UNION ALL SELECT PP.PROJECT_ID, PP.NAME, PP.SEGMENT1, 0, 0, PPA.CAPITALIZED_COST, pp.project_type, pp.carrying_out_organization_id FROM PA_PROJECTS_ALL PP, PA_PROJECT_ASSETS PPA WHERE PPA.PROJECT_ID(+) = PP.PROJECT_ID AND PPA.PROJECT_ASSET_TYPE = 'RETIREMENT_ADJUSTMENT' UNION ALL SELECT PP.PROJECT_ID, PP.NAME, PP.SEGMENT1, T.TASK_ID, DECODE(PPT.CAPITAL_COST_TYPE_CODE, 'R', PTA.I_TOT_RAW_COST, 'B', PTA.I_TOT_BURDENED_COST) retirable_cost ,0 ,pp.project_type ,pp.carrying_out_organization_id FROM PA_PROJECTS_ALL PP, PA_PROJECT_TYPES_ALL PPT, PA_TXN_ACCUM PTA, PA_TASKS T WHERE PTA.PROJECT_ID = PP.PROJECT_ID AND PTA.actual_cost_rollup_flag ='Y' AND PP.PROJECT_ID = T.PROJECT_ID AND PTA.task_id = T.task_id AND nvl(T.RETIREMENT_COST_FLAG, 'N') = 'Y' AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE AND (pp.org_id is null or pp.org_id =ppt.org_id)

View Text - HTML Formatted

SELECT PP.PROJECT_ID
, PP.NAME
, PP.SEGMENT1
, T.TASK_ID
, DECODE(PPT.CAPITAL_COST_TYPE_CODE
, 'R'
, A.RAW_COST_ITD
, 'B'
, A.BURDENED_COST_ITD) RETIRABLE_COST
, 0
, PP.PROJECT_TYPE
, PP.CARRYING_OUT_ORGANIZATION_ID
FROM PA_PROJECT_ACCUM_HEADERS H
, PA_PROJECT_ACCUM_ACTUALS A
, PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES_ALL PPT
, PA_TASKS T
WHERE H.RESOURCE_ID = 0
AND H.PROJECT_ACCUM_ID = A.PROJECT_ACCUM_ID
AND H.TASK_ID = T.TASK_ID
AND H.PROJECT_ID = PP.PROJECT_ID
AND PP.PROJECT_ID = T.PROJECT_ID
AND NVL(T.RETIREMENT_COST_FLAG
, 'N') = 'Y'
AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE
AND (PP.ORG_ID IS NULL OR PP.ORG_ID =PPT.ORG_ID) UNION ALL SELECT PP.PROJECT_ID
, PP.NAME
, PP.SEGMENT1
, 0
, 0
, PPA.CAPITALIZED_COST
, PP.PROJECT_TYPE
, PP.CARRYING_OUT_ORGANIZATION_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_ASSETS PPA
WHERE PPA.PROJECT_ID(+) = PP.PROJECT_ID
AND PPA.PROJECT_ASSET_TYPE = 'RETIREMENT_ADJUSTMENT' UNION ALL SELECT PP.PROJECT_ID
, PP.NAME
, PP.SEGMENT1
, T.TASK_ID
, DECODE(PPT.CAPITAL_COST_TYPE_CODE
, 'R'
, PTA.I_TOT_RAW_COST
, 'B'
, PTA.I_TOT_BURDENED_COST) RETIRABLE_COST
, 0
, PP.PROJECT_TYPE
, PP.CARRYING_OUT_ORGANIZATION_ID
FROM PA_PROJECTS_ALL PP
, PA_PROJECT_TYPES_ALL PPT
, PA_TXN_ACCUM PTA
, PA_TASKS T
WHERE PTA.PROJECT_ID = PP.PROJECT_ID
AND PTA.ACTUAL_COST_ROLLUP_FLAG ='Y'
AND PP.PROJECT_ID = T.PROJECT_ID
AND PTA.TASK_ID = T.TASK_ID
AND NVL(T.RETIREMENT_COST_FLAG
, 'N') = 'Y'
AND PP.PROJECT_TYPE = PPT.PROJECT_TYPE
AND (PP.ORG_ID IS NULL OR PP.ORG_ID =PPT.ORG_ID)