PV_NODE_KEYWORD

(SQL View)
 Index Back

Direct Connect Node View


SELECT A.MSGNODENAME ,B.PV_NV_NAME ,B.PV_NV_VALUE 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 B.PV_NV_NAME = 'KEYWORDS'

# 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 PROPNAME Character(30) VARCHAR2(30) NOT NULL Property Name

Prompt Table: PSNODPROPNAMEVW

3 PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value