Search Results amw_wf_org_hierarchy_main_v




Overview
Explore in AI Chat

Overview

AMW_WF_ORG_HIERARCHY_MAIN_V is a database view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMW (Internal Controls Manager) product family. Its documented purpose is to return details of the Parent–Child Process Hierarchy within an organization context. In practice, the view flattens the Workflow-based process hierarchy maintained by Internal Controls Manager and joins it to process definitions so that each returned row expresses a single parent-to-child relationship, together with the descriptive, ownership, risk, control, and certification attributes of the referenced process. This makes the view particularly relevant to searches involving the term "process_org", because a dedicated PROCESS_ORG_ID column identifies the Process Organization against which each hierarchy relationship is evaluated.

The view serves as a reporting and integration layer rather than a transaction-processing object. It is commonly consumed by OAF-based pages, BI Publisher reports, and custom extracts that need to present process hierarchies per organization without directly navigating the AMW base tables and workflow activity structures.

Underlying Base Objects

The ETRM metadata for this view documents no referenced base objects explicitly; however, the view text itself reveals its dependency set. The parent and child legs of the hierarchy are derived from workflow process activity structures (aliased WPA) and are resolved to process identity through AMWP1 and AMWP2, which supply PARENT_PROCESS_ID and CHILD_PROCESS_ID respectively. The principal descriptive source is a process-organization table aliased AMPO, which contributes organization, process, owner, risk, control, approval, and certification attributes. A lookup table (aliased AMWLKUP) translates certification status codes into user-facing meanings, and a package function, AMW_WF_HIERARCHY_PKG.FIND_TRANSITION_ORDER, is invoked to compute the TRANSITION_REVERSE_ORDER for a given instance.

Key Columns

Common Use Cases and Queries

Typical scenarios include reporting the parent-child process tree for a specific organization, retrieving owner and certification details for process hierarchy nodes, and building navigation links directly into the Process Details OAF page. A representative query filtering by process organization is:

  • SELECT parent_process_name, child_process_name, process_org_id, org_name, process_owner_name, certification_status FROM apps.amw_wf_org_hierarchy_main_v WHERE process_org_id = :p_process_org_id ORDER BY transition_reverse_order;
  • SELECT process_display_name, risk_count, control_count, significant_process_flag FROM apps.amw_wf_org_hierarchy_main_v WHERE org_id = :p_org_id AND process_id <> -1;

Because the view embeds both hierarchy relationships and process-organization attributes, it is well suited to ad hoc hierarchy extraction, certification status monitoring, and integration feeds that require process context scoped to a Process Organization.