Search Results amw_process_organization_vl




Overview
Explore in AI Chat

Overview

AMW_PROCESS_ORGANIZATION_VL is a language-specific (VL) view within the AMW — Internal Controls Manager product, a module now classified as obsolete in Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents complete organization process entities by combining translated, language-specific display values with the operational and control data held against each organization process. Its purpose is to expose a denormalized, presentation-ready row for each process revision belonging to a specific organization, so that forms, reports, and integration interfaces can retrieve the human-readable process name and description alongside the full set of process attributes without performing their own joins to the translation table.

The view is documented in the ETRM metadata with the note that it is not implemented in the reference database, meaning the definition is provided for informational and troubleshooting purposes rather than as an active object in every environment. The description text in the metadata refers to AMW_PROCESS_NAMES_VL; this appears to be a naming inconsistency in the source documentation, since the column list and view text clearly describe an organization process entity rather than a simple process name lookup.

Underlying Base Objects

The view text joins three objects:

  • AMW_PROCESS_ORGANIZATION AOP — the primary driving table, supplying the non-displayed process organization data such as process identifiers, organization, revision, approval, and control counts.
  • AMW_PROCESS AP — joined via an outer join on AP.PROCESS_REV_ID(+) = AOP.RL_PROCESS_REV_ID, providing the standard process indicator.
  • AMW_PROCESS_NAMES_TL APTL — joined on APTL.PROCESS_REV_ID = AOP.RL_PROCESS_REV_ID with a language restriction of APTL.LANGUAGE = USERENV('LANG'), supplying the translated display name and description.

The metadata records no other documented base objects, and the view definition itself is the authoritative source for the join relationships above. An outer join between AMW_PROCESS_ORGANIZATION and AMW_PROCESS allows organization process rows to be returned even when a matching process revision does not exist, while the language join filters rows to the session language.

Key Columns

Common Use Cases and Queries

The view is typically used to produce organization-scoped process listings that display translated names, to feed control and risk summary reports, and to support integration extracts that require owner, approval, and count data in a single query. A representative query retrieves significant processes for an organization with their control counts:

SELECT display_name, process_code, revision_number, approval_status, certification_status, risk_count_latest, control_count_latest FROM amw_process_organization_vl WHERE organization_id = :org_id AND significant_process_flag = 'Y' ORDER BY display_name;

A second pattern lists all processes for which the standard process indicator is set, using the outer-joined AMW_PROCESS data:

SELECT p.organization_id, p.display_name, p.standard_variation, p.control_count, p.risk_count FROM amw_process_organization_vl p WHERE p.standard_process_flag = 'Y' AND p.end_date IS NULL AND p.deletion_date IS NULL;

Because the view enforces APTL.LANGUAGE = USERENV('LANG'), queries return names and descriptions in the language of the connected session. Reports intended for multilingual audiences should therefore either execute under the desired language context or join directly to AMW_PROCESS_NAMES_TL when a specific language must be forced regardless of session settings. Given the obsolete status of the AMW module, these queries should be treated as migration reference material for environments transitioning away from Internal Controls Manager.