[Home] [Help]
View: GMS_PROJECT_TYPES
View Text
SELECT PA.PROJECT_TYPE
, DESCRIPTION
, PROJECT_TYPE_CLASS_CODE
, DECODE(SPONSORED_FLAG
, NULL
, 'N'
, SPONSORED_FLAG) SPONSORED_FLAG
, ORG_ID FROM PA_PROJECT_TYPES PA
WHERE PA.PROJECT_TYPE <> 'AWARD_PROJECT'
Columns
Name |
PROJECT_TYPE |
DESCRIPTION |
PROJECT_TYPE_CLASS_CODE |
SPONSORED_FLAG |
ORG_ID |