PSWSBINDOPS_VW

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 NameField TypeColumn TypeDescription
OPERATION_UIDCharacter(40)VARCHAR2(40) NOT NULLOperation Id
BINDING_UIDCharacter(40)VARCHAR2(40) NOT NULLBinding Id
DOC_UIDCharacter(40)VARCHAR2(40) NOT NULLWSDL Name
ELEMENT_PREFIXCharacter(20)VARCHAR2(20) NOT NULLElement Prefix
BINDINGNAMECharacter(60)VARCHAR2(60) NOT NULLBinding Name
QPORTTYPECharacter(20)VARCHAR2(20) NOT NULLportType Qualifier
PORTTYPENAMECharacter(60)VARCHAR2(60) NOT NULLPortType Name
OPERATIONNAMECharacter(60)VARCHAR2(60) NOT NULLOperation
BINDINGPROTOCOLCharacter(20)VARCHAR2(20) NOT NULLBinding Protocol
TRANSPORTCharacter(60)VARCHAR2(60) NOT NULLTransport
SOAPACTIONCharacter(120)VARCHAR2(120) NOT NULLSoap Action
BINDINGSTYLECharacter(10)VARCHAR2(10) NOT NULLBinding Style
OPERATIONSTYLECharacter(10)VARCHAR2(10) NOT NULLBinding Style
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19