Results for “order_type_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The view APPS.WSH_ITM_REFERENCE_NUMBERS_V is a Shipping Execution (WSH) reporting object that provides a unified, denormalized listing of reference numbers associated with Inbound/Outbound Tracking and Management (ITM) request control records. It consolidates references that originate from two distinct application contexts: Oracle Order Management (application ID 660) and Oracle Shipping Execution deliveries (application ID 665). The view exposes the source application, the original system reference identifier, a descriptive type or organization name, the human-readable reference number, and the current status code. It is defined with SELECT DISTINCT over a UNION of two branches, so it presents a single, de-duplicated list of trackable references suitable for lookups, reporting, and integration queries keyed on the search term "reference_number."
The object is owned by the APPS schema and is marked VALID. It relies on Row Level Security through the inclusion of the HR_SECURITY and HR_GENERAL packages in its dependency chain, meaning visible rows are filtered according to the operating user's security profile.
Underlying Base Objects
The documented base objects underlying the view are HR_GENERAL (package), HR_SECURITY (package), OE_ORDER_HEADERS_ALL (synonym), ORG_ORGANIZATION_DEFINITIONS (view), WSH_ITM_REQUEST_CONTROL (synonym), and WSH_NEW_DELIVERIES (synonym). Additional objects appear in the view text, including OE_TRANSACTION_TYPES_VL (order type descriptions) and WSH_ITM_REQUEST_CONTROL as the driving table.
- WSH_ITM_REQUEST_CONTROL — The central driver table. Both UNION branches join from it, filtering on
APPLICATION_IDto distinguish order references (660) from delivery references (665) viaORIGINAL_SYSTEM_REFERENCE. - OE_ORDER_HEADERS_ALL / OE_TRANSACTION_TYPES_VL — Supply the order number, flow status, and order type name for the Order Management branch.
- WSH_NEW_DELIVERIES / ORG_ORGANIZATION_DEFINITIONS — Supply the delivery identifier, status code, and organization name for the Shipping branch.
- HR_SECURITY / HR_GENERAL — Implement organization and user-based Row Level Security on the exposed records.
Key Columns
- APPLICATION_ID — Identifies the source application. A value of 660 corresponds to Order Management order references; 665 corresponds to Shipping delivery references.
- REFERENCE_ID — The original system reference. For orders this is the order header ID; for deliveries it is the delivery ID.
- ORDER_TYPE_NAME — For order rows, the transaction type name; for delivery rows, the organization name is projected into this column by the UNION.
- REFERENCE_NUMBER — For order rows, the order number; for delivery rows, the delivery ID is projected here. This is the primary human-readable reference value.
- STATUS_CODE — The current flow status code for orders or the status code for deliveries.
Common Use Cases and Queries
Typical uses include resolving a scanned or externally supplied reference number into its internal identifier, listing active references for a given application, and joining ITM request control data to order or delivery status.
- Look up a specific reference number:
SELECT application_id, reference_id, reference_number, status_code FROM apps.wsh_itm_reference_numbers_v WHERE reference_number = :p_ref_num; - List all order-based references:
SELECT reference_id, reference_number, order_type_name, status_code FROM apps.wsh_itm_reference_numbers_v WHERE application_id = 660; - List all delivery-based references:
SELECT reference_id, reference_number, status_code FROM apps.wsh_itm_reference_numbers_v WHERE application_id = 665;
-
APPS.WSH_ITM_REFERENCE_NUMBERS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: OE_WF_ORDER_ASSIGN_V 12.2.2
View to show workflow assignments for a order transaction type and is used by UI.
APPS.OE_WF_ORDER_ASSIGN_V·↳ OE_TRANSACTION_TYPES_VL·↳ OE_WORKFLOW_ASSIGNMENTS·Explore ONT module →
-
APPS.SO_ORDER_TYPES_REGULAR_V·↳ SO_ORDER_TYPES·Explore OE module →
-
View: OE_WF_ORDER_ASSIGN_V 12.1.1
View to show workflow assignments for a order transaction type and is used by UI.
APPS.OE_WF_ORDER_ASSIGN_V·↳ OE_TRANSACTION_TYPES_VL·↳ OE_WORKFLOW_ASSIGNMENTS·Explore ONT module →
-
Table: OE_PURGE_ORDERS 12.2.2
OE_PURGE_ORDERS stores the order details for orders included in a purge set.
-
APPS.WSH_ITM_REFERENCE_NUMBERS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: OEBV_SALES_ORDER_TYPES 12.2.2
- Retrofitted
APPS.OEBV_SALES_ORDER_TYPES·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore OE module →
-
APPS.WSH_ORDER_TYPES_REGULAR_V·↳ OE_TRXT_TYPES_NOORGS_VL·Explore WSH module →
-
Table: OE_PURGE_ORDERS 12.1.1
OE_PURGE_ORDERS stores the order details for orders included in a purge set.
-
View: ARFV_CUSTOMER_SITES 12.1.1
APPS.ARFV_CUSTOMER_SITES·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
View: WSH_BACKORDER_LINES_V 12.2.2
APPS.WSH_BACKORDER_LINES_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_DELIVERY_LEGS·Explore WSH module →
-
APPS.WSH_ORDER_TYPES_REGULAR_V·↳ OE_TRXT_TYPES_NOORGS_VL·Explore WSH module →
-
APPS.SO_ORDER_TYPES_REGULAR_V·↳ SO_ORDER_TYPES·Explore OE module →
-
View: OEBV_SALES_ORDER_TYPES 12.1.1
Base BIS Business View for Sales Order Types.
APPS.OEBV_SALES_ORDER_TYPES·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
View: OEBV_SALES_ORDER_TYPES 12.2.2
Base BIS Business View for Sales Order Types.
APPS.OEBV_SALES_ORDER_TYPES·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore ONT module →
-
APPS.SO_LINES_CURRENT_DEMAND_V·↳ OE_QUERY·↳ SO_HEADERS·↳ SO_LINES·Explore OE module →
-
This view shows information about the selection criteria for WMS Rules
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
View: CE_FORECAST_ROWS_V 12.2.2
- Retrofitted
APPS.CE_FORECAST_ROWS_V·↳ AR_RECEIPT_METHODS·↳ AS_SALES_STAGES_ALL·↳ CE_BANK_ACCOUNTS·Explore CE module →
-
View: OEFV_SALES_ORDER_TYPES 12.1.1
- Retrofitted
APPS.OEFV_SALES_ORDER_TYPES·↳ FND_CURRENCIES_TL·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_CONVERSION_TYPES·Explore OE module →
-
View: OEFV_SALES_ORDER_TYPES 12.1.1
Full BIS Business View for Sales Order Types.
APPS.OEFV_SALES_ORDER_TYPES·↳ FND_CURRENCIES_TL·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_CONVERSION_TYPES·Explore ONT module →
-
View: OEFV_SALES_ORDER_TYPES 12.2.2
- Retrofitted
APPS.OEFV_SALES_ORDER_TYPES·↳ FND_CURRENCIES_TL·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_CONVERSION_TYPES·Explore OE module →
-
View: ASO_I_ORDER_HEADERS_V 12.1.1
view provides order related information
APPS.ASO_I_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_PARTIES·Explore ASO module →
-
View: WSH_BACKORDER_LINES_V 12.1.1
APPS.WSH_BACKORDER_LINES_V·↳ WSH_DELIVERY_ASSIGNMENTS_V·↳ WSH_DELIVERY_DETAILS·↳ WSH_DELIVERY_LEGS·Explore WSH module →
-
View: ASO_QUOTE_HEADERS_V 12.2.2
quotations
APPS.ASO_QUOTE_HEADERS_V·↳ ASO_I_PARTIES_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_B·Explore ASO module →
-
View: HZ_SITE_USES_V 12.2.2
APPS.HZ_SITE_USES_V·↳ AR_RECEIVABLES_TRX·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
View: ARFV_CUSTOMER_SITES 12.2.2
APPS.ARFV_CUSTOMER_SITES·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
View: OEBV_SALES_ORDER_TYPES 12.1.1
- Retrofitted
APPS.OEBV_SALES_ORDER_TYPES·↳ OE_TRANSACTION_TYPES_SYN·↳ OE_TRANSACTION_TYPES_TL·Explore OE module →
-
View: CE_FORECAST_ROWS_V 12.1.1
- Retrofitted
APPS.CE_FORECAST_ROWS_V·↳ AR_RECEIPT_METHODS·↳ AS_SALES_STAGES_ALL·↳ CE_BANK_ACCOUNTS·Explore CE module →
-
APPS.SO_LINES_CURRENT_DEMAND_V·↳ OE_QUERY·↳ SO_HEADERS·↳ SO_LINES·Explore OE module →
-
APPS.SO_ORDER_CANCELLATIONS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
APPS.SO_ORDER_CANCELLATIONS_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
View: ASO_QUOTE_HEADERS_V 12.1.1
quotations
APPS.ASO_QUOTE_HEADERS_V·↳ ASO_I_PARTIES_V·↳ ASO_QUOTE_HEADERS·↳ ASO_QUOTE_STATUSES_B·Explore ASO module →
-
Information about parts requirement headers
APPS.CSP_REQUIREMENT_HEADERS_V·↳ CSP_REQUIREMENT_HEADERS·↳ HR_GENERAL·↳ HR_SECURITY·Explore CSP module →
-
Information about parts requirement headers
APPS.CSP_REQUIREMENT_HEADERS_V·↳ CSP_REQUIREMENT_HEADERS·↳ HR_GENERAL·↳ HR_SECURITY·Explore CSP module →
-
View: HZ_SITE_USES_V 12.1.1
APPS.HZ_SITE_USES_V·↳ AR_RECEIVABLES_TRX·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·Explore AR module →
-
APPS.ASO_PVT_QUOTE_HEADERS_V·↳ ASO_I_ORDER_TYPES_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
APPS.WMS_SELECTION_CRITERIA_TXN_V·↳ WMS_RULES_B·↳ WMS_RULES_WORKBENCH_PVT·↳ WMS_SELECTION_CRITERIA_TXN·Explore WMS module →
-
View: ASO_I_ORDER_HEADERS_V 12.2.2
view provides order related information
APPS.ASO_I_ORDER_HEADERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCOUNT_ROLES·↳ HZ_PARTIES·Explore ASO module →
-
View: OEFV_SALES_ORDER_TYPES 12.2.2
Full BIS Business View for Sales Order Types.
APPS.OEFV_SALES_ORDER_TYPES·↳ FND_CURRENCIES_TL·↳ GL_CODE_COMBINATIONS·↳ GL_DAILY_CONVERSION_TYPES·Explore ONT module →
-
View: AR_SITE_USES_V 12.2.2
(Release 11.5 Only)
APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →
-
View: AR_SITE_USES_V 12.1.1
(Release 11.5 Only)
APPS.AR_SITE_USES_V·↳ AR_LOOKUPS·↳ AR_RECEIVABLES_TRX·↳ FND_COMMON_LOOKUPS·Explore AR module →
-
APPS.ASO_PVT_QUOTE_HEADERS_V·↳ ASO_I_ORDER_TYPES_V·↳ ASO_I_PRICE_LISTS_V·↳ ASO_QUOTE_HEADERS·Explore ASO module →
-
VIEW: ONT.OE_PURGE_ORDERS# 12.2.2
-
Not implemented in this database·Explore OE module →
-
Not implemented in this database·Explore OE module →