Results for “csp_packlist_boxes”

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

Overview

CSP_PACKLIST_BOXES is a transactional table in the CSP (Spares Management) product schema of Oracle E-Business Suite, documented as valid in both 12.1.1 and 12.2.2. It stores the box-level detail of a packing list, allowing shipment contents to be grouped and tracked as discrete physical containers. A packing list header represents the overall shipment document, while each row in CSP_PACKLIST_BOXES represents an individual box belonging to that shipment, capturing attributes such as box identity, weight, and the inventory organization responsible for the packing operation.

From a Data Vault modeling perspective, the heuristic classification of CSP_PACKLIST_BOXES is satellite-leaning. It carries descriptive, context-dependent attributes (box name, weight) tied to a parent packing list header rather than serving purely as a hub of business keys or a link between independent entities. Modelers treating this table analytically would typically view it as a descriptive satellite attached to the CSP_PACKLIST_HEADERS hub, with dependent detail rows in CSP_PACKLIST_LINES.

Key Information Stored

The table contains 27 documented columns with a single-column primary key, CSP_PACKLIST_BOXES_PK, defined on BOX_ID. This surrogate identifier is also enforced by the unique index CSP_PACKLIST_BOXES_U1, making BOX_ID both the primary key and the sole documented business-key candidate.

• BOX_ID — Surrogate primary key uniquely identifying each box record.
• BOX_NAME — Descriptive label or identifier used to distinguish one box from another within the packing list.
• PACKLIST_HEADER_ID — Foreign key to CSP_PACKLIST_HEADERS, linking the box to its parent packing list document.
• ORGANIZATION_ID — Inventory organization context for the box, supporting multi-organization reporting.
• WEIGHT — Recorded weight of the box contents, used for shipping and manifest purposes.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing row-level data access for the record.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard EBS DFF (Descriptive Flexfield) column set, providing extensible, customer-defined attributes for the box.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record creation and modification.

Common Use Cases and Queries

Typical scenarios include reporting the boxes contained in a given packing list, validating box weights for shipment manifests, and tracing which packing list lines belong to which physical box. A simple join retrieves box detail for a specific packing list:

• SELECT b.box_id, b.box_name, b.weight FROM csp_packlist_boxes b WHERE b.packlist_header_id = :p_header_id;
• Aggregating box counts and weights per packing list: SELECT packlist_header_id, COUNT(*), SUM(weight) FROM csp_packlist_boxes GROUP BY packlist_header_id;
• Correlating boxes to lines: SELECT b.box_name, l.* FROM csp_packlist_boxes b JOIN csp_packlist_lines l ON l.box_id = b.box_id WHERE b.packlist_header_id = :p_header_id;

Because the table carries DFF attributes, reporting frequently unpacks ATTRIBUTE_CATEGORY and the ATTRIBUTE1–15 columns to surface customer-specific box metadata. Security-group filtering should be applied when queries run in a multi-org or secured context.

Related Objects

The following objects are the most significant dependencies derived from the documented foreign-key relationships:

• CSP_PACKLIST_HEADERS — Parent table; joined via CSP_PACKLIST_BOXES.PACKLIST_HEADER_ID = CSP_PACKLIST_HEADERS.PACKLIST_HEADER_ID.
• CSP_PACKLIST_LINES — Child detail table; references this table through CSP_PACKLIST_LINES.BOX_ID = CSP_PACKLIST_BOXES.BOX_ID, associating individual line items with a box.
• FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for row-level access control.

Together these objects form the packing list data model: header, box, and line, with security group integration governing visibility across the CSP Spares Management module.