SELECT CUSTOMER_TRX_ID , COUNT(1) NUM_LINES , MAX(LAST_UPDATE_DATE) WHEN_LAST_UPDATED FROM JAI_AR_TRX_INS_LINES_T WHERE ERROR_FLAG ='R' AND Source = 'RAXTRX' GROUP BY CUSTOMER_TRX_ID
View Text - HTML Formatted
SELECT CUSTOMER_TRX_ID , COUNT(1) NUM_LINES , MAX(LAST_UPDATE_DATE) WHEN_LAST_UPDATED FROM JAI_AR_TRX_INS_LINES_T WHERE ERROR_FLAG ='R' AND SOURCE = 'RAXTRX' GROUP BY CUSTOMER_TRX_ID