Search Results ap_tl




Overview
Explore in AI Chat

Overview

APPS.AMW_LATEST_REV_ORG_V is a multilingual (language-resolved) database view owned by the APPS schema and registered under the FND Design Data reference AMW.AMW_LATEST_REV_ORG_V. Its documented purpose is to expose all latest revisions of organization processes within the Oracle E-Business Suite environment, specifically in support of the Enterprise Risk and Compliance Management (ETRM) modules delivered in releases 12.1.1 and 12.2.2. Rather than requiring report authors and integrators to resolve revision history manually, the view presents the most current revision of each process-organization combination, making it suitable for dashboards, compliance reporting, and downstream interfaces.

The view carries a status of VALID. Because it is described as a language-resolved view, its DISPLAY_NAME and DESCRIPTION values are returned in the session's current language, allowing multilingual deployments to present localized process names and descriptions without additional translation logic in the calling application.

Underlying Base Objects

The ETRM documentation metadata for this view does not enumerate specific referenced base objects; the "Referenced base objects" section is recorded as none documented. In practice, the view is constructed over the ETRM process and process-organization revision tables and related risk and control count aggregations. The prefix AMW corresponds to the application module for enterprise risk and compliance, and the naming convention indicates a join between the process revision entity and the organization assignment entity, filtered to return only the latest revision per organization.

Because the documented column set is complete and stable, consumers should treat the view as the supported access path and avoid querying the underlying revision tables directly, as internal joins and latest-revision filtering are encapsulated within the view definition.

Key Columns

Common Use Cases and Queries

Typical use cases include compliance status reporting, audit scheduling, and organization-level risk and control summaries. Because the view already resolves to the latest revision, reports do not need MAX(REVISION_NUMBER) logic.

Processes by category for a given organization:

SELECT process_code, process_category_code, display_name, revision_number
FROM   apps.amw_latest_rev_org_v
WHERE  organization_id = :org_id
AND    process_category_code = :category_code
ORDER BY display_name;

Compliance status summary per category:

SELECT process_category_code,
       COUNT(*)                      AS process_count,
       SUM(risk_count)               AS total_risks,
       SUM(control_count)            AS total_controls
FROM   apps.amw_latest_rev_org_v
WHERE  significant_process_flag = 'Y'
GROUP BY process_category_code;

Upcoming audits by organization and category:

SELECT process_code, display_name, last_audit_status, next_audit_date
FROM   apps.amw_latest_rev_org_v
WHERE  next_audit_date IS NOT NULL
AND    next_audit_date <= SYSDATE + 30
ORDER BY next_audit_date;