AR European Sales Listing (1)

Description
Categories: BI Publisher, Financials
Application: Receivables
Source: European Sales Listing (XML)
Short Name: ARYVTSLD_XML
DB package: AR_ARYVTSLD_XMLP_PKG
SELECT	ft.territory_short_name		cty_name,
     	ft.territory_code			country_code,
	rasu.tax_reference			 vat_no,
	ract.invoice_currency_code		currency_code,
	sum(nvl(racg.amount,0))   		line_tot,
                  sum(nvl(racg.acctd_amount,0))                        line_acctd_tot
                 -- ,AR_ARYVTSLD_XMLP_PKG.inc_line_no()
                  ,AR_ARYVTSLD_XMLP_PKG.C_LINE_NO_P()  C_LINE_NO
FROM	hz_cust_acct_sites		ra,
	hz_party_sites		party_site,
	hz_locations		loc,
	fnd_territories_vl		ft,
	hz_cust_accounts		racu,
	ra_customer_trx		ract,
                  ra_cust_trx_types                         ractt,
	ra_customer_trx_lines	racl,
                   ra_cust_trx_line_gl_dist               racg,
	hz_cust_site_uses		rasu
WHERE	rasu.cust_acct_site_id 	= ra.cust_acct_site_id
and	ra.party_site_id = party_site.party_site_id
and	loc.location_id =	party_site.location_id
and	loc.country 		= ft.territory_code
and	ft.alternate_territory_code IS NOT NULL
and	loc.country != :C_COUNTRY
and             ractt.cust_trx_type_id = ract.cust_trx_type_id
and            decode(ractt.type,'CM',:P_REMIT_TO_ADDRESS,ract.remit_to_address_id) = :P_REMIT_TO_ADDRESS
and	racl.customer_trx_id	= ract.customer_trx_id
and            racl.customer_trx_line_id = racg.customer_trx_line_id
and	racg.gl_date 	between :P_STARTDATE and  :P_ENDDATE
and 	ract.set_of_books_id = :P_SET_OF_BOOKS_ID
and	racl.line_type != 'TAX'
and            ract.complete_flag = 'Y'
&lp_where
group by 	ft.territory_code,
	ft.territory_short_name,
               	rasu.tax_reference,
	ract.invoice_currency_code
	&C_GROUP_BY
order by 	ft.territory_short_name,
	rasu.tax_reference
Parameter Name SQL text Validation
Chart of Accounts Id
 
LOV Oracle
Ledger Id
 
LOV Oracle
Site Reported
 
LOV Oracle
Branch (to which remitted)
 
LOV Oracle
To Date
 
Date
From Date
 
Date
Detail/Summary
 
LOV Oracle