Patch info query in SQL (Oracle APPS)

select application_short_name, bug_number, to_char(creation_date,'DD-MON-YYYY HH24:MI:SS') dated
from apps.ad_bugs
where bug_number = '5968876';

select * from apps.fnd_product_Groups ;
select * from fnd_product_installations where patch_level like '%AD%';

select * from WF_RESOURCES  where TYPE = 'WFTKN' and NAME = 'WF_VERSION';

select * from v$version

SELECT DECODE (bug_number
, '3554613', '4.5.0'
, '3263588', 'XDO.H'
, '3822219', '5.0.0'
, '4236958', '5.0.1'
, '4206181', '5.5.0'
, '4561451', '5.6.0'
, '4905678', '5.6.1'
, '5097966', '5.6.2') PATCH, bug_number
FROM ad_bugs
WHERE bug_number IN
('3554613'
, '3263588'
, '3822219'
, '4236958'
, '4206181'
, '4561451'
, '4905678'
, '5097966');

select WF_EVENT_XML.XMLVersion() XML_VERSION  from sys.dual;


select fnd_oracle_schema.getouvalue('LOGINSERVER') from dual