[Home] [Help]
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|---|
| Description: | View for risk library process |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DISPLAY_NAME
, DESCRIPTION
, AP.PROCESS_ID PROCESS_ID
, ITEM_TYPE
, NAME
, PROCESS_CODE
, AP.REVISION_NUMBER REVISION_NUMBER
, AP.PROCESS_REV_ID PROCESS_REV_ID
, APPROVAL_STATUS
, START_DATE
, APPROVAL_DATE
, APPROVAL_END_DATE
, END_DATE
, CONTROL_COUNT
, RISK_COUNT
, ORG_COUNT
, SIGNIFICANT_PROCESS_FLAG
, STANDARD_PROCESS_FLAG
, CERTIFICATION_STATUS
, PROCESS_CATEGORY
, PROCESS_OWNER_ID
, FINANCE_OWNER_ID
, APPLICATION_OWNER_ID
, STANDARD_VARIATION
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AP.CREATED_FROM CREATED_FROM
, AP.CREATION_DATE CREATION_DATE
, AP.CREATED_BY CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, AP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DELETION_DATE
, RISK_COUNT_LATEST
, CONTROL_COUNT_LATEST
, PROCESS_TYPE
, CONTROL_ACTIVITY_TYPE
, CLASSIFICATION
FROM AMW_PROCESS AP
, AMW_PROCESS_NAMES_TL AP_TL
WHERE AP_TL.PROCESS_REV_ID = AP.PROCESS_REV_ID
AND AP_TL.LANGUAGE = USERENV('LANG')