Search Results csp_stock_lists_u2

Overview

CSP.CSP_STOCK_LISTS is a transactional table in the Oracle EBS CSP (Advanced Supply Chain Planning / Collaborative Planning) schema. It stores supplemental attribute information for stocklist items, specifically capturing how an item was placed on a stocklist and the rationale behind that placement. While the core stocklist-to-item relationship is maintained elsewhere, this table augments the stocklist definition by recording whether an entry was added manually or by an automated process, and, in the manual case, the reason code that justified the addition. This distinction is material for planning accuracy: items inserted through manual intervention can affect the credibility of demand/supply plans and are frequently audited.

The table is created with the APPS_TS_TX_DATA tablespace, PCT Free 10, and is registered against FND Design Data as CSP.CSP_STOCK_LISTS. From a Data Vault modeling perspective, the mined foreign-key structure (references to MTL_SYSTEM_ITEMS_B and FND_SECURITY_GROUPS) suggests a satellite-leaning classification: the table extends the stocklist/item relationship with descriptive attributes rather than defining a new business entity or acting as a pure association link.

Key Information Stored

• ORGANIZATION_ID (NUMBER 38) — Organization identifier; part of the composite primary key and of both unique business-key indexes.
• INVENTORY_ITEM_ID (NUMBER 38) — Inventory item identifier; the FK to MTL_SYSTEM_ITEMS_B and part of the primary key.
• SUBINVENTORY_CODE (VARCHAR2 30) — Subinventory code qualifying the stocklist entry; present in both unique indexes.
• MANUAL_AUTO (VARCHAR2 30) — Flag indicating whether the item was entered manually or automatically, the central reason this table exists.
• REASON_CODE (VARCHAR2 30) — Reason supplied when a manual stocklist item was entered.
• SECURITY_GROUP_ID (NUMBER 38) — Used in hosted environments; FK to FND_SECURITY_GROUPS.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns providing user and audit lineage.

The documented primary key is CSP_STOCK_LISTS_PK (ORGANIZATION_ID, INVENTORY_ITEM_ID). Two unique indexes act as business-key candidates: CSP_STOCK_LISTS_U1 (INVENTORY_ITEM_ID, SUBINVENTORY_CODE, ORGANIZATION_ID) and CSP_STOCK_LISTS_U2 (ORGANIZATION_ID, SUBINVENTORY_CODE, INVENTORY_ITEM_ID). The user’s search term, csp_stock_lists_u2, corresponds precisely to the second of these unique indexes. Both indexes carry the same three columns in differing orders, enforcing that no duplicate item/subinventory/organization combination may exist on a stocklist regardless of ordering. There are no documented non-unique indexes.

Common Use Cases and Queries

Typical scenarios include auditing manual stocklist additions, validating planner-maintained stocklists against automated ones, and generating reports that distinguish manual from system-generated entries. A common query filters by MANUAL_AUTO:

• SELECT inventory_item_id, subinventory_code, manual_auto, reason_code FROM csp.csp_stock_lists WHERE organization_id = :org AND manual_auto = 'MANUAL';
• Joining to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID and ORGANIZATION_ID for item descriptions and attributes.
• Joining to FND_SECURITY_GROUPS on SECURITY_GROUP_ID for hosted/multi-tenant filtering.
• Querying via the U2 index columns (ORGANIZATION_ID, SUBINVENTORY_CODE, INVENTORY_ITEM_ID) to optimize lookups by organization and subinventory.

Because the row is a satellite-style supplement, reporting should join it to the parent stocklist definition rather than treating it as a standalone source of truth.

Related Objects

• MTL_SYSTEM_ITEMS_B — Joined on INVENTORY_ITEM_ID; provides item master data for any stocklist entry.
• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID; supports hosted-environment row filtering.
• APPS.CSP_STOCK_LISTS — The APPS synonym/view layer referencing CSP.CSP_STOCK_LISTS, used by concurrent programs and forms.
• CSP_STOCK_LISTS_U1 / CSP_STOCK_LISTS_U2 — Unique indexes enforcing the item/subinventory/organization business key; U2 is the searched index.
• CSP_STOCK_LISTS_PK — Primary key on ORGANIZATION_ID and INVENTORY_ITEM_ID supporting direct row retrieval.
• FND_USER — Implicit reference via CREATED_BY and LAST_UPDATED_BY for audit trails.

No dependencies on other database objects are documented; the table is referenced only by its APPS synonym and consuming CSP application logic. Oracle Proprietary, Confidential Information.