Results for “returnable_flag”

50+ results




Overview
Explore in AI Chat

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

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:

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.