Search Results source_organization

Overview

APPS.CSP_ITEM_SUB_INVENTORIES_ALL_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CSP (Spares Management) product family. Its documented purpose is to present the authorized stocklist for subinventories — that is, the set of inventory items that are approved for stocking within specific subinventories of specific inventory organizations. The view joins item master data, subinventory-level item attributes, organization definitions, and spares stocklist control records into a single denormalized result set, allowing consumers to query stocklist information without navigating the individual base tables.

The user search term primary_subinventory_flag corresponds directly to the PRIMARY_SUBINVENTORY_FLAG column exposed by this view. This flag originates on the underlying item/subinventory association and identifies whether the subinventory being reported is the primary (default) stocking location for the item within the organization. It is a frequently referenced attribute in stocklist, replenishment, and spares planning inquiries.

Because the object is a view rather than a table, it carries no stored data of its own and is read-only from a SQL perspective; it is intended for reporting, integration extracts, and lookup by concurrent programs and OAF-based pages that need a consolidated authorized-stocklist perspective.

Underlying Base Objects

The documented view text is defined over the following objects:

• MTL_ITEM_SUB_INVENTORIES_ALL_V (MIS) — the principal driver, supplying item-to-subinventory association rows, primary subinventory flag, picking order, min-max and order quantity planning attributes, source type, source organization and subinventory, lead times, and the DFF attribute columns.
• MTL_SYSTEM_ITEMS_B_KFV (KFV) — the key flexfield view of the item master, supplying CONCATENATED_SEGMENTS (the concatenated item number) and joining on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• CSP_STOCK_LISTS (CSL) — the spares stocklist table, outer-joined on item, organization, and subinventory, contributing MANUAL_AUTO and REASON_CODE. A synonym to this object is listed in the ETRM base-object metadata.
• ORG_ORGANIZATION_DEFINITIONS (OOD) — supplies ORGANIZATION_CODE and ORGANIZATION_NAME.
• FND_LOOKUPS (FND) — an outer join on LOOKUP_TYPE = 'CSP_ASL_REASON_CODE' that translates REASON_CODE into the REASON_CODE_MEANING value.

Documented referenced objects also include the PL/SQL packages FND_GLOBAL, HR_GENERAL, and HR_SECURITY, which typically support organization and security context resolution (e.g., multi-org and MOAC filtering) invoked when the view or its underlying foundation view is queried.

Key Columns

• ROW_ID — surrogate identifier for the item/subinventory association row on the underlying base object.
• INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS, ITEM_DESCRIPTION — item identity and description.
• ORGANIZATION_ID, ORGANIZATION_CODE, ORGANIZATION_NAME — the inventory organization context.
• SECONDARY_INVENTORY, SUB_DESCRIPTION — the subinventory code and its description.
• PRIMARY_SUBINVENTORY_FLAG — indicates whether the subinventory is the item's primary stocking subinventory. This is the attribute referenced by the user's search term.
• PICKING_ORDER, MIN_MINMAX_QUANTITY, MAX_MINMAX_QUANTITY, INVENTORY_PLANNING_CODE, FIXED_LOT_MULTIPLE, MINIMUM_ORDER_QUANTITY, MAXIMUM_ORDER_QUANTITY — planning and replenishment control attributes carried at the subinventory level.
• SOURCE_TYPE and SOURCE_TYPE_NAME — DECODE-derived label mapping 1='INVENTORY', 2='VENDOR', 3='SUBINVENTORY', together with SOURCE_ORGANIZATION_ID, SOURCE_ORGANIZATION, SOURCE_ORG_NAME, and SOURCE_SUBINVENTORY identifying the replenishment source.
• ENCUMBRANCE_ACCOUNT, PREPROCESSING_LEAD_TIME, PROCESSING_LEAD_TIME, POSTPROCESSING_LEAD_TIME — account and lead-time attributes.
• MANUAL_AUTO, REASON_CODE, REASON_CODE_MEANING — stocklist maintenance mode and the translated authorized-stocklist reason code.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns.

Common Use Cases and Queries

Typical uses include identifying the primary stocking subinventory for an item in an organization, extracting authorized stocklists for spares planning or third-party integration, and auditing replenishment sources and lead times at subinventory granularity.

To locate the primary subinventory for an item:

• SELECT inventory_item_id, concatenated_segments, organization_code, secondary_inventory FROM csp_item_sub_inventories_all_v WHERE primary_subinventory_flag = 'Y' AND organization_id = :org_id AND inventory_item_id = :item_id;

To report the authorized stocklist with source and reason information:

• SELECT concatenated_segments, organization_code, secondary_inventory, source_type_name, source_subinventory, manual_auto, reason_code_meaning FROM csp_item_sub_inventories_all_v WHERE organization_id = :org_id ORDER BY concatenated_segments, picking_order;

To review replenishment planning attributes across subinventories:

• SELECT concatenated_segments, secondary_inventory, min_minmax_quantity, max_minmax_quantity, minimum_order_quantity, maximum_order_quantity, processing_lead_time FROM csp_item_sub_inventories_all_v WHERE primary_subinventory_flag = 'Y';

Because MOAC security is applied through the underlying foundation views and HR security packages, queries should be issued under an appropriately initialized Oracle Applications session so that organization and operating unit context is correctly enforced.