Search Results csp_packlist_lines_pk

Overview

The CSP_PACKLIST_LINES table is a core transactional entity within the Oracle E-Business Suite Spares Management (CSP) module. It serves as the detailed repository for all line items included on a packing list, which is a critical document in the logistics and fulfillment process for spare parts. Each record in this table represents a specific inventory item that has been allocated and prepared for shipment to fulfill a service request or move order. The table's primary role is to track the precise quantity of each part being packed, link that item to its source pick list and move order lines, and associate it with a specific physical container or box for shipment. Its integrity is maintained through a robust set of foreign key relationships to other fundamental inventory and spares management tables.

Key Information Stored

While the full column list is not detailed in the provided metadata, the foreign key relationships and primary key define the essential data structure. The central identifier is the PACKLIST_LINE_ID, which is the primary key for each unique pack list line. Critical relational columns include PICKLIST_LINE_ID, which links back to the source CSP_PICKLIST_LINES record, and LINE_ID, which references the original demand line in either MTL_TXN_REQUEST_LINES or CSP_MOVEORDER_LINES. The INVENTORY_ITEM_ID and ORGANIZATION_ID columns uniquely identify the specific item and inventory organization being shipped, tied to MTL_SYSTEM_ITEMS_B. The BOX_ID associates the line item with a specific physical container defined in CSP_PACKLIST_BOXES. The table also likely stores the packed QUANTITY and potentially status flags to manage the packing workflow.

Common Use Cases and Queries

A primary use case is generating or auditing the contents of a packing list for a specific shipment or box. For example, a query to list all items in a specific pack list box would join CSP_PACKLIST_LINES to MTL_SYSTEM_ITEMS_B for item details. Another critical scenario is tracing the fulfillment lineage from the original move order line, through the pick list, to the final packed item, requiring joins to CSP_MOVEORDER_LINES and CSP_PICKLIST_LINES. Reporting on packing efficiency or identifying items pending packing often involves aggregating quantities from this table and filtering by status. A common SQL pattern is to select pack list lines along with their associated serial or lot numbers from the child CSP_PACKLIST_SERIAL_LOTS table for detailed shipment tracking.

Related Objects

The table is centrally connected within the Spares Management data model. Key documented relationships are:

• Primary Key: CSP_PACKLIST_LINES_PK on PACKLIST_LINE_ID.
• Foreign Keys (Referenced By This Table):
  • MTL_SYSTEM_ITEMS_B via INVENTORY_ITEM_ID and ORGANIZATION_ID.
  • MTL_TXN_REQUEST_LINES via LINE_ID.
  • CSP_PACKLIST_BOXES via BOX_ID.
  • CSP_PICKLIST_LINES via PICKLIST_LINE_ID.
  • CSP_MOVEORDER_LINES via LINE_ID.
• Foreign Keys (Referencing This Table):
  • CSP_PACKLIST_SERIAL_LOTS via PACKLIST_LINE_ID, which stores detailed serial and lot control information for each packed line.