eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PA_DEDUCTION_SUMMARY_BASE_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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