SQL & PL/SQL

SELECT dp.sub_id,
       dl.id,
       dp.description,
       ce.entid,
       ce.NAME || '/' || prj.project_name,
       dp.engaged_ind,
       dp.status,
       dp.cd
  FROM dl_product dp
 INNER JOIN deal dl ON dp.id = dl.id
 INNER JOIN entity ce ON dl.entid = ce.entid
  LEFT OUTER JOIN project prj ON dl.proj_id = prj.proj_id
 INNER JOIN attributes attr ON dp.sub_id = attr.sub_id
 WHERE dp.status = 'A'
       AND attr.attribute_cd = 'AR'
       AND attr.attribute_value = 'Y'

Is it possible to get the results of the following query in a different manner without using LEFT OUTER JOIN or (+) or INNER JOIN as these are not supported in hibernate?


Thanks