[Home] [Help]
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|---|
| Description: | This view returns basic information about Process |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AP.NAME NAME
, WAT.DISPLAY_NAME DISPLAY_NAME
, AP.PROCESS_CATEGORY
, AP.ITEM_TYPE
, WAT.VERSION
, AP.SIGNIFICANT_PROCESS_FLAG
, AP.STANDARD_PROCESS_FLAG
, AP.APPROVAL_STATUS
, AP.CERTIFICATION_STATUS
, AP.PROCESS_OWNER_ID
, AP.PROCESS_ID
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATED_BY
, AP.CREATION_DATE
, AP.CREATED_BY
, AP.LAST_UPDATE_LOGIN
, AP.CREATED_FROM
, AP.REQUEST_ID
, AP.PROGRAM_APPLICATION_ID
, AP.PROGRAM_ID
, AP.PROGRAM_UPDATE_DATE
, AP.ATTRIBUTE_CATEGORY
, AP.ATTRIBUTE1
, AP.ATTRIBUTE2
, AP.ATTRIBUTE3
, AP.ATTRIBUTE4
, AP.ATTRIBUTE5
, AP.ATTRIBUTE6
, AP.ATTRIBUTE7
, AP.ATTRIBUTE8
, AP.ATTRIBUTE9
, AP.ATTRIBUTE10
, AP.ATTRIBUTE11
, AP.ATTRIBUTE12
, AP.ATTRIBUTE13
, AP.ATTRIBUTE14
, AP.ATTRIBUTE15
, AP.SECURITY_GROUP_ID
, AP.OBJECT_VERSION_NUMBER
, AP.CONTROL_COUNT
, AP.RISK_COUNT
, AP.FINANCE_OWNER_ID
, AP.APPLICATION_OWNER_ID
FROM AMW_PROCESS AP
, WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WAT
WHERE AP.NAME=WA.NAME
AND AP.ITEM_TYPE=WA.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WAT.NAME=WA.NAME
AND WAT.VERSION=WA.VERSION
AND WAT.ITEM_TYPE=WA.ITEM_TYPE
AND WAT.LANGUAGE=USERENV('LANG')