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