VIEW: APPS.PA_PWP_CUSTOMER_SUMMARY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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