ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46FF151A9E05362FB09050512 SELECT pov.FIRST_NAME, pov.SECOND_NAME, pov.LAST_NAME, pov.SALUTATION, (decode(pov.SALUTATION, NULL, NULL, pov.SALUTATION || '. ') || decode(pov.FIRST_NAME, NULL, NULL, pov.FIRST_NAME || ' ') || pov.LAST_NAME) SUPPLIER_NAME, pov.VENDOR_NAME VENDOR_NAME, pov.COMPANY_REGISTRATION_NUMBER COMPANY_REGISTRATION_NUMBER, pov.SEGMENT1, pov.TRADING_NAME, (select meaning from fnd_lookup_values_vl where LOOKUP_TYPE = 'VENDOR TYPE' and LOOKUP_CODE = pov.VENDOR_TYPE_LOOKUP_CODE) VENDOR_TYPE, (SELECT to_char(MAX(aip.ACCOUNTING_DATE),'DD-MON-YYYY') FROM AP_CHECKS ac, AP_INVOICE_PAYMENTS aip, AP_INVOICES inv, AP_SUPPLIER_SITES pvs WHERE ac.VENDOR_ID = pov.VENDOR_ID AND ac.VOID_DATE IS NULL AND aip.CHECK_ID = ac.CHECK_ID AND inv.INVOICE_ID = aip.invoice_id AND pvs.VENDOR_ID = inv.VENDOR_ID AND pvs.VENDOR_SITE_ID = inv.VENDOR_SITE_ID AND upper(pvs.ALLOW_AWT_FLAG) = 'Y') LAST_PAYMENT_DATE, (select tax.TAX_RATE from dual where pov.awt_group_id is null or pov.pay_awt_group_id is null or pov.awt_group_id = pov.pay_awt_group_id)TAX_RATE, decode(pov.VENDOR_TYPE_LOOKUP_CODE, 'PARTNERSHIP', pov.PARTNERSHIP_UTR, pov.UNIQUE_TAX_REFERENCE_NUM) UNIQUE_TAX_REFERENCE_NUM, pov.NATIONAL_INSURANCE_NUMBER, (select tax.TAX_NAME from dual where pov.awt_group_id is null or pov.pay_awt_group_id is null or pov.awt_group_id = pov.pay_awt_group_id)TAX_NAME, (select meaning from IGI_LOOKUPS where LOOKUP_TYPE = 'IGI_CIS2007_MATCH_STATUS' and LOOKUP_CODE = pov.MATCH_STATUS_FLAG) MATCH_STATUS, to_char(pov.CIS_VERIFICATION_DATE,'DD-MON-YYYY') CIS_VERIFICATION_DATE, pov.VERIFICATION_NUMBER, (select grp.NAME from dual where pov.awt_group_id is null or pov.pay_awt_group_id is null or pov.awt_group_id = pov.pay_awt_group_id) TAX_GROUP_NAME, IGI_CIS2007_IGIPSUPR_PKG.igi_cis_is_verify_required(pov.VENDOR_ID) VERIFY_STATUS FROM AP_SUPPLIERS pov, AP_AWT_GROUPS grp, AP_AWT_GROUP_TAXES grp_tax, AP_TAX_CODES tax_codes, AP_AWT_TAX_RATES tax WHERE &pwhereclause &porderclause Y IGI IGIPSUPR_XMLP AR IGI تقرير قائمة الموردين المسجلين في CIS2007 Imported from BI Publisher Description: مخطط صناعة الإنشاءات : تقرير قائمة الموردين المسجلين Application: الماليات الدولية للقطاع العام Source: IGI : تقرير قائمة الموردين المسجلين في CIS2007 Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG D IGI CIS2007 Liste registrierter Lieferanten Imported from BI Publisher Description: Steuereinbehalt im Baugewerbe: Auswertung "Liste registrierter Lieferanten" Application: Public Sector Financials International Source: IGI: CIS2007 Liste registrierter Lieferanten Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG E IGI CIS2007 Listado de Proveedores Registrados Imported from BI Publisher Description: Construction Industry Scheme: Informe de listado de proveedores registrados Application: Public Sector Financials International Source: IGI: CIS2007 Listado de Proveedores Registrados Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG F IGI CIS2007 - Etat sous forme de liste des fournisseurs enregistrés Imported from BI Publisher Description: Construction Industry Scheme (régime applicable à l'industrie du bâtiment) : Etat sous forme de liste des fournisseurs enregistrés Application: Public Sector Financials International Source: IGI : CIS2007 - Etat sous forme de liste des fournisseurs enregistrés Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG I IGI rapporto elenco fornitori registrati schema industria edilizia 2007 Imported from BI Publisher Description: Schema industria edilizia: rapporto elenco fornitori registrati Application: Public Sector Financials International Source: IGI: rapporto elenco fornitori registrati schema industria edilizia 2007 Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG KO IGI CIS2007 등록 공급자 목록 보고서 Imported from BI Publisher Description: 건설업 체계: 등록 공급자 목록 보고서 Application: Public Sector Financials International Source: IGI: CIS2007 등록 공급자 목록 보고서 Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG RU IGI CIS2007 - список зарегистрированных поставщиков Imported from BI Publisher Description: Схема для строительства: список зарегистрированных поставщиков Application: Государственный сектор: международные финансы Source: IGI: CIS2007 - список зарегистрированных поставщиков Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG S IGI CIS2007 - listrapport över registrerade leverantörer Imported from BI Publisher Description: Byggnadsindustriplan: Listrapport över registrerade leverantörer Application: Public Sector Financials International Source: IGI : CIS2007 - listrapport över registrerade leverantörer Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG US IGI CIS2007 Registered Supplier Listing Imported from BI Publisher Description: Construction Industry Scheme : Registered Supplier Listing Report Application: Public Sector Financials International Source: IGI : CIS2007 Registered Supplier Listing Report Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG ZHS IGI IGI：CIS2007 已注册的供应商列表报表 Imported from BI Publisher Description: 建筑业模式：已注册的供应商列表报表 Application: Public Sector Financials International Source: IGI：CIS2007 已注册的供应商列表报表 Short Name: IGIPSUPR_XMLP DB package: IGI_CIS2007_IGIPSUPR_PKG BI Publisher &porderclause &pwhereclause :p_active :p_report :p_sort_by :p_supplier_from :p_supplier_to :porderclause :pwhereclause 1 -10 :p_report LOV Oracle IGI_CIS2007_NEW_REPORTS Y select lookup_code id, lookup_code value, null description from igi_lookups where lookup_type='IGI_CIS2007_NEW_REPORTS' order by meaning select lookup_code from IGI_LOOKUPS where lookup_type = 'IGI_CIS2007_NEW_REPORTS' and lookup_code = 'IGIPSUPR' Y AR اسم التقرير D Auswertung E Nombre del Informe F Nom de l'état I Nome rapporto KO 보고서명 RU Имя отчета S Rapport US Report Name ZHS 报表名称 2 10 :p_supplier_from LOV Oracle IGI_CIS2007_SUPPLIERS Y select vendor_name id, vendor_name value, null description from ap_suppliers where cis_enabled_flag='Y' order by 1 AR مورد من D Von Lieferant E De Proveedor F Fournisseur - De I Fornitore - Da KO 공급자 출처 RU Поставщик с S Från leverantör US Supplier From ZHS 供应商自 3 20 :p_supplier_to LOV Oracle IGI_CIS2007_SUPPLIERS Y select vendor_name id, vendor_name value, null description from ap_suppliers where cis_enabled_flag='Y' order by 1 AR مورد إلى D Bis Lieferant E A Proveedor F Fournisseur - A I Fornitore - A KO 공급자 대상 RU Поставщик по S Till leverantör US Supplier To ZHS 供应商至 4 30 :p_sort_by LOV Oracle IGI_CIS2007_SUPR_SORT_COLS Y select lookup_code id, meaning value, null description from igi_lookups where lookup_type='IGI_CIS2007_SUPR_SORT_COLS' order by meaning AR فرز حسب D Sortieren nach E Ordenar por F Tri par I Ordina per KO 정렬 기준 RU Сортировка S Sortera efter US Sort By ZHS 排序依据