AP Supplier Sites Open Interface Import - draft

Description
Categories: BI Publisher, Financials, Procurement
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
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
Trace Switch
 
LOV Oracle
Debug Switch
 
LOV Oracle
Print Exceptions Only
 
LOV Oracle
Batch Size
 
Number
Import Options
 
LOV Oracle