how to check existing patches with a query
Hi,
I need to check the existing patches in oracle appls 11i with a sql query.
I assume I can reference the table ad_applied_patches . But, I am not sure if the column PATCH_NAME is actually the number : 5903765 in ATG Rollup Patchset 6 (11i.ATG_PF.H.delta.6, Patch 5903765) . if not, how can i check that.
Also, I couldn't find the proper TRM. so any help with that too would be appreciated.
Thank you..