[Home] [Help]
View: 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
Name |
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 |