AR Unaccounted Transaction Sweep
Description
Categories: BI Publisher
Imported from BI Publisher
Application: Receivables
Source: Unaccounted Transaction Sweep
Short Name: ARTRXSWP
DB package: ar_unaccounted_trx_sweep
Application: Receivables
Source: Unaccounted Transaction Sweep
Short Name: ARTRXSWP
DB package: ar_unaccounted_trx_sweep
Run
AR Unaccounted Transaction Sweep and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT sum(a.amount_dr) SUM_ENTER_DEBIT ,sum(a.amount_cr) SUM_ENTER_CREDIT ,sum(a.acctd_amount_dr) SUM_ACCTD_DEBIT ,sum(a.acctd_amount_cr) SUM_ACCTD_CREDIT ,glcc.concatenated_segments SUM_DIST_ACT_CODE FROM ( SELECT gt.amount_dr ,gt.amount_cr ,gt.acctd_amount_dr ,gt.acctd_amount_cr ,gld.code_combination_id FROM ar_period_close_excps_gt gt ,ra_cust_trx_line_gl_dist_all gld WHERE gt.org_id = :ORG_ID AND gld.cust_trx_line_gl_dist_id = gt.cust_trx_line_gl_dist_id UNION ALL SELECT gt.amount_dr ,gt.amount_cr ,gt.acctd_amount_dr ,gt.acctd_amount_cr ,dst.code_combination_id FROM ar_period_close_excps_gt gt ,ar_distributions_all dst WHERE gt.org_id = :ORG_ID AND dst.line_id = gt.dist_line_id ) a,gl_Code_combinations_kfv glcc WHERE glcc.code_Combination_id = a.code_combination_id GROUP BY a.code_Combination_id, glcc.concatenated_segments |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Reporting Level |
|
LOV Oracle | |
Reporting Context |
|
LOV Oracle | |
From Accounting Date |
|
Date | |
To Accounting Date |
|
Date | |
Period Name |
|
LOV Oracle | |
Sweep Now |
|
LOV Oracle | |
Sweep To Period Name |
|
LOV Oracle | |
Debug Flag |
|
LOV Oracle |