ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3EE3869E053B46B63588994 SELECT pov.vendor_name Vendor , pvs.vendor_site_code Vendor_site , pvs.address_line1 Address , pvs.address_line2 , pvs.address_line3 , pvs.city , pvs.state , pvs.country , pvs.zip FROM po_vendor_sites pvs , po_vendors pov WHERE pov.vendor_id = pvs.vendor_id AND pov.vendor_name >= nvl(:P_vendor_from,pov.vendor_name) AND pov.vendor_name <= nvl(:P_vendor_to,pov.vendor_name) AND pov.creation_date BETWEEN nvl(:P_create_date_from, pov.creation_date - 1) AND nvl(:P_create_date_to, pov.creation_date + 1) AND nvl(pvs.purchasing_site_flag,'N') = decode(:P_site, 'PURCHASING', 'Y', 'BOTH', 'Y', nvl(pvs.purchasing_site_flag, 'N')) AND nvl(pvs.pay_site_flag, 'N') = decode(:P_site, 'PAY','Y', 'BOTH', 'Y', nvl(pvs.pay_site_flag, 'N')) AND nvl(pov.vendor_type_lookup_code, '-1') = nvl(:P_vendor_type,nvl(pov.vendor_type_lookup_code,'-1')) AND ( (:P_active_inactive = 'ACTIVE' AND sysdate BETWEEN nvl(pov.start_date_active, sysdate-1) AND nvl(pov.end_date_active, sysdate+1)) OR (:P_active_inactive = 'INACTIVE' AND ( sysdate <= nvl(pov.start_date_active, sysdate-1) OR sysdate >= nvl(pov.end_date_active, sysdate+1))) OR nvl(:P_active_inactive,'BOTH') = 'BOTH') ORDER BY &orderby_clause Y PO POXVDRVL_XML AR PO تقرير خطاب المورد الجديد (بتنسيق XML) Application: المشتريات Source: تقرير خطاب المورد الجديد (بتنسيق XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG D PO Lieferanten - Schreiben Application: Einkauf Source: Lieferanten - Schreiben (XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG F PO Lettre aux nouveaux fournisseurs Application: Purchasing Source: Lettre aux nouveaux fournisseurs (XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG US PO New Vendor Letter Application: Purchasing Source: New Vendor Letter Report (XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG ZHS PO 新供应商信函报表 Application: 采购管理系统 Source: 新供应商信函报表 (XML) Short Name: POXVDRVL_XML DB package: PO_POXVDRVL_XMLP_PKG BI Publisher &orderby_clause :operating_unit :p_active_inactive :p_active_inactive_disp :p_conc_request_id :p_create_date_from :p_create_date_to :p_orderby :p_orderby_displayed :p_site :p_title :p_vendor_from :p_vendor_to :p_vendor_type :p_vendor_type_displayed 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_vendor_type LOV Oracle PO_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='VENDOR TYPE' order by displayed_field AR نوع المورد D Lieferantenart F Type de fournisseur US Vendor Type ZHS 供应商类型 3 30 :p_vendor_from LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR الموردون من D Von Lieferant F Fournisseurs - De US Vendors From ZHS 供应商自 4 70 :p_create_date_to Date AR إلى D Bis F Au US To ZHS 至 5 40 :p_vendor_to LOV Oracle PO_SRS_VENDOR_NAME Y Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى D Bis F A US To ZHS 至 6 50 :p_site LOV Oracle PO_SRS_VENDOR_SITE_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='VENDOR SITE USAGE' order by displayed_field AR موقع المورد D Lieferantenadresse F Site fournisseur US Vendor Site ZHS 供应商地点 7 60 :p_create_date_from Date AR تواريخ التكوين من D Von Erstellungsdatum F Dates de création - Du US Creation Dates From ZHS 创建日期自 8 80 :p_active_inactive LOV Oracle PO_SRS_ACTIVE_OPTIONS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='ACTIVE_INACTIVE' order by displayed_field Y AR ساري/غير ساري D Gültig/Ungültig F Activé/Désactivé US Active/Inactive ZHS 有效/无效 9 90 :p_orderby LOV Oracle PO_SRS_POXVDRVL_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('VENDOR','VENDOR SITE','ZIP CODE') order by displayed_field AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据