Application Modules info ( short name and id ) and identifying Patch Level apps

Use the following query to retrieve this information on your specific instance.

SELECT FND.APPLICATION_ID, APPLICATION_SHORT_NAME, PRODUCT_CODE, APPLICATION_NAME
FROM FND_APPLICATION FND , FND_APPLICATION_TL FNDTL WHERE FND.APPLICATION_ID=FNDTL.APPLICATION_ID


How to find an AD patchset level in Oracle Applications


SQL> select PATCH_LEVEL from fnd_product_installations where APPLICATION_ID=50;

select APP_SHORT_NAME, PATCH_LEVEL from apps.AD_PATCH_DRIVER_MINIPKS where APP_SHORT_NAME like '%PF%';