ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3FC3869E053B46B63588994Y SELECT /*+ LEADING(ASIR ASSI)*/ASIR.BATCH_ID C_BATCH_ID, ASIR.IMPORT_REQUEST_ID,ASSI.ORG_ID C_REJECTED_ORG_ID, PARTY_ORIG_SYSTEM C_VENDOR_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE C_VENDOR_ORIG_SYSTEM_REFERENCE, ASSI.VENDOR_SITE_CODE C_REJECTED_SITE_CODE, SUPPLIER_SITE_ORIG_SYSTEM C_SUPPLIER_SITE_ORIG_SYSTEM, SUP_SITE_ORIG_SYSTEM_REFERENCE C_SUP_SITE_ORIG_SYSTEM_REF, PARTY_SITE_ORIG_SYSTEM C_PARTY_SITE_ORIG_SYSTEM, PARTY_SITE_ORIG_SYS_REFERENCE C_PARTY_SITE_ORIG_SYS_REF, ADDRESS_LINE1 C_ADDRESS_LINE1, ADDRESS_LINE2 C_ADDRESS_LINE2, ADDRESS_LINE3 C_ADDRESS_LINE3, CITY C_CITY, STATE C_STATE, ZIP C_ZIP, COUNTRY C_COUNTRY, nvl(fnm.message_text, asir.reject_lookup_code) C_REJECTION_REASON FROM AP_SUPPLIER_SITES_INT ASSI, POS_SUPPLIER_INT_REJECTIONS ASIR, FND_NEW_MESSAGES FNM WHERE ASSI.STATUS = 'REJECTED' AND ASSI.IMPORT_REQUEST_ID = :p_import_request_id AND ASSI.IMPORT_REQUEST_ID = ASIR.IMPORT_REQUEST_ID AND ASIR.BATCH_ID = :p_batch_id AND ASIR.BATCH_ID = ASSI.SDH_BATCH_ID AND ASIR.PARENT_ID=ASSI.VENDOR_SITE_INTERFACE_ID AND ASIR.PARENT_TABLE='AP_SUPPLIER_SITES_INT' AND fnm.message_name(+)=ASIR.REJECT_LOOKUP_CODE AND fnm.language_code(+)=USERENV('LANG') POS POS_SUPP_IMP_REJ_REP AR POS تقرير عمليات رفض استيراد بيانات المورد المتكامل Application: بوابة الدعم بالإنترنت Source: تقرير عمليات رفض استيراد بيانات المورد المتكامل Short Name: POS_SUPP_IMP_REJ_REP DB package: D POS Import für integrierte Lieferanten - Zurückweisungen Application: iSupplier Portal Source: Import für integrierte Lieferanten - Zurückweisungen Short Name: POS_SUPP_IMP_REJ_REP DB package: F POS Etat des rejets d'importation de fournisseurs intégré Application: iSupplier Portal Source: Etat des rejets d'importation de fournisseurs intégré Short Name: POS_SUPP_IMP_REJ_REP DB package: US POS Integrated Supplier Import Rejections Application: iSupplier Portal Source: Integrated Supplier Import Rejections Report Short Name: POS_SUPP_IMP_REJ_REP DB package: ZHS POS 集成的供应商导入拒绝报表 Application: 网上供应商门户 Source: 集成的供应商导入拒绝报表 Short Name: POS_SUPP_IMP_REJ_REP DB package: BI Publisher :p_batch_id :p_import_request_id 1 10 :p_batch_id Number AR معرف المجموعة D Stapelkennung F ID lot US Batch Id ZHS 批标识 2 20 :p_import_request_id Number AR معرف طلب الاستيراد D Importprozess-Nr. F ID demande d'importation US Import Request Id ZHS 导入请求编号