VIEW: APPS.PA_ALLOC_AUDIT_BASIS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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