PSPUBLSVC_VW

index back

Services with ANY routing

Services with ANY routing
SELECT DISTINCT C.IB_SERVICENAME , C.DESCR , C.IB_ALIASNAME , C.OBJECTOWNERID , C.IB_REST_SERVICE FROM PSOPERATION A , PSOPRVERDFN B , PSSERVICE C , PSSERVICEOPR D WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND A.RTNGTYPE IN ('A', 'S', 'R') AND A.IB_OPERATIONNAME = D.IB_OPERATIONNAME AND D.IB_SERVICENAME = C.IB_SERVICENAME AND C.IB_SERVICENAME NOT IN ('SOAPTOCI', 'IB_UTILITY') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME)

  • Related language record: PSPUBLSVC_LVW
  • PeopleSoft Field Name Field Type Column Type Description
    IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    IB_ALIASNAME Character(128) VARCHAR2(128) NOT NULL Service Alias
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    IB_REST_SERVICE Number(1,0) SMALLINT NOT NULL REST Service Type
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19