Search Results salespkg_id




Overview
Explore in AI Chat

Overview

The OP_PKGD_ITM table is a core data object within the Process Manufacturing Logistics (GML) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the master repository for packaged item definitions, which are distinct from bulk or raw material items. The table's primary role is to store the names and shipping weights for these packaged items, establishing a critical link between a sales package identifier and its corresponding bulk item. This master data is essential for downstream logistics, sales order processing, and pricing activities within the manufacturing and distribution cycle.

Key Information Stored

The table's structure centers on two key identifiers and their related attributes. The primary business key is the SALESPKG_ID, which uniquely identifies a packaged item within the sales and order management context. A unique constraint also exists on PACKAGED_ITEM_NO, providing an alternate identifier. A critical foreign key is BULK_ITEM_ID, which links the packaged item to its source bulk material defined in the inventory items master table (IC_ITEM_MST). While the explicit column list is not fully detailed in the provided metadata, the description confirms the table holds packaged item names and shipping weights, implying columns such as DESCRIPTION and SHIPPING_WEIGHT are present to support these functions.

Common Use Cases and Queries

This table is central to operations involving the sale and shipment of finished goods. Common use cases include generating packing lists with accurate weights, determining freight charges, and ensuring the correct packaged item is selected on sales orders and quotations. A typical query might join OP_PKGD_ITM to the inventory master to retrieve a comprehensive item listing for a catalog or report.

  • Sample Query for Packaged Item Details:
    SELECT pi.salespkg_id, pi.packaged_item_no, pi.description, pi.shipping_weight, im.item_no AS bulk_item_number
    FROM gml.op_pkgd_itm pi,
         inv.ic_item_mst im
    WHERE pi.bulk_item_id = im.item_id
    AND im.organization_id = :p_org_id;
  • Reporting use cases often involve aggregating shipped weight by sales package or validating that all active packaged items have a valid bulk item reference.

Related Objects

As indicated by its foreign key relationships, OP_PKGD_ITM is a hub table referenced by several transactional entities. The primary key (SALESPKG_ID) is referenced by the OP_CUST_ITM (customer-specific item data), OP_ORDR_DTL (sales order lines), and OP_PRSL_DTL (proposal or quotation lines) tables, demonstrating its integral role in the order-to-cash process. Its defining relationship is with the inventory master, via the BULK_ITEM_ID foreign key to both IC_ITEM_MST and IC_ITEM_MST_B, anchoring packaged items to the foundational item definition.