JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Italian Payables Exemption Letter Register
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
Run JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Reporting Identifier 
 
 LOV Oracle
Period From 
 
 LOV Oracle
Period To 
 
 LOV Oracle
First Page Number 
 
 Number
Download
Related Blitz Reports
JE Italian Payables Exemption Letter Process- Not Supported: Reserved For Future Use AP Withholding Tax by Tax Authority - draft AP Withholding Tax by Payment Report- Not Supported: Reserved For Future Use AP Withholding Tax by Invoice AP Withholding Tax by Supplier - draft JE Portuguese Payables Taxpayer ID Exception Report- Not Supported: Reserved For Future Use JE Israeli Withholding Tax Summary/Detail JE Israeli Withholding Tax Reconciliation INV Purchasing Packing Slip
Blitz Report™

Blitz Report™ provides multiple benefits: