FND Design Data [Home] [Help]

View: GMS_PROJECT_TYPES

Product: GMS - Grants Accounting
Description:
Implementation/DBA Data: ViewAPPS.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