[Home] [Help]
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|---|
| Description: | This view returns information about Process Hierarchy |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AMWP1.PROCESS_ID PARENT_PROCESS_ID
, AMWP2.PROCESS_ID CHILD_PROCESS_ID
, WA_TL.DISPLAY_NAME PARENT_PROCESS_NAME
, WA_TL1.DISPLAY_NAME PROCESS_NAME
, TO_CHAR(NULL) ORGANIZATION
, TO_CHAR(NULL) PROCESSOWNER
, TO_CHAR(NULL) CERTIFICATION_STATUS
, TO_CHAR(NULL) APPROVAL_STATUS
, TO_CHAR(NULL) LAST_AUDIT_STATUS
, TO_CHAR(NULL) LAST_AUDIT_DATE
, TO_CHAR(NULL) NEXT_AUDIT_DATE
, WPA.ACTIVITY_ITEM_TYPE PROCESS_ACTIVITY_TYPE
, 'PROCESS' PROCESS
, WA.NAME PARENT_NONDISP_NAME
, WA2.NAME CHILD_NONDISP_NAME
FROM WF_PROCESS_ACTIVITIES WPA
, WF_ACTIVITIES_TL WA_TL
, WF_ACTIVITIES_TL WA_TL1
, WF_ACTIVITIES WA
, WF_ACTIVITIES WA2
, AMW_PROCESS AMWP1
, AMW_PROCESS AMWP2
WHERE WPA.PROCESS_VERSION = WA.VERSION
AND AMWP1.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
AND AMWP1.NAME = WPA.PROCESS_NAME
AND AMWP2.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
AND AMWP2.NAME = WPA.ACTIVITY_NAME
AND AMWP1.NAME=WA.NAME
AND AMWP1.ITEM_TYPE=WA.ITEM_TYPE
AND AMWP2.NAME=WA2.NAME
AND AMWP2.ITEM_TYPE=WA2.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WA2.END_DATE IS NULL
AND WA_TL.NAME=WA.NAME
AND WA_TL.VERSION=WA.VERSION
AND WA_TL.ITEM_TYPE=AMWP1.ITEM_TYPE
AND WA_TL1.NAME=WA2.NAME
AND WA_TL1.VERSION=WA2.VERSION
AND WA_TL1.ITEM_TYPE=AMWP2.ITEM_TYPE
AND WA_TL.LANGUAGE=USERENV('LANG')
AND WA_TL1.LANGUAGE=USERENV('LANG')