WORKLISTNAME_VW

 index back

Worklist Name View


SELECT DISTINCT A.OBJNAME, B.COMPNAME FROM PSBUSPROCITEM A, PSBUSPROCITEM B WHERE A.OBJTYPE = 0 AND A.COMPTYPE = 5 AND B.OBJTYPE = 1 AND A.COMPNAME = B.OBJNAME AND B.COMPTYPE = 8

PeopleSoft Field Name Field Type Column Type Description
BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20