[Script]EBS里查看模块的版本、文件的版本信息【Z】
系统版本信息装了哪些模块，以及版本信息
[*]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.iyunv.com/pan_tian/article/details/7697736
页:
[1]