[Home] [Help]
View: PA_PROJECT_STATUSES_V
Product: | PA - Projects |
Description: | This view provides the control items statuses. |
Implementation/DBA Data: |
APPS.PA_PROJECT_STATUSES_V
|
View Text
SELECT PROJECT_STATUS_CODE
, PROJECT_STATUS_NAME
, PROJECT_SYSTEM_STATUS_CODE
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PREDEFINED_FLAG
, STARTING_STATUS_FLAG
, ENABLE_WF_FLAG
, WORKFLOW_ITEM_TYPE
, WORKFLOW_PROCESS
, WF_SUCCESS_STATUS_CODE
, WF_FAILURE_STATUS_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, STATUS_TYPE
, NEXT_ALLOWABLE_STATUS_FLAG
, STATUS_ICON_IND
, STATUS_ICON_ACTIVE_IND
, PROJECT_STATUS_WEIGHT
FROM PA_PROJECT_STATUSES
WHERE STATUS_TYPE = 'CONTROL_ITEM'
Columns
Name |
PROJECT_STATUS_CODE |
PROJECT_STATUS_NAME |
PROJECT_SYSTEM_STATUS_CODE |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
PREDEFINED_FLAG |
STARTING_STATUS_FLAG |
ENABLE_WF_FLAG |
WORKFLOW_ITEM_TYPE |
WORKFLOW_PROCESS |
WF_SUCCESS_STATUS_CODE |
WF_FAILURE_STATUS_CODE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ATTRIBUTE_CATEGORY |
ATTRIBUTE1 |
ATTRIBUTE2 |
ATTRIBUTE3 |
ATTRIBUTE4 |
ATTRIBUTE5 |
ATTRIBUTE6 |
ATTRIBUTE7 |
ATTRIBUTE8 |
ATTRIBUTE9 |
ATTRIBUTE10 |
ATTRIBUTE11 |
ATTRIBUTE12 |
ATTRIBUTE13 |
ATTRIBUTE14 |
ATTRIBUTE15 |
STATUS_TYPE |
NEXT_ALLOWABLE_STATUS_FLAG |
STATUS_ICON_IND |
STATUS_ICON_ACTIVE_IND |
PROJECT_STATUS_WEIGHT |