Results for “jtf_brm_wf_item_type”

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

Overview

APPS.JTF_BRM_WF_ATTR_V is a reporting and integration view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes the attributes of Oracle Workflow activities together with their currently persisted attribute values. It joins the Workflow activity attribute definitions found in WF_ACTIVITY_ATTRIBUTES_VL with the runtime values stored in JTF_BRM_WF_ATTR_VALUES, and resolves formatted display values through the JTF_BRM_UTILITY_PVT package. The view is owned by APPS and is typically accessed by CRM/Interaction Center components and by custom reporting that needs to present workflow activity configuration and data values in a single, denormalized result set.

The user search term "activity_version" is central to this view. The view deliberately restricts itself to the latest definition of each activity attribute by comparing wal.activity_version against a correlated subquery returning MAX(wf2.activity_version), so that only the newest version of an attribute definition is surfaced. The version is then propagated through the wf_process_version column.

Underlying Base Objects

The documented base objects referenced by this view are FND_LOOKUP_VALUES (SYNONYM), JTF_BRM_UTILITY_PVT (PACKAGE), JTF_BRM_WF_ATTR_VALUES (SYNONYM), and WF_ACTIVITY_ATTRIBUTES_VL (VIEW). FND_LOOKUP_VALUES is filtered on lookup_type 'JTF_BRM_WF_ITEM_TYPE' and USERENV('LANG'), and is used to restrict the result to workflow item types that are valid for the JTF/CRM context. JTF_BRM_WF_ATTR_VALUES holds the stored attribute values (text_value, number_value, date_value) keyed by item type, activity name, activity version, and attribute name. WF_ACTIVITY_ATTRIBUTES_VL supplies the attribute metadata: item type, activity name, attribute name, display name, description, type, format, defaults, and activity version. JTF_BRM_UTILITY_PVT.Attribute_Format converts the raw or defaulted value into a formatted attribute value. The view is assembled as a UNION ALL of two branches, the second emitting NULL placeholders for wf_attr_value_id and wf_process_id.

Key Columns

• ROW_ID — the row identifier from the Workflow activity attribute definition (wal.row_id).
• WF_ATTR_VALUE_ID, WF_PROCESS_ID — surrogate identifiers from JTF_BRM_WF_ATTR_VALUES; NULL in the second union branch.
• WF_ITEM_TYPE — the workflow item type (wal.activity_item_type), restricted to values in the JTF_BRM_WF_ITEM_TYPE lookup.
• WF_PROCESS_NAME — the workflow activity name (wal.activity_name).
• WF_PROCESS_VERSION — the activity version (wal.activity_version), limited to the maximum version per item type and activity.
• WF_ATTRIBUTE_NAME, WF_ATTRIBUTE_DISPLAY_NAME, WF_ATTRIBUTE_DESCRIPTION — attribute metadata.
• WF_ATTRIBUTE_TYPE, WF_ATTRIBUTE_FORMAT — attribute data type and format mask.
• WF_ATTRIBUTE_VALUE — the formatted value returned by JTF_BRM_UTILITY_PVT.Attribute_Format, coalescing stored values with defaults.
• TEXT_VALUE, NUMBER_VALUE, DATE_VALUE — the raw stored values from JTF_BRM_WF_ATTR_VALUES.

Common Use Cases and Queries

Typical uses include listing the attributes and values for the current version of a workflow activity, building CRM configuration reports, and auditing which attribute values are persisted versus defaulted. Because the view selects only the maximum activity_version, queries do not need to filter on version unless a specific historical version is required.

SELECT wf_item_type,
       wf_process_name,
       wf_process_version,
       wf_attribute_name,
       wf_attribute_value
FROM   apps.jtf_brm_wf_attr_v
WHERE  wf_item_type = :p_item_type
AND    wf_process_name = :p_activity_name
ORDER  BY wf_attribute_name;

To isolate attributes whose values come only from defaults, filter on the raw value columns being NULL:

SELECT wf_attribute_name, wf_attribute_value
FROM   apps.jtf_brm_wf_attr_v
WHERE  text_value IS NULL
AND    number_value IS NULL
AND    date_value IS NULL;

Because the view exposes activity_version, it is also convenient for verifying that the definitions in use correspond to the newest Workflow version available for a given item type and activity.