Search Results child_control_count




Overview
Explore in AI Chat

Overview

The view APPS.AMW_LEGAL_HIER_V exposes the legal hierarchy of a company's value sets as used by the Oracle E-Business Suite (EBS) Enterprise Governance, Risk, and Compliance (EGRC) / Audit Management module (AMW). It presents a flattened representation of the parent-child relationships defined between flex values in a Key Flexfield value set, specifically those value sets configured as subsidiaries for audit units. The view is central to legal-entity hierarchy reporting used by the Audit Management workbench, where users navigate from a parent company value down through its subsidiary companies.

Because the hierarchy is derived from the standard FND flex value infrastructure, the view serves as an integration point between EBS General Ledger value sets and the EGRC data model. It is a UNION query designed to emit both root values (companies with no parent) and child values (companies nested beneath a parent), while also flagging each row with a LINE_TYPE of 'COMPANY'.

Underlying Base Objects

The view is defined over the following FND foundation objects:

No base tables are documented as directly referenced by the ETRM metadata; the view operates entirely through these FND views and the AMW audit-units view.

Key Columns

Common Use Cases and Queries

Typical usage retrieves the legal hierarchy for a given subsidiary value set, or resolves the parent of a specific child company. Because CHILD_ORDER_NUMBER is exposed (though currently null), callers who filter or sort on that column will receive consistent structural results.

Sample query for all company rows in a value set:

  • SELECT child_value, child_display_name, parent_value, line_type FROM apps.amw_legal_hier_v WHERE flex_value_set_id = :set_id ORDER BY parent_value, child_order_number;

Sample query for root companies only:

  • SELECT child_value, child_display_name FROM apps.amw_legal_hier_v WHERE flex_value_set_id = :set_id AND parent_value IS NULL;

These patterns support legal-entity roll-up reporting, subsidiary selection in audit scheduling, and hierarchical prompting in the EGRC user interface.