Results for “wf_description”

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

Overview

JTF_LOOKUPS_BRM_WF_V is a read-only database view owned by the APPS schema within Oracle E-Business Suite. It belongs to the JTF (CRM Foundation) product family and is documented at metadata version 12.2.2, with applicability across 12.1.1 and 12.2.2 environments. The view is purpose-built to support the JTFBRWKB form, a CRM Foundation user interface component that lets administrators select an Oracle Workflow process. Rather than exposing the entire contents of the Workflow runtime repository, the view restricts the returned process list to those item types that have been explicitly enabled for Business Rule Management (BRM) usage through the FND_LOOKUPS lookup type JTF_BRM_WF_ITEM_TYPE.

From a reporting and integration perspective, the view presents a curated list of workflow item types and their runnable processes, accompanied by human-readable descriptions. It therefore serves as a validation and selection source: downstream applications, forms, and custom reports can query this view to obtain only the workflows that the CRM Foundation configuration permits for BRM, avoiding the need to re-implement the lookup filtering logic.

Underlying Base Objects

The view is defined over three documented referenced objects:

• WF_RUNNABLE_PROCESSES_V — a Workflow view that supplies the runnable item types, process names, and display descriptions. It is the primary data source for the three exposed columns.
• FND_LOOKUPS — an Oracle Application Object Library view used in the IN subquery. The view filters against LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE', requiring ENABLED_FLAG = 'Y', and validates both START_DATE_ACTIVE and END_DATE_ACTIVE against SYSDATE so that only currently effective lookup codes qualify.
• FND_GLOBAL — the standard Oracle Applications global context package, referenced as part of the execution environment for the underlying lookup and workflow queries.

Structurally, the view joins Workflow metadata to Application Object Library lookup configuration: only item types whose lookup code is enabled and date-valid at query time are returned. Results are ordered by ITEM_TYPE and PROCESS_NAME, producing a stable, predictable listing.

Key Columns

• WF_ITEM_TYPE — the Workflow item type identifier, drawn from ITEM_TYPE in WF_RUNNABLE_PROCESSES_V. This is the value validated against the JTF_BRM_WF_ITEM_TYPE lookup codes.
• WF_PROCESS_NAME — the name of the runnable process within that item type, from PROCESS_NAME. Together with WF_ITEM_TYPE it uniquely identifies a selectable workflow process.
• WF_DESCRIPTION — the display name or description of the process, sourced from DISPLAY_NAME, intended for presentation in the JTFBRWKB selection UI and in reports.

Because the view is a selection helper, it exposes no primary key of its own; the item type and process name pair serves as the practical composite identifier.

Common Use Cases and Queries

The primary use case is populating the workflow process list in the JTFBRWKB form. Beyond the form, the view supports validation checks, configuration audits, and custom reports that need the permitted BRM workflow set. A typical query listing all selectable processes is:

SELECT WF_ITEM_TYPE, WF_PROCESS_NAME, WF_DESCRIPTION FROM APPS.JTF_LOOKUPS_BRM_WF_V ORDER BY WF_ITEM_TYPE, WF_PROCESS_NAME;

To target a specific item type, add a predicate such as WHERE WF_ITEM_TYPE = :item_type. Because the lookup filter is already embedded, results automatically respect the enabled flag and active date ranges of the JTF_BRM_WF_ITEM_TYPE lookups, so no additional FND_LOOKUPS join is required. This makes the view a reliable, self-contained source for retrieving the effective BRM workflow processes in an Oracle EBS 12.1.1 or 12.2.2 instance.