How to verify the current level for the product family patches/patchsets installed on the system?

How to verify the current level for the product family patches/patchsets installed on the system?

 Current level for the product family patches/patchsets installed on the system can be
 verified by querying table : AD_TRACKABLE_ENTITIES

  It has Columns:
  ABBREVIATION VARCHAR2 - Product Abbreviation
  NAME VARCHAR2 - Holds the name of the trackable entity
  TYPE VARCHAR2 - Holds the type of the trackable entity
  CODELEVEL VARCHAR2 - Holds the codelevel of the trackable entity ---> baseline.delta      version  BASELINE VARCHAR2 - Holds the baseline of the trackable entity


  An example query:
  SQL>  SELECT ABBREVIATION,

             NAME,

             TYPE,

             CODELEVEL,

             BASELINE

       FROM AD_TRACKABLE_ENTITIES

       WHERE ABBREVIATION IN ('ad',

                          'txk',

                          'fnd',

                          'fwk',

                          'atg_pf',

                          'icx')

      ORDER BY ABBREVIATION;

   

       Doc ID 2234900.1