AP Supplier Sites Open Interface Import - draft

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