eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.AMW_ORG_RELATIONS_V

Source

View Text - Preformatted


SELECT apobv1.name PARENT_PROCESS_NAME, 'AUDITMGR' PARENT_ITEM_TYPE, apobv2.name CHILD_PROCESS_NAME, 'AUDITMGR' CHILD_ITEM_TYPE, apor.parent_process_id parent_process_id, apor.child_process_id child_process_id, apor.instance_id INSTANCE_ID, AMW_WF_HIERARCHY_PKG.find_transition_order(instance_id) TRANSITION_REVERSE_ORDER, apobv2.process_organization_id Process_Org_Id, apobv2.organization_id Org_Id, apobv2.audit_unit Org_Name, apobv2.display_name Process_Display_Name, apobv2.process_id Process_Id, apobv2.name name, apobv2.item_type item_type, apobv2.significant_process_flag SIGNIFICANT_PROCESS_FLAG, apobv2.standard_process_flag STANDARD_PROCESS_FLAG, apobv2.approval_status APPROVAL_STATUS, apobv2.risk_count RISK_COUNT, apobv2.control_count CONTROL_COUNT, apobv2.process_owner_id PROCESS_OWNER_ID, apobv2.party_name process_owner_name, apobv2.certification_status Certification_Status_Code, AMW_Utility_PVT.get_proc_org_opinion_status(apor.child_process_id, apobv2.organization_id, 'CERTIFICATION') Certification_Status, 'OA.jsp?OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=0&addBreadCrumb=Y&retainAM=Y' URLString, 'OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=2>ab=2&addBreadCrumb=Y&retainAM=Y' RiskCntURL, 'OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=3>ab=3&addBreadCrumb=Y&retainAM=Y' CtrlCntURL from Amw_Process_Org_Relations apor, amw_process_org_basicinfo_v apobv1, amw_process_org_basicinfo_v apobv2 WHERE apobv1.organization_id = apor.organization_id and apobv1.process_id = apor.parent_process_id and apobv2.organization_id = apor.organization_id and apobv2.process_id = apor.child_process_id and apobv1.end_date is null and apobv2.end_date is null union SELECT 'PROCESS' PARENT_PROCESS_NAME, 'AUDITMGR' PARENT_ITEM_TYPE, apobv2.name CHILD_PROCESS_NAME, 'AUDITMGR' CHILD_ITEM_TYPE, apor.parent_process_id parent_process_id, apor.child_process_id child_process_id, apor.instance_id INSTANCE_ID, AMW_WF_HIERARCHY_PKG.find_transition_order(instance_id) TRANSITION_REVERSE_ORDER, apobv2.process_organization_id Process_Org_Id, apobv2.organization_id Org_Id, apobv2.audit_unit Org_Name, apobv2.display_name Process_Display_Name, apobv2.process_id Process_Id, apobv2.name name, apobv2.item_type item_type, apobv2.significant_process_flag SIGNIFICANT_PROCESS_FLAG, apobv2.standard_process_flag STANDARD_PROCESS_FLAG, apobv2.approval_status APPROVAL_STATUS, apobv2.risk_count RISK_COUNT, apobv2.control_count CONTROL_COUNT, apobv2.process_owner_id PROCESS_OWNER_ID, apobv2.party_name process_owner_name, apobv2.certification_status Certification_Status_Code, AMW_Utility_PVT.get_proc_org_opinion_status(apor.child_process_id, apobv2.organization_id, 'CERTIFICATION') Certification_Status, 'OA.jsp?OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=0&addBreadCrumb=Y&retainAM=Y' URLString, 'OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=2>ab=2&addBreadCrumb=Y&retainAM=Y' RiskCntURL, 'OAFunc=AMW_PROCESS_DETAILS&processId='||apobv2.process_id||'&processOrgId='||apobv2.process_organization_id||'&orgId='||apobv2.organization_id||'&pObjectContext=PROCESS_ORG&OA_SubTabIdx=3>ab=3&addBreadCrumb=Y&retainAM=Y' CtrlCntURL from Amw_Process_Org_Relations apor, amw_process_org_basicinfo_v apobv2 where apor.parent_process_id = -1 and apobv2.organization_id = apor.organization_id and apobv2.process_id = apor.child_process_id and apobv2.end_date is null union SELECT null PARENT_PROCESS_NAME, null PARENT_ITEM_TYPE, 'PROCESS' CHILD_PROCESS_NAME, 'AUDITMGR' CHILD_ITEM_TYPE, to_number(null) parent_process_id, -1 child_process_id, to_number(null) INSTANCE_ID, to_number(null) TRANSITION_REVERSE_ORDER, to_number(null) Process_Org_Id, ampo.organization_id Org_Id, null Org_Name, amw_utility_pvt.get_message_text('AMW_ASSIGNED_PROCESSES') Process_Display_Name, -1 Process_Id, 'PROCESS' name, 'AUDITMGR' item_type, null SIGNIFICANT_PROCESS_FLAG, null STANDARD_PROCESS_FLAG, null APPROVAL_STATUS, to_number(null) RISK_COUNT, to_number(null) CONTROL_COUNT, to_number(null) PROCESS_OWNER_ID, null process_owner_name, null Certification_Status_Code, null Certification_Status, null URLString, null RiskCntURL, null CtrlCntURL from wf_activities wa, WF_ACTIVITIES_TL wa_TL, (select distinct organization_id from amw_process_organization) ampo WHERE wa.name = 'PROCESS' and wa.item_type ='AUDITMGR' 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')

