Reports2017-11-18T12:27:27+00:00

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
By continuing to use the site, you agree to the use of cookies. Accept