ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE953869E053B46B63588994Y SELECT org.organization_name party_name, party.party_number party_number, lookup.meaning requested_product, 1 as records, fnduser.user_name purchased_by, request.creation_date purchased_date FROM hz_parties party, hz_organization_profiles org, hz_dnb_request_log request, fnd_user fnduser, ar_lookups lookup WHERE request.party_id = party.party_id AND TRUNC( request.creation_date ) >= trunc(:p_from_date) AND TRUNC( request.creation_date ) <= trunc(:p_to_date) AND copied_from_party_id IS NULL AND org.party_id = party.party_id AND org.effective_end_date IS NULL AND org.actual_content_source = 'DNB' AND fnduser.user_id = request.created_by AND lookup.lookup_type = 'DNB_GDP_PRODUCT' AND lookup.lookup_code = request.requested_product UNION SELECT '' as party_name, '' as party_number, 'Batch Load' as requested_product, batch.NUM_PARTIES_PURCHASED as records, fnduser.user_name purchased_by, batch.creation_date purchased_date FROM hz_imp_batch_summary batch, fnd_user fnduser WHERE TRUNC(batch.creation_date) >= trunc(:p_from_date) AND TRUNC(batch.creation_date) <= trunc(:p_to_date) AND fnduser.user_id = batch.created_by AND batch.NUM_PARTIES_PURCHASED is not null ANd batch.original_system = 'DNB' order by purchased_date AR ARHGDPRQ_XML AR AR تقرير طلب منتجات البيانات العامة لـ DNB (بتنسيق XML) Application: المقبوضات Source: تقرير طلب منتجات البيانات العامة لـ DNB (بتنسيق XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG D AR Dun and Bradstreet - Anforderung globaler Datenprodukte Application: Debitoren Source: Dun and Bradstreet - Anforderung globaler Datenprodukte (XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG F AR Etat Demande de produit de données globales D&B Application: Receivables Source: Etat Demande de produit de données globales D&B (XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG US AR DNB Global Data Products Request Application: Receivables Source: DNB Global Data Products Request Report (XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG ZHS AR DNB 全球数据产品请求报表 Application: 应收帐款 Source: DNB 全球数据产品请求报表 (XML) Short Name: ARHGDPRQ_XML DB package: AR_ARHGDPRQ_XMLP_PKG BI Publisher :p_company_name :p_conc_request_id :p_date_format :p_from_date :p_int_from_date :p_int_to_date :p_to_date 1 10 :p_from_date Date Y AR تاريخ البداية D Startdatum F Date de début US Start Date ZHS 起始日期 2 20 :p_to_date Date select sysdate from dual Y AR تاريخ النهاية D Enddatum F Date de fin US End Date ZHS 终止日期