PTPP_CREF_LVW |
index back |
---|---|
Content Reference Prompt Lng |
SELECT A.PORTAL_NAME , A.PORTAL_OBJNAME , B.LANGUAGE_CD , B.PORTAL_LABEL , C.PORTAL_LABEL FROM PSPRSMDEFN A , PSPRSMDEFNLANG B , PSPRSMDEFNLANG C WHERE A.PORTAL_NAME = B.PORTAL_NAME AND A.PORTAL_NAME = C.PORTAL_NAME AND A.PORTAL_REFTYPE = B.PORTAL_REFTYPE AND A.PORTAL_OBJNAME = B.PORTAL_OBJNAME AND B.LANGUAGE_CD = C.LANGUAGE_CD AND A.PORTAL_REFTYPE = 'C' AND C.PORTAL_REFTYPE = 'F' AND A.PORTAL_CREF_URLT NOT IN('UMPG','UPTM','UPHP') AND A.PORTAL_CREF_USGT = 'TARG' AND A.PORTAL_PRNTOBJNAME NOT IN ('PORTAL_USERS' ,'PORTAL_TEMPLATES', 'PORTAL_TEMPLATE_PAGELETS') AND A.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAME |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
PORTAL_NAME | Character(30) | VARCHAR2(30) NOT NULL | Portal Name (see PSPRDMDEFN). |
PORTAL_OBJNAME | Character(30) | VARCHAR2(30) NOT NULL | Content Reference Name |
LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code translate values |
PTPP_CREF_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Content Reference Label |
PTPP_FLDR_LABEL | Character(30) | VARCHAR2(30) NOT NULL | Parent Label |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |