JE Italian Payables Exemption Letter Register - draft

Description
Categories: BI Publisher
Application: European Localizations
Source: Italian Payables Exemption Letter Register (XML) - Not Supported: Reserved For Future Use
Short Name: JEITXLRG_XML
DB package: JE_JEITXLRG_XMLP_PKG
SELECT	substr(xl.year,3,4) 		year,
	xl.exemption_letter_id, 
	xl.issue_date,
	xl.issue_date,            
                substr(pv.vendor_name,1,80) 	vendor_name,
	substr(pvs.address_line1,1,35) 	address_line1,
	pvs.city,
	pv.vat_registration_num
FROM	je_it_exempt_letters xl,
	po_vendors pv,
	po_vendor_sites_all pvs
WHERE	xl.vendor_id = pv.vendor_id
AND	pv.vendor_id = pvs.vendor_id
AND	pvs.tax_reporting_site_flag = 'Y'  
AND         pvs.org_id=MO_GLOBAL.get_current_org_id
AND	xl.legal_entity_id = :LP_LEGAL_ENTITY_ID
AND	trunc(to_date(xl.issue_date,'DD-MON-YYYY')) between trunc(:p_first_day) and trunc(:p_last_day)
ORDER BY xl.year,
	 xl.exemption_letter_id
Parameter Name SQL text Validation
Ledger ID
 
Number
Period_Set_Name
 
First Page Number
 
Number
Period To
 
LOV Oracle
Period From
 
LOV Oracle
Reporting Identifier
 
LOV Oracle