View: PA_DEDUCTION_SUMMARY_V

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

View Text

SELECT CI_ID
, TASK_ID
, PROJECT_ID
, TASK_NUMBER
, EXPENDITURE_ORG
, EXPENDITURE_TYPE
, EXPENDITURE_ORG_ID
, (SELECT NVL(SUM(BURDEN_COST)
, 0)
FROM PA_EXPENDITURE_ITEMS_ALL EI
, PA_EXPENDITURES_ALL E
WHERE EI.EXPENDITURE_ID =E.EXPENDITURE_ID
AND NVL(EI.OVERRIDE_TO_ORGANIZATION_ID
, E.INCURRED_BY_ORGANIZATION_ID)=V.EXPENDITURE_ORG_ID
AND EI.TASK_ID =V.TASK_ID
AND EI.EXPENDITURE_TYPE =V.EXPENDITURE_TYPE ) PF_EXP_AMOUNT
, PFC_DEDUCTIONS_AMOUNT
, (PFC_DEDUCTIONS_AMOUNT- PFC_PROC_DED_AMOUNT ) PFC_UNPROC_DED_AMOUNT
, PFC_PROC_DED_AMOUNT
FROM PA_DEDUCTION_SUMMARY_BASE_V V

Columns