How to view the INV RUP version number on an 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.* to (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 dual Union 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 Ten, ' 3460000 ', ' 11.5.0 ', ' 11.5.10.2 ' from Dualunion Select one, ' 3480000 ', ' 11.5.0 ', ' 11.5.10.2 ' from DualuNion Select, ' 4440000 ', ' 12.0.0 ', ' 12.0 ' from Dualunion Select, ' 94440000 ', ' 12.0.0 ', ' 12.0* ' from Dualunion Select 13, ' 5082400 ', ' 12.0.0 ', ' 12.0.1 ' from the dualunion Select, ' 5484000 ', ' 12.0.0 ', ' 12.0.2 ' from dualunion Select 14, ' 95484000 ', ' 12.0.0 ', ' 12.0.2* ' from Dualunion Select, ' 6141000 ', ' 12.0.0 ', ' 12.0.3 ' from dualunion Select 15, ' 96141000 ', ' 12.0.0 ', ' 12.0.3* ' from Dualunion Select +, ' 6435000 ', ' 12.0.0 ', ' 12.0.4 ' from Dualunion Select, ' 7282993 ', ' 12.0.0 ', ' 12.0.5 ' from Dualunion Select, ' 6728000 ', ' 12.0.0 ', ' 12.0.6 ' from Dualunion Select, ' 6646600 ', ' 12.0.0 ', ' 12.1.0 ' from dualunion Select, ' 7303030 ', ' 12.0.0 ', ' 12.1.1 ' from Dualunion Select, ' 97303030 ', ' 12.0.0 ', ' 12.1.1* ' from dualunion select 21, ' 7303033 ', ' 12.0.0 ', ' 12.1.2 ' from the dualunion Select, ' 9239090 ', ' 12.0.0 ', ' 12.1.3 ' from Dualunion Select 23, ' 10079002 ', ' 12.0.0 ', ' 12.2.0 ' from Dualunion Select, ' 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, ' 17020683 ', ' 12.0.0 ', ' 12.2.3 ' from Dualunion Select, ' 17919161 ', ' 12.0.0 ', ' 12.2.4 ' from Dualunion Select, ' 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 Ten, ' 2133107 ', ' 11.5.0 ', ' MFG. G ' from Dualunion Select one, ' 2118482 ', ' 11.5.0 ', ' OM.G ' from Dualunion Select, ' 2004922 ', ' 11.5.0 ', ' INV. G ' from Dualunion Select, ' 2248408 ', ' 11.5.0 ', ' MFG. H ' from Dualunion Select, ' 2250333 ', ' 11.5.0 ', ' OM. H ' from Dualunion Select, ' 2248490 ', ' 11.5.0 ', ' INV. H ' from Dualunion Select, ' 2697753 ', ' 11.5.0 ', ' MFG. I ' from Dualunion Select, ' 2698175 ', ' 11.5.0 ', ' OM. I ' from Dualunion Select, ' 2371213 ', ' 11.5.0 ', ' INV. I ' from Dualunion Select, ' 3384350 ', ' 11.5.0 ', ' INV. J ' from Dualunion Select, ' 4042499 ', ' 11.5.0 ', ' INV. J RUP1 ' from Dualunion Select, ' 4231215 ', ' 11.5.0 ', ' INV. J RUP2 ' from Dualunion Select, ' 4734840 ', ' 11.5.0 ', ' INV. J RUP3 ' from Dualunion Select, ' 5739724 ', ' 11.5.0 ', ' INV. J RUP4 ' from Dualunion Select, ' 6449139 ', ' 11.5.0 ', ' INV. J RUP5 ' from Dualunion Select, ' 6461517 ', ' 11.5.0 ', ' INV. J RUP6 ' from Dualunion Select, ' 6461519 ', ' 11.5.0 ', ' INV. J RUP7 ' from Dualunion Select, ' 6461522 ', ' 11.5.0 ', ' INV. J RUP8 ' from Dualunion Select, ' 6870030 ', ' 11.5.0 ', ' INV. J RUP9 ' from Dualunion Select, ' 7258620 ', ' 11.5.0 ', ' INV. J RUP10 ' from DualuNion Select, ' 7258624 ', ' 11.5.0 ', ' INV. J RUP11 ' from Dualunion Select, ' 7258629 ', ' 11.5.0 ', ' INV. J RUP12 ' from Dualunion Select, ' 7581431 ', ' 11.5.0 ', ' INV. J RUP13 ' from Dualunion Select, ' 7666112 ', ' 11.5.0 ', ' INV. J RUP14 ' from Dualunion Select, ' 8403245 ', ' 11.5.0 ', ' INV. J RUP15 ' from Dualunion Select, ' 8403254 ', ' 11.5.0 ', ' INV. J RUP16 ' from Dualunion Select, ' 8403258 ', ' 11.5.0 ', ' INV. J RUP17 ' from Dualunion select PNs, ' 9063156 ', ' 11.5.0 ', ' INV. J RUP18 ' from Dualunion Select, ' 9265857 ', ' 11.5.0 ', ' INV. J RUP19 ' from Dualunion Select, ' 9466436 ', ' 11.5.0 ', ' INV. J RUP20 ' from Dualunion Select, ' 9649124 ', ' 11.5.0 ', ' INV. J RUP21 ' from Dualunion Select, ' 9878808 ', ' 11.5.0 ', ' INV. J RUP22 ' from Dualunion Select, ' 10111967 ', ' 11.5.0 ', ' INV. J RUP23 ' from Dualunion Select, ' 8478486 ', ' 12.0.0 ', ' R12 inv/rcv RUP7 ' from Dualunion Select, ' 7587155 ', ' 12.0.0 ', ' R12 '. 1.1 OPM-INV Consolidated May-2009 ' from Dualunion Select, ' 12345554 ', ' 12.0.0 ', ' R12.1.3 OPM-INV Consolidated Apr-2011 ' F Rom Dualunion Select 46, ' 12916273 ', ' 12.0.0 ', ' r12.1+ INV Dual UOM related fixes 3 ' from Dualunion Select, ' 13885374 ', ' 12.0.0 ', ' R12.1+inv Dual U OM related fixes 4 ' from Dualunion Select, ' 14586882 ', ' 12.0.0 ', ' r12.1+ INV RUP 5 ' from Dualunion Select 49, ' 16328540 ', ' 1 2.0.0 ', ' r12.1+ Inv Rup 6 ' from Dualunion Select, ' 16826285 ', ' 12.0.0 ', ' r12.1+ INV rup 7 (Requires RUP6) ' from Dualunion s  Elect, ' 17512558 ', ' 12.0.0 ', ' r12.1+ INV RUP 7 Consolidated ' from Dualunion Select, ' 18076740 ', ' 12.0.0 ', ' r12.1+ inv RUP 8 ' from dual ×, (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.* to (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 ' bugs, ' 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 ' bugs, ' 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 Dualun Ion Select 8 seq, ' 7591071 ' Bug, ' 11.5.0 ' PV, ' wms RUP10 ' ver from dualunion select 9 seq, ' 7644924 ' Bug, ' 11.5.0 ' PV, ' wms RU P11 ' ver from dualunion select ten seq, ' 7688739 ' Bug, ' 11.5.0 ' PV, ' WMS RUP12 ' ver from dualunion select one seq, ' 8337529 ' bug , ' 11.5.0 ' PV, ' wms RUP13 ' ver from dualunion select-Seq, ' 8524873 ' Bug, ' 11.5.0 ' PV, ' wms RUP14 ' ver from dualunion Select Seq, ' 8785944 ' Bug, ' 11.5.0 ' PV, ' wms RUP15 ' ver from dualunion select seq, ' 8941985 ' Bug, ' 11.5.0 ' PV, ' wms RUP16 ' ver fr Om dualunion Select-seq, ' 9127290 ' Bug, ' 11.5.0 ' PV, ' WMS RUP17 ' ver from dualunion select-Seq, ' 9857061 ' Bug, ' 11.5.0 ' p V, ' WMS RUP18 ' ver from dualunion select-Seq, ' 9951502 ' Bug, ' 11.5.0 ' PV, ' wms RUP19 ' ver from dualunion select-Seq, ' 101 29740 ' Bug, ' 11.5.0 ' PV, 'WMS RUP20 ' ver from dualunion select-Seq, ' 7716519 ', ' 12.0.0 ', ' R12.1.1 opm-wms Consolidated May-2009 ' from Dualunion Sele Ct. seq, ' 12364985 ', ' 12.0.0 ', ' R12.1.1 opm-wms Consolidated Apr-2011 ' from dualunion select seq, ' 12916291 ', ' 12.0.0 ', ' r12.1+ WMS Dual UOM fixes Rup 3 ' from dualunion select seq, ' 13885396 ', ' 12.0.0 ', ' r12.1+ WMS Dual UOM fixes Rup 4 ' from D  Ualunion select-Seq, ' 14611722 ', ' 12.0.0 ', ' r12.1+ wms RUP 5 ' from dualunion select seq, ' 16272776 ', ' 12.0.0 ', ' r12.1+ WMS Rup 6 ' from Dualunion select-Seq, ' 16812342 ', ' 12.0.0 ', ' r12.1+ WMS RUP 7 (Requires RUP6) ' from dualunion select seq, ' 17442200 ', ' 12.0.0 ', ' r12.1+ WMS Rup 7 Consolidated ' from Dualunion Select-Seq, ' 18081430 ', ' 12.0.0 ', ' r12.1+ WMS rup 8 ' fro M dual) x, (select Product_version PV from Fnd_product_installationswhere application_id=385) i,ad_bugs bugswhere x.bug = b Ugs.bug_number and X.PV = I.PV ORDER BY 1 desc) where rownum = 1unionselect ' Product installation List: ' From dualunions Elect ' 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

Results Demo Sample:

Application environment:ml3ys211, Host:rws60075rems, Application release:12.1.1, DB version:11.1.0.7.0current Applica tion release:12.1.1 (7303030) Current INV rollup:r12.1+ INV RUP 7 Consolidated (17512558) current WMS rollup:r12.1+ WMS R Up 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

How to view the INV RUP version number on an EBS environment