Monday, June 20, 2011

How To Check Patch Level Status

select
a.application_name,
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

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect