ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F4913869E053B46B63588994 SELECT dv.vendor_id C_VENDOR_ID, dv.vendor_site_id C_OLD_VENDOR_SITE_ID, duplicate_vendor_id C_DUP_VENDOR_ID, duplicate_vendor_site_id C_DUP_VENDOR_SITE_ID, entry_id C_ENTRY_ID, dv.org_id C_ORG_ID, a.vendor_name C_VENDOR_NAME, b.vendor_name C_DUP_VENDOR_NAME, c.vendor_site_code C_VENDOR_SITE_CODE, d.vendor_site_code C_DUP_VENDOR_SITE_CODE, dv.keep_site_flag C_KEEP_SITE_FLAG, dv.paid_invoices_flag C_PAID_INVOICES_FLAG, a.segment1 C_NEW_VENDOR_NUMBER, b.segment1 C_OLD_VENDOR_NUMBER, a.party_id c_party_id, dv.keep_site_flag C_KEEP_SITE_FLAG, d.party_site_id C_DUP_PARTY_SITE_ID, c.party_site_id C_PARTY_SITE_ID, AP_APXINUPD_XMLP_PKG.c_operating_unitformula(dv.org_id) C_OPERATING_UNIT, AP_APXINUPD_XMLP_PKG.c_vendor_site_idformula(dv.org_id, dv.keep_site_flag, dv.vendor_id, c.vendor_site_code, dv.vendor_site_id) C_VENDOR_SITE_ID, --AP_APXINUPD_XMLP_PKG.c_dup_recurring_countformula(duplicate_vendor_id, duplicate_vendor_site_id, dv.vendor_id, :C_VENDOR_SITE_ID) C_DUP_RECURRING_COUNT, AP_APXINUPD_XMLP_PKG.c_dup_recurring_countformula(duplicate_vendor_id, duplicate_vendor_site_id, dv.vendor_id, AP_APXINUPD_XMLP_PKG.c_vendor_site_idformula(dv.org_id, dv.keep_site_flag, dv.vendor_id, c.vendor_site_code, dv.vendor_site_id)) C_DUP_RECURRING_COUNT, AP_APXINUPD_XMLP_PKG.c_recurring_countformula(dv.vendor_id, AP_APXINUPD_XMLP_PKG.c_vendor_site_idformula(dv.org_id, dv.keep_site_flag, dv.vendor_id, c.vendor_site_code, dv.vendor_site_id), duplicate_vendor_id, duplicate_vendor_site_id) C_RECURRING_COUNT, AP_APXINUPD_XMLP_PKG.c_update_dup_vendorformula(:C_DUP_INVOICE_COUNT, AP_APXINUPD_XMLP_PKG.c_dup_recurring_countformula(duplicate_vendor_id, duplicate_vendor_site_id, dv.vendor_id, AP_APXINUPD_XMLP_PKG.c_vendor_site_idformula(dv.org_id, dv.keep_site_flag, dv.vendor_id, c.vendor_site_code, dv.vendor_site_id)), dv.keep_site_flag, AP_APXINUPD_XMLP_PKG.c_vendor_site_idformula(dv.org_id, dv.keep_site_flag, dv.vendor_id, c.vendor_site_code, dv.vendor_site_id), entry_id, :C_PAID_INVOICE_COUNT_RESET, :C_UNPAID_INVOICE_COUNT_RESET, duplicate_vendor_id, duplicate_vendor_site_id, dv.vendor_id, c.party_site_id, d.party_site_id) C_UPDATE_DUP_VENDOR, AP_APXINUPD_XMLP_PKG.c_invoice_countformula(:C_DUP_INVOICE_COUNT, :C_NON_DUP_INVOICE_COUNT, :C_DUP_RECURRING_COUNT, :C_RECURRING_COUNT) C_INVOICE_COUNT FROM ap_duplicate_vendors_all dv, ap_suppliers a, ap_suppliers b, ap_supplier_sites_all c, ap_supplier_sites_all d WHERE dv.process_flag='S' AND a.vendor_id=dv.vendor_id AND c.vendor_site_id=nvl(dv.vendor_site_id,duplicate_vendor_site_id) AND b.vendor_id=dv.duplicate_vendor_id AND d.vendor_site_id=dv.duplicate_vendor_site_id AND d.org_id =dv.org_id AND dv.process<>'P' Y SQLAP APXINUPD_XML AR AP برنامج دمج الموردين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: المدفوعات Source: برنامج دمج الموردين (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: APXINUPD_XML DB package: AP_APXINUPD_XMLP_PKG D AP Lieferanten zusammenfassen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Kreditoren Source: Lieferanten zusammenfassen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: APXINUPD_XML DB package: AP_APXINUPD_XMLP_PKG F AP Programme de fusion de fournisseurs- Non pris en charge : réservé pour une utilisation future Application: Payables Source: Programme de fusion de fournisseurs (XML) - Non pris en charge : réservé pour une utilisation future Short Name: APXINUPD_XML DB package: AP_APXINUPD_XMLP_PKG US AP Supplier Merge Program - draft Application: Payables Source: Supplier Merge Program (XML) - Not Supported: Reserved For Future Use Short Name: APXINUPD_XML DB package: AP_APXINUPD_XMLP_PKG ZHS AP 供应商合并程序- 不支持：已保留供将来使用 Application: 应付帐款 Source: 供应商合并程序 (XML) - 不支持：已保留供将来使用 Short Name: APXINUPD_XML DB package: AP_APXINUPD_XMLP_PKG BI Publisher :c_base_currency_code :c_base_description :c_base_min_acct_unit :c_base_precision :c_chart_of_accounts_id :c_company_name_header :c_dup_invoice_count :c_dup_recurring_count :c_nls_all :c_nls_end_of_report :c_nls_no :c_nls_no_data_exists :c_nls_yes :c_non_dup_invoice_count :c_paid_invoice_count_reset :c_recurring_count :c_report_run_time :c_report_start_date :c_unpaid_invoice_count_reset :p_chv_installed_flag :p_conc_request_id :p_debug_switch :p_fa_installed_flag :p_fa_installed_flag_t :p_flexdata :p_inv_installed_flag :p_inv_installed_flag_t :p_last_updated_by :p_last_updated_by_t :p_min_precision :p_mrp_installed_flag :p_pa_installed_flag :p_pa_installed_flag_t :p_pn_installed_flag :p_pn_installed_flag_t :p_po_installed_flag :p_po_installed_flag_t :p_pos_called :p_primary_pay :p_set_of_books_id :p_set_of_books_id_t