PSWSDLOPER_VW

(SQL View)
 Index Back

Service operation details.

Service operation WSDL details

SELECT D.IB_SERVICENAME , %TrimSubstr(B.IB_OPERATIONNAME,1,30) %Concat '.' %Concat %TrimSubstr(B.VERSIONNAME,1,30) , A.RTNGTYPE , B.DESCR , B.ACTIVE_FLAG , %TrimSubstr(C.IB_REQMSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(C.INMSGVERSION,1,30) , %TrimSubstr(C.IB_RESPMSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(C.OUTMSGVERSION,1,30) , %TrimSubstr(C.IB_FLTMSGNAME,1,30) %Concat '.' %Concat %TrimSubstr(C.FLTMSGVERSION,1,30) , A.IB_USERPWDREQ , B.IB_EXPORTSTATUS FROM PSSERVICEOPR D , PSOPERATION A , PSOPRVERDFN B , PSOPRVERMSGS_VW C WHERE D.IB_OPERATIONNAME = A.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND B.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.VERSIONNAME = C.VERSIONNAME AND A.RTNGTYPE IN ('A', 'S', 'R') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME)

  • Related Language Record: PSWSDLOPER_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    2 IB_OPERWITHVER Character(65) VARCHAR2(65) NOT NULL Service Operation
    3 RTNGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
    A=Asynchronous - One Way
    N=Synchronous Non-Blocking
    R=Asynch Request/Response
    S=Synchronous
    X=Asynch to Synch
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
    A=Active
    I=Inactive
    6 IB_INMSGWITHVER Character(65) VARCHAR2(65) NOT NULL Application Message Name. Name of the Application Message Definition.
    7 IB_OUTMSGWITHVER Character(65) VARCHAR2(65) NOT NULL Application Message Name. Name of the Application Message Definition.
    8 IB_FLTMSGWITHVER Character(65) VARCHAR2(65) NOT NULL Application Message Name. Name of the Application Message Definition.
    9 IB_USERPWDREQ Character(1) VARCHAR2(1) NOT NULL User/Password Required

    Y/N Table Edit

    10 IB_EXPORTSTATUS Character(1) VARCHAR2(1) NOT NULL Export Status
    C=Changed After Export
    E=Exported
    N=Not Exported