View: PA_DEDUCTION_SUMMARY_BASE_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_DEDUCTION_SUMMARY_BASE_V

View Text

SELECT DED1.CI_ID
, DED1.PROJECT_ID
, TRANS1.TASK_ID
, PT.TASK_NUMBER
, TRANS1.EXPENDITURE_TYPE
, O1.NAME EXPENDITURE_ORG
, TRANS1.EXPENDITURE_ORG_ID
, SUM(NVL(TRANS1.OVERRIDE_PROJFUNC_AMOUNT
, TRANS1.ORIG_PROJFUNC_AMOUNT)) PFC_DEDUCTIONS_AMOUNT
, (SELECT NVL(SUM(NVL(TRANS2.OVERRIDE_PROJFUNC_AMOUNT
, TRANS2.ORIG_PROJFUNC_AMOUNT))
, 0)
FROM PA_DEDUCTION_TRANSACTIONS_ALL TRANS2
, PA_DEDUCTIONS_ALL DED2
WHERE DED2.CI_ID =DED1.CI_ID
AND DED2.STATUS ='PROCESSED'
AND TRANS2.EXPENDITURE_ORG_ID= TRANS1.EXPENDITURE_ORG_ID
AND TRANS2.TASK_ID =TRANS1.TASK_ID
AND TRANS2.EXPENDITURE_TYPE =TRANS1.EXPENDITURE_TYPE
AND DED2.DEDUCTION_REQ_ID =TRANS2.DEDUCTION_REQ_ID ) PFC_PROC_DED_AMOUNT
FROM PA_DEDUCTION_TRANSACTIONS_ALL TRANS1
, PA_DEDUCTIONS_ALL DED1
, HR_ALL_ORGANIZATION_UNITS O1
, PA_TASKS PT
WHERE TRANS1.EXPENDITURE_ORG_ID= O1.ORGANIZATION_ID
AND PT.TASK_ID=TRANS1.TASK_ID
AND DED1.DEDUCTION_REQ_ID=TRANS1.DEDUCTION_REQ_ID
AND DED1.CI_ID IS NOT NULL GROUP BY DED1.CI_ID
, DED1.PROJECT_ID
, PT.TASK_NUMBER
, TRANS1.EXPENDITURE_TYPE
, O1.NAME
, TRANS1.EXPENDITURE_ORG_ID
, TRANS1.TASK_ID

Columns