AM_PNL_AUTH2_VW

(SQL View)
 Index Back

Auth view used by Asset Search

Barname included in join.

SELECT DISTINCT B.OPRID , A.BARITEMNAME , M.ITEMLABEL FROM PSAUTHITEM A , PSOPRCLS B , PSMENUITEM M WHERE B.OPRCLASS = A.CLASSID AND A.MENUNAME='MANAGE_ASSETS' AND A.MENUNAME = M.MENUNAME AND A.BARITEMNAME = M.ITEMNAME AND A.BARNAME = M.BARNAME AND A.BARITEMNAME %Sql(AM_BARITEMNAMES)

  • Related Language Record: AM_PNL_AUTHLNVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    3 GOTOMENUNAME Character(30) VARCHAR2(30) NOT NULL Go to Menu Name