Search Results csp_packlist_boxes_u1

Overview

CSP.CSP_PACKLIST_BOXES is a transactional table in the Oracle E-Business Suite 12.1.1 and 12.2.2 schema owned by CSP. It stores the weight and the name of each box used for packing parts on a move order. The table functions as a child of the packlist header structure: every row represents a single physical box associated with a packlist header, and downstream packing lines reference that box. It resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, consistent with high-transaction OLTP data in a multi-org EBS deployment.

Based on the foreign-key topology mined from the ETRM metadata, the object carries a satellite-leaning Data Vault classification. Its dependency on CSP_PACKLIST_HEADERS through PACKLIST_HEADER_ID, combined with the child relationship from CSP_PACKLIST_LINES.BOX_ID, indicates that it behaves as a descriptive satellite attached to the packlist header hub/link while itself seeding a further child relationship. This classification is a modeling suggestion rather than an enforced EBS construction.

Key Information Stored

The table comprises 27 documented columns. The most significant are:

• BOX_ID — the surrogate primary key, enforced by the unique index CSP_PACKLIST_BOXES_U1 on column BOX_ID. The ETRM documentation also lists CSP_PACKLIST_BOXES_PK on BOX_ID.
• BOX_NAME (VARCHAR2(30)) — the descriptive name of the box.
• WEIGHT (NUMBER(35)) — the weight recorded for the box.
• PACKLIST_HEADER_ID — the foreign key to CSP_PACKLIST_HEADERS and the parent linkage for the box.
• ORGANIZATION_ID — the organization identifier that ties the box to a specific inventory organization.
• SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS that scopes row-level access.
• The five standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — which provide auditability.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the Descriptive Flexfield structure-defining and segment columns enabling customer extensions.

Only BOX_ID is documented as a unique (business-key) candidate via CSP_PACKLIST_BOXES_U1. A nonunique index, CSP_PACKLIST_BOXES_N1, exists on PACKLIST_HEADER_ID to support parent-key lookups.

Common Use Cases and Queries

Typical usage centers on move-order packing and shipment reporting, where users retrieve the boxes belonging to a packlist and their associated weights:

• Listing all boxes for a packlist header, driving from the nonunique index: SELECT box_id, box_name, weight FROM csp_packlist_boxes WHERE packlist_header_id = :header_id;
• Aggregating total packed weight per packlist header for shipping manifests.
• Joining to CSP_PACKLIST_LINES to report the contents of each box.
• Filtering by ORGANIZATION_ID for multi-org reporting across inventory organizations.
• Auditing box creation and weight changes through the Who columns.
• Reading or writing flexfield values in ATTRIBUTE1 through ATTRIBUTE15 for customer-specific extensions.

Related Objects

The ETRM dependency data identifies the following significant related objects:

• CSP_PACKLIST_HEADERS — the parent header, joined on CSP_PACKLIST_BOXES.PACKLIST_HEADER_ID = CSP_PACKLIST_HEADERS.PACKLIST_HEADER_ID.
• CSP_PACKLIST_LINES — the child packing lines, joined on CSP_PACKLIST_LINES.BOX_ID = CSP_PACKLIST_BOXES.BOX_ID.
• FND_SECURITY_GROUPS — the security group reference, joined on CSP_PACKLIST_BOXES.SECURITY_GROUP_ID = FND_SECURITY_GROUPS.SECURITY_GROUP_ID.
• FND_USER — the source of user identifiers for the Who columns.

These relationships establish CSP_PACKLIST_BOXES as the central packing-level object between packlist headers and packlist lines in the CSP move-order packing model.