AP Supplier Open Interface Import - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Supplier Open Interface Import (XML) - Not Supported: Reserved For Future Use
Short Name: APXSUIMP_XML
DB package: AP_APXSUIMP_XMLP_PKG
SELECT nvl(asi.segment1,' ') C_Reject_Supplier_Number,
           asi.vendor_name  C_Reject_Supplier_Name,
           fnm.message_text C_Rejection_Message
FROM   ap_supplier_int_rejections asir,
       ap_suppliers_int asi,
       fnd_new_messages fnm        
WHERE  asi.status = 'REJECTED'
AND    asi.import_request_id = :p_conc_request_id
AND    asir.parent_id=asi.vendor_interface_id
AND    asir.parent_table='AP_SUPPLIERS_INT'
AND    fnm.message_name=asir.reject_lookup_code
AND    fnm.language_code=userenv('LANG')
Parameter Name SQL text Validation
Trace Switch
 
LOV Oracle
Debug Switch
 
LOV Oracle
Print Exceptions Only
 
LOV Oracle
Batch Size
 
Number
Import Options
 
LOV Oracle