Total Pageviews

Sunday, March 10, 2013


Find Applied Patch Set Information Query


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