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 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 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20