PSWSENDPOINT_VW

index back

WSDL Endpoints view


SELECT D.ELEMENT_UID ,DOC.DOC_UID ,B.ELEMENT_PREFIX ,%Substring(B1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS SERVICENAMEW ,%Substring(C1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS PORTNAME ,C2.QSPACE AS QBINDING ,%Substring(C2.WS_ATTRIBUTE_VALUE, 1, 60 ) AS BINDINGNAME ,D1.WS_ATTRIBUTE_VALUE AS ENDPOINT FROM PSDOCUMENT DOC , PSELEMENT A , PSATTRIBUTE A1 , PSELEMENT B , PSATTRIBUTE B1 , PSELEMENT C , PSATTRIBUTE C1 , PSATTRIBUTE C2 , PSELEMENT D , PSATTRIBUTE D1 WHERE A.DOC_UID = DOC.DOC_UID AND DOC.DOC_UID_SEQNO = 1 AND A.PARENT_UID = '0' AND A.ELEMENT_ORD = 1 AND A.ELEMENT_TAG = 'definitions' AND A1.DOC_UID = A.DOC_UID AND A1.ELEMENT_UID = A.ELEMENT_UID AND A1.WS_ATTRIBUTE_VALUE = 'http://schemas.xmlsoap.org/wsdl/soap/' AND B.DOC_UID = A.DOC_UID AND B.PARENT_UID = A.ELEMENT_UID AND B.ELEMENT_PREFIX = A.ELEMENT_PREFIX AND B.ELEMENT_TAG = 'service' AND B1.DOC_UID = B.DOC_UID AND B1.ELEMENT_UID = B.ELEMENT_UID AND B1.ATTRIBUTE_TAG = 'name' AND C.DOC_UID = B.DOC_UID AND C.PARENT_UID = B.ELEMENT_UID AND C.ELEMENT_PREFIX = B.ELEMENT_PREFIX AND C.ELEMENT_TAG = 'port' AND C1.DOC_UID = C.DOC_UID AND C1.ELEMENT_UID = C.ELEMENT_UID AND C1.ATTRIBUTE_TAG = 'name' AND C2.ELEMENT_UID = C.ELEMENT_UID AND C2.ATTRIBUTE_TAG = 'binding' AND D.DOC_UID = C.DOC_UID AND D.PARENT_UID = C.ELEMENT_UID AND D.ELEMENT_PREFIX = %Substring(A1.ATTRIBUTE_TAG,7,54) AND D.ELEMENT_TAG = 'address' AND D1.DOC_UID = D.DOC_UID AND D1.ELEMENT_UID = D.ELEMENT_UID AND D1.ATTRIBUTE_TAG = 'location'

PeopleSoft Field NameField TypeColumn TypeDescription
ENDPOINT_UIDCharacter(40)VARCHAR2(40) NOT NULLEndpoint Id
DOC_UIDCharacter(40)VARCHAR2(40) NOT NULLWSDL Name
ELEMENT_PREFIXCharacter(20)VARCHAR2(20) NOT NULLElement Prefix
SERVICENAMEWCharacter(60)VARCHAR2(60) NOT NULLService Name
PORTNAMECharacter(60)VARCHAR2(60) NOT NULLPort Name
QBINDINGCharacter(20)VARCHAR2(20) NOT NULLbinding Qualifier
BINDINGNAMECharacter(60)VARCHAR2(60) NOT NULLBinding Name
ENDPOINTCharacter(240)VARCHAR2(240) NOT NULLEndpoint
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19