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 NameField TypeColumn TypeDescription
IB_WSDLNAMECharacter(70)VARCHAR2(70) NOT NULLWSDL Name (see PSIBWSDLDFN).
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_WSDLVERSIONNumber(5,0)INTEGER NOT NULLSequence Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19