Subversion Repositories DevTools

/* Patches List In a Given Node In Given OS */
SELECT osc.*,
           pkg.pkg_name,
           pv.pkg_version,
           pd.IS_REJECTED,
           pv.IS_PATCH,
           pv.IS_OBSOLETE
  FROM PACKAGES pkg,
           PACKAGE_VERSIONS pv,
           PRODUCT_DETAILS pd,
           (
                SELECT osc.seq_num, osc.prod_id, osc.product_comments, osc.change_log_flag, osc.is_node_spec
                  FROM os_contents osc
                 WHERE osc.os_id = :OS_ID          
           ) osc,
           (
           select * from package_patches where pv_id = :PV_ID
           )pp
 WHERE pd.PROD_ID (+)= pv.PV_ID
   AND pv.pkg_id = pkg.pkg_id
   AND osc.PROD_ID = pv.pv_id   
   and pv.IS_PATCH IS NOT NULL   
   and pp.PATCH_ID = osc.PROD_ID
ORDER BY osc.SEQ_NUM