Results for “oe_order_types_v”

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

Overview

OE_ORDER_TYPES_V is an APPS-owned view in the Oracle E-Business Suite Order Management (ONT) module that exposes order transaction types scoped to a specific organization and language. It is a convenience wrapper that filters the underlying multilingual transaction type definitions so that only sales order types — those whose transaction type code equals 'ORDER' — are returned, and it excludes types flagged as internal or otherwise non-order document categories. The view carries a status of VALID across the ETRM 12.2.2 reference set and is equally applicable to 12.1.1 deployments.

The view plays a supporting role in reporting and integration. Because it presents a denormalized, readable projection of order type configuration, developers and analysts routinely use it in custom SQL, Oracle Reports, and BI Publisher data models where the objective is to list or validate order types for a given operating unit without navigating the full OE_TRANSACTION_TYPES_VL definition directly.

Underlying Base Objects

Per the documented metadata, the sole referenced base object is OE_TRANSACTION_TYPES_VL, itself a view over the transaction types base tables (OE_TRANSACTION_TYPES_B and its translation table). OE_TRANSACTION_TYPES_VL supplies the language-specific NAME and DESCRIPTION along with the transactional attributes; OE_ORDER_TYPES_V selects from it and applies two predicates:

• TRANSACTION_TYPE_CODE = 'ORDER'
• NVL(SALES_DOCUMENT_TYPE_CODE, 'O') <> 'B'

The first predicate limits the result set to order entry transaction types. The second removes types whose sales document type is 'B'. The view therefore inherits the multi-language behavior of the VL view, returning rows whose name and description reflect the session language, while the organization context is carried through the ORG_ID column.

Key Columns

The view exposes the full transactional attribute set of the underlying transaction type. Prominent columns include:

• ORDER_TYPE_ID / TRANSACTION_TYPE_ID — Identifiers for the order type. The view text aliases TRANSACTION_TYPE_ID twice, effectively surfacing it as ORDER_TYPE_ID and TRANSACTION_TYPE_ID.
• TRANSACTION_TYPE_CODE, NAME, DESCRIPTION — The code ('ORDER' for the filtered rows) and the user-facing name and description.
• ORDER_CATEGORY_CODE — Classifies the order category (for example, order or return).
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective-dating bounds for the type.
• ORG_ID — The operating unit or organization to which the type applies.
• PRICE_LIST_ID, WAREHOUSE_ID, DEMAND_CLASS_CODE, SHIPMENT_PRIORITY_CODE — Default order entry and fulfillment attributes.
• INVOICING_RULE_ID, ACCOUNTING_RULE_ID, INVOICE_SOURCE_ID, CUST_TRX_TYPE_ID — Receivables and invoicing defaults.
• SHIPPING_CREDIT_CHECK_RULE_ID, ENTRY_CREDIT_CHECK_RULE_ID, PICKING_CREDIT_CHECK_RULE_ID, PACKING_CREDIT_CHECK_RULE_ID — Credit checking rule references across the order-to-ship cycle.
• ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT — The descriptive flexfield segments.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, PROGRAM_ID, REQUEST_ID.

Common Use Cases and Queries

Typical scenarios include listing active order types for an operating unit, driving LOV queries in custom forms, and validating configuration before order import.

List order types for a specific organization:

SELECT order_type_id, name, order_category_code FROM oe_order_types_v WHERE org_id = :p_org_id ORDER BY name;

Retrieve default attributes for a single order type:

SELECT name, price_list_id, warehouse_id, demand_class_code FROM oe_order_types_v WHERE transaction_type_id = :p_type_id;

Filter to currently active types:

SELECT order_type_id, name FROM oe_order_types_v WHERE org_id = :p_org_id AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Because the view already restricts to TRANSACTION_TYPE_CODE = 'ORDER', queries do not need to repeat that predicate. Analysts should remember that name and description are language-dependent and that ORG_ID must be supplied to scope results to the intended operating unit.