PTPPB_IBOPR_VW

index back

SELECT 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 Name Field Type Column Type Description
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version
DESCR Character(30) VARCHAR2(30) NOT NULL Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19