Search Results so_order_types_115_all




Overview
Explore in AI Chat

Overview

The SO_ORDER_TYPES_115_ALL table is a core master data table within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It serves as the central repository for defining and managing order types, which are critical transaction classifiers that govern the business rules, workflows, and processing logic for sales orders. Its role is foundational, as the order type is a mandatory attribute on a sales order header, linking every transaction to a predefined set of behaviors and validations. The table supports multi-organization access control through its "_ALL" suffix and the use of the ORG_ID column, allowing it to store definitions specific to different operating units within a single installation.

Key Information Stored

While the provided metadata does not list specific columns beyond the keys, based on its function and standard EBS table design, SO_ORDER_TYPES_115_ALL contains critical attributes for each order type definition. The primary identifier is ORDER_TYPE_ID, a unique system-generated sequence number serving as the primary key. The NAME column provides a unique, user-defined short name for the order type. Essential descriptive and control columns typically include a DESCRIPTION, an ENABLED_FLAG to control active status, and the ORG_ID for multi-org partitioning. The table also stores configuration flags that link the order type to specific transaction flows, such as invoice source rules, credit check requirements, and default values for pricing, shipping, and accounting.

Common Use Cases and Queries

This table is central to configuration, reporting, and data validation. Administrators query it to audit setup or enable new order types. A common reporting use case is joining order headers to this table to analyze order volumes by type. For troubleshooting, one might verify the order type associated with a problematic order. Sample SQL patterns include fetching all active order types for a given operating unit or resolving an order type name from a header ID.

  • SELECT name, description FROM oe.so_order_types_115_all WHERE org_id = :p_org_id AND enabled_flag = 'Y' ORDER BY name;
  • SELECT oth.name, COUNT(h.header_id) FROM so_headers_all h, so_order_types_115_all oth WHERE h.order_type_id = oth.order_type_id AND h.org_id = :p_org_id GROUP BY oth.name;
  • SELECT h.order_number, oth.name FROM so_headers_all h JOIN so_order_types_115_all oth ON h.order_type_id = oth.order_type_id WHERE h.header_id = :p_header_id;

Related Objects

The SO_ORDER_TYPES_115_ALL table has extensive relationships across the EBS ecosystem, as evidenced by its foreign keys. It is primarily referenced by transaction and setup tables that require a valid order type. Key documented relationships include: