Finding the Patch Level In Oracle apps

Use the Below queries for finding the Oracle Apps patch Levels for a particular Application



SELECT patch_level FROM fnd_product_installations WHERE application_id = 200;

SELECT a.application_name,
  DECODE (b.status, 'I', 'Installed', 'S', 'Shared', 'N/A') status,
  patch_level ,
  a.application_id
FROM apps.fnd_application_vl a,
  apps.fnd_product_installations b
WHERE a.application_id = b.application_id;


SELECT patch_name,
  patch_type,
  maint_pack_level,
  creation_date
FROM applsys.ad_applied_patches
ORDER BY creation_date DESC;

SELECT fa.APPLICATION_SHORT_NAME,
  fpi.PATCH_LEVEL,
  DECODE(fpi.STATUS, 'I','Installed', 'S','Shared', 'N', 'Inactive', fpi.STATUS) Status ,
  fpi.DB_STATUS
FROM fnd_product_installations fpi,
  FND_APPLICATION fa
WHERE fpi.APPLICATION_ID IN
  (SELECT APPLICATION_ID
  FROM FND_APPLICATION
  WHERE APPLICATION_SHORT_NAME IN ('CSK','IBU','BIS','SQLAP')
  )
AND fa.APPLICATION_ID=fpi.APPLICATION_ID;