Search Results process_category_code




Overview
Explore in AI Chat

Overview

AMW_INACTIVE_REV_ORG_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the AMW – Internal Controls Manager product family. Its documented purpose is to expose end-dated (inactive) process revisions associated with an organization, allowing implementers and auditors to query historical—rather than currently effective—revision records without filtering the full transaction tables manually.

The view is defined over two base objects: AMW_PROCESS_ORGANIZATION and AMW_PROCESS_NAMES_TL. It is a pure query object—no DML is supported—and is typically consumed by audit reporting, compliance dashboards, and custom extracts that must distinguish retired process revisions from active ones. The object name itself references the "inactive" scope, which is enforced through the WHERE clause rather than through a dedicated column.

The view status is documented as VALID, and it is exposed in both 12.1.1 and 12.2.2 as a translated view (the _TL suffix on the joined table indicates multilingual support).

Underlying Base Objects

Two AMW tables form the data foundation:

  • AMW_PROCESS_ORGANIZATION (aliased A) — the primary table, holding the process/organization revision records, counts, statuses, and date fields.
  • AMW_PROCESS_NAMES_TL (aliased AP_TL) — the translated names table supplying DISPLAY_NAME and DESCRIPTION, joined on PROCESS_REV_ID.

The join condition is AP_TL.PROCESS_REV_ID = A.RL_PROCESS_REV_ID combined with AP_TL.LANGUAGE = USERENV('LANG'), so display text is returned for the session language. The view is restricted to inactive revisions via three NOT NULL predicates: A.APPROVAL_END_DATE IS NOT NULL, A.APPROVAL_DATE IS NOT NULL, and A.END_DATE IS NOT NULL. Only revisions that have both been approved and subsequently end-dated appear, which is what qualifies them as inactive.

Key Columns

The view exposes thirty columns. The most relevant include:

Common Use Cases and Queries

Typical scenarios include auditing retired revisions, reconciling historical control coverage, and building reports of processes that lapsed by end date.

SELECT process_org_rev_id, process_code, display_name,
       revision_number, start_date, end_date, approval_end_date
  FROM apps.amw_inactive_rev_org_v
 WHERE organization_id = :org_id
   AND end_date >= :from_date
 ORDER BY end_date DESC;

To count inactive revisions per process:

SELECT process_code, COUNT(*) inactive_revisions
  FROM apps.amw_inactive_rev_org_v
 GROUP BY process_code;

Because the view joins the translated names table, ensure the reporting session's LANGUAGE is set correctly; otherwise display text may return null.