Results for “az_context_type”

24 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AZ_PROCESSES_ALL_V is a reporting view owned by the APPS schema in Oracle E-Business Suite. It exposes the process definitions registered against Oracle E-Business Suite's application integration and context framework, presenting the process hierarchy together with the display names, descriptions, and lookup-based context type meanings that make the underlying configuration data human-readable. In the 12.1.1 and 12.2.2 releases, this view is documented in the E-Business Technology Reference Manual (ETRM).

The view functions as the presentation layer for the AZ_PROCESSES entity. Rather than exposing raw foreign keys and status codes, it joins to Workflow activity metadata (WF_ACTIVITIES_VL) and to the AZ_CONTEXT_TYPE lookup (FND_LOOKUPS) so that a process row carries its display name, its description, and the translated meaning of its context type. This makes it suitable for reporting, diagnostics, and integration scripts that need to read process and context configuration without resolving lookup codes manually. Its name carries the _ALL suffix because it is intended for use within an environment where organization or language filtering is not applied at the view level.

Underlying Base Objects

The view is defined over the following documented objects:

  • AZ_PROCESSES (referenced as a synonym) — the driving table holding process definitions, including item type, process name, context identifiers, display order, status, process type, and context type.
  • WF_ACTIVITIES_VL — the Workflow activities view, providing the display name and description for each process and enforcing that only active activities are returned.
  • FND_LOOKUPS — the Oracle Application Object Library lookups view, supplying the meaning of the context type from the AZ_CONTEXT_TYPE lookup type.
  • FND_GLOBAL (package) — referenced in the documented metadata for session context resolution.

Joins are established on item type and process name between AZ_PROCESSES and WF_ACTIVITIES_VL, and on lookup type and lookup code between FND_LOOKUPS and AZ_PROCESSES.CONTEXT_TYPE. Only activities whose item type and name begin with the "AZ" prefix and whose end date is null are returned, restricting the result set to the application context framework's own active definitions.

Key Columns

  • ITEM_TYPE — the Workflow item type to which the process belongs.
  • PROCESS_NAME — the internal identifier of the process.
  • DISPLAY_NAME — the user-facing name of the activity, sourced from WF_ACTIVITIES_VL.
  • CONTEXT_ID / PARENT_ID / DISPLAY_ORDER — identifiers and ordering that define the process hierarchy and its position in the tree.
  • STATUS_CODE — the current status flag of the process definition.
  • PROCESS_TYPE — the classification of the process.
  • CONTEXT_TYPE / CONTEXT_TYPE_NAME — the raw lookup code and its translated meaning from the AZ_CONTEXT_TYPE lookup.
  • CONTEXT_NAME — the context instance or name associated with the process.
  • COMMENTS / DESCRIPTION — free-text annotations from AZ_PROCESSES and WF_ACTIVITIES_VL respectively.

Common Use Cases and Queries

The view is commonly queried to inventory the processes configured for a given item type, to resolve context type lookups into readable meanings, or to validate hierarchy and ordering before deployment. Because it already filters on active "AZ" activities, it is convenient as a diagnostic source when troubleshooting application context behaviour.

  • List all processes for a specific item type, ordered by hierarchy:
    SELECT item_type, process_name, display_name, display_order FROM az_processes_all_v WHERE item_type = :p_item_type ORDER BY display_order;
  • Decode context types for reporting:
    SELECT context_type, context_type_name, COUNT(*) FROM az_processes_all_v GROUP BY context_type, context_type_name;
  • Locate a process by its user-facing name:
    SELECT process_name, context_name, comments FROM az_processes_all_v WHERE display_name LIKE :p_name;

The user search term "az_context_type" maps directly to the CONTEXT_TYPE and CONTEXT_TYPE_NAME columns, which are populated from the AZ_CONTEXT_TYPE lookup applied by this view.