To find the current on-site code level of entities?

SELECT app_short_name, MAX(patch_level) FROM apps.ad_patch_driver_minipks
GROUP BY app_short_name ;

APP_SHORT_NAME,   MAX(PATCH_LEVEL)

MSR,R12.MSR.B.1
CRP,R12.CRP.B.1
BSC,R12.BSC.B.1
WMS,R12.WMS.B.1
QPR,R12.QPR.C.1
PON,R12.PON.B.1
FLM,R12.FLM.B.1
PMI,R12.PMI.B.1
CZ,R12.CZ.B.1
FND,R12.FND.B.1
SQLGL,R12.GL.B.1
AMW,R12.AMW.B.1
QOT,R12.QOT.B.1
AST,R12.AST.B.1
ASP,R12.ASP.B.1
AME,R12.AME.B.1
BIS,R12.BIS.B.1
LNS,R12.LNS.B.1
DPP,R12.DPP.B.1
XNB,R12.XNB.B.1
JL,R12.JL.B.1
CSL,R12.CSL.B.1
RLM,R12.RLM.B.1
QP,R12.QP.B.1
AD,R12.AD.B.1
MST,R12.MST.B
IGI,R12.IGI.B.1
IEB,R12.IEB.B.1
BIL,R12.BIL.B.1
RG,R12.RG.B.1
IBY,R12.IBY.B.1
IZU,R12.IZU.B.1
ZPB,R12.ZPB.B.1
PSB,R12.PSB.B.1
QA,R12.QA.B.1
IEO,R12.IEO.B.1
MSO,R12.MSO.B.1
MWA,R12.MWA.B.1
XLE,R12.XLE.B.1
XLA,R12.XLA.B.1
CCT,R12.CCT.B.1
INV,R12.INV.B.1
ENI,R12.ENI.B.1
ENG,R12.ENG.C.1
CSD,R12.CSD.B.1
PQH,R12.PQH.B.1
AR,R12.AR.B.1
IEX,R12.IEX.B.1
JG,R12.JG.B.1
OFA,R12.FA.B.1
AHL,R12.AHL.B.1
IBC,R12.IBC.B.1
CSC,R12.CSC.B.1
DOM,R12.DOM.B.1
BNE,R12.BNE.B.1
GR,R12.GR.B.1
WPS,R12.WPS.B.1
AMS,R12.AMS.B.1
PFT,R12.PFT.B.1
PO,R12.PO.B.1
OKI,R12.OKI.B.1
ITA,R12.ITA.B.1
PER,R12.PER.B.1
FRM,R12.FRM.B.1
CS,R12.CS.B.1
BIV,R12.BIV.B.1
BEN,R12.BEN.B.1
FEM,R12.FEM.B.1
BOM,R12.BOM.C.1
DT,R12.DT.B.1
GMA,R12.GMA.B.1
IRC,R12.IRC.B.1
IEU,R12.IEU.B.1
IEM,R12.IEM.B.1
ASL,R12.ASL.B.1
ASF,R12.ASF.B.1
OZF,R12.OZF.B.1
OTA,R12.OTA.B.1
GMP,R12.GMP.B.1
INL,R12.INL.B.1
OKE,R12.OKE.B.1
GMD,R12.GMD.B.1
CSF,R12.CSF.B.1
POM,R12.POM.B.1
PSA,R12.PSA.B.1
ECX,R12.ECX.B.1
AMV,R12.AMV.B.1
ASO,R12.ASO.B.1
ISC,R12.ISC.B.1
XTR,R12.XTR.B.1
PJM,R12.PJM.B.1
FII,R12.FII.B.1
HRI,R12.HRI.B.1
CSM,R12.CSM.B.1
CSE,R12.CSE.B.1
FPA,R12.FPA.B.1
CN,R12.CN.B.1
IA,R12.IA.B.1
EGO,R12.EGO.C.1
BIM,R12.BIM.B.1
FUN,R12.FUN.B.1
DDD,R12.DDD.C.1
FV,R12.FV.B.1
DNA,R12.DNA.C.1
FF,R12.FF.B.1
GCS,R12.GCS.B.1
WIP,R12.WIP.B.1
SSP,R12.SSP.B.1
MTH,R12.MTH.B.1
CUG,R12.CUG.B.1
FTP,R12.FTP.B.1
JTM,R12.JTM.B.1
CE,R12.CE.B.1
OE,R12.OE.B.1
XDP,R12.XDP.B.1
PN,R12.PN.B.1
GMS,R12.GMS.B.1
ALR,R12.ALR.B.1
GMO,R12.GMO.B.1
MRP,R12.MRP.B.1
PAY,R12.PAY.B.1
ICX,R12.ICX.B.1
SHT,R12.SHT.B.1
CLN,R12.CLN.C.1
MSC,R12.MSC.B.1
BIC,R12.BIC.B.1
ZX,R12.ZX.B.1
EDR,R12.EDR.B.1
CSR,R12.CSR.B.1
CSP,R12.CSP.B.1
GML,R12.GML.B.1
MFG,R12.MFG.B.1
ITG,R12.ITG.B.1
GHR,R12.GHR.B.1
EAM,R12.EAM.B.1
MSD,R12.MSD.B.1
BIX,R12.BIX.B.1
PJI,R12.PJI.B.1
VEA,R12.VEA.B.1
PV,R12.PV.B.1
IBW,R12.IBW.B.1
IBU,R12.IBU.B.1
OKX,R12.OKX.B.1
OKL,R12.OKL.B.1
QRM,R12.QRM.B.1
IBE,R12.IBE.B.1
GMI,R12.GMI.B.1
GME,R12.GME.B.1
RRS,R12.RRS.B.1
JTF,R12.JTF.B.1
EC,R12.EC.B.1
IES,R12.IES.B.1
ONT,R12.ONT.B.1
ASN,R12.ASN.B.1
OPI,R12.OPI.B.1
IMC,R12.IMC.B.1
DDR,R12.DDR.B.1
PRP,R12.PRP.B.1
PA,R12.PA.B.1
WSM,R12.WSM.B.1
GMF,R12.GMF.B.1
OKC,R12.OKC.B.1
AZ,R12.AZ.B.1
SQLAP,R12.AP.B.1
IGW,R12.IGW.B.1
ASG,R12.ASG.B.1
HXT,R12.HXT.B.1
JMF,R12.JMF.B.1
JE,R12.JE.B.1
JA,R12.JA.B.1
WSH,R12.WSH.B.1
CSI,R12.CSI.B.1