EBS : Patchset level query

select fpi.patch_level,
fa.application_short_name,
fa.application_id
from fnd_product_installations fpi,
fnd_application fa
where fa.application_short_name = '&PATCHSET_SHORT_NAME'
and fa.application_id = fpi.application_id;

Note: Provide the patchset_short_name as input