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;
  • January 12, 2016 | 24 views
  • Comments