PSWSENDPOINT_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 ENDPOINT_UID Character(40) VARCHAR2(40) NOT NULL Endpoint Id
2 DOC_UID Character(40) VARCHAR2(40) NOT NULL WSDL Name
3 ELEMENT_PREFIX Character(20) VARCHAR2(20) NOT NULL Element Prefix
4 SERVICENAMEW Character(60) VARCHAR2(60) NOT NULL Service Name
5 PORTNAME Character(60) VARCHAR2(60) NOT NULL Port Name
6 QBINDING Character(20) VARCHAR2(20) NOT NULL binding Qualifier
7 BINDINGNAME Character(60) VARCHAR2(60) NOT NULL Binding Name
8 ENDPOINT Character(240) VARCHAR2(240) NOT NULL Endpoint