[Script]EBS里查看模块的版本、文件的版本信息

系统版本信息

装了哪些模块，以及版本信息

select \'Current Application Release: \'||ver||\' (\'||bug||\')\' "Description" from (
select x.* from
(select 1 seq, \'1939818\' bug,\'11.5.0\' pv,\'11.5.6\' ver from dual
union select 2,\'2123967\',\'11.5.0\',\'11.5.7\' from dual
union select 3,\'2293243\',\'11.5.0\',\'11.5.8\' from dual
union select 4,\'2669606\',\'11.5.0\',\'11.5.9 MP\' from dual
union select 5,\'3126422\',\'11.5.0\',\'11.5.9 Update1\' from dual
union select 6,\'3171663\',\'11.5.0\',\'11.5.9 Update2\' from dual
union select 7,\'3714435\',\'11.5.0\',\'11.5.9 June Update\' from dual
union select 8,\'3140000\',\'11.5.0\',\'11.5.10\' from dual
union select 9,\'3240000\',\'11.5.0\',\'11.5.10.1\' from dual
union select 10,\'3460000\',\'11.5.0\',\'11.5.10.2\' from dual
union select 11,\'3480000\',\'11.5.0\',\'11.5.10.2\' from dual
union select 12,\'4440000\',\'12.0.0\',\'12.0\' from dual
union select 12,\'94440000\',\'12.0.0\',\'12.0*\' from dual
union select 12,\'5082400\',\'12.0.0\',\'12.0.1\' from dual
union select 12,\'5484000\',\'12.0.0\',\'12.0.2\' from dual
union select 12,\'95484000\',\'12.0.0\',\'12.0.2*\' from dual
union select 12,\'6141000\',\'12.0.0\',\'12.0.3\' from dual
union select 12,\'96141000\',\'12.0.0\',\'12.0.3*\' from dual
union select 12,\'6435000\',\'12.0.0\',\'12.0.4\' from dual
union select 12,\'7282993\',\'12.0.0\',\'12.0.5\' from dual
union select 12,\'6728000\',\'12.0.0\',\'12.0.6\' from dual
union select 12,\'6646600\',\'12.0.0\',\'12.1.0\' from dual
union select 12,\'7303030\',\'12.0.0\',\'12.1.1\' from dual
union select 12,\'97303030\',\'12.0.0\',\'12.1.1*\' from dual) x,
(select product_version pv from fnd_product_installations
where application_id=401) i,
ad_bugs bugs
where x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1
union
select \'Current INV Rollup: \'||ver||\' (\'||bug||\')\' "Description" from (
select x.* from
(select 1 seq, \'1426212\' bug,\'11.5.0\' pv,\'INV.C\' ver from dual
union select 2,\'1551167\',\'11.5.0\',\'MFG.D\' from dual
union select 3, \'1550583\',\'11.5.0\',\'OM.D\' from dual
union select 4,\'1538130\',\'11.5.0\',\'INV.D\' from dual
union select 5, \'1745355\',\'11.5.0\',\'MFG.E\' from dual
union select 6,\'1696652\',\'11.5.0\',\'INV.E\' from dual
union select 7, \'1891480\',\'11.5.0\',\'MFG.F\' from dual
union select 8, \'1942144\',\'11.5.0\',\'OM.F\' from dual
union select 9,\'1886015\',\'11.5.0\',\'INV.F\' from dual
union select 10, \'2133107\',\'11.5.0\',\'MFG.G\' from dual
union select 11, \'2118482\',\'11.5.0\',\'OM.G\' from dual
union select 12,\'2004922\',\'11.5.0\',\'INV.G\' from dual
union select 13, \'2248408\',\'11.5.0\',\'MFG.H\' from dual
union select 14,\'2250333\',\'11.5.0\',\'OM.H\' from dual
union select 15,\'2248490\',\'11.5.0\',\'INV.H\' from dual
union select 16, \'2697753\',\'11.5.0\',\'MFG.I\' from dual
union select 17,\'2698175\',\'11.5.0\',\'OM.I\' from dual
union select 18,\'2371213\',\'11.5.0\',\'INV.I\' from dual
union select 19,\'3384350\',\'11.5.0\',\'INV.J\' from dual
union select 20,\'4042499\',\'11.5.0\',\'INV.J RUP1\' from dual
union select 21,\'4231215\',\'11.5.0\',\'INV.J RUP2\' from dual
union select 22,\'4734840\',\'11.5.0\',\'INV.J RUP3\' from dual
union select 23,\'5739724\',\'11.5.0\',\'INV.J RUP4\' from dual
union select 24,\'6449139\',\'11.5.0\',\'INV.J RUP5\' from dual
union select 25,\'6461517\',\'11.5.0\',\'INV.J RUP6\' from dual
union select 26,\'6461519\',\'11.5.0\',\'INV.J RUP7\' from dual
union select 27,\'6461522\',\'11.5.0\',\'INV.J RUP8\' from dual
union select 28,\'6870030\',\'11.5.0\',\'INV.J RUP9\' from dual
union select 29,\'7258620\',\'11.5.0\',\'INV.J RUP10\' from dual
union select 30,\'7258624\',\'11.5.0\',\'INV.J RUP11\' from dual
union select 31,\'7258629\',\'11.5.0\',\'INV.J RUP12\' from dual
union select 32,\'7581431\',\'11.5.0\',\'INV.J RUP13\' from dual
union select 33,\'7666112\',\'11.5.0\',\'INV.J RUP14\' from dual
union select 34,\'8403245\',\'11.5.0\',\'INV.J RUP15\' from dual
union select 35,\'8403254\',\'11.5.0\',\'INV.J RUP16\' from dual
union select 36,\'8403258\',\'11.5.0\',\'INV.J RUP17\' from dual
union select 37,\'9063156\',\'11.5.0\',\'INV.J RUP18\' from dual
union select 38,\'8478486\',\'12.0.0\',\'R12 INV/RCV RUP7\' from dual
union select 39,\'7587155\',\'12.1.1\',\'R12.1.1 OPM-INV Consolidated\' from dual
) x,
(select product_version pv from fnd_product_installations
where application_id = 401) i,
ad_bugs bugs
where x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1
UNION
select \'Current WMS Rollup: \'||ver||\' (\'||bug||\')\' "Description" from (
select x.* from
(select 1 seq, \'4734840\' bug, \'11.5.0\' pv,\'RUP3\' ver from dual
union select 2 seq, \'5855276\' bug,\'11.5.0\' pv,\'WMS RUP4\' ver from dual
union select 3 seq, \'6957082\' bug,\'11.5.0\' pv,\'WMS RUP5\' ver from dual
union select 4 seq, \'7041845\' bug,\'11.5.0\' pv,\'WMS RUP6\' ver from dual
union select 5 seq, \'7219660\' bug,\'11.5.0\' pv,\'WMS RUP7\' ver from dual
union select 6 seq, \'7317230\' bug,\'11.5.0\' pv,\'WMS RUP8\' ver from dual
union select 7 seq, \'7453739\' bug,\'11.5.0\' pv,\'WMS RUP9\' ver from dual
union select 8 seq, \'7591071\' bug,\'11.5.0\' pv,\'WMS RUP10\' ver from dual
union select 9 seq, \'7644924\' bug,\'11.5.0\' pv,\'WMS RUP11\' ver from dual
union select 10 seq,\'7688739\' bug,\'11.5.0\' pv,\'WMS RUP12\' ver from dual
union select 11 seq,\'8337529\' bug,\'11.5.0\' pv,\'WMS RUP13\' ver from dual
union select 12 seq,\'8524873\' bug,\'11.5.0\' pv,\'WMS RUP14\' ver from dual
union select 13 seq,\'8785944\' bug,\'11.5.0\' pv,\'WMS RUP15\' ver from dual
) x,
(select product_version pv from fnd_product_installations
where application_id=385) i,
ad_bugs bugs
where x.bug = bugs.bug_number and x.pv = i.pv order by 1 desc) where rownum = 1
union
select \'Product Installation List : \' from dual
union
select \'Product Installation: \'||patch_level||\': \'||decode(status,
\'I\',\'Installed\',\'S\',\'Shared\',\'Not Installed\')
from fnd_product_installations
where application_id IN (401, 385, 201, 431, 702, 703)
order by 1;

