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 Name Field Type Column Type Description
PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20