AP Supplier Sites Open Interface Import - draft

➜ Back to Library
Description
Categories: BI Publisher
Application: Payables
Source: Supplier Sites Open Interface Import (XML) - Not Supported: Reserved For Future Use
Short Name: APXSSIMP_XML
DB package: AP_APXSSIMP_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT assi.org_id C_Rejected_Org_Id,
             aps.segment1 C_Rejected_Vendor_Number,
             aps.vendor_name C_Rejected_Vendor_Name,
             assi.vendor_site_code  C_Rejected_Site_Code,
             fnm.message_text       C_Rejection_Reason
FROM   ap_supplier_sites_int assi,
            ap_supplier_int_rejections asir,
           ap_suppliers aps,
       fnd_new_messages fnm
WHERE  assi.status = 'REJECTED'
AND    assi.import_request_id = :p_conc_request_id
AND    asir.parent_id=assi.vendor_site_interface_id
AND    asir.parent_table='AP_SUPPLIER_SITES_INT'
AND    assi.vendor_id=aps.vendor_id
AND    fnm.message_name=asir.reject_lookup_code
AND    fnm.language_code=userenv('LANG')
ORDER BY assi.org_id, aps.vendor_name, assi.vendor_site_code
Parameter Name SQL text Validation
Import Options 
 
 LOV Oracle
Batch Size 
 
 Number
Print Exceptions Only 
 
 LOV Oracle
Debug Switch 
 
 LOV Oracle
Trace Switch 
 
 LOV Oracle
Download
 
Related Blitz Reports
AP Supplier Open Interface Import - draft POS Integrated Supplier Import Rejections AP Accounted Invoice Aging XXRG GL Account Analysis ECC Payables, AP Closing, SQL2 GL Account Analysis GL Account Analysis (Distributions) 11g ECC Payables, AP Closing, SQL1 PO Receiving Transactions Pipeline
Blitz Report™

Blitz Report™ provides multiple benefits: