JE Italian Annual Customer and Supplier Electronic Format

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Application: European Localizations
Source: Italian Annual Customer and Supplier Electronic Format
Short Name: JEITLSTE_XMLP
DB package: JE_IT_XML_LISTING_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

		 SELECT XR.registered_name  LEGAL_ENTITY_NAME
			   ,XR.registration_number TAXPAYER_ID
			   ,vatrep.tax_registration_number VAT_REGISTRATION_NUMBER
	           ,HL.country  COUNTRY   
		       ,HL.address_line_1 ADDRESS_LINE_1
			   ,HL.address_line_2 ADDRESS_LINE_2
	           ,NVL(HL.address_line_3, HL.town_or_city||' '||HL.postal_code||' '||HL.country) ADDRESS_LINE_3
		       ,HL.town_or_city TOWN_OR_CITY
			   ,HL.postal_code POSTAL_CODE
	           ,HL.region_1 PROVINCE
			   ,XEP.legal_entity_id LEGAL_ENTITY_ID
			   ,fl.meaning REPORTING_TYPE
		FROM    xle_registrations       XR
			   ,xle_entity_profiles     XEP
	           ,hr_locations_all        HL
	           ,hz_parties              HP
	           ,jg_zz_vat_rep_entities  VATREP
			   ,jg_zz_vat_rep_entities ACC
			   ,fnd_lookups fl
	    WHERE   ACC.VAT_REPORTING_ENTITY_ID = :P_VAT_REPORTING_ENTITY_ID
        AND  ((ACC.ENTITY_TYPE_CODE = 'ACCOUNTING'
                   AND ACC.MAPPING_VAT_REP_ENTITY_ID = VATREP.VAT_REPORTING_ENTITY_ID)
                   OR
                  (ACC.ENTITY_TYPE_CODE = 'LEGAL'
                   AND ACC.VAT_REPORTING_ENTITY_ID = VATREP.VAT_REPORTING_ENTITY_ID)
                  )
	    AND     XR.source_id          =  XEP.legal_entity_id
	    AND     XR.source_table       = 'XLE_ENTITY_PROFILES'
	    AND     XEP.legal_entity_id   =  VATREP.legal_entity_id
	    AND     XR.location_id        =  HL.location_id
	    AND     XEP.party_id          =  HP.party_id
	    AND     xr.identifying_flag   = 'Y'
		AND     fl.lookup_type = 'JGZZ_REPORT_TYPE'
		AND     fl.lookup_code = :P_REPORT_TYPE
Parameter Name SQL text Validation
Reporting Identifier 
 
 LOV Oracle
Year of Declaration 
 
 LOV Oracle
Electronic Progression Number 
 
 Number
Download
 
Related Blitz Reports
JE Italian Annual Customer and Supplier Listing JE Italian Withholding Yearly JE Belgian VAT Sales Journal JG EMEA VAT: Journal AR Extract JE Italian Receivables Deferred VAT Register JE Italian Sales VAT Register JE Spanish Output VAT Journal ZX Party Tax Profiles XLE Legal Entities
Blitz Report™

Blitz Report™ provides multiple benefits: