Results for “deviation_hi”

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

Overview

The IC_PKGS_MST table is a physical database object owned by the GMI schema and belongs to the Oracle Process Manufacturing Inventory (OPM Inventory) module. In Oracle EBS 12.1.1 and 12.2.2, this table participates in the packaging and container specification model used by process manufacturing operations. The object is formally marked as *NOT USED* in the ETRM documentation, meaning Oracle no longer treats it as an active functional entity within the current application logic; however, the table remains VALID at the database level and continues to hold legacy data, foreign key constraints, and index structures that may be referenced by surviving integration points.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure is satellite-leaning. This suggests the table is best interpreted as a descriptive satellite capturing attributes about a packaging entity rather than as a hub of independent business keys or a pure link table. The single-column primary key IC_PKGS_MST_PK on PKG_ID supports this interpretation, as PKG_ID behaves as a candidate business key referenced by parent inventory structures.

Key Information Stored

The table contains 16 documented columns. The most significant are summarized below.

• PKG_ID — The surrogate primary key and the sole unique index candidate (IC_PKGS_MST_PK). It identifies each packaging specification record and is the column referenced by dependent inventory tables.
• FILL_QTY and FILL_UM — The fill quantity and its unit of measure. FILL_UM carries a foreign key to SY_UOMS_MST, establishing the valid UOM domain.
• TARE_WT and TARE_UM — The tare weight and its unit of measure. TARE_UM is likewise constrained against SY_UOMS_MST.
• DEVIATION_LO and DEVIATION_HI — Lower and upper tolerance thresholds applied to fill or weight specifications.
• RETURN_CODE — A code indicating return or disposition behavior associated with the package.
• TEXT_CODE — A foreign key to IC_TEXT_HDR, linking the package record to extended textual or instructional content.
• DELETE_MARK — The standard OPM soft-delete flag; records with DELETE_MARK set are logically removed.
• TRANS_CNT — A transaction counter used for concurrency control and audit lineage.
• CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns capturing who created and last modified each row and when.

Common Use Cases and Queries

Because the table is documented as not used, contemporary development should treat it as a read-only legacy artifact. Typical investigative queries include retrieving active packaging specifications by joining to the UOM master, and tracing which inventory items still reference a given package identifier.

• Listing non-deleted package specifications with their units of measure:
  SELECT p.PKG_ID, p.FILL_QTY, p.FILL_UM, p.TARE_WT, p.TARE_UM
FROM GMI.IC_PKGS_MST p
WHERE NVL(p.DELETE_MARK,0) = 0;
• Joining to SY_UOMS_MST to resolve UOM descriptions for both fill and tare units.
• Identifying items that depend on a package via IC_ITEM_MST.PKG_ID, useful when assessing the impact of retiring or migrating legacy packaging data.

Related Objects

The following objects are most significant in relation to IC_PKGS_MST, based on documented foreign key relationships.

• IC_TEXT_HDR — Referenced by IC_PKGS_MST.TEXT_CODE; supplies extended textual content.
• SY_UOMS_MST — Referenced twice, through FILL_UM and TARE_UM, providing unit of measure definitions.
• IC_ITEM_MST — References IC_PKGS_MST through its PKG_ID column; the primary item master link.
• IC_ITEM_MST_B — References IC_PKGS_MST.PKG_ID at the item master detail level.
• GMI_ITEMS_XML_INTERFACE — References IC_PKGS_MST.PKG_ID, indicating the package identifier is carried through the item XML integration interface, a notable dependency despite the table's deprecated status.