View: GMS_ACT_PROJECTS_BASIC_V

Product:	GMS - Grants Accounting
Description:	Actual projects that could potentially be funded by awards excluding the award projects
Implementation/DBA Data:	APPS.GMS_ACT_PROJECTS_BASIC_V

View Text

SELECT P.PROJECT_ID PROJECT_ID
, P.SEGMENT1 PROJECT_NUMBER
, P.NAME PROJECT_NAME
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, NVL(P.TEMPLATE_FLAG
, 'N') TEMPLATE_FLAG
, P.PM_PROJECT_REFERENCE PM_PROJECT_REFERENCE
, P.SEGMENT1 PROJECT_NUMBER_SORT_ORDER
, P.PROJECT_TYPE PROJECT_TYPE
, PT.ORG_ID ORG_ID
FROM PA_PROJECT_TYPES PT
, PA_PROJECTS_ALL P
WHERE PA_SECURITY.ALLOW_QUERY(P.PROJECT_ID) = 'Y'
AND P.TEMPLATE_FLAG <> 'Y'
AND P.PROJECT_TYPE = PT.PROJECT_TYPE
AND PT.PROJECT_TYPE <> 'AWARD_PROJECT'
AND PT.ORG_ID = P.ORG_ID

Columns