How to view the inv rup version in the EBS Environment

select 'Application Environment: '|| i.instance_name || ', Host: '|| i.host_name ||', Application Release: ' || f.release_name || ', DB Version: '|| i.version from v$instance i,fnd_product_groups fwhere upper(substr(i.instance_name,1,4)) =  upper(substr(f.applications_system_name,1,4))UNIONselect 'Current Application Release: '||ver||' ('||bug||')'  from (select x.* from(select 1 seq, '1939818' bug,'11.5.0' pv,'11.5.6' ver from dualunion select 2,'2123967','11.5.0','11.5.7' from dualunion select 3,'2293243','11.5.0','11.5.8' from dualunion select 4,'2669606','11.5.0','11.5.9 MP' from dualunion select 5,'3126422','11.5.0','11.5.9 Update1' from dualunion select 6,'3171663','11.5.0','11.5.9 Update2' from dualunion select 7,'3714435','11.5.0','11.5.9 June Update' from dualunion select 8,'3140000','11.5.0','11.5.10' from dualunion select 9,'3240000','11.5.0','11.5.10.1' from dualunion select 10,'3460000','11.5.0','11.5.10.2' from dualunion select 11,'3480000','11.5.0','11.5.10.2' from dualunion select 12,'4440000','12.0.0','12.0' from dualunion select 12,'94440000','12.0.0','12.0*' from dualunion select 13,'5082400','12.0.0','12.0.1' from dualunion select 14,'5484000','12.0.0','12.0.2' from dualunion select 14,'95484000','12.0.0','12.0.2*' from dualunion select 15,'6141000','12.0.0','12.0.3' from dualunion select 15,'96141000','12.0.0','12.0.3*' from dualunion select 16,'6435000','12.0.0','12.0.4' from dualunion select 17,'7282993','12.0.0','12.0.5' from dualunion select 18,'6728000','12.0.0','12.0.6' from dualunion select 19,'6646600','12.0.0','12.1.0' from dualunion select 20,'7303030','12.0.0','12.1.1' from dualunion select 20,'97303030','12.0.0','12.1.1*' from dualunion select 21,'7303033','12.0.0','12.1.2' from dualunion select 22,'9239090','12.0.0','12.1.3' from dualunion select 23,'10079002','12.0.0','12.2.0' from dualunion select 24,'910079002','12.0.0','12.2.0' from dualunion select 25,'14222221','12.0.0','12.2.1' from dualunion select 26,'16207672','12.0.0','12.2.2' from dualunion select 27,'17020683','12.0.0','12.2.3' from dualunion select 28,'17919161','12.0.0','12.2.4' from dualunion select 29,'917919161','12.0.0','12.2.4' from dual) x,(select product_version pv from fnd_product_installationswhere application_id=401) i,ad_bugs bugswhere x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1unionselect 'Current INV Rollup: '||ver||' ('||bug||')' from (select x.* from(select 1 seq, '1426212' bug,'11.5.0' pv,'INV.C' ver from dualunion select 2,'1551167','11.5.0','MFG.D' from dualunion select 3, '1550583','11.5.0','OM.D' from dualunion select 4,'1538130','11.5.0','INV.D' from dualunion select 5, '1745355','11.5.0','MFG.E' from dualunion select 6,'1696652','11.5.0','INV.E' from dualunion select 7, '1891480','11.5.0','MFG.F' from dualunion select 8, '1942144','11.5.0','OM.F' from dualunion select 9,'1886015','11.5.0','INV.F' from dualunion select 10, '2133107','11.5.0','MFG.G' from dualunion select 11, '2118482','11.5.0','OM.G' from dualunion select 12,'2004922','11.5.0','INV.G' from dualunion select 13, '2248408','11.5.0','MFG.H' from dualunion select 14,'2250333','11.5.0','OM.H' from dualunion select 15,'2248490','11.5.0','INV.H' from dualunion select 16, '2697753','11.5.0','MFG.I' from dualunion select 17,'2698175','11.5.0','OM.I' from dualunion select 18,'2371213','11.5.0','INV.I' from dualunion select 19,'3384350','11.5.0','INV.J' from dualunion select 20,'4042499','11.5.0','INV.J RUP1' from dualunion select 21,'4231215','11.5.0','INV.J RUP2' from dualunion select 22,'4734840','11.5.0','INV.J RUP3' from dualunion select 23,'5739724','11.5.0','INV.J RUP4' from dualunion select 24,'6449139','11.5.0','INV.J RUP5' from dualunion select 25,'6461517','11.5.0','INV.J RUP6' from dualunion select 26,'6461519','11.5.0','INV.J RUP7' from dualunion select 27,'6461522','11.5.0','INV.J RUP8' from dualunion select 28,'6870030','11.5.0','INV.J RUP9' from dualunion select 29,'7258620','11.5.0','INV.J RUP10' from dualunion select 30,'7258624','11.5.0','INV.J RUP11' from dualunion select 31,'7258629','11.5.0','INV.J RUP12' from dualunion select 32,'7581431','11.5.0','INV.J RUP13' from dualunion select 33,'7666112','11.5.0','INV.J RUP14' from dualunion select 34,'8403245','11.5.0','INV.J RUP15' from dualunion select 35,'8403254','11.5.0','INV.J RUP16' from dualunion select 36,'8403258','11.5.0','INV.J RUP17' from dualunion select 37,'9063156','11.5.0','INV.J RUP18' from dualunion select 38,'9265857','11.5.0','INV.J RUP19' from dualunion select 39,'9466436','11.5.0','INV.J RUP20' from dualunion select 40,'9649124','11.5.0','INV.J RUP21' from dualunion select 41,'9878808','11.5.0','INV.J RUP22' from dualunion select 42,'10111967','11.5.0','INV.J RUP23' from dualunion select 43,'8478486','12.0.0','R12 INV/RCV RUP7' from dualunion select 44,'7587155','12.0.0','R12.1.1 OPM-INV Consolidated May-2009' from dualunion select 45,'12345554','12.0.0','R12.1.3 OPM-INV Consolidated Apr-2011' from dualunion select 46,'12916273','12.0.0','R12.1+ INV Dual UOM related fixes 3' from dualunion select 47,'13885374','12.0.0','R12.1+INV Dual UOM related fixes 4' from dualunion select 48,'14586882','12.0.0','R12.1+ INV RUP 5' from dualunion select 49,'16328540','12.0.0','R12.1+ INV RUP 6' from dualunion select 50,'16826285','12.0.0','R12.1+ INV RUP 7 (Requires RUP6)' from dualunion select 51,'17512558','12.0.0','R12.1+ INV RUP 7 Consolidated' from dualunion select 52,'18076740','12.0.0','R12.1+ INV RUP 8' from dual) x,(select product_version pv from fnd_product_installationswhere application_id = 401) i,ad_bugs bugswhere x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1UNIONselect 'Current WMS Rollup: '||ver||' ('||bug||')'  from (select x.* from(select 1 seq, '4734840' bug, '11.5.0' pv,'RUP3' ver from dualunion select 2 seq, '5855276' bug,'11.5.0' pv,'WMS RUP4' ver from dualunion select 3 seq, '6957082' bug,'11.5.0' pv,'WMS RUP5' ver from dualunion select 4 seq, '7041845' bug,'11.5.0' pv,'WMS RUP6' ver from dualunion select 5 seq, '7219660' bug,'11.5.0' pv,'WMS RUP7' ver from dualunion select 6 seq, '7317230' bug,'11.5.0' pv,'WMS RUP8' ver from dualunion select 7 seq, '7453739' bug,'11.5.0' pv,'WMS RUP9' ver from dualunion select 8 seq, '7591071' bug,'11.5.0' pv,'WMS RUP10' ver from dualunion select 9 seq, '7644924' bug,'11.5.0' pv,'WMS RUP11' ver from dualunion select 10 seq,'7688739' bug,'11.5.0' pv,'WMS RUP12' ver from dualunion select 11 seq,'8337529' bug,'11.5.0' pv,'WMS RUP13' ver from dualunion select 12 seq,'8524873' bug,'11.5.0' pv,'WMS RUP14' ver from dualunion select 13 seq,'8785944' bug,'11.5.0' pv,'WMS RUP15' ver from dualunion select 13 seq,'8941985' bug,'11.5.0' pv,'WMS RUP16' ver from dualunion select 14 seq,'9127290' bug,'11.5.0' pv,'WMS RUP17' ver from dualunion select 15 seq,'9857061' bug,'11.5.0' pv,'WMS RUP18' ver from dualunion select 16 seq,'9951502' bug,'11.5.0' pv,'WMS RUP19' ver from dualunion select 17 seq,'10129740' bug,'11.5.0' pv,'WMS RUP20' ver from dualunion select 18 seq,'7716519','12.0.0','R12.1.1 OPM-WMS Consolidated May-2009' from dualunion select 19 seq,'12364985','12.0.0','R12.1.1 OPM-WMS Consolidated Apr-2011' from dualunion select 20 seq,'12916291','12.0.0','R12.1+ WMS Dual UOM fixes RUP 3' from dualunion select 21 seq,'13885396','12.0.0','R12.1+ WMS Dual UOM fixes RUP 4' from dualunion select 22 seq,'14611722','12.0.0','R12.1+ WMS RUP 5' from dualunion select 23 seq,'16272776','12.0.0','R12.1+ WMS RUP 6' from dualunion select 24 seq,'16812342','12.0.0','R12.1+ WMS RUP 7 (Requires RUP6)' from dualunion select 25 seq,'17442200','12.0.0','R12.1+ WMS RUP 7 Consolidated' from dualunion select 26 seq,'18081430','12.0.0','R12.1+ WMS RUP 8' from dual) x,(select product_version pv from fnd_product_installationswhere application_id=385) i,ad_bugs bugswhere x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1unionselect 'Product Installation List : ' from dualunionselect 'Product Installation: '||patch_level||': '||decode(status,'I','Installed','S','Shared','Not Installed')from fnd_product_installationswhere application_id IN (401, 385, 201, 431, 702, 703)order by 1

Result example:

Application Environment: ml3ys211, Host: rws60075rems, Application Release: 12.1.1, DB Version: 11.1.0.7.0Current Application Release: 12.1.1 (7303030)Current INV Rollup: R12.1+ INV RUP 7 Consolidated (17512558)Current WMS Rollup: R12.1+ WMS RUP 7 Consolidated (17442200)Product Installation List : Product Installation: R12.BOM.C.1: InstalledProduct Installation: R12.EGO.C.1: InstalledProduct Installation: R12.ENG.C.1: InstalledProduct Installation: R12.INV.B.1: InstalledProduct Installation: R12.PO.B.1: InstalledProduct Installation: R12.WMS.B.1: Installed