PSPTMSGNODE_VW

 index back

SELECT A.MSGNODENAME , A.LOCALDEFAULTFLG , A.DESCR FROM PSMSGNODEDEFN A WHERE ( ( A.LOCALDEFAULTFLG = 'Y') OR ( A.IB_NETWORK = 1 AND A.MSGNODENAME = ( SELECT B.MSGNODENAME FROM PSIBHUBDATA B WHERE B.MSGNODENAME = A.MSGNODENAME)))

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).
LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node

Y/N Table Edit

Default: N

DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20