AV_CMPNT_VW

(SQL View)
 Index Back

AV Components View

Used for BU Security

SELECT A.PNLGRPNAME , B.DESCR , A.MENUNAME , A.BARNAME FROM PSMENUITEM A , PSPNLGRPDEFN B WHERE A.MENUNAME IN ('AV_ENTER_COMMITMENTS', 'AV_MANAGE_MEMBERSHIP') AND A.BARNAME IN ('USE', 'INQUIRE', 'INQUIRE2', 'WORKSET','REPORT','PROCESS') AND A.PNLGRPNAME LIKE 'AV_%' AND A.PNLGRPNAME = B.PNLGRPNAME AND B.DESCR <> ' '

  • Related Language Record: AVCMPNTVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    4 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name