PTPPB_IBOPR_VW

Return to Index

View: PS_PTPPB_IBOPR_VW

PlatformView Text
DefaultSELECT A.IB_OPERATIONNAME , A.VERSIONNAME , C.DESCR FROM PSIBRTNGDEFN A , PSMSGNODEDEFN B , PSOPERATION C WHERE A.RTNGTYPE='S' AND A.EFF_STATUS='A' AND A.SENDERNODENAME=B.MSGNODENAME AND B.LOCALDEFAULTFLG='Y' AND A.IB_OPERATIONNAME=C.IB_OPERATIONNAME AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PSIBRTNGDEFN D WHERE A.IB_OPERATIONNAME=D.IB_OPERATIONNAME)

PeopleSoft Field NameDescription
IB_OPERATIONNAMEService Operation
VERSIONNAMEService Operation Version
DESCRDescription

Author: PeopleTools

Return to Index

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