Search Results fte_load_details_v

Overview

FTE_LOAD_DETAILS_V is a reporting and integration view in the Oracle E-Business Suite Transportation Execution (FTE) module, exposed in releases 12.1.1 and 12.2.2. It presents the line-level detail of transportation loads, including container, weight, volume, commodity, quantity, and tracking information associated with each load detail record. The view serves as a denormalized, read-only projection of load detail data, intended for inquiry screens, reports, and outbound integrations rather than for transactional data entry.

Because it consolidates physical attributes, commercial references, and shipment status flags into a single row per load detail, the view is well suited to carrier-facing and customer-facing reporting. The user's search term, received_flag, corresponds directly to a column exposed by this view and reflects the receipt confirmation state of a load detail.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the base table FTE_LOAD_DETAILS, selecting a defined set of columns from that table. No additional base tables or joined objects are documented as referenced objects. The view text also invokes the FTE_XML_TRANS_UTIL package function GET_OUT_MAPPING, applied to the CREATED_BY and ADDITIONAL_SERVICES columns to produce the ADDITIONAL_SERVICES output. This function call is the only non-column-based derivation present in the documented definition.

Two columns, VOLUME_QUALIFIER and QUANTITY_QUALIFIER, are literal constants in the view definition ('VOLUME' and 'REQUIRED', respectively) rather than stored values, providing fixed qualifier context for downstream consumers. Notably, the documented metadata records the view as "Not implemented in this database" for the implementation/DBA section, and lists no owner. The strong structural correspondence between the selected column list and the underlying load detail table indicates the view is a straightforward projection with minimal transformation.

Key Columns

• LOAD_DETAIL_ID, PARENT_LOAD_DETAIL_ID, LOAD_ID — Primary identifiers for the load detail and its parent load and parent detail, enabling hierarchical reconstruction of a load.
• CONTAINER_FLAG, CONTAINER_SERIAL_NUMBER, CONTAINER_TYPE, SEAL_CODE — Container and equipment identification attributes.
• TARE_WEIGHT, GROSS_WEIGHT, WEIGHT_UOM, VOLUME, VOLUME_UOM, VOLUME_QUALIFIER — Physical measurement and unit-of-measure data.
• QUANTITY, QUANTITY_UOM, QUANTITY_QUALIFIER, PACKAGE_TYPE, NUM_PACKAGES, MARK_NUMBER — Shipped quantity and packaging detail.
• RECEIVED_QUANTITY, RECEIVED_FLAG, DELIVERED_QUANTITY, DELIVERED_FLAG — Receipt and delivery confirmation data; RECEIVED_FLAG indicates whether the detail has been received, supported by the received quantity value.
• CARRIER_TRACKING_NUMBER, CARRIER_NOTES, CONSIGNEE_NOTES — Tracking and free-text communication fields.
• COMM_PO_NUMBER, COMMODITY_PRICE, CURRENCY_CODE, FREIGHT_CLASS, PRODUCT_CODE, HAZARD_CODE, IMDG_CODE — Commercial, commodity, and hazardous-material classification values.
• SPLIT_FLAG, SPLIT_QUANTITY — Indicators of load detail splitting and the associated split quantity.
• ADDITIONAL_SERVICES — Derived through FTE_XML_TRANS_UTIL.GET_OUT_MAPPING; supports XML/outbound service mapping.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, OPERATOR_ID — Standard audit and operator tracking columns.

Common Use Cases and Queries

The view supports load detail inquiry, receipt and delivery status reporting, and extraction of shipment detail for integration. Because RECEIVED_FLAG is exposed directly, receipt reconciliation queries are straightforward.

• Listing all unreceived load details: SELECT LOAD_ID, LOAD_DETAIL_ID, CARRIER_TRACKING_NUMBER FROM FTE_LOAD_DETAILS_V WHERE RECEIVED_FLAG = 'N';
• Comparing ordered versus received quantities: SELECT LOAD_DETAIL_ID, QUANTITY, RECEIVED_QUANTITY, DELIVERED_QUANTITY FROM FTE_LOAD_DETAILS_V WHERE RECEIVED_QUANTITY <> QUANTITY;
• Extracting container and weight detail for a load: SELECT LOAD_ID, CONTAINER_SERIAL_NUMBER, GROSS_WEIGHT, WEIGHT_UOM FROM FTE_LOAD_DETAILS_V WHERE LOAD_ID = :load_id;
• Retrieving commercial and commodity references: SELECT COMM_PO_NUMBER, PRODUCT_CODE, COMMODITY_PRICE, CURRENCY_CODE FROM FTE_LOAD_DETAILS_V;

As with all ETRM views, query cost and row counts depend on the volume of load detail data, and consumers should filter by LOAD_ID or date columns where possible.