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 |
# | 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 |