Sorry the above has some mistakes,pls consider this

select PKG_NME, BG_DTTM, END_DTTM, PKG_STU

from

(select ST.PKG_NME, ST.BG_DTTM, ST.END_DTTM

,ST.PKG_STU

,row_number() over(partition by ST.PKG_NME order by ST.BG_DTTM desc) as LatestRun

from

dbo.VW_JOB_EXCTN_RPT ST) ST1

where (ST1.LatestRun=1 and

PKG_NME like '%EDW_IDS%FACT')or

(ST1.LatestRun=1 and

PKG_NME like 'MST_EDW%CHILD_MASTER')

order by PKG_NME