ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1153869E053B46B63588994 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 Y JE JEITLSTR_XMLP AR JE قائمة العملاء والموردين السنوية في إيطاليا Application: المحليات الأوروبية Source: قائمة العملاء والموردين السنوية في إيطاليا Short Name: JEITLSTR_XMLP DB package: JE_IT_XML_LISTING_PKG D JE Jahresliste der Kunden und Lieferanten Application: Europäische Lokalisierungen Source: Italien: Jahresliste der Kunden und Lieferanten Short Name: JEITLSTR_XMLP DB package: JE_IT_XML_LISTING_PKG F JE Italie - Liste annuelle des clients et des fournisseurs Application: European Localizations Source: Italie - Liste annuelle des clients et des fournisseurs Short Name: JEITLSTR_XMLP DB package: JE_IT_XML_LISTING_PKG US JE Italian Annual Customer and Supplier Listing Application: European Localizations Source: Italian Annual Customer and Supplier Listing Short Name: JEITLSTR_XMLP DB package: JE_IT_XML_LISTING_PKG BI Publisher :p_prog_num :p_report_mode :p_report_type :p_vat_reporting_entity_id :p_year_of_declaration 1 10 :p_vat_reporting_entity_id 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 AR معرف إعداد التقارير D Kennung Steuerpflichtiger F Identifiant d'entité déclarante US Reporting Identifier 2 20 :p_year_of_declaration LOV Oracle JGZZ_VAT_FISCAL_YEAR Y select glp.period_year id, glp.period_year value, null description from (select distinct(period_year),period_set_name from gl_periods) glp,jg_zz_vat_rep_entities cfgs where glp.period_set_name=cfgs.tax_calendar_name and cfgs.vat_reporting_entity_id= (select b.vat_reporting_entity_id from jg_zz_vat_rep_entities a,jg_zz_vat_rep_entities b where a.vat_reporting_entity_id=:$flex$.jgzz_vat_reporting_entity_id and ((a.entity_type_code='ACCOUNTING' and a.mapping_vat_rep_entity_id=b.vat_reporting_entity_id ) or (a.entity_type_code='LEGAL' and a.vat_reporting_entity_id=b.vat_reporting_entity_id ) )) order by value,description Y AR سنة الإقرار D Jahr der Steuererklärung F Année de déclaration US Year of Declaration 3 30 :p_report_mode LOV Oracle JEIT_REPORT_MODE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='JEIT_REPORT_MODE' order by meaning Y AR طور التقرير D Auswertungsmodus F Mode d'édition US Report Mode 4 40 :p_report_type LOV Oracle JGZZ_REPORT_TYPE Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JGZZ_REPORT_TYPE' order by value,description Y AR نوع التقرير D Auswertungsart F Type d'état US Report Type