AR European Sales Listing (1)

Description
Categories: BI Publisher
Columns: Cty Name, Country Code, Vat No, Currency Code, Line Tot, Line Acctd Tot, C Line No ...
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
Detail/Summary
 
LOV Oracle
From Date
 
Date
To Date
 
Date
Branch (to which remitted)
 
LOV Oracle
Site Reported
 
LOV Oracle
Ledger Id
 
LOV Oracle
Chart of Accounts Id
 
LOV Oracle