Search Results pallet_wt




Overview
Explore in AI Chat

Overview

OP_PKGD_ITM is a Process Manufacturing Logistics (GML) table that stores packaged item definitions along with their shipping weights, fill quantities, and packaging attributes. In Oracle EBS 12.1.1 and 12.2.2, it serves as the master reference for the packaged (finished, sellable) form of a bulk product. Each row links a bulk item to a packaging configuration, allowing order entry, pricing, and shipping activities to operate on the packaged unit rather than the bulk item itself. The table is owned by the GML schema and is documented as VALID in ETRM.

From a Data Vault modeling perspective, the heuristic classification is hub-leaning. The SALESPKG_ID primary key behaves as a durable business key, and the surrounding descriptive and weight columns function as satellite attributes. The two foreign keys to IC_ITEM_MST and IC_ITEM_MST_B on BULK_ITEM_ID suggest a hub-to-hub relationship that could be modeled as a link. This is a modeling suggestion only; in the EBS physical schema, OP_PKGD_ITM is a conventional transactional master table.

Key Information Stored

The table contains 27 documented columns. The most important are:

Standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, TRANS_CNT) and TEXT_CODE complete the schema.

Common Use Cases and Queries

Typical reporting includes listing packaged items for a given bulk item, retrieving shipping weights for a sales package, and validating fill tolerances during order entry or shipping verification.

Sample query to list packaged items for a bulk item:

  • SELECT p.PACKAGED_ITEM_NO, p.PACKAGED_DESC, p.PKGITEM_UM, p.FILL_QTY, p.TARE_WT, p.PALLET_WT FROM GML.OP_PKGD_ITM p WHERE p.BULK_ITEM_ID = :bulk_item_id AND p.DELETE_MARK = 0;

Sample query to retrieve shipping weights for a sales package referenced on an order line:

  • SELECT o.SALESPKG_ID, p.PACKAGED_ITEM_NO, p.UNITS_PER_PALLET, p.PALLET_WT FROM GML.OP_ORDR_DTL o, GML.OP_PKGD_ITM p WHERE o.SALESPKG_ID = p.SALESPKG_ID AND o.ORDER_ID = :order_id;

Because SALESPKG_ID is reused across OP_CUST_ITM, OP_ORDR_DTL, and OP_PRSL_DTL, this table is frequently joined into order-line, pricing, and customer-item reporting extracts for GML process manufacturing.

Related Objects

  • IC_ITEM_MST — Master item table; joined on OP_PKGD_ITM.BULK_ITEM_ID = IC_ITEM_MST.ITEM_ID.
  • IC_ITEM_MST_B — Bulk item extension table; joined on OP_PKGD_ITM.BULK_ITEM_ID.
  • OP_CUST_ITM — Customer item cross-reference; references OP_PKGD_ITM.SALESPKG_ID.
  • OP_ORDR_DTL — Sales order detail lines; references OP_PKGD_ITM.SALESPKG_ID.
  • OP_PRSL_DTL — Proposal detail lines; references OP_PKGD_ITM.SALESPKG_ID.

These relationships make OP_PKGD_ITM a central reference point across item setup, order management, and pricing in Process Manufacturing Logistics.