Search Results use_pkg_desc

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:

• SALESPKG_ID — Surrogate primary key (OP_PKGD_ITM_PK). Identifies the sales package record and is the column referenced by downstream transaction tables.
• BULK_ITEM_ID — Foreign key to IC_ITEM_MST and IC_ITEM_MST_B; identifies the bulk item from which the packaged item is derived.
• PACKAGED_ITEM_NO — Business-key candidate enforced by unique index OP_PKGD_ITM_U1. The user-facing packaged item number.
• PACKAGED_DESC and USE_PKG_DESC — Descriptive text for the packaged item and control flag for whether that description is applied.
• PKG_FORMULA_ID — Links the packaged item to its packaging formula.
• PKGITEM_UM — Unit of measure for the packaged item.
• FILL_QTY and FILL_UM — Standard fill quantity and its unit of measure.
• TARE_WT and TARE_UM — Tare (empty container) weight and unit.
• PALLET_WT and PALLET_UM — Pallet weight and unit.
• UNITS_PER_PALLET — Count of packaged units on a pallet.
• QTY_TOLERANCE_HI and QTY_TOLERANCE_LO — Acceptable over/under fill tolerances.
• PER_UNIT_VOL, PER_PALLET_VOL, and VOLUME_UM — Volumetric attributes.
• DELETE_MARK — Soft-delete flag used by EBS.

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.