POS Integrated Supplier Import Rejections

➜ Back to Library
Description
Categories: BI Publisher
Application: iSupplier Portal
Source: Integrated Supplier Import Rejections Report
Short Name: POS_SUPP_IMP_REJ_REP
DB package:
Run POS Integrated Supplier Import Rejections and other Oracle EBS reports with Blitz Report™ on our demo environment
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')
Parameter Name SQL text Validation
Batch Id 
 
 Number
Import Request Id 
 
 Number
Download
Related Blitz Reports
AP Supplier Sites Open Interface Import - draft AP Supplier Open Interface Import - draft PO Receiving Transactions Pipeline ECC Payables, AP Closing, SQL1 XLA Import Initial Balance for Third Party Control Account ECC Payables, AP Closing, SQL2 GL Account Analysis GL Account Analysis (Distributions) 11g AP Accounted Invoice Aging
Blitz Report™

Blitz Report™ provides multiple benefits: