AR Unaccounted Transaction Sweep

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
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
Download
Related Blitz Reports
GL Account Analysis GL Account Analysis (Distributions) GL Account Analysis (Distributions) 11g XXSJ Report VAT Register GL Account Analysis 11g AR Miscellaneous Receipts JG EMEA VAT: Turnover AR Non TRL Extract JE Portuguese Customers Recapitulative JE Italian Annual Customer Listing
Blitz Report™

Blitz Report™ provides multiple benefits: