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 Name Field Type Column Type Description
ENDPOINT_UID Character(40) VARCHAR2(40) NOT NULL Endpoint Id
DOC_UID Character(40) VARCHAR2(40) NOT NULL WSDL Name
ELEMENT_PREFIX Character(20) VARCHAR2(20) NOT NULL Element Prefix
SERVICENAMEW Character(60) VARCHAR2(60) NOT NULL Service Name
PORTNAME Character(60) VARCHAR2(60) NOT NULL Port Name
QBINDING Character(20) VARCHAR2(20) NOT NULL binding Qualifier
BINDINGNAME Character(60) VARCHAR2(60) NOT NULL Binding Name
ENDPOINT Character(240) VARCHAR2(240) NOT NULL Endpoint
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19