How do I know which template was a project created or copied from?

Document ID : KB000071348
Last Modified Date : 19/02/2018
Show Technical Document Details
I want to know which project templates have been used to create the existing projects. How can I knwo what is the template used?
Here is a query to identify the internal ID of a template from which a project has been created or copied from:

select templ.code copiedFrom, copied.code copiedTo, flat.created_by copiedBy, flat.created_date copiedDate

from odf_object_copy_flat flat, inv_investments templ, inv_investments copied

where flat.src_object_id =

and flat.object_code = 'project'

and flat.object_id =