Component Permission List Query

SELECT  menu.menuname, compdfn.pnlgrpname, auth.classid permission_list,
         CLASS.classdefndesc permission_desc
   FROMpsauthitem auth,
         psmenudefn menu,
         psmenuitem menuitm,
         pspnlgroup comp,
         pspnlgrpdefn compdfn,
         psclassdefn CLASS
   WHEREmenu.menuname = menuitm.menuname
     ANDmenuitm.pnlgrpname = comp.pnlgrpname
     ANDcompdfn.pnlgrpname = comp.pnlgrpname
     ANDcompdfn.pnlgrpnameLIKEUPPER(:component_name)
     ANDauth.menuname = menu.menuname
     ANDauth.barname = menuitm.barname
     ANDauth.baritemname = menuitm.itemname
     ANDauth.pnlitemname = comp.itemname
     ANDauth.classid = CLASS.classid
GROUP BYmenu.menuname, compdfn.pnlgrpname, auth.classid, CLASS.classdefndesc
ORDER BYmenu.menuname, compdfn.pnlgrpname, permission_list;