View: GMS_PROJECTS_BASIC_V

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

View Text

SELECT PROJECT_ID
, PROJECT_NUMBER
, PROJECT_NAME
, LONG_NAME
, PROJECT_TYPE_CLASS_CODE
, PROJECT_STATUS_CODE
, TEMPLATE_FLAG
, PM_PROJECT_REFERENCE
, PROJECT_NUMBER_SORT_ORDER
, PROJECT_CURRENCY_CODE
, CC_PRVDR_FLAG
, ORG_ID
, OPERATING_UNIT
FROM PA_PROJECTS_BASIC_V
WHERE PROJECT_TYPE_CLASS_CODE <> 'CONTRACT'
AND GMS_COMMON_PKG.IS_PROJECT_TEMPLATE(TEMPLATE_FLAG) = 1 ORDER BY PROJECT_NUMBER

Columns