PORTAL_OBJNAMELANGUAGE_CDAGC_HPG_LW(SQL View) |
Index Back |
|---|---|
AGC Homepage Rel Lang ViewActivity Guide Composer Homepage Related Language View |
| SELECT PRT.PORTAL_OBJNAME , PRTL.LANGUAGE_CD , PRTL.PORTAL_LABEL FROM PSPRSMDEFN PRT , PSPRSMDEFNLANG PRTL WHERE PRT.PORTAL_NAME = PRTL.PORTAL_NAME AND PRT.PORTAL_REFTYPE = PRTL.PORTAL_REFTYPE AND PRT.PORTAL_OBJNAME = PRTL.PORTAL_OBJNAME AND PRT.PORTAL_CREF_USGT = 'GRPT' AND PRT.OBJECTOWNERID <> 'PPT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PORTAL_OBJNAME |
Character(30) | VARCHAR2(30) NOT NULL | Portal Object Name |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | PORTAL_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Portal Label |