PSMSGVERCONR_VW

index back

IB Messages and Versions

Shows concatenated messages and corresponding versions.
SELECT %TrimSubstr(A.MSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(A.APMSGVER,1,30) FROM PSMSGVER A WHERE A.IB_PACKAGEID <> ' ' AND NOT EXISTS( SELECT 'X' FROM PSLSDEPCHLDDFN B WHERE B.IB_PACKAGEID = A.IB_PACKAGEID AND (B.IB_SCHEMANAME = A.IB_SCHEMANAME) AND (B.IB_VARIANTNAME = A.IB_VARIANTNAME)) AND EXISTS( SELECT 'X' FROM PSLSDEFN C WHERE C.IB_PACKAGEID = A.IB_PACKAGEID AND (C.IB_SCHEMANAME = A.IB_SCHEMANAME) AND (C.IB_VARIANTNAME = A.IB_VARIANTNAME))

PeopleSoft Field Name Field Type Column Type Description
IB_XFRMMESSAGE2 Character(61) VARCHAR2(61) NOT NULL Message.Ver out of Transforms
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20