PSSRVOPRWSD_VW

(SQL View)
Index Back

SELECT DISTINCT P.IB_OPERATIONNAME , P.VERSIONNAME FROM PSOPRMSGWSDL_VW P WHERE NOT EXISTS ( SELECT 'X' FROM PSSRVOPRWSDL_VW W WHERE W.IB_OPERATIONNAME = P.IB_OPERATIONNAME)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
2 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version