[Home] [Help]
View: PA_ALLOC_MISSING_COSTS_V
View Text
SELECT MC.RUN_ID
, MC.TYPE_CODE
, PL.MEANING
, AR.DRAFT_REQUEST_ID
, AR.RELEASE_REQUEST_ID
, AR.RUN_PERIOD
, MC.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, MC.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, MC.AMOUNT
, AR.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_TASKS PT
, PA_LOOKUPS PL
, PA_ALLOC_RUNS AR
, PA_ALLOC_MISSING_COSTS MC
WHERE MC.RUN_ID = AR.RUN_ID
AND MC.PROJECT_ID= PP.PROJECT_ID(+)
AND MC.TASK_ID= PT.TASK_ID (+)
AND MC.TYPE_CODE=PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE='ALLOC_MISSING_AMT_TYPE'
Columns
Name |
RUN_ID |
TYPE_CODE |
TYPE |
DRAFT_REQUEST_ID |
RELEASE_REQUEST_ID |
RUN_PERIOD |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
TASK_ID |
TASK_NUMBER |
TASK_NAME |
AMOUNT |
ORG_ID |