PSIBMSGCONT_VW

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 NameField TypeColumn TypeDescription
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
APMSGVERCharacter(30)VARCHAR2(30) NOT NULLMessage Version
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19