RBB_SERVOPR_VW

(SQL View)
 Index Back

BPEL Service Operations

View of default versions for all Service Operations created using BPEL WSDLs.

SELECT A.IB_OPERATIONNAME , B.VERSIONNAME , A.IB_SERVICENAME , A.DESCR FROM PSOPERATION A , PSOPRVERDFN B , PSIBRTNGDEFN C , PSNODEPROP D WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.IB_OPERATIONNAME = C.IB_OPERATIONNAME AND B.ACTIVE_FLAG = 'A' AND C.RECEIVERNODENAME = D.MSGNODENAME AND D.PROPNAME = 'BPELCONSOLEURL' AND %EffdtCheck(PSIBRTNGDEFN, C, %CurrentDateIn) AND C.EFF_STATUS = 'A'

  • Related Language Record: RBB_SERVOPR_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RBB_SERV_OPR_ID Character(100) VARCHAR2(100) NOT NULL Service Operation ID
    2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
    3 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description