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 NameField TypeColumn TypeDescription
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
WORKLISTNAMECharacter(30)VARCHAR2(30) NOT NULLWorklist Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19