Search Results csp_packlist_serial_lots




Overview
Explore in AI Chat

Overview

CSP_PACKLIST_SERIAL_LOTS is a transactional child table within the CSP (Spares Management) product of Oracle E-Business Suite, holding the serial number and lot number assignments recorded against a packlist line. In depot repair, field service, and spares logistics flows, a packlist represents the physical shipment or return manifest that accompanies goods moving between an organization and a customer or repair depot. Because spares items are frequently serial-controlled, lot-controlled, or both, the packlist must capture the exact serial numbers and lot numbers included in each shipment. This table provides that level of granularity, linking a packlist line to specific inventory instances.

Under the heuristic Data Vault classification derived from the foreign key structure, this table is best modeled as a link table. It resolves a many-to-many style association between packlist lines and the serial or lot identifiers held in Oracle Inventory, and it carries descriptive payload columns of its own. The classification is offered as a modeling suggestion; the table is a native EBS transactional entity, not a Data Vault artifact.

Key Information Stored

The documented physical schema for 12.2.2 contains 13 columns. The most significant are:

Common Use Cases and Queries

Primary use cases include verifying what serial numbers were shipped on a given packlist, reconciling packlist contents against inventory serial and lot records, and supporting returns, repair receipts, and warranty tracking. A representative query joins the packlist hierarchy to inventory masters:

  • List all serials on a packlist: SELECT psl.SERIAL_NUMBER, psl.QUANTITY FROM CSP_PACKLIST_SERIAL_LOTS psl WHERE psl.PACKLIST_LINE_ID = :line_id;
  • Validate a serial against Inventory: join SERIAL_NUMBER, INVENTORY_ITEM_ID, and ORGANIZATION_ID to MTL_SERIAL_NUMBERS.
  • Validate a lot against Inventory: join LOT_NUMBER, INVENTORY_ITEM_ID, and ORGANIZATION_ID to MTL_LOT_NUMBERS.
  • Trace a packlist line to its parent packlist: join PACKLIST_LINE_ID to CSP_PACKLIST_LINES and onward to the packlist header.

Reports typically aggregate QUANTITY by item and organization, or list serial-level detail for field service documentation.

Related Objects

  • CSP_PACKLIST_LINES — parent table; joined on CSP_PACKLIST_SERIAL_LOTS.PACKLIST_LINE_ID = CSP_PACKLIST_LINES.PACKLIST_LINE_ID.
  • MTL_SERIAL_NUMBERS — inventory serial master; joined on SERIAL_NUMBER, INVENTORY_ITEM_ID, and ORGANIZATION_ID.
  • MTL_LOT_NUMBERS — inventory lot master; joined on LOT_NUMBER, INVENTORY_ITEM_ID, and ORGANIZATION_ID.
  • FND_SECURITY_GROUPS — security group definition; joined on SECURITY_GROUP_ID.
  • MTL_SYSTEM_ITEMS_B — item definition for INVENTORY_ITEM_ID and ORGANIZATION_ID.