[Home] [Help]
View: PA_RETIREMENT_COSTS_V
View Text
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)
Columns
Name |
PROJECT_ID |
PROJECT_NAME |
PROJECT_NUMBER |
TASK_ID |
RETIRABLE_COST |
RETIRED_COST |
PROJECT_TYPE |
CARRYING_OUT_ORGANIZATION_ID |