-- need to have it check subpanels
-- Joins to primary index to get a sense of relevance
select a.pnlgrpname, count(*)
from pspnlgroup a, pspnlfield b, psrecdefn c, all_ind_columns d
where 
    a.pnlname = b.pnlname and
    b.recname = c.recname and
    a.pnlgrpname <> ' '  and
    b.recname = upper('&&1') and
    d.index_owner = 'SYSADM' and
    d.index_name = 'PS_' || b.recname and
    d.column_name = b.fieldname
group by a.pnlgrpname
order by 2 desc,1
/
undef 1