PSPUBLSVC_LVW

Return to Index

Services with ANY routing

PlatformView Text
DefaultSELECT DISTINCT A.IB_SERVICENAME , C.LANGUAGE_CD , C.DESCR FROM PSOPERATION A , PSOPRVERDFN B , PSSERVICELANG C WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND A.DEFAULTVER = B.VERSIONNAME AND A.RTNGTYPE IN ('A', 'S', 'R') AND A.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 for PSPUBLSVC_VW

    • PeopleSoft Field NameDescription
    IB_SERVICENAMEService
    LANGUAGE_CDLanguage Code translate values
    DESCRDescription

    Author: PeopleTools

    Return to Index

    © Go-Faster Consultancy Ltd.  Last updated 24 July 2010