ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4B43869E053B46B63588994 SELECT pvs.vendor_site_id vendor_site_id, pv.vendor_name vendor_name, pvs.address_line1 address1, pvs.address_line2 address2, pvs.address_line3 address3, pvs.city city, nvl(pvs.state, pvs.province) state, pvs.zip zip, nvl(pvs.country,:DEFAULT_COUNTRY_CODE_1) country_code, nvl(ft.territory_short_name,:DEFAULT_COUNTRY_NAME) country_name, decode(pvs.attention_ar_flag, 'N', NULL, :ATTN_MESSAGE) attention, AP_APXVDLBL_XMLP_PKG.c_address_concatenatedformula(pvs.address_line1, pvs.address_line2, pvs.address_line3, pvs.city, nvl(pvs.state, pvs.province), pvs.zip, nvl(ft.territory_short_name,:DEFAULT_COUNTRY_NAME), nvl(pvs.country,:DEFAULT_COUNTRY_CODE_1), pv.vendor_name, decode(pvs.attention_ar_flag, 'N', NULL, :ATTN_MESSAGE)) C_address_concatenated FROM po_vendors pv , po_vendor_sites pvs, fnd_territories_vl ft WHERE pv.vendor_id = pvs.vendor_id AND pvs.country = ft.territory_code (+) and pvs.vendor_site_id=:site_id Y SQLAP APXVDLBL_XML AR AP البطاقات البريدية للمورِّدين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: البطاقات البريدية للمورِّدين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXVDLBL_XML DB package: AP_APXVDLBL_XMLP_PKG D AP Lieferanten Adressetiketten- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Lieferanten Adressetiketten (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXVDLBL_XML DB package: AP_APXVDLBL_XMLP_PKG F AP Etiquettes d'adresses fournisseurs- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Etiquettes d'adresses fournisseurs (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXVDLBL_XML DB package: AP_APXVDLBL_XMLP_PKG US AP Supplier Mailing Labels - draft Application: Payables Source: Supplier Mailing Labels (XML) - Not Supported: Reserved For Future Use Short Name: APXVDLBL_XML DB package: AP_APXVDLBL_XMLP_PKG ZHS AP 供应商邮寄标签- 不支持：已保留供将来使用 Application: 应付帐款 Source: 供应商邮寄标签 (XML) - 不支持：已保留供将来使用 Short Name: APXVDLBL_XML DB package: AP_APXVDLBL_XMLP_PKG BI Publisher :attn_message :default_country_code :default_country_code_1 :default_country_name :operating_unit :p_conc_request_id :p_debug_switch :p_order_column :p_print_home_country :p_print_style :p_site :p_site_1 :p_trace_switch :p_vendor_type :p_vendor_type_1 :pay_site :site_id :sort_by_alternate 1 10 :p_vendor_type LOV Oracle AP_SRS_VENDOR_TYPE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='VENDOR TYPE' order by value,description AR نوع المورد D Lieferantenart F Type de fournisseur US Supplier Type ZHS 供应商类型 2 20 :p_order_column LOV Oracle AP_SRS_LABEL_ORDER Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='LABELS ORDERING' order by displayed_field desc select displayed_field from ap_lookup_codes where lookup_type = 'LABELS ORDERING' and lookup_code = 'Name' Y AR ترتيب بواسطة D Sortieren nach F Tri par US Order By ZHS 排序依据 3 30 :p_site LOV Oracle AP_SRS_VENDOR_SITE_TYPE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='LABELS SITES' order by value,description AR استخدامات الموقع D Adresszweck F Fonctions du site US Site Uses ZHS 地点用途 4 40 :p_print_home_country LOV Oracle AP_SRS_YES_NO_MAND Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' order by value,description select meaning from fnd_lookups where lookup_type = 'YES_NO' and lookup_code = 'Y' Y AR طباعة مسقط الرأس D Land bei Inlandsrechnungen drucken F Imprimer le pays principal US Print Home Country ZHS 打印本国 5 50 :p_print_style LOV Oracle AP_SRS_MAIL_LABEL_PRINT_STYLE Y select lookup_code id, displayed_field value, null description from ap_lookup_codes where nvl(inactive_date,sysdate+1)>sysdate and lookup_type='MAIL_LABEL_PRINT_STYLE' order by value,description select displayed_field from ap_lookup_codes where lookup_type = 'MAIL_LABEL_PRINT_STYLE' and lookup_code = 'FORMATTED' Y AR نمط المخرجات D Ausgabeformat F Style de la sortie US Output Style ZHS 输出方式