Search Results cln_xml_deliveries_v




Overview
Explore in AI Chat

Overview

CLN_XML_DELIVERIES_V is an Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 database view owned by the APPS schema, with a status of VALID. It belongs to the CLN product family — Supply Chain Trading Connector for RosettaNet — which provides the messaging and XML translation layer that allows EBS to exchange standardized business documents with trading partners via the RosettaNet framework. This particular view assembles the deliveries section of the OAG SHOW_SHIPMENT_005 XML payload, the outbound message used to communicate shipment and delivery details to a partner.

In ETRM/connector terms, the view acts as a denormalized, EDI/XML-ready projection of the underlying Oracle Shipping (WSH) and Trading Community (HZ) data. Rather than emitting raw internal IDs and codes, it resolves and formats the values needed by the OAG schema, including location codes, contact names, addresses, carrier/transport details, and shipper waybill references. It is consumed by the RosettaNet connector when building the SHOW_SHIPMENT_005 message, and is equally usable for ad-hoc queries and custom reports that need shipment delivery detail in an external-facing layout.

Because the view embeds calls to the WSH_ECE_VIEWS_DEF and WSH_UTIL_CORE packages and references location, address, and party data, it is read-only in nature and intended for querying, not for transactional manipulation.

Underlying Base Objects

The view is defined over a set of shipping, location, and party synonyms, joined to resolve the delivery header, its stops, contacts, and destination/shipper addresses. Documented base objects include:

Key Columns

Columns are aliased to match the OAG SHOW_SHIPMENT_005 field names. Note that carrier_name_int, the term that prompted this search, is not exposed as a discrete column in this view's SELECT list; carrier/transport context is instead reflected through the ship method, freight terms, trip, and leg columns below.

Common Use Cases and Queries

Typical uses include troubleshooting outgoing SHOW_SHIPMENT_005 messages, validating destination and trading-partner codes, and building shipment reconciliation reports.

  • Retrieve delivery details for a specific delivery ID and validate the destination address and contact.
  • Confirm transport references (waybill, bill of lading, packing slip) for a delivery before the XML message is generated.
  • Audit trading-partner location codes resolved by the connector.

Sample query:

SELECT document_code, delivery_id, shipper_number, waybill_number, bill_of_lading, destination_name, destination_city, destination_country_int, ship_method_code_int, planned_departure_date FROM apps.cln_xml_deliveries_v WHERE delivery_id = :p_delivery_id;

Because the view applies DISTINCT and joins across many transactional and reference tables, queries should be filtered by delivery ID or date to avoid excessive result sets.