VIEW: APPS.PA_PROJ_STATUSES_V

Source

View Text - Preformatted

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 = 'PROJECT' UNION ALL select lookup_code, meaning, lookup_code, DESCRIPTION, START_DATE_ACTIVE, END_DATE_ACTIVE, PREDEFINED_FLAG, 'N', 'N', NULL, NULL, NULL, NULL, 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, 'PROJECT', 'N', NULL, NULL, NULL from pa_lookups where lookup_type = 'PROJECT STATUS' and lookup_code in ('ALL','ALL_EXCEPT_CLOSED')

View Text - HTML Formatted

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 = 'PROJECT' UNION ALL SELECT LOOKUP_CODE
, MEANING
, LOOKUP_CODE
, DESCRIPTION
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PREDEFINED_FLAG
, 'N'
, 'N'
, NULL
, NULL
, NULL
, NULL
, 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
, 'PROJECT'
, 'N'
, NULL
, NULL
, NULL
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'PROJECT STATUS'
AND LOOKUP_CODE IN ('ALL'
, 'ALL_EXCEPT_CLOSED')