Search Results returnable_flag

Overview

The APPS.SO_ITEM_WAREHOUSES_V view is a reporting and integration object within the Oracle E-Business Suite Order Entry (OE) product family. Its purpose is to present a consolidated list of inventory organizations (warehouses) in which a given inventory item is enabled for customer order processing. The view joins organization definition data, organization parameter data, and item master data to expose, for every item-organization combination, the organization code, organization name, and the item-level flags that govern whether the item may be transacted on a customer order.

Because the Order Entry module must validate that an item is orderable within a specific warehouse before an order line can be entered, this view is frequently referenced by order-entry forms, validation logic, and downstream reports. It provides a denormalized, human-readable projection so that reporting tools and interfaces do not need to resolve the relationship between MTL_SYSTEM_ITEMS, MTL_PARAMETERS, and the HR organization model independently. The object is documented as VALID in the APPS schema and is classified as a View.

Underlying Base Objects

The view is defined over three directly referenced objects and depends indirectly on personnel security objects. The documented base objects are:

• MTL_PARAMETERS (referenced as a synonym) — supplies the ORGANIZATION_CODE and the organization-level inventory parameters. The join is made on ORGANIZATION_ID.
• HR_ORGANIZATION_UNITS (view) — supplies the organization NAME and ORGANIZATION_ID, and enforces the effective-dating of the organization through the DATE_FROM and DATE_TO columns.
• MTL_SYSTEM_ITEMS (referenced as a synonym) — supplies the item-level attributes INVENTORY_ITEM_ID, CUSTOMER_ORDER_ENABLED_FLAG, and RETURNABLE_FLAG, joined by ORGANIZATION_ID and item.
• HR_GENERAL (package) and HR_SECURITY (package) — supporting objects associated with the HR organization model and its security model.

The defining query joins MTL_PARAMETERS, HR_ORGANIZATION_UNITS, and MTL_SYSTEM_ITEMS on ORGANIZATION_ID, and further restricts rows so that only organizations currently in effect are returned. This is achieved with the predicates TRUNC(SYSDATE) >= HRU.DATE_FROM and TRUNC(SYSDATE) <= NVL(DATE_TO, TRUNC(SYSDATE)), ensuring that organizations whose DATE_TO has passed are excluded and those with no end date remain active indefinitely.

Key Columns

• ORGANIZATION_CODE — the short code of the inventory organization, sourced from MTL_PARAMETERS.
• ORGANIZATION_NAME — the descriptive name of the organization, sourced from HR_ORGANIZATION_UNITS.NAME.
• ORGANIZATION_ID — the unique identifier of the inventory organization, used as the join key across base tables.
• INVENTORY_ITEM_ID — the unique identifier of the inventory item within the item master.
• CUSTOMER_ORDER_ENABLED_FLAG — the item-level indicator (Y/N) that determines whether the item may be placed on a customer order in that organization. This is the column most directly relevant to the user's search term.
• RETURNABLE_FLAG — indicates whether the item may be returned by a customer.

Common Use Cases and Queries

Typical uses include validating order-entry eligibility for an item-warehouse pair, populating LOVs for warehouse selection, and building reports of orderable items by organization. The following query lists all warehouses where a specific item is enabled for customer orders:

• SELECT organization_code, organization_name, organization_id, inventory_item_id, customer_order_enabled_flag, returnable_flag FROM apps.so_item_warehouses_v WHERE inventory_item_id = :item_id AND customer_order_enabled_flag = 'Y';
• SELECT organization_code, COUNT(*) FROM apps.so_item_warehouses_v WHERE customer_order_enabled_flag = 'Y' GROUP BY organization_code ORDER BY organization_code;

Because the view filters on the current system date, results always reflect organizations active as of the query date, making it suitable for real-time validation as well as point-in-time operational reporting.