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
Run AP Supplier Sites Open Interface Import - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 GL Account Analysis 11g 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: