View: GMS_PROJECTS_BURDEN_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_PROJECTS_BURDEN_V

View Text

SELECT A.SEGMENT1
, A.NAME
, A.DESCRIPTION
, A.PROJECT_ID
, A.ORG_ID
FROM PA_PROJECTS A
, GMS_PROJECT_TYPES PT
WHERE A.PROJECT_TYPE = PT.PROJECT_TYPE
AND A.PROJECT_TYPE <> 'AWARD_PROJECT'
AND A.TEMPLATE_FLAG = 'N'
AND PT.SPONSORED_FLAG = 'Y'
AND PA_PROJECT_STUS_UTILS.IS_PROJECT_STATUS_CLOSED(PROJECT_STATUS_CODE) = 'N'

Columns