AR Key Indicators Report -- Summary

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: Key Indicators Report -- Summary (XML)
Short Name: RAXSKI_XML
DB package: AR_RAXSKI_XMLP_PKG
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
Parameter Name SQL text Validation
Ledger Id
 
LOV Oracle
Currency High
 
LOV Oracle
Currency Low
 
LOV Oracle
Prior Period End Date
 
Date
Prior Period Start Date
 
Date
Current Period End Date
 
Date
Current Period Start Date
 
Date