Search Results so_order_types_115




Overview
Explore in AI Chat

Overview

The APPS.SO_ORDER_TYPES_115 view is a reportable, ORG_ID-secured projection of Order Entry order types (transaction types) within Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes the configuration that governs how sales orders are entered, priced, reserved, shipped, invoiced, and integrated to Receivables, including credit-check behavior, accounting rules, and order-entry defaults. The view carries a fixed product prefix (115) that identifies the release lineage of the underlying order type definition, while the Object Type of VIEW and Status of VALID confirm it is a queryable, supported dictionary object rather than a table that stores data directly.

Because it is secured by ORG_ID through the USERENV('CLIENT_INFO') predicate, the view returns only the order types belonging to the currently initialized operating unit. This makes it suitable for multi-org aware reporting, concurrent programs, and integration extracts. The presence of the ENTRY_CREDIT_CHECK_RULE_ID column is significant for users searching that term: this view is one of the primary places where the credit-check rule assigned to the order-entry stage of an order type can be retrieved and joined to the credit rule definition.

Underlying Base Objects

The view is defined over a single documented base object, the synonym SO_ORDER_TYPES_115_ALL. The "_ALL" naming convention in Oracle EBS denotes a multi-org (partitioned by ORG_ID) table. The view applies the standard operating-unit filter, comparing NVL(ORG_ID, -99) against the value decoded from the CLIENT_INFO session context. All columns listed in the view text are drawn from SO_ORDER_TYPES_115_ALL. No joins or aggregations are present, so the view is a straight row-level projection of the base synonym with row security applied.

Key Columns

Common Use Cases and Queries

The view is commonly used to list order types for the current operating unit, to audit credit-check assignments, and to drive integrations that mirror order type configuration. A representative query listing order types and their entry credit rules follows.

SELECT ORDER_TYPE_ID, NAME, ORDER_CATEGORY_CODE, ENTRY_CREDIT_CHECK_RULE_ID, SHIPPING_CREDIT_CHECK_RULE_ID FROM APPS.SO_ORDER_TYPES_115 WHERE ORDER_CATEGORY_CODE = 'ORDER';

To locate the rule referenced by a specific order type, query ENTRY_CREDIT_CHECK_RULE_ID and join it to the credit rule definition table used by Order Management. Reporting and integration scenarios also select NAME, CURRENCY_CODE, INVOICING_RULE_ID, and ACCOUNTING_RULE_ID together to document end-to-end order type setup across Order Entry and Receivables.