Search Results csp_asl_items_v




Overview
Explore in AI Chat

Overview

The CSP_ASL_ITEMS_V view is an APPS-owned, VALID database object delivered with the Oracle E-Business Suite Spares Management (CSP) module. Its documented purpose is to list all items that reside on a stocklist — the Approved Supplier List equivalent maintained by Spares Management for field service and depot replenishment. Because Spares Management operates on stocked spare parts rather than on generic purchased items, this view filters its driving table to items whose inventory planning code designates them as min-max planned (INVENTORY_PLANNING_CODE = 2), then joins in organization details, stocklist definition attributes, and lookup translations.

For reporting and integration purposes, CSP_ASL_ITEMS_V provides a denormalized, human-readable projection of item master data combined with CSP stocklist control attributes. It is the natural reporting source when a query must answer which parts are carried on a stocklist, how they are replenished, and — critically for planning queries — what preprocessing and postprocessing lead times apply. Users searching on preprocessing_lead_time will find that column exposed directly by this view, alongside its companion postprocessing_lead_time.

Underlying Base Objects

The ETRM 12.2.2 metadata identifies the following referenced objects:

  • MTL_SYSTEM_ITEMS_B_KFV (view) — the key-flexfield variant of the item master; supplies the item identifier, concatenated segment string, description, planning attributes, min-max quantities, order modifiers, sourcing, and the preprocessing/postprocessing lead times.
  • ORG_ORGANIZATION_DEFINITIONS (view) — resolves ORGANIZATION_NAME for the owning inventory organization.
  • CSP_STOCK_LISTS (synonym) — the CSP stocklist definition, outer-joined to the item master so that items appear even when no stocklist row exists; contributes the manual/auto replenishment flag, reason code, and descriptive flexfield attribute columns.
  • FND_LOOKUPS (view) — joined by lookup type CSP_ASL_REASON_CODE to translate REASON_CODE into its MEANING.
  • FND_GLOBAL, HR_GENERAL, HR_SECURITY (packages) — supporting security and session context used by the underlying views.

The join conditions require ORGANIZATION_ID equality between the item master and organization definitions, an equality between INVENTORY_ITEM_ID/ORGANIZATION_ID and the stocklist (with the (+) outer-join operator on the stocklist side), and an outer join to FND_LOOKUPS on REASON_CODE with LOOKUP_TYPE fixed to CSP_ASL_REASON_CODE. All three joins to CSP_STOCK_LISTS and FND_LOOKUPS are outer joins, so the view is effectively an item-driven listing enriched, not restricted, by stocklist data.

Key Columns

Common Use Cases and Queries

Typical usage includes auditing stocklist contents per organization, deriving total replenishment lead time, and integrating spare-parts sourcing data into downstream planning systems. Because the view exposes preprocessing lead time directly, a frequent query is:

SELECT organization_name, concatenated_segments, item_description,
preprocessing_lead_time, postprocessing_lead_time,
preprocessing_lead_time + postprocessing_lead_time total_lead_time
FROM apps.csp_asl_items_v
WHERE organization_id = :org_id
ORDER BY concatenated_segments;

Another common pattern filters by sourcing behaviour to identify vendor-replenished items with automatic replenishment enabled:

SELECT concatenated_segments, source_type_name, manual_auto, reason_code_meaning
FROM apps.csp_asl_items_v
WHERE source_type = 2 AND manual_auto = 'AUTO';

Reports that render the stocklist for a technician-facing interface simply select the descriptive columns (CONCATENATED_SEGMENTS, ITEM_DESCRIPTION, ORGANIZATION_NAME) joined back to CSP stocklist detail tables. Because the view is defined over key-flexfield and organization views, queries should be run with the appropriate MO: Operating Unit or organization security context established by FND_GLOBAL and HR_SECURITY, so that ORG_ORGANIZATION_DEFINITIONS returns only the organizations the session is permitted to see.