MSGNAMEAPMSGVERPSIBMSGCONT_VW(SQL View) |
Index Back |
|---|---|
IB Container Messages.Displays only container messages that reference structured (rowset-based) parts. |
| SELECT DISTINCT V.MSGNAME , V.APMSGVER FROM PSMSGVER V , PSMSGPARTS P , PSMSGREC R WHERE V.MSGNAME = P.MSGNAME AND V.APMSGVER = P.APMSGVER AND P.IB_MSGNAME = R.MSGNAME AND P.IB_MSGVERSION = R.APMSGVER AND V.IB_PARTS = 0 AND IB_MESSAGEUSE = 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MSGNAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN). |
| 2 | APMSGVER |
Character(30) | VARCHAR2(30) NOT NULL | Message Version |