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 2019, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 25-NOV-20