[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 |