Results for “order_source_id”

50+ results




Overview
Explore in AI Chat

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

Overview

ASO_I_ORDER_SOURCES_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, registered with a VALID status in the ETRM repository. It belongs to the ASO - Order Capture product family and is documented as a view based on OE_ORDER_SOURCES that "gives information of the order source." In functional terms, the view exposes the master list of order sources — the coded values that identify where an order originated (for example, a manually entered order, a call center interaction, or an imported channel). It is one of the interface-supporting objects prefixed with ASO_I_, indicating that it is intended for lookup and validation during order capture and import processing rather than for transactional posting.

Its role in EBS reporting and integration is that of a thin, purpose-built projection. Rather than forcing callers to read OE_ORDER_SOURCES directly, the view presents a stable column set that the Order Capture layer can rely on for validating an incoming source code, rendering order-source lists in UI components, and enriching downstream extracts with source descriptions and behavioral flags.

Underlying Base Objects

The documented referenced base object is OE_ORDER_SOURCES (a SYNONYM resolving to the Order Management base table). The view text is a straight SELECT with no joins, unions, or filtering predicates:

Because there is no WHERE clause, the view returns every order source row defined in the instance, including disabled ones. The relationship is therefore one-to-one and unfiltered: ASO_I_ORDER_SOURCES_V is a subset-of-columns projection of OE_ORDER_SOURCES, and any DML against the view is not supported. Referential integrity, validation of the source ID, and multi-org considerations all remain the responsibility of the base table and the Order Management application logic.

Key Columns

  • ORDER_SOURCE_ID — Surrogate primary key of the order source; the value stored on OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID for captured orders.
  • NAME — User-visible name of the source, typically the value presented in list-of-values and validation messages.
  • DESCRIPTION — Longer descriptive text for the source, used in reporting and help text.
  • ENABLED_FLAG — Y/N indicator controlling whether the source may be selected during order entry. Filtering on 'Y' is essential for current, selectable sources.
  • CREATE_CUSTOMER_FLAG (documented in the view text as CREATE_CUSTOMERS_FLAG, and listed as CREATE_CUSTOMER_FLAG in the column inventory) — Y/N indicator governing whether the source permits creation of a new customer at order entry time.
  • USE_IDS_FLAG — Y/N indicator that determines whether the source uses a separate identifier allocation scheme for orders captured through it, influencing how order numbers or external identifiers are derived and validated during order import.

Common Use Cases and Queries

The most frequent use is populating or validating an order source in an interface load. A typical validation query enumerates selectable sources:

  • SELECT order_source_id, name FROM aso_i_order_sources_v WHERE enabled_flag = 'Y' ORDER BY name;
  • SELECT ORDER_SOURCE_ID, NAME, USE_IDS_FLAG FROM ASO_I_ORDER_SOURCES_V WHERE USE_IDS_FLAG = 'Y'; — identifies sources configured for ID-based identification, a check commonly applied before importing external order references.
  • SELECT h.order_source_id, s.name, COUNT(*) FROM oe_order_headers_all h, aso_i_order_sources_v s WHERE h.order_source_id = s.order_source_id GROUP BY h.order_source_id, s.name; — order-volume reporting by source.
  • An interface program resolving an inbound source name to its ID: SELECT order_source_id FROM aso_i_order_sources_v WHERE name = :p_source_name AND enabled_flag = 'Y';

Because the view is unfiltered, callers must apply their own ENABLED_FLAG and USE_IDS_FLAG predicates according to business rules; the view itself imposes none.