PSSERVPERM2_VW

index back

Perms for Serv Operations

Service operations that have been assigned to at least one permission list.
SELECT DISTINCT A.IB_SERVICENAME , A.IB_OPERATIONNAME FROM PSSERVICEOPR A , PSAUTHWS B WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME

PeopleSoft Field NameField TypeColumn TypeDescription
IB_SERVICENAMECharacter(30)VARCHAR2(30) NOT NULLService (see PSSERVICE).
IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19