VIEW: APPS.AMW_PROCESS_HIERARCHY_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')