Oracle Applications - Query to quickly get the Financials family pack level

The below query will be useful to quickly get the financials family pack level you are in:

SELECT bug_number,decode(bug_number,

'3653484', 'FIN_PF.G',

'3153675', 'FIN_PF.F',

'2842697', 'FIN_PF.E',

'3016445', 'FIN_PF.D1',

'2380068', 'FIN_PF.C',

'2218339', 'FIN_PF.B',

'1807809', 'FIN_PF.A',

'no family packs applied') "Family Pack Level"

FROM ad_bugs

WHERE

bug_number in ('3653484', '3153675', '2842697', '3016445', '2380068', '2218339', '1807809')

ORDER BY 1;