ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EED93869E053B46B63588994Y SELECT substr(upper(translate(party.party_name, 'a!&#/\~-$%^,''&*.','a')) , 1,:p_number_of_char)Name, substrb(party.party_name,1,50) Customer_Name , look.meaning Site_Code , substr(cust.account_number,1,8) Customer_Number, loc.address1 Address , site.location Location , loc.city City , loc.state State , loc.postal_code Postal_Code , terr.territory_short_name Country, AR_RAXMRP_XMLP_PKG.c_data_not_foundformula(substr ( upper ( translate ( party.party_name , 'a!&#/\~-$%^,''&*.' , 'a' ) ) , 1 , :p_number_of_char )) C_DATA_NOT_FOUND FROM hz_cust_site_uses site, hz_cust_acct_sites addr, hz_party_sites party_site, hz_locations loc, hz_cust_accounts cust, hz_parties party, fnd_territories_vl terr, ar_lookups look WHERE cust.cust_account_id = addr.cust_account_id AND cust.party_id = party.party_id AND addr.party_site_id = party_site.party_site_id AND loc.location_id = party_site.location_id AND addr.cust_acct_site_id = site.cust_acct_site_id AND loc.country = terr.territory_code AND look.lookup_type = 'SITE_USE_CODE' AND look.lookup_code = site.site_use_code and 1<= ( select count(hz_parties.party_name) from hz_parties ,hz_cust_accounts where hz_cust_accounts.party_id = hz_parties.party_id and hz_parties.party_id != party.party_id and length(hz_parties.party_name) >= :p_number_of_char and upper(hz_parties.party_name) like upper(substr(party.party_name,1,:p_number_of_char))||'%' ) and upper(substr(translate(party.party_name, 'a!&#/\~-$%^,''&*.','a'),1,:p_number_of_char)) like upper(substrb(translate(:cp_customer_name, 'a!&#/\~-$%^,''&*.','a'),1,:p_number_of_char)||'%') and length(party.party_name) >= :p_number_of_char order by 1,2,4,3,5,6,7,8,9,10 AR RAXMRP_XML AR AR تقرير العميل المكرر (بتنسيق XML) Application: المقبوضات Source: تقرير العميل المكرر (بتنسيق XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG D AR Kundenduplikate Application: Debitoren Source: Kundenduplikate (XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG F AR Liste des clients en double Application: Receivables Source: Liste des clients en double (XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG US AR Duplicate Customer Application: Receivables Source: Duplicate Customer Report (XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG ZHS AR 重复客户报表 Application: 应收帐款 Source: 重复客户报表 (XML) Short Name: RAXMRP_XML DB package: AR_RAXMRP_XMLP_PKG BI Publisher :cp_customer_name :p_conc_request_id :p_customer_name :p_number_of_char :ph_cust_name :rp_company_name :rp_data_found :rp_report_name 1 10 :p_number_of_char Number Y AR عدد الحروف D Anzahl Zeichen F Nombre de caractères US Number of Characters ZHS 字符数 2 20 :p_customer_name LOV Oracle AR_CUSTOMER_NAME Y Y select party.party_name id, party.party_name value, null description from hz_cust_accounts cu,hz_parties party where cu.party_id=party.party_id and cu.cust_account_id in (select cu2.cust_account_id from hz_cust_accounts cu2,hz_parties party2 where cu2.party_id=party2.party_id and party2.party_name= party.party_name) order by party.party_name AR اسم العميل D Kundenname F Nom du client US Customer Name ZHS 客户名称