Below script to know the patch level or code level of oracle apps.
Script:
SELECT app_short_name, MAX(patch_level)
FROM apps.ad_patch_driver_minipks
GROUP BY app_short_name ;
Output:
APP_SHORT_NAME MAX(PATCH_LEVEL)
----------------------------------------------------------------------
ITA R12.ITA.B.3
ISC R12.ISC.B.3