DBA Data[Home] [Help]

VIEW: APPS.AMW_PROCESS_ORG_HIERARCHY_V

Source

View Text - Preformatted

SELECT PARENT_PROCESS_ID, CHILD_PROCESS_ID from AMW_PROCESS_HIERARCHY_V union select -1, amwpobv.top_process_id from amw_process_org_basicinfo_v amwpobv WHERE amwpobv.top_process_id is not null
View Text - HTML Formatted

SELECT PARENT_PROCESS_ID
, CHILD_PROCESS_ID
FROM AMW_PROCESS_HIERARCHY_V UNION SELECT -1
, AMWPOBV.TOP_PROCESS_ID
FROM AMW_PROCESS_ORG_BASICINFO_V AMWPOBV
WHERE AMWPOBV.TOP_PROCESS_ID IS NOT NULL