Results for “application_usg”

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

Overview

AHL_WF_MAPPING_V is an APPS-owned database view within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment, belonging to the AHL product family, which supports Complex Maintenance Repair and Overhaul. The view is documented with a VALID status and serves to store the query used to retrieve Workflow information. In practical terms, it joins the AHL Workflow mapping configuration table against the Workflow runnable processes view and the FND lookup values view to present a consolidated, readable list of Workflow process definitions that may be invoked for approval and routing purposes.

The object is frequently encountered by developers and administrators who search for WF_RUNNABLE_PROCESSES_V, because that Workflow view is one of the three referenced base objects underlying AHL_WF_MAPPING_V. The mapping view effectively resolves the relationship between the AHL application usage codes and the underlying Workflow item types and process names, exposing a denormalized result set suitable for reporting, integration, and validation of Workflow configuration.

Underlying Base Objects

The ETRM 12.2.2 metadata documents three referenced base objects for this view:

• AHL_WF_MAPPING (SYNONYM) — the primary configuration table that stores Workflow mapping records, including the item type, process name, application usage code, approval object, and active flag.
• FND_LOOKUP_VALUES_VL (VIEW) — the standard Oracle Applications lookup view, used here to translate the stored APPLICATION_USG_CODE into its descriptive MEANING for the lookup type AHL_APPLICATION_USAGE_CODE.
• WF_RUNNABLE_PROCESSES_V (VIEW) — the Oracle Workflow view listing runnable processes, supplying the DISPLAY_NAME and the item type/process name used for the case-insensitive join against the AHL mapping table.

The view text is composed of the union of two subqueries. The first joins all three objects and returns a populated DISPLAY_NAME derived from WRPV.DISPLAY_NAME. The second subquery returns only those AHL mapping rows where both ITEM_TYPE and WF_PROCESS_NAME are null, substituting a single blank space for the display name. Both branches apply an outer join to the lookup view, so a missing lookup value does not suppress the row.

Key Columns

• WF_MAPPING_ID — primary identifier of the AHL Workflow mapping record.
• OBJECT_VERSION_NUMBER — optimistic locking version number.
• APPLICATION_USG_CODE — the code identifying the AHL application usage context.
• APPLICATION_USG — the decoded meaning of the application usage code, aliased from FND_LOOKUP_VALUES_VL.MEANING.
• WF_PROCESS_NAME — the Workflow process name associated with the mapping.
• ACTIVE_FLAG — indicates whether the mapping is currently enabled.
• APPROVAL_OBJECT — the object subject to Workflow approval.
• DISPLAY_NAME — the human-readable process name from WF_RUNNABLE_PROCESSES_V; blank for null-type mappings.
• ITEM_TYPE — the Workflow item type key.

Common Use Cases and Queries

The view is typically queried to audit which Workflow processes are mapped for AHL and whether they remain active. A basic listing follows:

SELECT WF_MAPPING_ID, ITEM_TYPE, WF_PROCESS_NAME,
       DISPLAY_NAME, APPLICATION_USG, ACTIVE_FLAG
FROM   APPS.AHL_WF_MAPPING_V
WHERE  ACTIVE_FLAG = 'Y';

To trace a specific Workflow item type back to its mapping and usage context:

SELECT APPLICATION_USG, WF_PROCESS_NAME, APPROVAL_OBJECT
FROM   APPS.AHL_WF_MAPPING_V
WHERE  UPPER(ITEM_TYPE) = UPPER(:p_item_type);

Because the view already incorporates the case-insensitive comparison against WF_RUNNABLE_PROCESSES_V, it is useful for verifying that each configured mapping resolves to a runnable Workflow process, and for identifying rows with a blank DISPLAY_NAME that indicate the null-type mapping branch.