Search Results certification_status




Overview
Explore in AI Chat

Overview

AMW_ORG_RELATIONS_V is a reporting view owned by the APPS schema within the AMW – Internal Controls Manager product. Its documented purpose is to store and present information concerning organization relations in the context of Audit Management process hierarchies. The view exposes parent and child process relationships across organizations, together with navigation URLs and computed status attributes, which makes it a convenient single source for reporting on how audit processes are interrelated across the enterprise.

Within the Oracle E-Business Suite 12.1.1 and 12.2.2 file systems, this view is particularly relevant to queries referencing parent_item_type. Although the column is exposed by the view, the view definition itself hard-codes its value as the literal string 'AUDITMGR'. This implies that all rows returned by the view belong to the Audit Management workflow item type, so any user filtering on parent_item_type will effectively be retrieving the full set of parent processes described by the view.

Underlying Base Objects

The view text indicates that AMW_ORG_RELATIONS_V is built over two principal sources:

Additional logic is supplied through calls to AMW_WF_HIERARCHY_PKG.FIND_TRANSITION_ORDER and AMW_UTILITY_PVT.GET_PROC_ORG_OPINION_STATUS, which compute transition ordering and certification status respectively. The metadata does not enumerate further base tables.

Key Columns

The view returns a rich set of columns that blend relationship identifiers with descriptive process information:

Common Use Cases and Queries

A frequent scenario involves locating all parent processes of item type AUDITMGR, which the user targeted with the search term parent_item_type:

SELECT parent_process_name,
       child_process_name,
       org_name,
       certification_status
FROM   apps.amw_org_relations_v
WHERE  parent_item_type = 'AUDITMGR';

Because the item type is a constant, the WHERE clause can be omitted, but retaining it preserves clarity when the query is copied between environments or extended with joins to other AMW objects. Other practical uses include identifying all children under a given parent process, extracting the navigation URLs for embedding in custom OAF or JSP pages, and reporting on certification coverage across organizations using CERTIFICATION_STATUS alongside ORG_NAME. The view is also well suited to building hierarchical audit-process reports when joined with risk or control count aggregates.