Results for “order_category_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The OE_AK_ORDER_CATEGORY_V view is a lightweight, read-only database object owned by the APPS schema within Oracle E-Business Suite. It belongs to the Order Management (ONT) product family and carries a status of VALID in both EBS 12.1.1 and 12.2.2. The view exposes a single logical attribute — the order category code — that classifies sales orders within the Order Management application. In the EBS data model, order categories are a lookup-driven classification used to group orders by business meaning, such as distinguishing standard orders from returns, internal transfers, or other order types configured by the implementing organization.
Functionally, the view acts as a thin presentation layer over the seeded quick code values held in the OE_LOOKUPS lookup repository. Because it decouples the consuming application or report from the physical lookup table, it provides a stable interface for retrieving the set of valid order categories without requiring the caller to know the internal lookup structure.
Underlying Base Objects
According to the documented ETRM metadata for release 12.2.2, the view is defined over a single referenced base object: OE_LOOKUPS, which is itself a view rather than a physical table.
The view definition is minimal and explicit:
SELECT LOOKUP_CODE FROM OE_LOOKUPS WHERE LOOKUP_TYPE = 'ORDER_CATEGORY'
The predicate on LOOKUP_TYPE = 'ORDER_CATEGORY' is what restricts the result set to order-category quick codes. This design means the view is entirely dependent on the integrity and maintenance of the ORDER_CATEGORY lookup type. Any additions, end-dating, or updates performed on that lookup type within the Order Management setup are immediately reflected in the view's output. Because OE_LOOKUPS is a view and not a base table, the functional behavior ultimately traces back to the lookup tables that OE_LOOKUPS queries internally.
Key Columns
The view exposes the following documented column:
- ORDER_CATEGORY_CODE — The lookup code value that uniquely identifies an order category. Despite the column alias differing from the underlying LOOKUP_CODE name, it surfaces the same string value. Valid entries correspond to the enabled quick codes defined for the ORDER_CATEGORY lookup type in the application.
No additional columns, such as description or meaning, are projected by this view. Callers requiring the translated or descriptive meaning of a category must join back to OE_LOOKUPS or the appropriate lookup table rather than relying on this view alone.
Common Use Cases and Queries
This view is typically consumed for validation, populating selection lists in custom concurrent programs, or driving conditional logic in reporting and integrations where a definitive list of order categories is needed. A representative query retrieving all available category codes follows:
SELECT order_category_code FROM apps.oe_ak_order_category_v;
A more complete reporting query joining to the lookup table for descriptive context would be:
SELECT v.order_category_code,
l.meaning
FROM apps.oe_ak_order_category_v v,
apps.oe_lookups l
WHERE l.lookup_type = 'ORDER_CATEGORY'
AND l.lookup_code = v.order_category_code;
Because the view performs no filtering for enabled or end-dated status by itself, applications requiring only currently active categories should apply additional criteria against the lookup source. In integration and interface scenarios, the view is useful as an authoritative, low-overhead reference to the order category domain, helping custom code remain aligned with the standard Order Management configuration rather than hard-coding category values.
-
View: OE_AK_ORDER_CATEGORY_V 12.1.1
APPS.OE_AK_ORDER_CATEGORY_V·↳ OE_LOOKUPS·Explore ONT module →
-
View: OE_AK_LINE_TYPES_V 12.1.1
APPS.OE_AK_LINE_TYPES_V·↳ OE_LINE_TYPES_V·Explore ONT module →
-
View: OE_AK_LINE_TYPES_V 12.2.2
APPS.OE_AK_LINE_TYPES_V·↳ OE_LINE_TYPES_V·Explore ONT module →
-
View: OE_AK_ORDER_CATEGORY_V 12.2.2
APPS.OE_AK_ORDER_CATEGORY_V·↳ OE_LOOKUPS·Explore ONT module →
-
View: OE_AK_ORDER_TYPES_V 12.1.1
APPS.OE_AK_ORDER_TYPES_V·↳ OE_ORDER_TYPES_V·Explore ONT module →
-
View: OE_LINE_TYPES_V 12.2.2
This is a view to show line transaction types types for a specific organization and language.
APPS.OE_LINE_TYPES_V·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_AK_ORDER_TYPES_V 12.2.2
APPS.OE_AK_ORDER_TYPES_V·↳ OE_ORDER_TYPES_V·Explore ONT module →
-
View: OE_ORDER_TYPES_115 12.1.1
No longer used
APPS.OE_ORDER_TYPES_115·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_ORDER_TYPES_115_ALL 12.2.2
No longer used
APPS.OE_ORDER_TYPES_115_ALL·↳ OE_TRANSACTION_TYPES_ALL·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
View: OE_ORDER_TYPES_115 12.2.2
No longer used
APPS.OE_ORDER_TYPES_115·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_ORDER_TYPES_115_ALL 12.1.1
No longer used
APPS.OE_ORDER_TYPES_115_ALL·↳ OE_TRANSACTION_TYPES_ALL·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
View: OE_CRM_ORDER_HEADERS_V 12.1.1
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_CRM_ORDER_HEADERS_V 12.2.2
Compatible view provoded for CRM usage only. The view is based on oe_order_headers_all table.
APPS.OE_CRM_ORDER_HEADERS_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_BLANKET_HDRS_HIST_V 12.1.1
APPS.OE_BLANKET_HDRS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLKT_HEADERS_HIST_V 12.1.1
This view is used to get BSA history headers information, and which is used in BSA organizer.
APPS.OE_BLKT_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_LINE_TYPES_V 12.1.1
This is a view to show line transaction types types for a specific organization and language.
APPS.OE_LINE_TYPES_V·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_ORDER_TYPES_V 12.1.1
This is a view to show order transaction types for a specific organization and language.
APPS.OE_ORDER_TYPES_V·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_ORDER_TYPES_V 12.2.2
This is a view to show order transaction types for a specific organization and language.
APPS.OE_ORDER_TYPES_V·↳ OE_TRANSACTION_TYPES_VL·Explore ONT module →
-
View: OE_TRANSACTION_TYPES_V 12.1.1
APPS.OE_TRANSACTION_TYPES_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ONT module →
-
MLS transaction types view for an organization.
APPS.OE_TRANSACTION_TYPES_VL·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
View: OE_TRANSACTION_TYPES_V 12.2.2
APPS.OE_TRANSACTION_TYPES_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore ONT module →
-
Org independent VL view for Shipping integration team to get the Order Type name.
APPS.OE_TRXT_TYPES_NOORGS_VL·↳ OE_TRANSACTION_TYPES_ALL·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
This table stores information about the order and line transaction types
-
Org independent VL view for Shipping integration team to get the Order Type name.
APPS.OE_TRXT_TYPES_NOORGS_VL·↳ OE_TRANSACTION_TYPES_ALL·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
MLS transaction types view for an organization.
APPS.OE_TRANSACTION_TYPES_VL·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
This table stores information about the order and line transaction types
-
View: OE_AK_ORDER_HEADERS_V 12.1.1
APPS.OE_AK_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
View: OE_ORDER_HEADERS_V 12.1.1
View for Order header used in sales order form.
APPS.OE_ORDER_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_BLANKET_HEADERS_V 12.2.2
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
This view is used to retrieve the Order History. This is used by the history form.
APPS.OE_ORDER_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
View: OE_ORDER_HEADERS_V 12.2.2
View for Order header used in sales order form.
APPS.OE_ORDER_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_AK_ORDER_HEADERS_V 12.2.2
APPS.OE_AK_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ OE_ORDER_HEADERS_ALL·Explore ONT module →
-
View: OE_BLANKET_HEADERS_V 12.1.1
APPS.OE_BLANKET_HEADERS_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
Stores history of attribute change for Order Headers
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
View: OE_BLANKET_HDRS_HIST_V 12.2.2
APPS.OE_BLANKET_HDRS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
View: OE_HEADER_ACKS_V 12.2.2
Information about the acknowledgements for Order Headers.
APPS.OE_HEADER_ACKS_V·↳ ECE_TP_DETAILS·↳ ECE_TP_HEADERS·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
This view is used to retrieve the Order History. This is used by the history form.
APPS.OE_ORDER_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·Explore ONT module →
-
Table to capture sales agreement header history. Primary for storing revisions.
-
OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
-
View: OE_HEADER_ACKS_V 12.1.1
Information about the acknowledgements for Order Headers.
APPS.OE_HEADER_ACKS_V·↳ ECE_TP_DETAILS·↳ ECE_TP_HEADERS·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
Table to capture sales agreement header details..
-
View: OE_BLKT_HEADERS_HIST_V 12.2.2
This view is used to get BSA history headers information, and which is used in BSA organizer.
APPS.OE_BLKT_HEADERS_HIST_V·↳ AR_LOOKUPS·↳ FND_CURRENCIES·↳ HZ_CUST_ACCOUNTS·Explore ONT module →
-
Stores history of attribute change for Order Headers
-
Table to capture sales agreement header details..
-
Table to capture sales agreement header history. Primary for storing revisions.
-
This tables stores information about the acknowledgements for Order Headers.
-
This tables stores information about the acknowledgements for Order Headers.
-
View: OE_HEADERS_IOP_115_V 12.1.1
No longer used
APPS.OE_HEADERS_IOP_115_V·↳ OE_ORDER_HEADERS·Explore ONT module →
-
View: OE_HEADERS_IOP_115_V 12.2.2
No longer used
APPS.OE_HEADERS_IOP_115_V·↳ OE_ORDER_HEADERS·Explore ONT module →