[Home] [Help]
View: PA_ALLOC_AUDIT_BASIS_V
View Text
SELECT PABD.RUN_ID
, DECODE (SIGN(PABD.LINE_NUM)
, -1
, ABS (PABD.LINE_NUM)
, PABD.LINE_NUM)
, PP.SEGMENT1
, PP.NAME
, PT.TASK_NUMBER
, PT.TASK_NAME
, PA_ALLOC_UTILS.RESOURCE_NAME ( 'BASIS'
, PABD.RESOURCE_LIST_MEMBER_ID
, PABD.RULE_ID )
, PABD.AMOUNT
, PABD.BASIS_PERCENT
, PABD.LINE_PERCENT
, (PABD.BASIS_PERCENT * PABD.LINE_PERCENT)/100
, DECODE (SIGN (PABD.LINE_NUM)
, -1
, 'Y'
, 'N')
FROM PA_ALLOC_RUN_BASIS_DET PABD
, PA_PROJECTS_ALL PP
, PA_TASKS PT
WHERE PABD.PROJECT_ID = PP.PROJECT_ID
AND PABD.TASK_ID = PT.TASK_ID
Columns
| Name |
| RUN_ID |
| LINE_NUMBER |
| PROJECT_NUMBER |
| PROJECT_NAME |
| TASK_NUMBER |
| TASK_NAME |
| RESOURCE_NAME |
| BASIS_AMOUNT |
| BASIS_PERCENT |
| LINE_PERCENT |
| EFFECTIVE_PERCENT |
| CLIENT_EXTENSION_FLAG |
APPS.PA_ALLOC_AUDIT_BASIS_V