Search Results action_seq

Overview

CZ_GROUPED_ACTION_TYPES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, belonging to the CZ (Configurator) product family. It presents a hierarchical, denormalized representation of configurator action types, organized by action group. In the Configurator data model, individual action types are stored as lookup values registered under a lookup list, while their grouping — such as display/update, model interaction, navigation, and session control — is derived from the ACTION_TYPE_GROUP lookup list. The view combines both levels into a single flattened result set, exposing the group attributes alongside the member action attributes. This makes it a convenient reporting and integration surface: rather than joining and decoding two separate lookup queries, developers and report authors can SELECT from one view. The view is particularly relevant when investigating the column ACTION_DESCRIPTION, which returns a description for each action. Its role is primarily informational — it supplies metadata used by Configurator runtime processing, diagnostics, and custom extensions that need to enumerate the available actions and their groupings without directly interrogating the lookup tables.

Underlying Base Objects

The documented base object for this view is CZ_LOOKUP_VALUES_VL, itself a view over the Configurator lookup value infrastructure. CZ_GROUPED_ACTION_TYPES_V references CZ_LOOKUP_VALUES_VL twice within its defining query. The first reference, aliased GRP, filters rows with LIST_NAME = 'ACTION_TYPE_GROUP' to obtain the action group definitions. The second reference, aliased ACT, supplies the individual action types whose LIST_NAME matches the derived group name. The join between the two is an outer join: GRP.ACTION_GROUP_NAME = ACT.LIST_NAME (+), so a group is returned even when it currently has no member actions. The group name itself is not stored literally; it is produced by a DECODE on the group's DATA_VALUE that translates values such as DISPLAY_UPDATE, MODEL_INTERACTION, NAVIGATION, and SESSION_CONTROL into the corresponding lookup list names ACTION_DISPLAY_UPDT, ACTION_MODEL_INTER, ACTION_NAV, and ACTION_SESSION_CTRL. Because the view is defined exclusively over lookup views, it is language-sensitive: the LANGUAGE and SOURCE_LANG columns are surfaced from the action-level lookup rows, supporting multilingual (translated) descriptions and labels.

Key Columns

• ACTION_GROUP_LIST_NAME — the top-level lookup list name (ACTION_TYPE_GROUP) from which the grouping originates.
• ACTION_GROUP_NAME — the decoded list name for the group, such as ACTION_DISPLAY_UPDT or ACTION_NAV.
• ACTION_GROUP_NUMERIC_VALUE, ACTION_GROUP_DATA_TYPE, ACTION_GROUP_NULL_FLAG — metadata describing the group's numeric identifier, expected data type, and nullability.
• ACTION_GROUP_LABEL, ACTION_GROUP_DESCRIPTION — the display label and description of the group.
• ACTION_SEQ / ACTION_CODE / ACTION_NAME — the sequence, code, and name of each member action, resolved via NVL so that the group's own values act as defaults when no action row exists.
• ACTION_DATA_TYPE, ACTION_LABEL — the effective data type and label of the action.
• ACTION_DESCRIPTION — the effective description for the action, computed as NVL(ACT.VALUE_DESCRIPTION, ACTION_GROUP_DESCRIPTION). This column is the one most commonly searched by users inspecting action metadata, since it centralizes the descriptive text that would otherwise require a lookup join.
• ACTION_NOTES, LANGUAGE, SOURCE_LANG — supplementary notes and the language context of the underlying lookup rows.

Common Use Cases and Queries

The view is typically used to enumerate the configurator's action catalog, to drive validation or documentation reports, and to provide pick-list data for extensions. A straightforward query retrieves all actions with their descriptions:

SELECT action_group_name, action_name, action_label, action_description FROM apps.cz_grouped_action_types_v ORDER BY action_group_seq, action_seq;

To find actions belonging to a specific behavior, restrict by group:

SELECT action_name, action_description FROM apps.cz_grouped_action_types_v WHERE action_group_name = 'ACTION_NAV';

Because the view is language-aware, callers filtering on a particular LANGUAGE obtain translated labels and descriptions. Note that the outer join can yield rows where action columns are null — these represent groups with no configured members — so queries should account for that when interpreting results.