PSWSBINDOPS_VW

(SQL View)
 Index Back

WSDL Binding Operations View


SELECT D.ELEMENT_UID AS OPERATION_UID ,B.ELEMENT_UID AS BINDING_UID ,DOC.DOC_UID ,B.ELEMENT_PREFIX ,%Substring(B1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS BINDINGNAME ,B2.QSPACE AS QPORTTYPE ,%Substring(B2.WS_ATTRIBUTE_VALUE, 1, 60 ) AS PORTTYPENAME ,%Substring(D1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS OPERATIONNAME ,C.ELEMENT_PREFIX AS BINDINGPROTOCOL ,%Substring(C1.WS_ATTRIBUTE_VALUE, 1, 60 ) AS TRANSPORT ,%Substring(E1.WS_ATTRIBUTE_VALUE, 1, 120 ) AS SOAPACTION ,'document' AS BINDINGSTYLE ,' ' AS OPERATIONSTYLE FROM PSDOCUMENT DOC , PSELEMENT A , PSATTRIBUTE A1 , PSELEMENT B , PSATTRIBUTE B1 , PSATTRIBUTE B2 , PSELEMENT C , PSATTRIBUTE C1 , PSELEMENT D , PSATTRIBUTE D1 , PSELEMENT E , PSATTRIBUTE E1 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 = 'binding' AND B1.DOC_UID = B.DOC_UID AND B1.ELEMENT_UID = B.ELEMENT_UID AND B1.ATTRIBUTE_TAG = 'name' AND B2.ELEMENT_UID = B.ELEMENT_UID AND B2.ATTRIBUTE_TAG = 'type' AND C.DOC_UID = B.DOC_UID AND C.PARENT_UID = B.ELEMENT_UID AND C.ELEMENT_PREFIX = %Substring(A1.ATTRIBUTE_TAG,7,54) AND C.ELEMENT_TAG = 'binding' AND C1.DOC_UID = C.DOC_UID AND C1.ELEMENT_UID = C.ELEMENT_UID AND C1.ATTRIBUTE_TAG = 'transport' AND D.DOC_UID = B.DOC_UID AND D.PARENT_UID = B.ELEMENT_UID AND D.ELEMENT_PREFIX = B.ELEMENT_PREFIX AND D.ELEMENT_TAG = 'operation' AND D1.DOC_UID = D.DOC_UID AND D1.ELEMENT_UID = D.ELEMENT_UID AND D1.ATTRIBUTE_TAG = 'name' AND E.DOC_UID = D.DOC_UID AND E.PARENT_UID = D.ELEMENT_UID AND E.ELEMENT_PREFIX = %Substring(A1.ATTRIBUTE_TAG,7,54) AND E.ELEMENT_TAG = 'operation' AND E1.DOC_UID = E.DOC_UID AND E1.ELEMENT_UID = E.ELEMENT_UID AND E1.ATTRIBUTE_TAG = 'soapAction'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPERATION_UID Character(40) VARCHAR2(40) NOT NULL Operation Id
2 BINDING_UID Character(40) VARCHAR2(40) NOT NULL Binding Id
3 DOC_UID Character(40) VARCHAR2(40) NOT NULL WSDL Name
4 ELEMENT_PREFIX Character(20) VARCHAR2(20) NOT NULL Element Prefix
5 BINDINGNAME Character(60) VARCHAR2(60) NOT NULL Binding Name
6 QPORTTYPE Character(20) VARCHAR2(20) NOT NULL portType Qualifier
7 PORTTYPENAME Character(60) VARCHAR2(60) NOT NULL PortType Name
8 OPERATIONNAME Character(60) VARCHAR2(60) NOT NULL Operation
9 BINDINGPROTOCOL Character(20) VARCHAR2(20) NOT NULL Binding Protocol
10 TRANSPORT Character(60) VARCHAR2(60) NOT NULL Transport
11 SOAPACTION Character(120) VARCHAR2(120) NOT NULL Soap Action
12 BINDINGSTYLE Character(10) VARCHAR2(10) NOT NULL Binding Style
13 OPERATIONSTYLE Character(10) VARCHAR2(10) NOT NULL Binding Style