Results for “csp_packlist_boxes_v”

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

Overview

CSP_PACKLIST_BOXES_V is a valid database view owned by the APPS schema within the CSP — Spares Management product family of Oracle E-Business Suite. Its documented purpose is to present "boxes belonging to packlists," making it a focused reporting and integration object for packlist boxing data. In the logistics and shipping workflow of Spares Management, packlists group items for dispatch, and individual physical boxes serve as the containers that hold those items. This view exposes the box-level detail associated with each packlist header, along with descriptive attributes and standard EBS audit columns.

The view is essentially a projection over a single base object. Rather than joining header, line, and inventory tables, it presents the box records with a stable set of columns, including the ROWID and a full set of descriptive flexfield attributes. This design makes the view well suited to queries, extracts, and interface programs that need box information without navigating the underlying transactional schema directly. Because the view carries the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN), it supports audit-oriented reporting and change tracking.

In Oracle EBS 12.1.1 and 12.2.2, the view remains consistent in structure and continues to be documented in the ETRM metadata with owner APPS and status VALID. Its presence as a view, rather than a table, means it abstracts the physical storage of box records while preserving column names and semantics for downstream consumers.

Underlying Base Objects

Per the documented metadata, CSP_PACKLIST_BOXES_V is defined over a single referenced base object: the synonym CSP_PACKLIST_BOXES. The view text confirms this relationship directly, selecting all exposed columns FROM CSP_PACKLIST_BOXES B. There are no joins, unions, groupings, or filters in the view definition, so it functions as a straightforward column-level projection of the base table.

Because the synonym typically resolves to the underlying APPS-owned table that stores packlist box records, the view and its base table share the same grain: one row per box. The view adds no derived calculated columns and applies no WHERE clause, so row counts and key values remain aligned with the base object. The documented DBA reference lists the view under APPS.CSP_PACKLIST_BOXES_V and identifies CSP_PACKLIST_BOXES as a synonym, reinforcing that the view is a read-oriented layer over the box entity in the Spares Management schema.

Key Columns

• ROW_ID — Exposes the base table ROWID, useful for row identification in certain EBS forms and DML operations.
• BOX_ID — The primary surrogate key identifying each box record.
• BOX_NAME — The descriptive name or label of the box; this is the column most directly associated with the searched term "box_name" and is commonly used to identify a specific box within a packlist.
• ORGANIZATION_ID — Identifies the inventory organization to which the box belongs, enabling multi-org aware querying.
• PACKLIST_HEADER_ID — Foreign key linking the box to its parent packlist header, establishing the box-to-packlist relationship.
• WEIGHT — The recorded weight of the box, relevant for shipping and carrier documentation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit (WHO) columns capturing record creation and modification history.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield (DFF) columns that store client-specific, context-sensitive box attributes.

Common Use Cases and Queries

Typical scenarios include listing all boxes on a given packlist, retrieving box names and weights for shipping documentation, extracting box data for integration with carrier or warehouse systems, and validating that boxes are correctly associated with an organization and packlist header. Because the view exposes BOX_NAME directly, it is frequently used when users search for a box by name.

Sample query — all boxes for a specific packlist:

• SELECT box_id, box_name, organization_id, weight
• FROM apps.csp_packlist_boxes_v
• WHERE packlist_header_id = :packlist_header_id;

Sample query — locate a box by name:

• SELECT box_id, box_name, packlist_header_id, organization_id
• FROM apps.csp_packlist_boxes_v
• WHERE box_name = :box_name;

Sample query — box totals and weights by organization:

• SELECT organization_id, COUNT(*) box_count, SUM(weight) total_weight
• FROM apps.csp_packlist_boxes_v
• GROUP BY organization_id;

These patterns reflect the view's role as a concise, query-friendly interface to packlist box data across Oracle EBS 12.1.1 and 12.2.2.