PTDM_PRJNAME_VW

(SQL View)
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 PeopleSoft Field Type Database Column Type Description
1 PROJECT_NAME Character(30) VARCHAR2(30) NOT NULL Displays the Project names.