AM_PNL_AUTHLNVW

(SQL View)
 Index Back

Auth view used by Asset Search

Barname included in join.

SELECT DISTINCT B.OPRID , A.BARITEMNAME , M.LANGUAGE_CD , M.ITEMLABEL FROM PSAUTHITEM A , PSOPRCLS B , PSMENUITEMLANG 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

  • Related Language Record for AM_PNL_AUTH2_VW AM_PNL_AUTH3_VW AM_PNL_AUTH4_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 GOTOMENUNAME Character(30) VARCHAR2(30) NOT NULL Go to Menu Name