AR Key Indicators Report -- Summary
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Key Indicators Report -- Summary
Application: Receivables
Source: Key Indicators Report -- Summary (XML)
Short Name: RAXSKI_XML
DB package: AR_RAXSKI_XMLP_PKG
Description: Key Indicators Report -- Summary
Application: Receivables
Source: Key Indicators Report -- Summary (XML)
Short Name: RAXSKI_XML
DB package: AR_RAXSKI_XMLP_PKG
Run
AR Key Indicators Report -- Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Operating Unit |
|
LOV | |
Current Period Start Date |
|
Date | |
Current Period End Date |
|
Date | |
Prior Period Start Date |
|
Date | |
Prior Period End Date |
|
Date | |
Currency Low |
|
LOV Oracle | |
Currency High |
|
LOV Oracle |