PSMENUCOMPLG_VW

(SQL View)
Index Back

Language rec for PSMENUCOMP_VW


SELECT A.MENUNAME , C.PNLGRPNAME , A.LANGUAGE_CD , B.DESCR FROM PSMENUITEMLANG A , PSPNLGRPDEFN B , PSMENUITEM C WHERE A.MENUNAME = C.MENUNAME AND A.BARNAME = C.BARNAME AND A.ITEMNAME = C.ITEMNAME AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET

  • Related Language Record for PSMENUCOMP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description