PTLT_MNUITM_VW2

(SQL View)
 Index Back

Menu Item View 1

View on PSMENUITEM, a Tools Table

SELECT DISTINCT A.MENUNAME , B.DESCR , %Sql(PTLT_TASK_CODE,A.PNLGRPNAME, A.MARKET) FROM PSMENUITEM A , PSMENUDEFN B WHERE A.MENUNAME = B.MENUNAME

  • Related Language Record: PTLT_MNUITMLVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 PTLT_TASK_CODE2 Character(30) VARCHAR2(30) NOT NULL Task Code