SELECT DISTINCT
C.ROLENAME,
A.MENUNAME,
A.BARITEMNAME as Component_Name,
A.PNLITEMNAME as Page_Name,
case when A.DISPLAYONLY = 0 then 'Read/Write' else 'Read Only' end as Display_Mode,
(SELECT D.PAGEACCESSDESCR FROM PSPGEACCESSDESC D WHERE D.AUTHORIZEDACTIONS = A.AUTHORIZEDACTIONS) as Authorized_Actions
FROM PSAUTHITEM A,
PSPNLDEFN B,
PSROLECLASS C
WHERE A.CLASSID = C.CLASSID
AND A.PNLITEMNAME = B.PNLNAME
AND A.PNLITEMNAME <> ' '
AND B.PNLNAME = 'EP_APPRAISAL_EE' --> Replace Page Name Here
No comments:
Post a Comment