VIEW: APPS.AMW_PROCESS_ORG_BASICINFO_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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