PSIBWSDLLAT_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 , B.IB_TGTLOCATION FROM PSIBWSDLDFN A , PSIBSVCSETUP B WHERE B.SEQNO = 1 AND A.IB_WSDLVERSION = ( SELECT MAX(X.IB_WSDLVERSION) FROM PSIBWSDLDFN X WHERE X.IB_SERVICENAME = A.IB_SERVICENAME) AND A.IB_WSDLURL = ' '

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
IB_TGTLOCATIONCharacter(254)VARCHAR2(254) NOT NULLTarget Location
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19