R12 Sample Output:

R12.INV.B.3 = R12.1.3

11i Sample Output:

11i.INV.J = 11.5.10

其他查看版本信息的脚本

查看安装的产品版本
SELECT patch_level FROM fnd_product_installations WHERE patch_level LIKE \'%INV%\';
Output:R12.INV.B.3

查询relase版本
 select release_name from fnd_product_groups;
Output:12.1.3

另外一个脚本

SELECT a.application_name,a.product_code,
DECODE (b.status, \'I\', \'Installed\', \'S\', \'Shared\', \'N/A\') status,
patch_level
FROM apps.fnd_application_vl a, apps.fnd_product_installations b
WHERE a.application_id = b.application_id and b.status=\'I\' 
order by product_code asc;

文件的版本

查看数据库Package的版本信息

SELECT text FROM all_source
WHERE name LIKE \'INV_QUANTITY_TREE_PVT%\'
AND text LIKE \'%$Header%\'; 

Output:

/* $Header: INVVQTTS.pls 120.1.12010000.4 2010/02/16 11:00:52 oradev ship $*/

/* $Header: INVVQTTB.pls 120.27.12010000.27 2010/10/21 05:37:05 oradev ship $*/

Linux/Unix下查看form,plx...文件的版本信息

ident INVTTMTX.fmx

或者

strings -a INVTTMTX.fmx | grep Header

转载请注明出处：http://blog.csdn.net/pan_tian/article/details/7697736

======EOF======

转载于:http://blog.itpub.net/26687597/viewspace-1203802/