[Home] [Help]
| Product: | AMW - Internal Controls Manager (Obsolete) |
|---|---|
| Description: | Lists process details from amw_process and workflow tables |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AMWP.PROCESS_REV_ID PROCESS_REV_ID
, WA_TL.DISPLAY_NAME PROCESS_DISPLAY_NAME
, AMWP.PROCESS_ID PROCESS_ID
, AMWP.NAME NAME
, AMWP.ITEM_TYPE ITEM_TYPE
, AMWP.SIGNIFICANT_PROCESS_FLAG SIGNIFICANT_PROCESS_FLAG
, AMWP.STANDARD_PROCESS_FLAG STANDARD_PROCESS_FLAG
, AMWP.APPROVAL_STATUS APPROVAL_STATUS
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.RISK_COUNT) RISK_COUNT
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.CONTROL_COUNT) CONTROL_COUNT
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.ORG_COUNT) ORG_COUNT
, AMWP.PROCESS_OWNER_ID PROCESS_OWNER_ID
, HZP1.PARTY_NAME PROCESS_OWNER_NAME
, AMWP.CERTIFICATION_STATUS CERTIFICATION_STATUS_CODE
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_CERTIFICATION_STATUS'
, AMWP.CERTIFICATION_STATUS) CERTIFICATION_STATUS
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_PROCESS_APPROVAL_STATUS'
, AMWP.APPROVAL_STATUS) APPROVAL_STATUS_MEANING
, AMWP.APPLICATION_OWNER_ID APPLICATION_OWNER_ID
, HZP2.PARTY_NAME APPLICATION_OWNER_NAME
, AMWP.PROCESS_CATEGORY PROCESS_CATEGORY
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_PROCESS_CATEGORY'
, AMWP.PROCESS_CATEGORY) PROCESS_CATEGORY_MEANING
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OA.JSP?OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&ADDBREADCRUMB=Y&RETAINAM=Y') URLSTRING
, AMWP.FINANCE_OWNER_ID FINANCE_OWNER_ID
, HZP3.PARTY_NAME FINANCE_OWNER_NAME
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=R&ADDBREADCRUMB=Y&RETAINAM=Y') RISKCNTURL
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=C&ADDBREADCRUMB=Y&RETAINAM=Y') CTRLCNTURL
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=O&ADDBREADCRUMB=Y&RETAINAM=Y') ORGCNTURL
, AMWP.STANDARD_VARIATION STANDARD_VARIATION
FROM AMW_PROCESS AMWP
, WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WA_TL
, HZ_PARTIES HZP1
, HZ_PARTIES HZP2
, HZ_PARTIES HZP3
WHERE AMWP.NAME = WA.NAME
AND AMWP.ITEM_TYPE = WA.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WA_TL.NAME = WA.NAME
AND WA_TL.VERSION = WA.VERSION
AND WA_TL.ITEM_TYPE = WA.ITEM_TYPE
AND WA_TL.LANGUAGE = USERENV('LANG')
AND HZP1.PARTY_ID (+) = AMWP.PROCESS_OWNER_ID
AND HZP2.PARTY_ID (+) = AMWP.APPLICATION_OWNER_ID
AND HZP3.PARTY_ID (+) = AMWP.FINANCE_OWNER_ID