|
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'
|
OPERATION_UID