View: AMW_PROCESS_ORG_BASICINFO_V

Product:	AMW - Internal Controls Manager
Description:	This view returns Basic information about Process Organization
Implementation/DBA Data:	APPS.AMW_PROCESS_ORG_BASICINFO_V

View Text

SELECT AMWP.NAME
, WAT.DISPLAY_NAME DISPLAY_NAME
, AMWP.ITEM_TYPE
, AMWP.PROCESS_CATEGORY
, AMW.RISK_COUNT
, AMW.CONTROL_COUNT
, WA.VERSION
, AMW.PROCESS_ORGANIZATION_ID
, AMW.LAST_UPDATE_DATE
, AMW.LAST_UPDATED_BY
, AMW.CREATION_DATE
, AMW.CREATED_BY
, AMW.LAST_UPDATE_LOGIN
, AMW.PROCESS_ID
, AMWP.STANDARD_PROCESS_FLAG
, AMW.RISK_CATEGORY
, AMW.APPROVAL_STATUS
, AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_STATUS(AMW.PROCESS_ID
, AMW.ORGANIZATION_ID
, 'CERTIFICATION') CERTIFICATION_STATUS
, AMW.LAST_AUDIT_STATUS
, AMW.ORGANIZATION_ID
, AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_DATE(AMW.PROCESS_ID
, AMW.ORGANIZATION_ID
, 'CERTIFICATION') LAST_CERTIFICATION_DATE
, AMW.LAST_AUDIT_DATE
, AMW.NEXT_AUDIT_DATE
, AMW.APPLICATION_OWNER_ID
, AMW.PROCESS_OWNER_ID
, HZP.PARTY_NAME
, AMW.PROCESS_CATEGORY_CODE
, AMW.SIGNIFICANT_PROCESS_FLAG
, AMW.CREATED_FROM
, AMW.REQUEST_ID
, AMW.PROGRAM_APPLICATION_ID
, AMW.PROGRAM_ID
, AMW.PROGRAM_UPDATE_DATE
, AMW.ATTRIBUTE_CATEGORY
, AMW.ATTRIBUTE1
, AMW.ATTRIBUTE2
, AMW.ATTRIBUTE3
, AMW.ATTRIBUTE4
, AMW.ATTRIBUTE5
, AMW.ATTRIBUTE6
, AMW.ATTRIBUTE7
, AMW.ATTRIBUTE8
, AMW.ATTRIBUTE9
, AMW.ATTRIBUTE10
, AMW.ATTRIBUTE11
, AMW.ATTRIBUTE12
, AMW.ATTRIBUTE14
, AMW.ATTRIBUTE13
, AMW.ATTRIBUTE15
, AMW.SECURITY_GROUP_ID
, AMW.OBJECT_VERSION_NUMBER
, AMW.END_DATE
, AAUV.NAME AUDIT_UNIT
, AAUV.COMPANY COMPANY
, AMW.FINANCE_OWNER_ID
, AMW.TOP_PROCESS_ID
, AAUV.LOB_CODE LOB_CODE
, AAUV.LOB_DESCRIPTION LOB_DESCRIPTION
, AMWP.STANDARD_VARIATION
FROM WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WAT
, AMW_PROCESS_ORGANIZATION AMW
, AMW_PROCESS AMWP
, HZ_PARTIES HZP
, AMW_AUDIT_UNITS_V AAUV
WHERE AMW.PROCESS_ID = AMWP.PROCESS_ID
AND WA.ITEM_TYPE = AMWP.ITEM_TYPE
AND WA.NAME = AMWP.NAME
AND WA.END_DATE IS NULL
AND WAT.ITEM_TYPE=WA.ITEM_TYPE
AND WAT.NAME=WA.NAME
AND WAT.VERSION=WA.VERSION
AND WAT.LANGUAGE=USERENV('LANG')
AND AMW.PROCESS_OWNER_ID = HZP.PARTY_ID (+)
AND AMW.ORGANIZATION_ID = AAUV.ORGANIZATION_ID

Columns