SELECT /*enumCLEARQUEST_DEVI_ID*/ AS iss_db,
      si.dbid AS iss_id,
      si.new_num AS iss_num,
      si.headline AS summary,
      sdef.name AS status,
      si.priority AS priority,
      dbms_lob.substr( si.releaseinfo, 4000, 1 )as releaseinfo,
      si.sbom as sbom,
      si.issue_type AS issue_type,
      si.release_part1,
      si.release_part2,
      si.release_part3,
      si.project,
      si.product,
      si.package_ref,
      dbms_lob.substr( si.notes_log, 4000, 1 ) AS notes_log,
      dbms_lob.substr( si.description, 4000, 1 )AS description,
      NULL AS release_id,
      NULL AS client_ref,
      NULL AS severity,
      NULL AS cr_internal,
      NULL AS cr_external,
      sp.fullname AS submitter,
      si.submit_date,
      ow.fullname AS owner,
      ap.fullname AS approver
FROM release_manager.CQ_software_issue si INNER JOIN
     release_manager.CQ_statedef sdef ON si.state = sdef.id INNER JOIN
     release_manager.CQ_users sp ON si.submitter = sp.dbid INNER JOIN
     release_manager.CQ_users ow ON si.owner = ow.dbid INNER JOIN
     release_manager.CQ_users ap ON si.approver = ap.dbid
WHERE si.dbid IN (/*DEVIiss*/)
ORDER BY iss_num ASC
