PTUN_MSGNODE_VW

index back

SELECT A.MSGNODENAME , A.DESCR FROM %Table(PSMSGNODEDEFN) A WHERE (A.NODE_TYPE='PIA') AND (A.ACTIVE_NODE='1') AND EXISTS ( SELECT 1 FROM %Table(PSNODEURITEXT) B WHERE (A.MSGNODENAME = B.MSGNODENAME) AND (B.URI_TYPE = 'PL') AND (B.URI_TEXT IS NOT NULL))

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).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19