Search Results oe_transaction_types_vl




Overview
Explore in AI Chat

Overview

OE_TRANSACTION_TYPES_VL is a Multi-Lingual Support (MLS) view owned by the APPS schema in Oracle E-Business Suite. It belongs to the ONT (Order Management) product family and is documented in ETRM for releases 12.1.1 and 12.2.2. The view presents order transaction types for an operating unit (organization), joining translatable descriptive attributes with the transactional definition of each transaction type. Its name carries the "VL" suffix, the standard EBS convention indicating that the view returns the translation appropriate to the session's language, resolved at runtime through the USERENV('LANG') function. In practice, OE_TRANSACTION_TYPES_VL is the primary reference for order entry, fulfillment, and pricing logic that must display or evaluate a transaction type in the user's own language, and it is widely used in reports, concurrent programs, and integration extracts that need a human-readable transaction type name alongside its operational settings.

Underlying Base Objects

The ETRM metadata records two referenced base objects, both exposed to APPS as synonyms: OE_TRANSACTION_TYPES_SYN and OE_TRANSACTION_TYPES_TL. The view text confirms the join relationship. OE_TRANSACTION_TYPES_TL supplies the translatable columns — NAME and DESCRIPTION — and is joined to the transactional table on TRANSACTION_TYPE_ID, filtered by the condition T.LANGUAGE = USERENV('LANG'). OE_TRANSACTION_TYPES_SYN supplies the non-translatable, single-row-per-transaction-type definition, including identifiers, order category, date ranges, financial defaults, credit check rules, fulfillment defaults, and the DFF context and attribute columns. Because the join is on the transaction type identifier and the TL table is language-filtered, the view returns exactly one row per transaction type per session language, combining the operational record with its localized text.

Key Columns

Common Use Cases and Queries

Typical applications include order management reports that must print localized transaction type names, LOV-style validation, and integrations extracting order defaults such as warehouse, price list, and credit check rules. A standard query retrieves active transaction types for an operating unit:

SELECT transaction_type_id, transaction_type_code, name, order_category_code, start_date_active, end_date_active FROM oe_transaction_types_vl WHERE org_id = :p_org_id AND (end_date_active IS NULL OR end_date_active > SYSDATE) ORDER BY name;

The view can be joined to OE_ORDER_HEADERS_ALL on TRANSACTION_TYPE_ID to label existing orders, or to fulfillment and pricing setups to audit default derivation. Because the language filter is embedded in the view definition, no additional translation join is required; querying the view directly yields the correct localized NAME and DESCRIPTION for the connected user's session language.