select
fav.application_name app_name
, fav.application_short_name app_s_name
, decode(fpi.status, 'I', 'Yes',
'S', 'Shared',
'N', 'No', fpi.status) inst_status
, nvl(fpi.patch_level, 'Not Available') patchset
, fav.application_id app_id
from apps.fnd_application_vl fav, apps.fnd_product_installations fpi
where fav.application_id = fpi.application_id
--and fav.application_name like '%Secu%Enterprise%'
and fav.application_short_name = 'PER'
order by 3;
No comments:
Post a Comment