AP Supplier Open Interface Import - draft
Description
- Categories
- BI Publisher
- Application
- Payables
- Source
- Supplier Open Interface Import (XML) - Not Supported: Reserved For Future Use
- Short Name
- APXSUIMP_XML
- DB package
- AP_APXSUIMP_XMLP_PKG
SQL 13 lines
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') |
Parameters 5
| Parameter | Type | List of values SQL |
|---|---|---|
| Import Options | LOV Oracle | |
| Batch Size | Number | |
| Print Exceptions Only | LOV Oracle | |
| Debug Switch | LOV Oracle | |
| Trace Switch | LOV Oracle |