SQL script to find out the product family packs

SELECT Bug_Number,
DECODE (bug_number, '3480000','R11.5.10.2',
'3460000','R11.5.10.2',
'3640000','R11.5.10.1',
'3240000','R11.5.10.1',
'3140000','R11.5.10',
'2669606','R11.5.9',
'3653484','Fin_PF.G',
'3153675','Fin_PF.F',
'2842697','Fin_PF.E',
'3016445','Fin_PF.D1',
'2629235','Fin_PF.D',
'2380068','Fin_PF.C',
'4551936','AP.O',
'3617668','AP.N',
'3151444','AP.M',
'2864907','AP.L',
'2488725','AP.K',
'2375849','AP.J',
'4873179','AME.B.1',
'4428060','AME.B',
'3962268','AME.A',
'4165000','OIE.K',
'4587858','OIE.J.3',
'4341684','OIE.J.2',
'4155556','OIE.J.1',
'3618125','OIE.J',
'4058603','OIE.I.2',
'3918066','OIE.I.1',
'3376648','OIE.I',
'2800610','OIE.H',
'3928255','OIE.G.5',
'3167972','OIE.G.4',
'3082454','OIE.G.3',
'2930999','OIE.G.2',
'2897962','OIE.G.1',
'2624855','OIE.G',
'2925592','OIE.F.3',
'2763982','OIE.F.2',
'2681459','OIE.F.1',
'2530274','OIE.F',
'2708455','OIE.E.1',
'1960506','OIE.E') Patch_level
FROM AD_Bugs
WHERE Bug_Number IN
( '3480000'/*REL 11.5.10.2 (Patchset)*/,
'3460000'/*REL 11.5.10.2 (Standalone)*/,
'3640000'/*REL 11.5.10.1 (Obsoleted)*/,
'3240000'/*REL 11.5.10.1*/, '3140000'/*REL 11.5.10*/,
'2669606'/*REL 11.5.9*/,
'3653484'/*Fin_PF.G*/,
'3153675'/*Fin_PF.F*/,
'2842697'/*Fin_PF.E*/,
'3016445'/*Fin_PF.D1*/,
'2629235'/*Fin_PF.D*/,
'2380068'/*Fin_PF.C*/,
'4551936'/*AP.O*/,
'3617668'/*AP.N*/,
'3151444'/*AP.M*/,
'2864907'/*AP.L*/,
'2488725'/*AP.K*/,
'2375849'/*AP.J*/,
'4873179'/*AME.B.1*/ ,
'4428060'/*AME.B*/ ,
'3962268'/*AME.A*/,
'4165000'/*OIE.K*/,
'4587858'/*OIE.J.3*/,
'4341684'/*OIE.J.2*/,
'4155556'/*OIE.J.1*/,
'3618125'/*OIE.J*/,
'4058603'/*OIE.I.2*/,
'3918066'/*OIE.I.1*/,
'3376648'/*OIE.I*/,
'2800610'/*OIE.H*/,
'3928255'/*OIE.G.5*/,
'3167972'/*OIE.G.4*/,
'3082454'/*OIE.G.3*/,
'2930999'/*OIE.G.2*/,
'2897962'/*OIE.G.1*/,
'2624855'/*OIE.G*/,
'2925592'/*OIE.F.3*/,
'2763982'/*OIE.F.2*/,
'2681459'/*OIE.F.1*/,
'2530274'/*OIE.F*/,
'2708455'/*OIE.E.1*/,
'1960506'/*OIE.E*/)
ORDER BY 2 DESC;