Results for “csp_sec_inventories”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSP_SEC_INVENTORIES is a table in the CSP (Spares Management) product schema of Oracle E-Business Suite, valid in both release 12.1.1 and 12.2.2. As stated in the ETRM metadata, its purpose is to "hold extra subinventory information." It functions as a CSP-specific extension to the standard Oracle Inventory subinventory model, allowing Spares Management to record attributes about a subinventory that are not available on the core MTL_SECONDARY_INVENTORIES table, such as ownership, return logistics destinations, condition classification, and spares-specific control flags. Each row is keyed by SECONDARY_INVENTORY_ID, the single primary key column of constraint CSP_SEC_INVENTORIES_PK.

Following the heuristic Data Vault classification mined from the foreign key structure, this table is best modeled as a link: it resolves relationships between a CSP parts loop, a repair hierarchy node, and a physical subinventory. That characterization is a modeling suggestion rather than a documented architectural assertion; functionally, the table behaves as a CSP satellite that carries descriptive attributes alongside those link relationships.

Key Information Stored

The table contains 37 documented columns. The most operationally significant are:

• SECONDARY_INVENTORY_ID — surrogate primary key (CSP_SEC_INVENTORIES_PK); also the sole business-key candidate via unique index CSP_SEC_INVENTORIES_U1.
• ORGANIZATION_ID — inventory organization owning the subinventory; part of the join to MTL_SECONDARY_INVENTORIES.
• SECONDARY_INVENTORY_NAME — the subinventory name; together with ORGANIZATION_ID it forms the logical foreign key to the core inventory subinventory table.
• PARTS_LOOP_ID — foreign key to CSP_PARTS_LOOPS_B, associating the subinventory with a spares parts loop definition.
• HIERARCHY_NODE_ID — foreign key to CSP_REP_HIERARCHIES, tying the subinventory to a repair hierarchy node.
• LOCATION_ID — inventory location associated with the subinventory record.
• CONDITION_TYPE — material condition classification used for spares handling.
• AUTORECEIPT_FLAG — controls whether receipts are automatically processed into this subinventory.
• SPARES_LOCATION_FLAG — identifies the subinventory as a spares stocking location.
• OWNER_RESOURCE_TYPE and OWNER_RESOURCE_ID — identify the owning resource of the material held.
• RETURN_ORGANIZATION_ID and RETURN_SUBINVENTORY_NAME — define the default return destination for repairable or excess material.
• GROUP_ID and LAST_EXCESS_RUN_DATE — support grouped processing and track the last excess-material run.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security access.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and the ATTRIBUTE1–ATTRIBUTE15 descriptive flexfield columns complete the structure.

Common Use Cases and Queries

Typical usage centers on resolving a subinventory's spares attributes in the context of a parts loop or repair hierarchy. A common pattern joins CSP_SEC_INVENTORIES to MTL_SECONDARY_INVENTORIES by organization and name:

• SELECT csi.secondary_inventory_id, csi.secondary_inventory_name, csi.condition_type, csi.autoreceipt_flag, csi.spares_location_flag FROM csp_sec_inventories csi WHERE csi.organization_id = :org_id.
• Reporting spares stocking locations: filter on SPARES_LOCATION_FLAG = 'Y' and join to CSP_PARTS_LOOPS_B via PARTS_LOOP_ID to attribute inventory to a loop.
• Return-destination analysis: select RETURN_ORGANIZATION_ID and RETURN_SUBINVENTORY_NAME to determine default return routing for repaired or excess items.
• Excess processing audits: use LAST_EXCESS_RUN_DATE and GROUP_ID to track which subinventories participated in the most recent excess run.

Related Objects

The documented foreign keys and joins define the most significant related objects:

• MTL_SECONDARY_INVENTORIES — joined on SECONDARY_INVENTORY_NAME and ORGANIZATION_ID; the core Inventory subinventory definition.
• CSP_PARTS_LOOPS_B — joined via PARTS_LOOP_ID; the parts loop base table.
• CSP_REP_HIERARCHIES — joined via HIERARCHY_NODE_ID; the repair hierarchy definition.
• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID; security grouping for access control.
• Standard CSP spares APIs and concurrent programs that read CSP_SEC_INVENTORIES to drive autoreceipt, return, and excess processing logic.