PTDM_PRJNAME_VW

index back

DM Project View


SELECT DISTINCT (A.PROJECTNAME) FROM PSPROJECTITEM A WHERE NOT EXISTS ( SELECT PROJECTNAME FROM PSPROJECTITEM B WHERE A.PROJECTNAME = B.PROJECTNAME AND B.OBJECTTYPE !=2)

PeopleSoft Field NameField TypeColumn TypeDescription
PROJECT_NAMECharacter(30)VARCHAR2(30) NOT NULLDisplays the Project names.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19