[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 |
APPS.PA_ALLOC_MISSING_COSTS_V