Search Results aso_i_countries_v




Overview
Explore in AI Chat

Overview

ASO_I_COUNTRIES_V is a read-only database view owned by the APPS schema within the ASO (Order Capture) product family of Oracle E-Business Suite. As documented in the ETRM metadata for releases 12.1.1 and 12.2.2, the view "retrieves the country information" and exists to expose a normalized list of territories and countries for use by Order Capture functionality and by any dependent reporting or integration layer that requires country reference data.

The prefix ASO_I follows the naming convention used for Order Capture inquiry and reference objects. Because the view is defined over a foundation layer object rather than a transactional table, it functions purely as a lightweight, denormalized access point for territory reference data. It carries no validation logic of its own and does not enforce any business rules; its sole purpose is to present a consistent, reusable projection of country records to callers within the EBS data model.

Underlying Base Objects

The ETRM documentation records a single referenced base object for this view: FND_TERRITORIES_VL. In Oracle EBS, the _VL suffix denotes a multi-language (ML) view. FND_TERRITORIES_VL is built on top of the FND_TERRITORIES base table and its associated translation table (FND_TERRITORIES_TL), returning the territory code and the short name resolved for the session's language.

ASO_I_COUNTRIES_V therefore sits one layer above the Applications Foundation territory model. It performs a straightforward column projection, selecting only the territory code, the territory short name, and the description from the underlying VL view. No filters, joins to Order Capture tables, or additional derivations are documented, confirming that the view is intended as a pass-through reference source rather than an aggregate or transformation layer.

Key Columns

  • TERRITORY_CODE — The unique, language-independent identifier for a country or territory (for example, a standard territory code such as "US" or "GB"). This is the value typically stored in transactional tables that reference a country.
  • TERRITORY_SHORT_NAME — The translated short name of the territory, resolved according to the language of the current EBS session through FND_TERRITORIES_VL. This is the value normally displayed on forms and reports.
  • DESCRIPTION — The descriptive text associated with the territory, providing an additional human-readable label suitable for reporting output and pick lists.

Common Use Cases and Queries

The view is most commonly used to populate country selection lists in Order Capture extensions, to resolve a stored territory code into a display name for reporting, and to join reference data onto custom queries without directly accessing the Foundation ML view. A typical listing query is:

SELECT territory_code, territory_short_name, description
FROM apps.aso_i_countries_v
ORDER BY territory_short_name;

To resolve a code held elsewhere in a query, the view can be joined on territory_code:

SELECT o.order_number, c.territory_short_name
FROM oe_order_headers_all o, apps.aso_i_countries_v c
WHERE o.ship_to_country = c.territory_code;

Because the view is a simple projection of FND_TERRITORIES_VL, no DML should be issued against it; all access is read-only. Performance is governed by the underlying Foundation view, so standard tuning practices for FND_TERRITORIES_VL apply.