PSMSGVERCONR_VW |
index back |
---|---|
IB Messages and 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 |