Informatica Metadata Query For Parameter File

SELECT DISTINCT

      B.SUBJECT_AREA,

      B.TASK_NAME AS SES_WF_NAME,

      A.ATTR_VALUE AS PRM_FILE_PATH

FROM

       REP_TASK_ATTR A,

       REP_ALL_TASKS B

WHERE

        A.ATTR_ID IN (1,4)

        AND A.TASK_ID = B.TASK_ID

        AND A.ATTR_VALUE IS NOT NULL

ORDER BY 1,2 ASC

-------------------------------------------------------------------------------------------------

SELECT
     *
 FROM
     (
         SELECT
             attr_id,
             b.subject_area,
             b.task_name    AS ses_wf_name,
             a.attr_value   AS prm_file_path,
             ROW_NUMBER() OVER(
                 PARTITION BY a.task_id
                 ORDER BY
                     a.version_number DESC
             ) AS rn
         FROM
             rep_task_attr a,
             rep_all_tasks b
         WHERE
             a.attr_id IN (
                 1,
                 4
             )
             AND a.task_id = b.task_id
             AND a.attr_value IS NOT NULL
             AND b.subject_area = 'RAW_DATA'
     )
 WHERE
     rn = 1