View: PA_PWP_CUSTOMER_SUMMARY_V

Product:	PA - Projects
Description:	Subcontractor workbench customer summary view
Implementation/DBA Data:	APPS.PA_PWP_CUSTOMER_SUMMARY_V

View Text

SELECT PROJECT_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, MAX(DRAFT_INVOICE_NUM) LAST_INVOICE_NUMBER
, MAX(PROJFUNC_CURRENCY_CODE)PROJFUNC_CURRENCY_CODE
, MAX(PROJECT_CURRENCY_CODE) PROJECT_CURRENCY_CODE
, SUM(NVL(PFC_BILL_AMOUNT
, 0)) PFC_BILL_AMOUNT
, SUM(NVL(PFC_CP_BILL_AMOUNT
, 0)) PFC_CP_BILL_AMOUNT
, SUM(NVL(PFC_RECIEPT_AMOUNT
, 0 )) PFC_RECIEPT_AMOUNT
, SUM(NVL(PFC_CP_RECIEPT_AMOUNT
, 0)) PFC_CP_RECIEPT_AMOUNT
, SUM(NVL(PFC_OUTSTANDING_AMOUNT
, 0 ))PFC_OUTSTANDING_AMOUNT
, SUM(NVL(PFC_ADJUSTMENT_AMOUNT
, 0)) PFC_ADJUSTMENT_AMOUNT
, SUM(NVL(PC_BILL_AMOUNT
, 0)) PC_BILL_AMOUNT
, SUM(NVL(PC_CP_BILL_AMOUNT
, 0) ) PC_CP_BILL_AMOUNT
, SUM(NVL(PC_RECIEPT_AMOUNT
, 0) ) PC_RECIEPT_AMOUNT
, SUM(NVL(PC_CP_RECIEPT_AMOUNT
, 0) ) PC_CP_RECIEPT_AMOUNT
, SUM(NVL(PC_OUTSTANDING_AMOUNT
, 0)) PC_OUTSTANDING_AMOUNT
, SUM(NVL(PC_ADJUSTMENT_AMOUNT
, 0)) PC_ADJUSTMENT_AMOUNT
FROM PA_PWP_CUSTOMER_SUMM GROUP BY PROJECT_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER

Columns