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 NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19