DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, January 12, 2016

To find installed products,status and patch level in oracle



set pages 300
set lines 300
column application_name format a50
column application_short_name format a10
column  status format a15
column application_id format a5
column patch_level format a15
SELECT SUBSTR(a.application_name, 1,40) product_name 
, a.application_id 
, SUBSTR(application_short_name, 1,4) short_name, 
DECODE(b.status,'I','INSTALLED', 
DECODE (b.status,'S','SHARED', 
DECODE (b.status,'N','NOTINSTALLED',b.status))) status, patch_level 
FROM fnd_application_vl a, fnd_product_installations b WHERE a.application_id = b.application_id;


No comments: