PV_NODES

(SQL View)
 Index Back

Direct Connect Node View


SELECT B.SETID , A.MSGNODENAME , A.VERSION , B.PV_NV_NAME , B.PV_NV_VALUE , A.IMAGE_NAME , A.DESCR , A.DESCRLONG FROM PSMSGNODEDEFN A , PS_PV_MS_SUPP_NV B , PS_PV_MS_SUPPLIER C WHERE A.MSGNODENAME=C.PV_DC_NODE AND B.SETID=C.SETID AND B.PV_MS_SUP_TYPE=C.PV_MS_SUP_TYPE AND B.VENDOR_ID=C.VENDOR_ID AND B.VNDR_LOC=C.VNDR_LOC AND A.ACTIVE_NODE='1'

  • Related Language Record: PV_NODES_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CATEGORY_SETID Character(5) VARCHAR2(5) NOT NULL Category SetID
    2 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 PROPNAME Character(30) VARCHAR2(30) NOT NULL Property Name

    Prompt Table: PSNODPROPNAMEVW

    5 PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value
    6 IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRLONG Long Character CLOB Long Description