select a.oprid as OPRID, a.oprdefndesc as NAME, b.rolename as ROLENAME, c.descr254 as NAVIGATION, c.descr150_mixed as DESCRIPTION
from psoprdefn a, psroleuser b, psroleclass d, psauthitem e, ps_authitem_cmp c
where a.oprid = b.roleuser
and b.rolename = d.rolename
and d.classid = e.classid
and e.menuname = c.menuname
and e.barname = c.barname
and e.baritemname = c.baritemname
and e.pnlitemname = c.pnlitemname
and a.oprclass like 'PP_UK%'
and a.acctlock = 0
order by a.oprid, b.rolename;
