[Home] [Help]
View: GMS_PROJECTS_V
View Text
SELECT /*+ INDEX PA_PROJECTS_U2 */ A.PROJECT_ID
, A.PROJECT_NUMBER
, A.PROJECT_NAME
, A.START_DATE
, A.COMPLETION_DATE
, A.PROJECT_CURRENCY_CODE
, A.PROJECT_OU
, A.PROJECT_TYPE_CLASS_CODE
, A.PROJECT_DESCRIPTION
, A.PROJFUNC_CURRENCY_CODE
FROM PA_PROJECTS_EXPEND_V A
WHERE A.PROJECT_TYPE<> 'AWARD_PROJECT' GROUP BY A.PROJECT_ID
, A.PROJECT_NUMBER
, A.PROJECT_NAME
, A.START_DATE
, A.COMPLETION_DATE
, A.PROJECT_CURRENCY_CODE
, A.PROJECT_OU
, A.PROJECT_TYPE_CLASS_CODE
, A.PROJECT_DESCRIPTION
, A.PROJFUNC_CURRENCY_CODE
Columns
Name |
PROJECT_ID |
PROJECT_NUMBER |
PROJECT_NAME |
START_DATE |
COMPLETION_DATE |
PROJECT_CURRENCY_CODE |
PROJECT_OU |
PROJECT_TYPE_CLASS_CODE |
PROJECT_DESCRIPTION |
PROJFUNC_CURRENCY_CODE |