ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4707151A9E05362FB09050512 SELECT jiel.vendor_id vendor_id, jiel.exemption_letter_id letter_id, jiel.year year, decode(jiel.clause_ref,'9',jiel.clause_ref||', 2^ comma,',jiel.clause_ref) clause_ref, to_char(jiel.effective_from,'DD-MON-RRRR') effective_from, to_char(jiel.effective_to,'DD-MON-RRRR') effective_to, substr(pv.vendor_name,1,40) envelope_name, decode(jiel.custom_flag,'Y',substr(pv.vendor_name,1,40), null) custom_name, decode(jiel.custom_flag,'Y',null,substr(pv.vendor_name,1,40)) vendor_name, pvs.address_line1 vendor_street, pvs.zip||' '||pvs.city vendor_zip, pv.party_id PartyId, hp.party_type ptype, pv.vat_registration_num regnum, nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)) taxpay, (select geography_name from hz_geographies where geography_code = pvs.country and geography_type='COUNTRY') Country, substr(pvs.city||' '||pvs.province,1,30) vendor_citycntry, jiel.rowid print_rowid, jiel.limit_amount exempt_amount, jiel.letter_type letter_type, JE_JEITAPEX_XMLP_PKG.print_commitformula(jiel.rowid) print_commit, JE_JEITAPEX_XMLP_PKG.cf_person_profileformula(hp.party_type, pv.party_id) CF_person_profile FROM je_it_exempt_letters jiel, po_vendors pv, hz_parties hp, po_vendor_sites_all pvs, (SELECT distinct person_id ,national_identifier FROM PER_ALL_PEOPLE_F) papf WHERE jiel.vendor_id = pv.vendor_id AND nvl(pv.employee_id,-99) = papf.person_id (+) AND pv.vendor_id = pvs.vendor_id AND pv.party_id = hp.party_id AND pvs.tax_reporting_site_flag = 'Y' AND pvs.country = :C_COUNTRY_CODE AND jiel.print_flag = 'Y' AND 100 = :force_order AND jiel.legal_entity_id = :P_LEGAL_ENTITY_ID_V AND trunc(jiel.issue_date) between trunc(:p_first_day) and trunc(:p_last_day) ORDER BY substr(pv.vendor_name,1,40), jiel.exemption_letter_id JE JEITAPEX_XML Y US JE Italian Payables Exemption Letter Process- Not Supported: Reserved For Future Use Imported from BI Publisher Description: Process and Print Exemption Letters Application: European Localizations Source: Italian Payables Exemption Letter Process (XML) - Not Supported: Reserved For Future Use Short Name: JEITAPEX_XML DB package: JE_JEITAPEX_XMLP_PKG BI Publisher :c_commercial_num :c_commit :c_country_code :c_functional_currency :c_le_name :c_listnum :c_location :c_our_country :c_our_sob_name :c_our_street :c_our_vatcode :c_our_zip_city :c_our_zipcity :c_place :c_sex :c_taxpayer_id :c_vat_reg_num :force_order :p_conc_request_id :p_first_day :p_last_day :p_legal_entity_id :p_legal_entity_id_v :p_period_from :p_period_set_name :p_period_to :p_province :p_rep_identifier :p_set_of_books_id :p_vat_number 1 -40 :p_set_of_books_id Number fnd_profile.value('GL_SET_OF_BKS_ID') Y US Ledger ID Ledger ID 2 -30 :p_province Char fnd_profile.value('JEIT_PROVINCE') Y US Province Province 3 -20 :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 4 10 :p_legal_entity_id LOV Oracle XLE_FIRSTPARTY Y select legal_entity_id id, name value, legal_entity_identifier description from xle_entity_profiles where transacting_entity_flag='Y' order by value,description US Legal Entity Legal Entity ID 5 20 :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 6 30 :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 7 40 :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 :$flex$.jeit_vat_period_from Period From Period To :$flex$.period_set_name Period_Set_Name Period From :$flex$.period_set_name Period_Set_Name Period To :$flex$.reporting_identifier Reporting Identifier Period_Set_Name