Search Results csp_asl_reason_code




Overview
Explore in AI Chat

Overview

APPS.CSP_ASL_ITEMS_V is a reporting and integration view in Oracle E-Business Suite, available in both 12.1.1 and 12.2.2, that consolidates Approved Supplier List (ASL) item attributes with item master, organization, and lookup information. The view is primarily used within the context of Oracle's sourcing and procurement modules, particularly where an item's sourcing rules, stock list assignments, and ASL reason codes need to be reported together. Unlike base tables, which often require complex joins and security predicates, this view encapsulates those joins and exposes a denormalized, query-friendly result set suitable for reports, inbound/outbound interfaces, and custom concurrent programs.

In EBS 12.2.2, the view is owned by APPS and is referenced by several ETRM (E-Business Suite Technical Reference Manual) entries. The view is built on top of MTL_SYSTEM_ITEMS_B_KFV, ORG_ORGANIZATION_DEFINITIONS, CSP_STOCK_LISTS, and FND_LOOKUPS, with supplemental calls to FND_GLOBAL, HR_GENERAL, and HR_SECURITY packages as part of the security and multi-org setup. The result is a single source for approved supplier item data combined with item planning attributes and human-readable lookup meanings.

Underlying Base Objects

The documented base objects for this view are:

  • CSP_STOCK_LISTS (synonym) — the ASL/stock list table providing the MANUAL_AUTO flag and REASON_CODE.
  • FND_LOOKUPS (view) — used to resolve the REASON_CODE into a readable meaning via lookup type CSP_ASL_REASON_CODE.
  • MTL_SYSTEM_ITEMS_B_KFV (view) — the key flexfield view over MTL_SYSTEM_ITEMS_B, providing item identifiers, concatenated segments, and planning attributes.
  • ORG_ORGANIZATION_DEFINITIONS (view) — supplies the organization name.
  • FND_GLOBAL, HR_GENERAL, HR_SECURITY (packages) — used for security and multi-org context.

The primary join condition links KFV.INVENTORY_ITEM_ID = CSL.INVENTORY_ITEM_ID(+) and KFV.ORGANIZATION_ID = CSL.ORGANIZATION_ID(+), making the stock list columns outer-joined so that items without an ASL entry still appear. The FND_LOOKUPS join is also outer, keyed on CSL.REASON_CODE = FND.LOOKUP_CODE(+) and FND.LOOKUP_TYPE(+) = 'CSP_ASL_REASON_CODE'. Critically, the view filters to KFV.INVENTORY_PLANNING_CODE = 2, restricting output to items using Min-Max planning.

Key Columns

The view exposes a broad set of item and sourcing columns. Notable ones include:

Common Use Cases and Queries

This view is commonly used to report items in Min-Max planning along with their approved supplier reason codes, to audit manual versus automatic ASL assignments, and to feed sourcing interfaces. A typical query referencing the CSP_ASL_REASON_CODE lookup is:

  • Find all Min-Max items with a specific ASL reason: SELECT inventory_item_id, organization_id, concatenated_segments, reason_code, reason_code_meaning FROM apps.csp_asl_items_v WHERE reason_code = 'YOUR_CODE';
  • List items without an ASL assignment: SELECT inventory_item_id, concatenated_segments FROM apps.csp_asl_items_v WHERE manual_auto = 'NO' AND reason_code IS NULL;
  • Report vendor-sourced Min-Max items: SELECT concatenated_segments, source_type_name, organization_name FROM apps.csp_asl_items_v WHERE source_type = 2;

Because the view applies an outer join to CSP_STOCK_LISTS and FND_LOOKUPS, queries return all qualifying Min-Max items regardless of whether an ASL entry exists. This behavior makes the view reliable for exception reporting and for reconciliation between item master setup and sourcing configuration across organizations in a multi-org environment.