PSIBWSDLMAX_VW

index back

WSDL Repository

View to hide the multiple rows. Show only WSDL names and related service.
SELECT A.IB_WSDLNAME , A.IB_SERVICENAME , A.IB_WSDLVERSION FROM PSIBWSDLDFN A WHERE A.IB_WSDLVERSION = ( SELECT MAX(X.IB_WSDLVERSION) FROM PSIBWSDLDFN X WHERE X.IB_SERVICENAME = A.IB_SERVICENAME)

PeopleSoft Field Name Field Type Column Type Description
IB_WSDLNAME Character(70) VARCHAR2(70) NOT NULL WSDL Name (see PSIBWSDLDFN).
IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
IB_WSDLVERSION Number(5,0) INTEGER NOT NULL Sequence Number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19