List of Project Objects
The following query lists all the objects created using the Project type or a Custom object type based on a Project.
The results of the query are used to populate the Object Name drop down list in the Project Locks report.
SELECT name, pdm_blobid
FROM Project, parent_list
WHERE parent_list.child=Project.pdm_blobid AND
Project.pdm_current=1 AND
Project.pdm_deleted=0;