Results for “shipvend_id”

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

Overview

IC_LOTS_MST is the lot master table within the GMI (Process Manufacturing Inventory) product of Oracle E-Business Suite, residing in the GMI schema. It stores the definitive record of every lot and sublot defined for an item in a process manufacturing environment, functioning as the central reference point for lot-controlled inventory. In Oracle EBS 12.1.1 and 12.2.2, this table underpins lot genealogy, quality association, expiry control, and cross-modular inventory transactions.

Applying a heuristic Data Vault classification derived from the foreign key topology, IC_LOTS_MST behaves as a hub. It holds the durable business key of a lot (item plus lot and sublot identifiers) and is referenced by a broad set of transactional and quality satellites. When modeling, this table should be treated as the anchor for lot identity, with dependent tables representing links and satellites around it.

Key Information Stored

The table is documented with 60 columns. The most significant include:

• LOT_ID — surrogate identifier for the lot, forming part of the IC_LOTS_MST_PK unique index alongside ITEM_ID.
• ITEM_ID — foreign key to the item master; combined with LOT_NO and SUBLOT_NO in the IC_LOTS_MST_I1 business-key index.
• LOT_NO / SUBLOT_NO — the human-readable business identifiers of the lot and its sublot.
• LOT_DESC — descriptive text for the lot.
• QC_GRADE — quality grade assigned to the lot, referencing GMD_GRADES_B and QC_GRAD_MST.
• EXPIRE_DATE / RETEST_DATE — shelf-life and retest scheduling dates.
• EXPACTION_CODE / EXPACTION_DATE — expiry action reference (QC_ACTN_MST) and its effective date.
• ORIGINATION_TYPE / SHIPVEND_ID / VENDOR_LOT_NO — provenance of the lot, including the supplying vendor.
• STRENGTH — potency or concentration value for the lot.
• INACTIVE_IND / DELETE_MARK — status and soft-delete flags.
• TEXT_CODE — link to extended descriptive text in IC_TEXT_HDR.
• TRANS_CNT — transaction counter for concurrency tracking.
• ATTRIBUTE_CATEGORY and the ATTRIBUTE1–ATTRIBUTE30 flex columns — extensible descriptive attributes.
• ODM_LOT_NUMBER — externally assigned lot identifier.
• Standard audit columns (CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY) and the request/program concurrency fields.

Two unique indexes define identity: IC_LOTS_MST_PK (ITEM_ID, LOT_ID) as the surrogate primary key and IC_LOTS_MST_I1 (LOT_NO, SUBLOT_NO, ITEM_ID) as the business-key candidate.

Common Use Cases and Queries

Typical usage centers on lot lookups, expiry reporting, and joining lot identity to transactional history. A common query retrieves active lots for an item with their expiry data:

SELECT l.lot_no, l.sublot_no, l.lot_desc, l.expire_date, l.qc_grade
FROM gmi.ic_lots_mst l
WHERE l.item_id = :item_id AND NVL(l.inactive_ind,'N') = 'N' AND NVL(l.delete_mark,0) = 0;

Expiry monitoring reports join RETEST_DATE and EXPIRE_DATE against the current date. Lot genealogy and inventory reconciliation join LOT_ID to IC_LOCT_INV, IC_TRAN_CMP, or IC_PERD_BAL, while quality investigations join to QC_RSLT_MST and QC_SMPL_MST. Vendor traceability reporting uses SHIPVEND_ID against PO_VEND_MST.

Related Objects

• IC_ITEM_MST / IC_ITEM_MST_B — item definition referenced by ITEM_ID.
• IC_LOCT_INV — on-hand inventory by lot, joined on ITEM_ID and LOT_ID.
• IC_TRAN_CMP, IC_TRAN_PND, IC_TRAN_ARC — completed, pending, and archived inventory transactions.
• IC_PERD_BAL and IC_ADJS_JNL — period balances and adjustment journals.
• IC_XFER_MST — transfer transactions referencing lots.
• QC_RSLT_MST, QC_SMPL_MST, QC_SPEC_MST — quality results, samples, and specifications.
• GMD_GRADES_B and QC_GRAD_MST — quality grade definitions for QC_GRADE.
• PO_VEND_MST — vendor master for SHIPVEND_ID.
• IC_TEXT_HDR — extended text referenced by TEXT_CODE.
• LM_ITEM_DAT — laboratory item data keyed by lot.