View Text - HTML Formatted

SELECT APOBV1.NAME PARENT_PROCESS_NAME
, 'AUDITMGR' PARENT_ITEM_TYPE
, APOBV2.NAME CHILD_PROCESS_NAME
, 'AUDITMGR' CHILD_ITEM_TYPE
, APOR.PARENT_PROCESS_ID PARENT_PROCESS_ID
, APOR.CHILD_PROCESS_ID CHILD_PROCESS_ID
, APOR.INSTANCE_ID INSTANCE_ID
, AMW_WF_HIERARCHY_PKG.FIND_TRANSITION_ORDER(INSTANCE_ID) TRANSITION_REVERSE_ORDER
, APOBV2.PROCESS_ORGANIZATION_ID PROCESS_ORG_ID
, APOBV2.ORGANIZATION_ID ORG_ID
, APOBV2.AUDIT_UNIT ORG_NAME
, APOBV2.DISPLAY_NAME PROCESS_DISPLAY_NAME
, APOBV2.PROCESS_ID PROCESS_ID
, APOBV2.NAME NAME
, APOBV2.ITEM_TYPE ITEM_TYPE
, APOBV2.SIGNIFICANT_PROCESS_FLAG SIGNIFICANT_PROCESS_FLAG
, APOBV2.STANDARD_PROCESS_FLAG STANDARD_PROCESS_FLAG
, APOBV2.APPROVAL_STATUS APPROVAL_STATUS
, APOBV2.RISK_COUNT RISK_COUNT
, APOBV2.CONTROL_COUNT CONTROL_COUNT
, APOBV2.PROCESS_OWNER_ID PROCESS_OWNER_ID
, APOBV2.PARTY_NAME PROCESS_OWNER_NAME
, APOBV2.CERTIFICATION_STATUS CERTIFICATION_STATUS_CODE
, AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_STATUS(APOR.CHILD_PROCESS_ID
, APOBV2.ORGANIZATION_ID
, 'CERTIFICATION') CERTIFICATION_STATUS
, 'OA.JSP?OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=0&ADDBREADCRUMB=Y&RETAINAM=Y' URLSTRING
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=2>AB=2&ADDBREADCRUMB=Y&RETAINAM=Y' RISKCNTURL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=3>AB=3&ADDBREADCRUMB=Y&RETAINAM=Y' CTRLCNTURL
FROM AMW_PROCESS_ORG_RELATIONS APOR
, AMW_PROCESS_ORG_BASICINFO_V APOBV1
, AMW_PROCESS_ORG_BASICINFO_V APOBV2
WHERE APOBV1.ORGANIZATION_ID = APOR.ORGANIZATION_ID
AND APOBV1.PROCESS_ID = APOR.PARENT_PROCESS_ID
AND APOBV2.ORGANIZATION_ID = APOR.ORGANIZATION_ID
AND APOBV2.PROCESS_ID = APOR.CHILD_PROCESS_ID
AND APOBV1.END_DATE IS NULL
AND APOBV2.END_DATE IS NULL UNION SELECT 'PROCESS' PARENT_PROCESS_NAME
, 'AUDITMGR' PARENT_ITEM_TYPE
, APOBV2.NAME CHILD_PROCESS_NAME
, 'AUDITMGR' CHILD_ITEM_TYPE
, APOR.PARENT_PROCESS_ID PARENT_PROCESS_ID
, APOR.CHILD_PROCESS_ID CHILD_PROCESS_ID
, APOR.INSTANCE_ID INSTANCE_ID
, AMW_WF_HIERARCHY_PKG.FIND_TRANSITION_ORDER(INSTANCE_ID) TRANSITION_REVERSE_ORDER
, APOBV2.PROCESS_ORGANIZATION_ID PROCESS_ORG_ID
, APOBV2.ORGANIZATION_ID ORG_ID
, APOBV2.AUDIT_UNIT ORG_NAME
, APOBV2.DISPLAY_NAME PROCESS_DISPLAY_NAME
, APOBV2.PROCESS_ID PROCESS_ID
, APOBV2.NAME NAME
, APOBV2.ITEM_TYPE ITEM_TYPE
, APOBV2.SIGNIFICANT_PROCESS_FLAG SIGNIFICANT_PROCESS_FLAG
, APOBV2.STANDARD_PROCESS_FLAG STANDARD_PROCESS_FLAG
, APOBV2.APPROVAL_STATUS APPROVAL_STATUS
, APOBV2.RISK_COUNT RISK_COUNT
, APOBV2.CONTROL_COUNT CONTROL_COUNT
, APOBV2.PROCESS_OWNER_ID PROCESS_OWNER_ID
, APOBV2.PARTY_NAME PROCESS_OWNER_NAME
, APOBV2.CERTIFICATION_STATUS CERTIFICATION_STATUS_CODE
, AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_STATUS(APOR.CHILD_PROCESS_ID
, APOBV2.ORGANIZATION_ID
, 'CERTIFICATION') CERTIFICATION_STATUS
, 'OA.JSP?OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=0&ADDBREADCRUMB=Y&RETAINAM=Y' URLSTRING
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=2>AB=2&ADDBREADCRUMB=Y&RETAINAM=Y' RISKCNTURL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||APOBV2.PROCESS_ID||'&PROCESSORGID='||APOBV2.PROCESS_ORGANIZATION_ID||'&ORGID='||APOBV2.ORGANIZATION_ID||'&POBJECTCONTEXT=PROCESS_ORG&OA_SUBTABIDX=3>AB=3&ADDBREADCRUMB=Y&RETAINAM=Y' CTRLCNTURL
FROM AMW_PROCESS_ORG_RELATIONS APOR
, AMW_PROCESS_ORG_BASICINFO_V APOBV2
WHERE APOR.PARENT_PROCESS_ID = -1
AND APOBV2.ORGANIZATION_ID = APOR.ORGANIZATION_ID
AND APOBV2.PROCESS_ID = APOR.CHILD_PROCESS_ID
AND APOBV2.END_DATE IS NULL UNION SELECT NULL PARENT_PROCESS_NAME
, NULL PARENT_ITEM_TYPE
, 'PROCESS' CHILD_PROCESS_NAME
, 'AUDITMGR' CHILD_ITEM_TYPE
, TO_NUMBER(NULL) PARENT_PROCESS_ID
, -1 CHILD_PROCESS_ID
, TO_NUMBER(NULL) INSTANCE_ID
, TO_NUMBER(NULL) TRANSITION_REVERSE_ORDER
, TO_NUMBER(NULL) PROCESS_ORG_ID
, AMPO.ORGANIZATION_ID ORG_ID
, NULL ORG_NAME
, AMW_UTILITY_PVT.GET_MESSAGE_TEXT('AMW_ASSIGNED_PROCESSES') PROCESS_DISPLAY_NAME
, -1 PROCESS_ID
, 'PROCESS' NAME
, 'AUDITMGR' ITEM_TYPE
, NULL SIGNIFICANT_PROCESS_FLAG
, NULL STANDARD_PROCESS_FLAG
, NULL APPROVAL_STATUS
, TO_NUMBER(NULL) RISK_COUNT
, TO_NUMBER(NULL) CONTROL_COUNT
, TO_NUMBER(NULL) PROCESS_OWNER_ID
, NULL PROCESS_OWNER_NAME
, NULL CERTIFICATION_STATUS_CODE
, NULL CERTIFICATION_STATUS
, NULL URLSTRING
, NULL RISKCNTURL
, NULL CTRLCNTURL
FROM WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WA_TL
, (SELECT DISTINCT ORGANIZATION_ID
FROM AMW_PROCESS_ORGANIZATION) AMPO
WHERE WA.NAME = 'PROCESS'
AND WA.ITEM_TYPE ='AUDITMGR'
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')