Oracle 11g and 12c RDBMS: How to check what are the PSU and CPU patches applied on the database

We can find the list of patches applied to RDBMS_ORACLE_HOME by the command opatch lsinventory or opatch lsinventory -detail. There is one another way to find the Patch Set Update (PSU) or Critical Patch Update (CPU) by querying against the database table.

Table Name: SYS.REGISTRY$HISTORY (10g, 11g) and SYS.REGISTRY$SQLPATCH (12c R1 and later)
CPU:

select comments, version, bundle_series from sys.registry$history where bundle_series = 'PSU' order by action_time;

PSU:

select action_time, action, id, comments from sys.registry$history where action = 'CPU' order by action_time;

Other Queries:

select to_char(action_time, 'dd-mon-yyyy hh24:mi:ss') as action_time, action, namespace, version, id, comments,bundle_series from   sys.registry$history order by action_time; 

12c R1  and later Query:

select patch_id,action,status,action_time,description from registry$sqlpatch;

Reference:
Do Patchset Updates (PSU's) Change the Oracle Release Version/Fifth Digit? (Doc ID 861152.1)
The COMMENTS Column Of dba_registry_history And registry$history Tables Shows The Value 11.2.0.2.0 Instead Of 11.2.0.3.0 or 11.2.0.4 (Doc ID 1439486.1)
What information Oracle Support needs to work on Critical Patch Update (CPU) Installation Service Requests (Doc ID 735257.1)