MSGNODENAMEPROPNAMELANGUAGE_CDPV_NODES_LANG(SQL View) |
Index Back |
|---|---|
Direct Connect Node View |
| SELECT A.MSGNODENAME , B.PV_NV_NAME , D.LANGUAGE_CD , D.DESCR , D.DESCRLONG FROM PSMSGNODEDEFN A , PS_PV_MS_SUPP_NV B , PS_PV_MS_SUPPLIER C ,PSNODEDEFNLANG D 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' AND A.MSGNODENAME=D.MSGNODENAME |
| # | 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 |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRLONG | Long Character | CLOB | Long Description |