PAGE_NAMELANGUAGE_CDCNT_TAB_LG_VW(SQL View) |
Index Back |
|---|---|
Contract Left Panel ViewPO0025 - Master Contract Fluid |
| SELECT C.PNLNAME , L.LANGUAGE_CD , L.ITEMLABEL , L.ITEMLABEL FROM PSPNLGROUP C , PSPNLDEFN P , PSPNLGROUPLANG L WHERE C.PNLGRPNAME = 'CNT_GRPCNT_FL' AND C.PNLNAME = P.PNLNAME AND P.PNLTYPE = 0 AND C.HIDDEN = 0 AND C.PNLGRPNAME=L.PNLGRPNAME AND C.PNLNAME=L.PNLNAME AND C.MARKET=L.MARKET |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAGE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Page Name |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |