PSNODEINFO_VW

index back

SELECT A.MSGNODENAME , A.NODE_TYPE , A.LOCALDEFAULTFLG , B.URI_TEXT FROM %Table(PSMSGNODEDEFN) A ,%Table(PSNODEURITEXT) B WHERE A.MSGNODENAME=B.MSGNODENAME AND B.URI_TYPE = 'CN'

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).
NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node
URI_TEXT Long Character CLOB URI Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19