PTBR_NODE_PVW

index back

Node Prompt


SELECT 'ANY' , MESSAGE_TEXT FROM %Table(PSMSGCATDEFN) WHERE MESSAGE_SET_NBR = 219 AND MESSAGE_NBR = 7470 UNION SELECT 'LOCAL_NODE' , MESSAGE_TEXT FROM %Table(PSMSGCATDEFN) WHERE MESSAGE_SET_NBR = 219 AND MESSAGE_NBR = 7471 UNION SELECT A.MSGNODENAME , A.DESCR FROM %Table(PSMSGNODEDEFN) A WHERE (A.NODE_TYPE='PIA') AND (A.ACTIVE_NODE='1') AND (A.LOCALNODE<>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))

  • Related language record: PTBR_NODE_LVW
  • 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