ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4707F51A9E05362FB09050512 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 Y JE JEITXLRG_XML US JE Italian Payables Exemption Letter Register- Not Supported: Reserved For Future Use 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 BI Publisher :c_address1 :c_commercial_num :c_country :c_name :c_postal_code_city :c_taxpayer_id :c_vat_reg_num :cp_country_name :cp_month :cp_year :lp_legal_entity_id :p_conc_request_id :p_first_day :p_first_page_num :p_last_day :p_legal_entity_id :p_month :p_period_from :p_period_set_name :p_period_to :p_rep_identifier :p_set_of_books_id :p_year 1 -30 :p_period_set_name Char SELECT NVL(A.TAX_CALENDAR_NAME,B.TAX_CALENDAR_NAME) FROM JG_ZZ_VAT_REP_ENTITIES A, JG_ZZ_VAT_REP_ENTITIES B WHERE A.MAPPING_VAT_REP_ENTITY_ID = B.VAT_REPORTING_ENTITY_ID(+) AND A.VAT_REPORTING_ENTITY_ID = :$flex$.reporting_identifier US Period_Set_Name Calendar Name 2 -20 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger ID Ledger ID 3 10 :p_rep_identifier LOV Oracle JGZZ_VAT_REPORTING_ENTITY_ID Y select vat_reporting_entity_id id, entity_identifier value, null description from jg_zz_vat_rep_entities order by value,description Y US Reporting Identifier VAT Reporting Identifier 4 20 :p_period_from LOV Oracle JEIT_VAT_PERIOD_FROM Y select period_name id, period_name value, null description from gl_periods where period_set_name=:$flex$.period_set_name order by period_year,period_num asc Y US Period From From Period 5 30 :p_period_to LOV Oracle JEIT_VAT_PERIOD_TO Y select period_name id, period_name value, null description from gl_periods where period_set_name=:$flex$.period_set_name and period_num>=(select period_num from gl_periods where period_name=:$flex$.jeit_vat_period_from and period_set_name=:$flex$.period_set_name) and period_year in(select period_year from gl_periods where period_name=:$flex$.jeit_vat_period_from and period_set_name=:$flex$.period_set_name) order by period_year,period_num asc Y US Period To To Period 6 40 :p_first_page_num Number Y US First Page Number