Search Results wshfv_trips




Overview
Explore in AI Chat

Overview

WSHFV_TRIPS is a read-only Business Intelligence System (BIS) business view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the WSH – Shipping Execution product module. It is a "full" BIS business view for trips, meaning it exposes the complete set of translated, key-flex, descriptive-flex, and security attributes associated with the WSH_TRIPS entity in a denormalized, reporting-friendly form. The view is registered as VALID in the ETRM 12.2.2 metadata and is available across 12.1.1 and 12.2.2 releases. Its principal role is to support Oracle Discoverer, BIS workbooks, and downstream integrations by presenting trips with decoded lookup meanings, descriptive flexfield context, and resolved foreign-key descriptions rather than raw coded identifiers. The embedded directives in the view text — such as _LA (lookup attribute), _KF (key flexfield), and _DF (descriptive flexfield) — are interpreted by the BIS layer to generate user-friendly column headings and joins automatically.

Underlying Base Objects

The view is defined over four base objects, all accessed via public synonyms in the APPS schema:

All joins to the vehicle-related tables are outer joins (indicated by the (+) operator), so a trip row is returned even when no vehicle item or organization is defined. The view is filtered with NVL(SHIPMENTS_TYPE_FLAG,'O') IN ('O','M') on both trip aliases, restricting output to outbound and miscellaneous shipment trip types. A row-level security predicate on VEHICLE_ORGANIZATION_ID enforces organization access, and the view is declared WITH READ ONLY.

Key Columns

The most frequently referenced columns include:

Common Use Cases and Queries

A typical integration or reporting query pivots on the vehicle item. To list trips for a given vehicle item:

  • SELECT trip_id, name, vehicle_number, vehicle_description, vehicle_organization_id FROM wshfv_trips WHERE vehicle_item_id = :p_item_id;

To report active trips by status for a warehouse, filter on organization and the decoded status column. To trace trip chaining, self-join on ARRIVE_AFTER_TRIP_ID. Because the view enforces organization security and is read-only, it is safe for use in Discoverer workbooks, OBIEE extracts, and read-only integration interfaces without risk of DML.