PTBR_NODE_PVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description