Search Results wa2_tl

Overview

APPS.AMW_WF_PROCESS_HIERARCHY_VL is a view in the Oracle E-Business Suite Application Management (AMW) schema that exposes the hierarchical relationship between Oracle Workflow processes and the sub-processes (activities of type PROCESS) that they invoke. It is a "VL" (view with language) object, meaning its definition joins to a translation table so that translatable attributes are returned in the session's language rather than only in the base language.

The view answers a common design-time and support question: which workflow processes call which other workflow processes, and what is the user-facing name and description of each called sub-process? Because the display name and description are resolved through WF_ACTIVITIES_TL using USERENV('LANG'), the view is localized and is suitable for building user-facing reports, process hierarchy diagrams, and impact-analysis tooling in Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

Although the ETRM metadata records no referenced base objects, the view text documents its sources unambiguously. The view is defined over four Workflow tables:

• WF_PROCESS_ACTIVITIES (aliased WPA) — the driving table, linking a process to its component activities, including their item type, name, version, and instance_id.
• WF_ACTIVITIES (aliased WA1) — the parent process definition; the join requires the parent record be current (END_DATE IS NULL).
• WF_ACTIVITIES (aliased WA2) — the child activity definition, filtered to TYPE = 'PROCESS' and END_DATE IS NULL, so only active sub-processes are returned.
• WF_ACTIVITIES_TL (aliased WA2_TL) — the translation table supplying DISPLAY_NAME and DESCRIPTION, joined on name, item type, version, and the session language.

The joins traverse item type, name, and version, which is the natural composite key of the Workflow activity model. The absence of END_DATE filters means the view reflects only currently effective definitions, an important consideration when auditing historical process versions.

Key Columns

• PROCESS_ITEM_TYPE, PROCESS_NAME — identify the calling (parent) workflow process.
• ACTIVITY_ITEM_TYPE, ACTIVITY_NAME — identify the called sub-process activity within the parent.
• ACTIVITY_DISPLAY_NAME — the translated, user-facing name of the sub-process (from wa2_tl.display_name).
• ACTIVITY_DESCRIPTION — the translated description of the sub-process (from wa2_tl.description).
• INSTANCE_ID — the workflow process activity instance identifier, useful for correlating with runtime activity data.

Common Use Cases and Queries

Typical uses include documentation of process hierarchies, identifying all sub-processes invoked by a given parent, and tracing where a reusable sub-process is referenced. A representative query filtering by parent item type:

• SELECT process_name, activity_name, activity_display_name, activity_description FROM apps.amw_wf_process_hierarchy_vl WHERE process_item_type = :item_type ORDER BY process_name, activity_name;

To locate all parents that call a specific sub-process:

• SELECT process_item_type, process_name, activity_display_name FROM apps.amw_wf_process_hierarchy_vl WHERE activity_name = :sub_process_name;

Because the view resolves translations via USERENV('LANG'), output adapts to the session language, making it well suited for multilingual deployments in 12.1.1 and 12.2.2.