PTWL_PORTAL_VW

index back

SELECT C.MSGNODENAME ,Z.URI_TEXT ,C.PORTAL_NAME FROM PSMSGNODEDEFN C ,PSPRDMDEFN P ,PS_PTLCLBASEURI_VW Z WHERE C.LOCALDEFAULTFLG ='Y' AND P.PORTAL_NAME = C.PORTAL_NAME

PeopleSoft Field NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
URI_TEXTLong CharacterCLOBURI Text
PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19