Query for File version track of DB packages in R12

Hi All,

Below SQL Query helps in extracting the Package Version details updated due to application of various patches to e-business home.

select a.file_id,(select filename from ad_files where b.file_id=file_id) file_name, to_char(a.last_update_date,'DD/MM/YYYY HH24:Mi:SS')

from ad_file_versions a,

(select file_id from AD_FILES where filename in

(select ltrim(substr(text,instr(text,'H',-1)+7,instr((substr(text,instr(text,'H',-1)+7)),'s 1',-1))) from dba_source

where name = '&Package_name'

and text like '%$Header%.pls%' )) b

where a.file_id =b.file_id

order by last_update_date

Hope this helps..