Search Results shippable_item_flag

Overview

The ICX_NONSHIP_ITEMS_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite (validated across 12.1.1 and 12.2.2). As its product classification (ICX – Oracle iProcurement) and description ("Non Shippable Items View") indicate, the view exposes a consolidated list of inventory items that are explicitly flagged as non-shippable and that are associated with a valid price list line. In iProcurement and related purchasing flows, shippable versus non-shippable status influences whether an item is treated as a physical good requiring shipment or as a service, charge, or intangible line. By pre-joining item master data with price list information, the view allows reporting tools, concurrent programs, and custom integrations to identify these items and their pricing context without re-implementing the join logic against the base tables.

Underlying Base Objects

The view is defined over a small set of documented base objects. The primary driving object is MTL_SYSTEM_ITEMS_KFV, a key-flexfield-enabled synonym over the item master that supplies the item identifier, description, organization, and the critical SHIPPABLE_ITEM_FLAG. Pricing data is drawn from two Oracle Pricing synonyms: SO_PRICE_LIST_LINES (the individual price list line records) and SO_PRICE_LISTS (the price list headers), joined on PRICE_LIST_ID. The view additionally references the QP_PRICE_LIST_PVT and QP_UTIL packages, which underpin Oracle Pricing price-list processing and utility logic. The ETRM metadata documents APPS.ICX_NONSHIP_ITEMS_V as referencing MTL_SYSTEM_ITEMS_KFV, SO_PRICE_LISTS, SO_PRICE_LIST_LINES (each as synonyms), and the QP_PRICE_LIST_PVT and QP_UTIL packages. In practice, the SELECT exposes data sourced from the item master and the price list tables via inner joins, filtered to non-shippable items.

Key Columns

The view projects seven columns. The ETRM column list and the underlying view text together define their meaning:

• INVENTORY_ITEM_ID — Surrogate key of the item in the item master; maps to MSI.INVENTORY_ITEM_ID and is the join key to PLL.INVENTORY_ITEM_ID.
• ITEM_DESCRIPTION — The item description from MSI.DESCRIPTION.
• ORGANIZATION_ID — The inventory organization to which the item record applies (MSI.ORGANIZATION_ID).
• SHIPPABLE_ITEM_FLAG — The shippability indicator from the item master; the view restricts this to the value 'N'.
• PRICE_LIST_NAME — The name of the associated price list (PLS.NAME).
• PRICE_LIST_ID — Identifier of the price list header (PLS.PRICE_LIST_ID), used to join the header and line tables.
• PRICE_LIST_LINE_ID — Identifier of the specific price list line (PLL.PRICE_LIST_LINE_ID) linking the item to its price list.

Common Use Cases and Queries

Typical scenarios include auditing which non-shippable items carry pricing, validating iProcurement catalog content, and feeding external ordering or punch-out integrations with a clean item/price reference set. Because non-shippable items are excluded from physical fulfillment considerations, the view is useful for procurement analytics that isolate service or intangible lines.

Sample query — all non-shippable items and their price lists:

SELECT inventory_item_id,
       item_description,
       organization_id,
       price_list_name,
       price_list_id,
       price_list_line_id
FROM   apps.icx_nonship_items_v
ORDER  BY item_description;

Targeted lookup by price list name:

SELECT inventory_item_id,
       item_description,
       price_list_line_id
FROM   apps.icx_nonship_items_v
WHERE  price_list_name = :p_price_list_name;

Count of non-shippable items per price list, supporting catalog coverage analysis:

SELECT price_list_name,
       COUNT(DISTINCT inventory_item_id) nonship_item_count
FROM   apps.icx_nonship_items_v
GROUP  BY price_list_name;

Because the view performs distinct item/price-list pairings and enforces the SHIPPABLE_ITEM_FLAG = 'N' predicate, callers need not add that filter themselves; the view already returns only non-shippable items that have a corresponding price list line.