PSWSDLOPER_LVW

Return to Index

PlatformView Text
DefaultSELECT A.IB_SERVICENAME , %TrimSubstr(B.IB_OPERATIONNAME,1,30) %Concat '.' %Concat %TrimSubstr(B.VERSIONNAME,1,30) , B.LANGUAGE_CD , B.DESCR FROM PSOPERATION A , PSOPRVERDFNLANG 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', 'S', 'R') AND EXISTS ( SELECT 'X' FROM PSRTGANYPARMVW X WHERE X.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND X.VERSIONNAME = B.VERSIONNAME)

  • Related language record for PSWSDLOPER_VW
  • PeopleSoft Field NameDescription
    IB_SERVICENAMEService
    IB_OPERWITHVERService Operation
    LANGUAGE_CDLanguage Code translate values
    DESCRDescription

    Author: PeopleTools

    Return to Index

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