AVCMPNTVWLNG

(SQL View)
 Index Back

AV Components View

Used for BU Security

SELECT A.PNLGRPNAME , B.LANGUAGE_CD , B.DESCR FROM PSMENUITEM A , PSPNLGDEFNLANG 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 for AV_CMPNT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description