ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE973869E053B46B63588994Y SELECT DECODE(PARTY_TYPE,'PERSON',pint.PERSON_FIRST_NAME||' '||pint.PERSON_LAST_NAME,pint.ORGANIZATION_NAME)CPTS_PARTY_NAME, (CASE WHEN cint.contact_point_type IN ('FAX','GEN','HOME','MOBILE','OFFICE','PAGER','VM', 'SMS') THEN NVL(cint.raw_phone_number,DECODE(PHONE_AREA_CODE,NULL,PHONE_NUMBER,PHONE_AREA_CODE||'-'||PHONE_NUMBER)) WHEN cint.contact_point_type = 'EMAIL' THEN cint.email_address WHEN cint.contact_point_type = 'EFT' THEN cint.eft_user_number WHEN cint.contact_point_type = 'EDI' THEN cint.edi_id_number WHEN cint.contact_point_type = 'WEB' THEN cint.url WHEN cint.contact_point_type = 'TLX' THEN cint.telex_number WHEN cint.contact_point_type IS NULL THEN cint.raw_phone_number ELSE cint.raw_phone_number END) CONTACT_POINT, lkp.MEANING CONTACT_POINT_TYPE, dedup.WINNER_RECORD_OSR CPTS_WINNER_RECORD_OSR, dedup.DUP_RECORD_OSR CPTS_SOURCE_SYSTEM_ID, dedup.DETAIL_PARTY_OSR CPTS_PARTY_SOURCE_SYSTEM_ID, HZ_BATCH_ACTION_PUB.GET_DEDUP_BATCH_STATUS(bat.BATCH_ID,dedup.ENTITY,bat.BD_ACTION_ON_CONTACT_POINTS,dedup.WINNER_RECORD_OS,dedup.WINNER_RECORD_OSR,dedup.DUP_RECORD_OS,dedup.DUP_RECORD_OSR) CPTS_DEDUP_STATUS FROM HZ_IMP_BATCH_SUMMARY bat, HZ_IMP_INT_DEDUP_RESULTS dedup, HZ_IMP_CONTACTPTS_INT cint, HZ_IMP_PARTIES_INT pint, FND_LOOKUP_VALUES lkp WHERE bat.BATCH_ID=:P_BATCH_ID AND bat.ORIGINAL_SYSTEM=:P_ORIG_SYS AND dedup.ENTITY='CONTACT_POINTS' AND bat.BATCH_ID=dedup.BATCH_ID AND bat.ORIGINAL_SYSTEM=dedup.DUP_RECORD_OS AND dedup.BATCH_ID=cint.BATCH_ID AND dedup.WINNER_RECORD_OS=cint.CP_ORIG_SYSTEM AND dedup.DUP_RECORD_OS=cint.CP_ORIG_SYSTEM AND dedup.DUP_RECORD_OSR=cint.CP_ORIG_SYSTEM_REFERENCE AND dedup.DETAIL_PARTY_OS=cint.PARTY_ORIG_SYSTEM AND dedup.DETAIL_PARTY_OSR=cint.PARTY_ORIG_SYSTEM_REFERENCE AND cint.BATCH_ID=pint.BATCH_ID AND cint.PARTY_ORIG_SYSTEM=pint.PARTY_ORIG_SYSTEM AND cint.PARTY_ORIG_SYSTEM_REFERENCE=pint.PARTY_ORIG_SYSTEM_REFERENCE AND lkp.LOOKUP_TYPE(+) = 'COMMUNICATION_TYPE' AND lkp.LOOKUP_CODE(+) = cint.CONTACT_POINT_TYPE AND lkp.LANGUAGE (+) = USERENV('LANG') AND lkp.VIEW_APPLICATION_ID (+) = 222 AND lkp.SECURITY_GROUP_ID (+) =fnd_global.lookup_security_group('COMMUNICATION_TYPE', 222) ORDER BY CPTS_DEDUP_STATUS AR ARHLVOUT_XML AR AR تقرير إلغاء تكرار مجموعات الاستيراد (بتنسيق XML) Application: المقبوضات Source: تقرير إلغاء تكرار مجموعات الاستيراد (بتنسيق XML) Short Name: ARHLVOUT_XML DB package: AR_ARHLVOUT_XMLP_PKG D AR Importstapel-Deduplizierung Application: Debitoren Source: Importstapel-Deduplizierung (XML) Short Name: ARHLVOUT_XML DB package: AR_ARHLVOUT_XMLP_PKG F AR Etat Importer des annulations de la duplication de lot Application: Receivables Source: Etat Importer des annulations de la duplication de lot (XML) Short Name: ARHLVOUT_XML DB package: AR_ARHLVOUT_XMLP_PKG US AR Import Batch De-Duplication Application: Receivables Source: Import Batch De-Duplication Report (XML) Short Name: ARHLVOUT_XML DB package: AR_ARHLVOUT_XMLP_PKG ZHS AR 导入批重复项删除报表 Application: 应收帐款 Source: 导入批重复项删除报表 (XML) Short Name: ARHLVOUT_XML DB package: AR_ARHLVOUT_XMLP_PKG BI Publisher :p_act_addr :p_act_cpt :p_act_cts :p_act_parties :p_batch_id :p_batch_name :p_conc_request_id :p_cre_dt :p_imp_status :p_load_type :p_orig_sys :p_tot_b_rec :p_tot_rec_imp 1 10 :p_batch_id Number Y AR معرف المجموعة D Stapelkennung F ID lot US Batch ID ZHS 批标识