PSWSDLSVCOPR_VW

index back

Service Operation Lang View

Service Operation Lang View
SELECT A.IB_SERVICENAME , B.IB_OPERATIONNAME , B.VERSIONNAME , A.IB_ALIASNAME , A.RTNGTYPE , B.DESCR , B.ACTIVE_FLAG , C.IB_REQMSGNAME , C.INMSGVERSION , C.IB_RESPMSGNAME , C.OUTMSGVERSION , C.IB_FLTMSGNAME , C.FLTMSGVERSION , A.IB_USERPWDREQ FROM PSOPERATION A , PSOPRVERDFN B , PSOPRVERMSGS_VW C WHERE 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', 'R', 'S') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME)

  • Related language record: PSWSDLSVCOPRLVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
    VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version
    IB_ALIASNAMECharacter(128)VARCHAR2(128) NOT NULLService Alias
    RTNGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
    A=Asynchronous - One Way
    N=Synchronous Non-Blocking
    R=Asynch Request/Response
    S=Synchronous
    X=Asynch to Synch
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    ACTIVE_FLAGCharacter(1)VARCHAR2(1) NOT NULLActive Flag
    A=Active
    I=Inactive
    IB_REQMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
    INMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLIn Message Version
    IB_RESPMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
    OUTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLOut Message Version
    IB_FLTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
    FLTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLFault Message Version
    IB_USERPWDREQCharacter(1)VARCHAR2(1) NOT NULLUser/Password Required

    Y/N Table Edit

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19