Results for “ship_to_county”

50+ results




Overview
Explore in AI Chat

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

Overview

ECE_MVSTO_LOCATIONS_V is a private, active view owned by the APPS schema and registered under the EC — e-Commerce Gateway product, with an underlying inventory (INV) reporting product designation and a display name of "Movement Statistics Line Location View." Its documented purpose is to extract line location information for the outbound Movement Statistics (INTRASTAT) transaction. INTRASTAT is the statistical reporting system used within the European Union to track the movement of goods between member states, and Oracle EBS implements the corresponding outbound transaction through the e-Commerce Gateway so that qualifying shipment and receipt lines can be reported to the relevant statistical authority.

The view consolidates the three party contexts that participate in a movement statistics line — bill-to, ship-to, and vendor — into a single denormalized row. This is significant for users searching on terms such as ship_to_address1, because the view exposes SHIP_TO_ADDRESS1 directly rather than requiring a join back to HZ_LOCATIONS. The view does not store data; it is purely a read construct, so it is safe to query for extracts, custom reports, and reconciliation without risk of writing to EBS base tables.

Underlying Base Objects

The ETRM documentation for 12.2.2 lists the following referenced base objects: FND_GLOBAL (PACKAGE), HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES (all synonyms), plus the PO_VENDORS and PO_VENDOR_SITES views. The view text joins HZ_PARTIES to HZ_CUST_ACCOUNTS to resolve party name and internal customer identifiers, then to HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL to obtain site-use context, and finally to HZ_LOCATIONS for the address attributes. Vendor-side columns come from PO_VENDORS and PO_VENDOR_SITES. FND_GLOBAL supplies runtime session context such as organization or user, consistent with self-service and gateway extract behavior.

Key Columns

The column set follows a consistent naming convention per party role:

Common Use Cases and Queries

Typical uses include pre-extract validation for the INTRASTAT outbound gateway interface, investigation of missing or malformed addresses that cause gateway rejects, and ad hoc reporting that needs both ship-to and bill-to detail in one row. The following query targets the searched column:

  • SELECT ship_to_name, ship_to_address1, ship_to_city, ship_to_postal_code, ship_to_country FROM apps.ece_mvsto_locations_v WHERE ship_to_address1 IS NULL; — identifies ship-to records lacking a primary address line.
  • SELECT ship_to_code_external, bill_to_code_external, vendor_code_ext FROM apps.ece_mvsto_locations_v WHERE ship_to_postal_code IS NOT NULL; — supports code cross-checking across bill-to, ship-to, and vendor.

Because the view is a read-only projection, developers can safely embed it in BI Publisher datasets and OAF/ADF queries.