[Home] [Help]
View: PSPFV_TEMPLATE_AWARDS
Product: | PSP - Labor Distribution |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PTA.TEMPLATE_ID
, PER.TEMPLATE_NAME
, PTA.AWARD_ID
, PTA.LAST_UPDATE_DATE
, PTA.LAST_UPDATED_BY
, PTA.CREATED_BY
, PTA.CREATION_DATE
, GAA.AWARD_NUMBER
, GAA.AWARD_SHORT_NAME
, GAA.AWARD_FULL_NAME
FROM PSP_TEMPLATE_AWARDS PTA
, GMS_AWARDS_ALL GAA
, PSP_EFFORT_REPORT_TEMPLATES PER
WHERE PTA.AWARD_ID = GAA.AWARD_ID
AND PTA.TEMPLATE_ID = PER.TEMPLATE_ID WITH READ ONLY
Columns
Name |
TEMPLATE_ID |
TEMPLATE_NAME |
AWARD_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |
AWARD_NUMBER |
AWARD_SHORT_NAME |
AWARD_FULL_NAME |