PTPP_CPPRTL_LVW |
index back |
---|---|
Portal Name view |
SELECT DISTINCT A.PROJECTNAME , A.OBJECTVALUE1 , C.LANGUAGE_CD , C.DESCR254 FROM PSPROJECTITEM A , PSPRDMDEFN B , PSPRDMDEFNLANG C WHERE A.OBJECTVALUE1 = B.PORTAL_NAME AND B.PORTAL_NAME = C.PORTAL_NAME AND A.OBJECTTYPE = 55 |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code translate values |
DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |