ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4706A51A9E05362FB09050512Y SELECT pvend.vendor_id vendor_id2, pvend.segment1 vendor_num1, &p_vendor_name_col &p_vendor_sitecode_col pvs.vendor_site_id vendor_site_id1, &p_vat_reg_no je_il_tax_pkg.is_number(&p_tax_payerid_cond, pvend.segment1) taxpayer_id, TRIM(pvs.address_line1 || ' ' || pvs.address_line2 || ' ' || pvs.address_line3 || ' ,' || pvs.CITY || ' ' || pvs.ZIP) vendor_address, &p_business_sec_cond (SELECT b.description FROM fnd_flex_value_sets a, fnd_flex_values_vl b WHERE a.flex_value_set_name = 'JEIL_TAX_OFFICER_NUMBER' AND a.flex_value_set_id = b.flex_value_set_id AND b.flex_value = &p_flex_value_cond) irs_tax_officer, (SELECT b.description FROM fnd_flex_value_sets a, fnd_flex_values_vl b WHERE a.flex_value_set_name = 'JEIL_WHT_TAX_RPT_GROUP' AND a.flex_value_set_id = b.flex_value_set_id AND b.flex_value = SUBSTR(&p_deduction_type_cond,1,2)) deduction_type -- SUBSTR(&p_deduction_type_cond, 1, 2) deduction_type FROM po_vendors pvend, (SELECT DISTINCT person_id, national_identifier FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf, po_vendor_sites_all pvs, ap_awt_groups aag WHERE pvend.vendor_id = pvs.vendor_id AND nvl(pvend.employee_id, -99) = papf.person_id(+) AND aag.group_id(+) = nvl(pvs.awt_group_id,pvs.pay_awt_group_id) AND pvs.vendor_site_id IN (SELECT ai.vendor_site_id FROM ap_invoices_all ai, ap_invoice_distributions_all aid WHERE ai.invoice_id = aid.invoice_id AND ai.set_of_books_id = &l_primary_ledger_id AND aid.set_of_books_id = &l_primary_ledger_id AND ai.legal_entity_id = :p_legal_entity_id AND aid.line_type_lookup_code = 'AWT' AND aid.awt_flag = 'A' AND aid.awt_invoice_payment_id IS NOT NULL AND aid.accounting_date >= :p_start_date AND aid.accounting_date <= :p_end_date UNION SELECT ac1.vendor_site_id FROM AP_INVOICE_PAYMENTS_ALL aip1 ,AP_CHECKS_ALL ac1 ,po_vendors pvend1 ,po_vendor_sites_all pvs1 WHERE ac1.vendor_id = pvend1.vendor_id AND ac1.vendor_site_id = pvs1.vendor_site_id AND pvend1.vendor_id = pvs1.vendor_id AND aip1.check_id = ac1.check_id AND ac1.legal_entity_id = :P_Legal_Entity_ID AND aip1.set_of_books_id= &l_primary_ledger_id AND ac1.global_attribute_category='JE.IL.APXPAWKB.CHECKS' AND NVL(ac1.global_attribute1,0) > 0 AND aip1.accounting_date >=:P_START_DATE AND aip1.accounting_date <=:P_END_DATE -- AND :P_REPORT_NAME = 'JEILWHTT' &l_currency_check &l_foreign_suppliers_check ) &p_vendor_type_cond &p_supplier_num_from &p_supplier_num_to ORDER BY pvs.vendor_id, pvs.vendor_site_id JE JEILAVCR AR JE تقرير شهادة عملية الاستقطاع السنوية للموردين في إسرائيل Imported from BI Publisher Application: المحليات الأوروبية Source: تقرير شهادة عملية الاستقطاع السنوية للموردين في إسرائيل Short Name: JEILAVCR DB package: JE_IL_TAX_PKG D JE Jährliche Steuereinbehaltungsbescheinigung für Lieferanten Imported from BI Publisher Application: Europäische Lokalisierungen Source: Israel: Jährliche Steuereinbehaltungsbescheinigung für Lieferanten Short Name: JEILAVCR DB package: JE_IL_TAX_PKG E JE Israel - Informe sobre Certificado Anual de Retención de Impuestos para Proveedores Imported from BI Publisher Application: Localizaciones Europeas Source: Israel - Informe sobre Certificado Anual de Retención de Impuestos para Proveedores Short Name: JEILAVCR DB package: JE_IL_TAX_PKG F JE Israël - Etat des certificats annuels de retenue pour les fournisseurs Imported from BI Publisher Application: European Localizations Source: Israël - Etat des certificats annuels de retenue pour les fournisseurs Short Name: JEILAVCR DB package: JE_IL_TAX_PKG I JE Israele - certificato annuale ritenute fiscali ai fornitori Imported from BI Publisher Application: European Localizations Source: Israele - certificato annuale ritenute fiscali ai fornitori Short Name: JEILAVCR DB package: JE_IL_TAX_PKG RU JE Отчет о сертификате годовых удержаний для поставщиков (Израиль) Imported from BI Publisher Application: Версии для Европы Source: Отчет о сертификате годовых удержаний для поставщиков (Израиль) Short Name: JEILAVCR DB package: JE_IL_TAX_PKG S JE Intyg för årlig källskatt för leverantörsrapport Imported from BI Publisher Application: European Localizations Source: Israel: Intyg för årlig källskatt för leverantörsrapport Short Name: JEILAVCR DB package: JE_IL_TAX_PKG TR JE Tedarikçilere İletilen İsrail Yıllık Stopaj Vergisi Sertifikası Raporu Imported from BI Publisher Application: Avrupa Yerelleştirmeleri Source: Tedarikçilere İletilen İsrail Yıllık Stopaj Vergisi Sertifikası Raporu Short Name: JEILAVCR DB package: JE_IL_TAX_PKG US JE Israeli Withholding Annual Certificate To Vendors Imported from BI Publisher Application: European Localizations Source: Israeli Withholding Annual Certificate To Vendors Report Short Name: JEILAVCR DB package: JE_IL_TAX_PKG BI Publisher &l_currency_check &l_foreign_suppliers_check &l_primary_ledger_id &p_business_sec_cond &p_deduction_type_cond &p_flex_value_cond &p_supplier_num_from &p_supplier_num_to &p_tax_payerid_cond &p_vat_reg_no &p_vendor_name_col &p_vendor_sitecode_col &p_vendor_type_cond :fnd_debug_log :gn_awt_amount :gn_check_id :gn_div_awt :gn_invoice_id :l_currency_check :l_foreign_suppliers_check :l_foreign_suppliers_check1 :l_period_set_name :l_primary_ledger_id :p_awt_taxrates_query :p_bank_supplier :p_business_sec_cond :p_comp_rpt_exist :p_count_lines_query :p_count_vendors_query :p_deduction_type_cond :p_definition_code :p_end_date :p_exp_irs_cond :p_first_party_query :p_flex_value_cond :p_from_period :p_from_supplier_number :p_global_cond :p_include_wht_0 :p_information_level :p_ledger_id :p_legal_entity_id :p_manual_rpt_exist :p_method :p_name_level :p_order_by :p_order_by_cond :p_payer_position :p_payment_info_query :p_report_name :p_start_date :p_supplier_num_from :p_supplier_num_to :p_supplier_type :p_tax_payerid_cond :p_to_period :p_to_supplier_number :p_vat_reg_no :p_vendor_balance_query :p_vendor_name :p_vendor_name_col :p_vendor_name_cond :p_vendor_site :p_vendor_site_cond :p_vendor_sitecode_col :p_vendor_type :p_vendor_type_col :p_vendor_type_cond :p_year 1 -20 :p_report_name Char JEILAVCR AR اسم التقرير اسم التقرير D Auswertungsbezeichnung Auswertungsbezeichnung E Nombre del Informe Nombre del Informe F Nom de l'état Nom de l'état I Nome rapporto Nome rapporto RU Имя отчета Имя отчета S Rapport Rapport US Report Name Report Name 2 10 :p_year LOV Oracle JEIL_FISCAL_YEAR Y select period_year id, period_year value, null description from (select distinct period_year,period_set_name from gl_periods) where period_set_name=fnd_profile.value('JEIL_TAX_CALENDAR') order by value,description Y AR السنة السنة D Jahr Jahr E Año Año F Année Année I Anno Anno RU Год Год S År År TR Yıl Yıl US Year Year 3 20 :p_from_period LOV Oracle JEIL_FISCAL_TAX_CAL_PERIOD_FROM Y select period_name id, period_name value, null description from gl_periods where period_set_name=fnd_profile.value('JEIL_TAX_CALENDAR') and period_year=:$flex$.jeil_fiscal_year order by period_type,period_num Y AR من الفترة من الفترة D Von Periode Von Periode E De Período De Período F Période - De Période - De I Periodo - Da Periodo - Da RU Начальный период Начальный период S Från period Från period TR İlk Dönem İlk Dönem US From Period From Period 4 30 :p_to_period LOV Oracle JEIL_FISCAL_TAX_CAL_PERIOD_TO Y select gpt.period_name id, gpt.period_name value, null description from gl_periods gpf,gl_periods gpt where gpt.period_set_name=fnd_profile.value('JEIL_TAX_CALENDAR') and gpf.period_set_name=gpt.period_set_name and gpt.period_year=gpf.period_year and gpf.period_type=gpt.period_type and gpf.period_name=:$flex$.jeil_fiscal_tax_cal_period_from and gpt.period_num>=gpf.period_num order by gpt.period_num SELECT :$flex$.from_period FROM DUAL Y AR إلى الفترة إلى الفترة D Bis Periode Bis Periode E A Período A Período F Période - A Période - A I Periodo - A Periodo - A RU Конечный период Конечный период S Till period Till period TR Son Dönem Son Dönem US To Period To Period 5 40 :p_ledger_id LOV Oracle JGZZ_SRS_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers_public_v l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by name Y AR دفتر الأستاذ دفتر الأستاذ D Buch Buch E Libro Mayor Libro Mayor F Livre Livre I Libro contabile Libro contabile RU Книга Книга S Huvudbok Huvudbok US Ledger Ledger 6 50 :p_legal_entity_id LOV Oracle JGZZ_LEGAL_ENTITY Y select legal_entity_id id, legal_entity_name value, null description from gl_ledger_le_v where ledger_id=:$flex$.jgzz_srs_ledger_name order by value,description Y AR الكيان القانوني الكيان القانوني D Mandant Mandant E Entidad Jurídica Entidad Jurídica F Entité juridique Entité juridique I Persona giuridica Persona giuridica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel Kişilik US Legal Entity Legal Entity 7 60 :p_include_wht_0 LOV Oracle JGZZ_SRS_YES_NO Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description Y Y AR تضمين WHT = 0 تضمين WHT = 0 D Mit Steuereinbehaltung = 0 Mit Steuereinbehaltung = 0 E Incluir Retención de Impuestos = 0 Incluir Retención de Impuestos = 0 F Inclure Retenue fiscale = 0 Inclure Retenue fiscale = 0 I Includi WHT = 0 Includi WHT = 0 RU Включая удержание налогов = 0 Включая удержание налогов = 0 S Inkludera källskatt = 0 Inkludera källskatt = 0 TR WHT = 0 Dahil WHT = 0 Dahil US Include WHT = 0 Include WHT = 0 8 70 :p_vendor_type LOV Oracle JEIL_VENDOR_TYPES Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JEIL_VENDOR_TYPE' order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type = 'JEIL_VENDOR_TYPE' AND lookup_code = 'A' Y AR نوع المورد نوع المورد D Lieferantenart Lieferantenart E Tipo de Proveedor Tipo de Proveedor F Type de fournisseur Type de fournisseur I Tipo di fornitore Tipo di fornitore RU Тип поставщика Тип поставщика S Leverantörstyp Leverantörstyp US Vendor Type Vendor Type 9 80 :p_from_supplier_number LOV Oracle JGZZ_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, vendor_name description from po_vendors where trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) order by segment1 AR من رقم المورد من رقم المورد D Von Lieferantennummer Von Lieferantennummer E De Número de Proveedor De Número de Proveedor F Numéro fournisseur - De Numéro fournisseur - De I Numero fornitore - Da Numero fornitore - Da RU Номер поставщика с Номер поставщика с S Från leverantörsnummer Från leverantörsnummer TR İlk Tedarikçi Numarası İlk Tedarikçi Numarası US From Supplier Number From Supplier Number 10 90 :p_to_supplier_number LOV Oracle JGZZ_SRS_VENDOR_NUMBER Y select segment1 id, segment1 value, vendor_name description from po_vendors where trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) order by segment1 AR إلى رقم المورد إلى رقم المورد D Bis Lieferantennummer Bis Lieferantennummer E A Número de Proveedor A Número de Proveedor F Numéro fournisseur - A Numéro fournisseur - A I Numero fornitore - A Numero fornitore - A RU Номер поставщика по Номер поставщика по S Till leverantörsnummer Till leverantörsnummer TR Son Tedarikçi Numarası Son Tedarikçi Numarası US To Supplier Number To Supplier Number 11 100 :p_information_level LOV Oracle JEIL_LEVEL Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JEIL_LEVEL' order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type = 'JEIL_LEVEL' AND lookup_code = 'S' Y AR مستوى المعلومات مستوى المعلومات D Informationsebene Informationsebene E Nivel de Información Nivel de Información F Niveau d'information Niveau d'information I Livello informazioni Livello informazioni RU Уровень сведений Уровень сведений S Informationsnivå Informationsnivå US Information Level Information Level 12 110 :p_name_level LOV Oracle JEIL_NAME_LEVEL Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='JEIL_NAME_LEVEL' order by value,description SELECT meaning FROM fnd_lookups WHERE lookup_type = 'JEIL_NAME_LEVEL' AND lookup_code = 'VSN' Y AR مستوى الاسم مستوى الاسم D Bezeichnungsebene Bezeichnungsebene E Nivel de Nombre Nivel de Nombre F Niveau de nom Niveau de nom I Livello nome Livello nome RU Уровень имени Уровень имени S Namnnivå Namnnivå US Name Level Name Level