ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE943869E053B46B63588994Y SELECT org.duns_number_c duns_number, org.organization_name party_name, party.party_number party_number, location.address1 address, location.city city, location.state state, lookup.territory_short_name country FROM hz_organization_profiles org, hz_parties party, fnd_territories_vl lookup, hz_locations location, ( SELECT UNIQUE duns_number_c FROM hz_organization_profiles WHERE duns_number_c IS NOT NULL AND actual_content_source = 'DNB' AND effective_end_date IS NULL AND ( ( :p_duns_number IS NOT NULL AND duns_number_c like :p_duns_number ) OR :p_duns_number IS NULL ) GROUP BY duns_number_c HAVING COUNT(*) > 1 ) duns WHERE org.actual_content_source = 'DNB' AND org.effective_end_date IS NULL AND org.duns_number_c IS NOT NULL AND org.duns_number_c = duns.duns_number_c AND org.party_id = party.party_id AND location.location_id = HZ_DNBUI_PVT.get_location_id(org.party_id, 'DNB') AND location.country = lookup.territory_code ORDER BY org.duns_number_c AR ARHDUNDP_XML AR AR تقرير DUNS المكرر (بتنسيق XML) Application: المقبوضات Source: تقرير DUNS المكرر (بتنسيق XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG D AR Doppelte DUNS-Nummern Application: Debitoren Source: Doppelte DUNS-Nummern (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG F AR Etat DUNS en double Application: Receivables Source: Etat DUNS en double (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG US AR Duplicate DUNS Application: Receivables Source: Duplicate DUNS Report (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG ZHS AR 重复的 DUNS 报表 Application: 应收帐款 Source: 重复的 DUNS 报表 (XML) Short Name: ARHDUNDP_XML DB package: AR_ARHDUNDP_XMLP_PKG BI Publisher :p_company_name :p_conc_request_id :p_duns_number 1 10 :p_duns_number Char AR رقم DUNS المكرر D Doppelte DUNS-Nummern F Numéro DUNS en double US Duplicate DUNS Number ZHS 重复的 DUNS 编号