PTWL_PORTAL_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

2 URI_TEXT Long Character CLOB URI Text

3 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2	URI_TEXT	Long Character	CLOB	URI Text
3	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).