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
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 |