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 Name Field Type Column Type Description
OPERATION_UID Character(40) VARCHAR2(40) NOT NULL Operation Id
BINDING_UID Character(40) VARCHAR2(40) NOT NULL Binding Id
DOC_UID Character(40) VARCHAR2(40) NOT NULL WSDL Name
ELEMENT_PREFIX Character(20) VARCHAR2(20) NOT NULL Element Prefix
BINDINGNAME Character(60) VARCHAR2(60) NOT NULL Binding Name
QPORTTYPE Character(20) VARCHAR2(20) NOT NULL portType Qualifier
PORTTYPENAME Character(60) VARCHAR2(60) NOT NULL PortType Name
OPERATIONNAME Character(60) VARCHAR2(60) NOT NULL Operation
BINDINGPROTOCOL Character(20) VARCHAR2(20) NOT NULL Binding Protocol
TRANSPORT Character(60) VARCHAR2(60) NOT NULL Transport
SOAPACTION Character(120) VARCHAR2(120) NOT NULL Soap Action
BINDINGSTYLE Character(10) VARCHAR2(10) NOT NULL Binding Style
OPERATIONSTYLE Character(10) VARCHAR2(10) NOT NULL Binding Style
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19