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