Search Results oe_ak_ship_from_orgs_v




Overview
Explore in AI Chat

Overview

OE_AK_SHIP_FROM_ORGS_V is a seeded Oracle E-Business Suite view owned by the APPS schema and validated in both release 12.1.1 and 12.2.2. It belongs to the Order Management (ONT) product family and forms part of the Oracle Application Framework toolkit layer used by Order Management forms and self-service pages to supply ship-from organization and address information. The view exposes a denormalized, read-only projection of the ship-from organization address data held in the underlying OE_SHIP_FROM_ORGS_V view, presenting the organization name, identifier, and the address attributes most commonly needed by order entry, shipping, and warehouse selection logic.

Rather than querying warehouse and location tables directly, the view consolidates organization identity and postal address details into a single row per ship-from organization, filtered at runtime by Oracle Application Object Library security. This makes it a convenient data source for reporting tools, concurrent programs, and integrations that need to list valid shipping organizations and their originating addresses without reconstructing the joins themselves.

Underlying Base Objects

The view text is a straightforward projection: it selects NAME, ORGANIZATION_ID, LOCATION_CODE, ADDRESS_LINE_1 through ADDRESS_LINE_3, REGION_1 through REGION_3, TOWN_OR_CITY, POSTAL_CODE, COUNTRY, and LOCATION_ID from OE_SHIP_FROM_ORGS_V. It performs no joins, aggregations, or filtering of its own.

The documented metadata lists the referenced base objects as HR_GENERAL (PACKAGE), HR_SECURITY (PACKAGE), and OE_SHIP_FROM_ORGS_V (VIEW). The two package references are significant: HR_SECURITY supplies the organization security policy applied by OE_SHIP_FROM_ORGS_V, enforcing the operating unit, inventory organization, or security profile restrictions defined for the current user. HR_GENERAL provides supporting Human Resources utility logic used in resolving organization and location information. Because the security predicate is embedded in the parent view, any query against OE_AK_SHIP_FROM_ORGS_V automatically inherits the same access restrictions, returning only those ship-from organizations visible to the connected responsibility.

Key Columns

  • NAME — the name of the ship-from organization as defined in inventory organization setup.
  • ORGANIZATION_ID — the unique inventory organization identifier, used as the foreign key into organization-related tables and as the value passed to order and shipping APIs.
  • LOCATION_ID — the identifier of the address location record associated with the organization, linking to the location and address tables.
  • LOCATION_CODE — the short location code used to identify the address record.
  • ADDRESS_LINE_1, ADDRESS_LINE_2, ADDRESS_LINE_3 — the free-form street address lines of the ship-from location.
  • REGION_1, REGION_2, REGION_3 — the region, state, province, or county attributes of the address, with semantics determined by the country's address style. REGION_1 is commonly the state or province used in tax and shipping calculations.
  • TOWN_OR_CITY — the city or town component of the address.
  • POSTAL_CODE — the postal or ZIP code. Note that Oracle stores this column in a single field, with validation and formatting applied through the location flexfield rather than a separate table.
  • COUNTRY — the country code or country name associated with the address, used for shipping eligibility and tax determination.

Common Use Cases and Queries

Typical applications include validating a user-selected ship-from organization before inserting order lines, populating ship-from lists of values in custom forms or OAF pages, and extracting shipping origin addresses for carrier manifests and label printing. The security-aware behavior means the same query returns different result sets depending on responsibility, which is valuable for multi-org deployments.

A basic listing of visible ship-from organizations and their city:

SELECT organization_id, name, town_or_city, region_1, country
FROM   oe_ak_ship_from_orgs_v
ORDER BY name;

Retrieving the full address for a specific organization, useful before calling shipping APIs:

SELECT name, address_line_1, address_line_2, address_line_3,
       town_or_city, region_1, postal_code, country, location_id
FROM   oe_ak_ship_from_orgs_v
WHERE  organization_id = :p_org_id;

Filtering by country and region for reporting shipping origins:

SELECT name, location_code, town_or_city, region_1, postal_code
FROM   oe_ak_ship_from_orgs_v
WHERE  country = :p_country
AND    region_1 = :p_region;

Because the view is security-enabled and read-only, it should be used strictly for query and reporting purposes. Direct DML is not supported; changes to ship-from organization and address data must be made through the standard inventory organization and location setup forms.