Search Results amw_process_approval_status




Overview
Explore in AI Chat

Overview

AMW_HIERARCHY_ENTITIES_V is a reporting view in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Enterprise Risk Management (ERM) / Application Management Workspace (AMW) module, the framework supporting Oracle's Governance, Risk, and Compliance (GRC) functionality within EBS 12.1.1 and 12.2.2. The view flattens process definitions stored in the AMW process repository into a hierarchical, denormalized structure suitable for display, integration, and querying. Each row represents a process entity (a hierarchy node) together with its associated attributes: display names, item type, ownership, counts of related risks, controls, and organizations, certification and approval state, and dynamically generated OAF (Oracle Application Framework) URLs that link into the Process Details page.

The view is intended for use by OAF-based pages and by reporting tools such as Oracle Reports, BI Publisher, and ad-hoc SQL. It does not store data itself; it derives all values from AMW base tables and lookup utilities at query time.

Underlying Base Objects

Based on the supplied view text, the defining query selects primarily from the AMW process table aliased amwp (referenced by columns such as PROCESS_ID, PROCESS_REV_ID, PROCESS_CATEGORY, SIGNIFICANT_PROCESS_FLAG, and APPROVAL_STATUS). It joins to WA_TL (Workflow/AMW lookup translation table) via wa_TL.Display_NAME to resolve the translated process display name. Owner and stakeholder party names are resolved through joins to the HZ_PARTIES table using aliases hzp1, hzp2, and hzp3, providing process owner, application owner, and finance owner names respectively. Lookup meanings are resolved at runtime via AMW_Utility_PVT.get_lookup_meaning against the AMW_CERTIFICATION_STATUS, AMW_PROCESS_APPROVAL_STATUS, and AMW_PROCESS_CATEGORY lookup types. The ETRM metadata documents no additional base objects beyond these referenced tables, so downstream consumers should treat the view as a business-facing abstraction rather than a stable physical table.

Key Columns

Common Use Cases and Queries

The view is typically consumed for hierarchy browsing, scoping reports, ownership dashboards, and certification tracking. A common query filters by process category to list all processes in a given AMW_PROCESS_CATEGORY:

SELECT process_id,
       process_display_name,
       process_category,
       process_category_meaning,
       significant_process_flag,
       risk_count,
       control_count,
       approval_status_meaning
  FROM apps.amw_hierarchy_entities_v
 WHERE process_category = :p_category
   AND process_id <> -1;

Ownership reporting uses the denormalized owner names to avoid repeated HZ_PARTIES lookups:

SELECT process_display_name,
       process_owner_name,
       application_owner_name,
       finance_owner_name,
       certification_status
  FROM apps.amw_hierarchy_entities_v
 WHERE certification_status IS NOT NULL;

Because the view emits ready-made URLs, integrations can embed RiskCntURL or CtrlCntURL directly into OAF regions or BI Publisher templates to navigate users to the corresponding Process Details tab. All queries should observe standard APPS schema access conventions, and consumers should be aware that lookup meanings are resolved at runtime and may vary with lookup configuration.