AM_PNL_AUTH4_VW

(SQL View)
Index Back

AuthVW used by Parent Asset

GoTo>> AuthVW used by Inquire Parent Assets 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_PC1)

  • 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