Search Results rl_process_rev_id




Overview
Explore in AI Chat

Overview

APPS.AMW_CURR_APPROVED_REV_ORG_V is a multilingual (language-resolved) view in the Oracle E-Business Suite Applications (APPS) schema, registered under FND Design Data as AMW.AMW_CURR_APPROVED_REV_ORG_V. It belongs to the Oracle Enterprise Governance, Risk, and Compliance (EGRC / GRC) product family and is classified as a view for current approved organization process revisions. In practice, the view exposes the set of organization-level process revisions that have reached an approved state, joining process definition metadata to organizational context and to aggregated control and risk counts. Because it is a multilingual view, the display name and description columns are resolved against the session language in the same manner as other AMW language views, so consumers receive their translated values without needing to write language joins themselves.

The view is most relevant to ETRM / GRC reporting and integration scenarios where downstream logic needs a single, filtered source of currently active, approved process revisions for an operating unit or organization. It abstracts the underlying revision and approval lifecycle, presenting only those rows that represent current approval status together with certification and audit status indicators.

Underlying Base Objects

The documented ETRM metadata lists no referenced base objects for this view; the View Source section enumerates only the projected columns and does not publish the FROM clause. Based on the AMW naming conventions and the column set, the view is defined over the process revision and organization linkage structures within the AMW schema — most notably the organization process revision entity (surfaced through PROCESS_ORG_REV_ID) and the associated process definition and multilingual (AMW_*_TL) translation tables that supply DISPLAY_NAME and DESCRIPTION.

The view's defining characteristic is its filter: it returns only current, approved revisions, so base revision tables may contain many more rows than are visible here. The RL_PROCESS_REV_ID column (Risk Library Process Revision Id) is the link that connects a revision projected by this view back to the risk library process revision, which is why searches for "rl_process_rev_id" surface this object.

Key Columns

Common Use Cases and Queries

Typical uses include approval-status dashboarding, control/risk coverage reporting by organization, and validating whether a given risk library process revision has an approved organization-level counterpart. The following query maps a risk library process revision to its approved organization revision:

  • SELECT process_org_rev_id, rl_process_rev_id, display_name, organization_id, approval_status, certification_status, control_count, risk_count FROM apps.amw_curr_approved_rev_org_v WHERE rl_process_rev_id = :rl_process_rev_id;
  • SELECT organization_id, process_category, COUNT(*) approved_revisions FROM apps.amw_curr_approved_rev_org_v GROUP BY organization_id, process_category;
  • SELECT display_name, next_audit_date FROM apps.amw_curr_approved_rev_org_v WHERE significant_process_flag = 'Y' ORDER BY next_audit_date;

Because the view is already constrained to current approved revisions, consuming reports should not re-apply approval filters; adding redundant predicates can exclude valid rows when approval semantics change between releases.