Search Results csp_packlist_headers




Overview
Explore in AI Chat

Overview

CSP_PACKLIST_HEADERS is the header-level table for the Spares Management (CSP) packlist functionality in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores one row per packlist, which represents a shipment or receipt of spare parts associated with a specific inventory organization and subinventory. The table acts as the controlling parent record that groups individual packlist lines and boxes, providing the document-level attributes needed to track a packlist from creation through packing, shipment, and receipt.

Based on the foreign key structure, this object is classified heuristically as satellite-leaning in a Data Vault model. It carries descriptive and state attributes (dates, carrier, status) that hang off inventory and organization context rather than acting as a pure reference hub or associative link. The documented physical schema in 12.2.2 lists 37 columns owned by the CSP schema, with status VALID.

Key Information Stored

The surrogate primary key is PACKLIST_HEADER_ID, enforced by the CSP_PACKLIST_HEADERS_PK constraint and mirrored in the unique index CSP_PACKLIST_HEADERS_U1. No alternate business-key unique index other than the primary key column is documented, so PACKLIST_NUMBER functions as the principal user-facing identifier.

Common Use Cases and Queries

Typical reporting retrieves packlist headers with their line and box detail, tracks shipments awaiting receipt, or reconciles carrier and waybill data. A representative query joins the header to its boxes:

  • SELECT h.packlist_number, h.packlist_status, h.carrier, h.waybill, b.box_id FROM csp_packlist_headers h, csp_packlist_boxes b WHERE b.packlist_header_id = h.packlist_header_id AND h.organization_id = :org_id;
  • Filter on PACKLIST_STATUS and DATE_SHIPPED to find in-transit packlists, or on DATE_RECEIVED to confirm closure.
  • Join to MTL_SECONDARY_INVENTORIES on ORGANIZATION_ID and SUBINVENTORY_CODE for subinventory descriptions.
  • Use the ATTRIBUTE columns for customer-specific flexfield reporting.

Related Objects

  • CSP_PACKLIST_BOXES — child table joined on PACKLIST_HEADER_ID.
  • CSP_PACKLIST_LINES — child table joined on PACKLIST_HEADER_ID, holding packlist line detail.
  • MTL_SECONDARY_INVENTORIES — referenced via ORGANIZATION_ID and SUBINVENTORY_CODE.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
  • MTL_SYSTEM_ITEMS_B / MTL_ONHAND_QUANTITIES — commonly joined through packlist lines to resolve item and on-hand context.