WORKLISTNAME_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).
2 WORKLISTNAME Character(30) VARCHAR2(30) NOT NULL Worklist Name