[Home] [Help]
View: PSPFV_TEMPLATE_PROJECTS
| Product: | PSP - Labor Distribution |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT PTP.PROJECT_ID
, PTP.TEMPLATE_ID
, PER.TEMPLATE_NAME
, PTP.LAST_UPDATE_DATE
, PTP.LAST_UPDATED_BY
, PTP.CREATED_BY
, PTP.CREATION_DATE
, PPA.NAME
, PPA.SEGMENT1
FROM PSP_TEMPLATE_PROJECTS PTP
, PA_PROJECTS_ALL PPA
, PSP_EFFORT_REPORT_TEMPLATES PER
WHERE PTP.PROJECT_ID = PPA.PROJECT_ID
AND PTP.TEMPLATE_ID = PER.TEMPLATE_ID WITH READ ONLY
Columns
| Name |
| PROJECT_ID |
| TEMPLATE_ID |
| TEMPLATE_NAME |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| CREATED_BY |
| CREATION_DATE |
| PROJECT_NAME |
| PROJECT_NUMBER |