[Home] [Help]
View: PA_ALLOC_AUDIT_SOURCES_V
View Text
SELECT PASD.RUN_ID
, DECODE (SIGN(PASD.LINE_NUM)
, -1
, ABS (PASD.LINE_NUM)
, PASD.LINE_NUM)
, PP.SEGMENT1
, PP.NAME
, PT.TASK_NUMBER
, PT.TASK_NAME
, PA_ALLOC_UTILS.RESOURCE_NAME ( 'SOURCE'
, PASD.RESOURCE_LIST_MEMBER_ID
, PAR.RULE_ID )
, PASD.AMOUNT
, PASD.RESOURCE_PERCENT
, PAR.POOL_PERCENT
, PASD.ELIGIBLE_AMOUNT
, DECODE (SIGN(PASD.LINE_NUM)
, -1
, 'Y'
, 'N')
, PAR.ORG_ID
FROM PA_PROJECTS_ALL PP
, PA_TASKS PT
, PA_ALLOC_RUNS PAR
, PA_ALLOC_RUN_SOURCE_DET PASD
WHERE PAR.RUN_ID = PASD.RUN_ID
AND PASD.PROJECT_ID = PP.PROJECT_ID
AND PASD.TASK_ID = PT.TASK_ID
Columns
| Name |
| RUN_ID |
| LINE_NUM |
| PROJECT_NUMBER |
| PROJECT_NAME |
| TASK_NUMBER |
| TASK_NAME |
| RESOURCE_NAME |
| AMOUNT |
| RESOURCE_PERCENT |
| POOL_PERCENT |
| ELIGIBLE_AMOUNT |
| CLIENT_EXTENSION_FLAG |
| ORG_ID |
APPS.PA_ALLOC_AUDIT_SOURCES_V