How to check if a patch is applied in Oracle Apps (11i, R12)

This article explains how to check if a patch is applied in Oracle E Business Suite (apps) 11i, R12.1.x and R12.2.x.