View: GMS_PROJECTS_EXPEND_V

Product:	GMS - Grants Accounting
Description:	Projects which expenditures can be charged to
Implementation/DBA Data:	APPS.GMS_PROJECTS_EXPEND_V

View Text

SELECT A.PROJECT_ID PROJECT_ID
, A.PROJECT_NUMBER PROJECT_NUMBER
, A.PROJECT_NAME PROJECT_NAME
, A.START_DATE START_DATE
, A.COMPLETION_DATE COMPLETION_DATE
, PT.PROJECT_TYPE_CLASS_CODE PROJECT_TYPE_CLASS_CODE
, A.PROJECT_NUMBER_SORT_ORDER PROJECT_NUMBER_SORT_ORDER
, A.PROJECT_TYPE PROJECT_TYPE
, (SELECT COUNT(C.TASK_ID)
FROM PA_TASKS C
WHERE C.PROJECT_ID = A.PROJECT_ID) TASKS_PER_PROJ
, PT.ORG_ID
FROM PA_PROJECTS_EXPEND_V A
, PA_PROJECT_TYPES PT
WHERE PT.PROJECT_TYPE = A.PROJECT_TYPE
AND PT.ORG_ID = A.PROJECT_OU

Columns