AR Key Indicators Report -- Summary

select  initcap( NVL( lc.meaning,
                :cf_no_reason )) v_name,
                NVL( count( distinct( a.customer_trx_id )),0)  v_count,
                sum( gld.acctd_amount) all_sum,
                min( NVL( a.reason_code, '0') ) reason,
	AR_RAXSKI_XMLP_PKG.sel_trxformula(min( NVL( a.reason_code, '0') ), :INVOICE_CURRENCY_CODE, sum( gld.acctd_amount)) Sel_Trx,
	AR_RAXSKI_XMLP_PKG.Current_Period_p Current_Period,
	AR_RAXSKI_XMLP_PKG.Prior_Period_p Prior_Period,
	AR_RAXSKI_XMLP_PKG.C_Percent_Change_p C_Percent_Change,
	AR_RAXSKI_XMLP_PKG.Current_Sum_p Current_Sum,
	AR_RAXSKI_XMLP_PKG.Prior_Sum_p Prior_Sum,
	AR_RAXSKI_XMLP_PKG.S_Percent_Change_p S_Percent_Change,
	AR_RAXSKI_XMLP_PKG.All_Sum_CTF_p All_Sum_CTF
from    ra_cust_trx_line_gl_dist gld,
                ar_lookups   lc,
                ra_cust_trx_types d,
                ra_customer_trx   a
        where   complete_flag = 'Y'
        and     d.type = 'CM'
        and     a.reason_code = lc.lookup_code(+)
        and     lc.lookup_type(+) = 'CREDIT_MEMO_REASON'
        and     a.customer_trx_id = gld.customer_trx_id
         and    gld.account_class = 'REC'
         and    gld.latest_rec_flag  = 'Y'
        and     a.cust_trx_type_id = d.cust_trx_type_id
        and     a.invoice_currency_code = :invoice_currency_code
        group by lc.meaning
        order by lc.meaning