Search Results parent_process_name




Overview
Explore in AI Chat

Overview

APPS.AMW_PROCESS_HIERARCHY_V is a public, VALID Oracle EBS view owned by the APPS schema and registered under FND Design Data as AMW.AMW_PROCESS_HIERARCHY_V. It exposes the parent-child relationships that define the Process Hierarchy maintained by the Application Management Workbench (AMW), the ETRM subsystem used to catalog internal controls, process owners, certifications, audits, and approvals. In Oracle EBS 12.1.1 and 12.2.2 the view is available to custom reporting and integration consumers; the ETRM documentation explicitly classifies it as "a public view which may be useful for custom reporting or other data requirements."

The view is the principal flat representation of the hierarchy, presenting both the parent and child process identifiers and names on a single row so that tree structures can be reconstructed without recursive PL/SQL. The search term parent_process_name corresponds directly to the PARENT_PROCESS_NAME column, which many customers use to group children under their owning parent process in extracts and dashboards.

Underlying Base Objects

According to the dependency information in the ETRM documentation, AMW_PROCESS_HIERARCHY_V is defined over the following objects:

  • AMW_PROCESS — the base AMW process repository, supplying process identifiers, display and non-display names, and descriptive attributes.
  • WF_ACTIVITIES and WF_ACTIVITIES_TL — the Workflow activity definitions and their translated names, used to resolve the process activity type and display names.
  • WF_PROCESS_ACTIVITIES — the Workflow process-to-activity mapping that links processes into a hierarchy.

The view is in turn referenced by AMW_PROCESS_ORG_HIERARCHY_V, AMW_PROC_ORG_HIERARCHY_PVT (dependent code), AMW_WF_HIERARCHY_PKG (dependent code), and AMW_WF_ORG_HIERARCHY_MAIN_V, which makes it a foundational layer for organization-scoped and workflow-driven hierarchy reporting.

Key Columns

Common Use Cases and Queries

Typical uses include parent-child extracts for GRC reporting, certification and audit status roll-ups, ownership reporting by organization, and reconciliation against AMW_PROCESS. The following query lists children under each parent, optionally filtered by parent name:

  • SELECT parent_process_name, process_name, organization, processowner, certification_status FROM apps.amw_process_hierarchy_v WHERE parent_process_name = :p_parent ORDER BY process_name;
  • SELECT parent_nondisp_name, child_nondisp_name, next_audit_date FROM apps.amw_process_hierarchy_v WHERE next_audit_date IS NOT NULL;
  • SELECT organization, parent_process_name, COUNT(*) child_count FROM apps.amw_process_hierarchy_v GROUP BY organization, parent_process_name;

Because the view is public and VALID in both 12.1.1 and 12.2.2, it may be queried directly from reports, BI Publisher data templates, and custom concurrent programs within APPS, subject to standard EBS security conventions and the requirement that AMW/ETRM be licensed and configured.