PTLT_TASK_CODEMENUNAMEPTLT_MNUITM_VW(SQL View) |
Index Back |
|---|---|
Menu Item View 1View on PSMENUITEM, a Tools Table |
| SELECT DISTINCT %Sql(PTLT_TASK_CODE,A.PNLGRPNAME, A.MARKET) , A.MENUNAME , B.DESCR FROM PSMENUITEM A , PSMENUDEFN B WHERE A.MENUNAME = B.MENUNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTLT_TASK_CODE |
Character(30) | VARCHAR2(30) NOT NULL | Task Code |
| 2 | MENUNAME |
Character(30) | VARCHAR2(30) NOT NULL | Menu Name (see PSMENUDEFN). |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |