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 Name Field Type Column Type Description
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
URI_TEXT Long Character CLOB URI Text
PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19