Search Results nettable_ind




Overview
Explore in AI Chat

Overview

IC_LOTS_STS is the lot status master table in the Oracle E-Business Suite Process Manufacturing Inventory (GMI) module. It resides in the GMI schema and is registered as a VALID table in both Oracle EBS 12.1.1 and 12.2.2. Its purpose is to define and store the set of valid lot status codes used throughout Process Manufacturing inventory transactions. Every inventory lot in a process manufacturing organization carries a status — such as released, quarantine, or rejected — and that status value must resolve to a row in this table.

The table functions as a reference or lookup object rather than a transactional fact table. It supplies the controlled vocabulary of lot statuses that governs whether a lot can be transacted, consumed, shipped, or produced. The ETRM heuristic Data Vault classification for IC_LOTS_STS is hub-leaning. As a modeling suggestion, this reflects the table's role as an authority list of business keys: the primary key column, LOT_STATUS, acts as a natural hub key, while descriptive attributes and indicator flags attached to each status behave like satellite attributes. Analysts building a Data Vault or dimensional model from GMI data would typically treat IC_LOTS_STS as a status dimension or hub.

Key Information Stored

The documented physical schema for IC_LOTS_STS in ETRM 12.2.2 contains 18 columns. The primary key is defined by the unique index IC_LOTS_STS_PK on the LOT_STATUS column, making LOT_STATUS both the surrogate primary key and the sole documented business-key candidate.

  • LOT_STATUS — The primary key and core business key. Holds the status code assigned to lots, and is referenced by numerous transactional and master tables.
  • STATUS_ID — An identifier associated with the status, distinct from the code itself.
  • STATUS_DESC — The human-readable description of the status used in reports and user interfaces.
  • QCHOLD_RES_CODE — Foreign key to QC_HRES_MST, linking a status to a Quality control hold resource reason.
  • TEXT_CODE — Foreign key to IC_TEXT_HDR, connecting the status to an extended text block.
  • NETTABLE_IND — Indicator controlling whether lots in this status are treated as nettable for inventory balance purposes.
  • ORDER_PROC_IND — Indicator governing whether order processing is permitted for lots in this status.
  • PROD_IND — Indicator controlling whether the status permits production activity.
  • SHIPPING_IND — Indicator determining whether lots in this status may be shipped.
  • REJECTED_IND — Indicator flagging the status as a rejected condition.
  • TRANS_CNT — A transaction counter used for concurrency or audit tracking.
  • DELETE_MARK — Soft-delete flag indicating logical removal of the status record.
  • MIGRATED_IND — Indicator marking records migrated from a prior system.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture standard Oracle WHO-column auditing.

The indicator flags collectively define the behavioral profile of each status, allowing the application to enforce business rules without hardcoding logic.

Common Use Cases and Queries

Typical uses include validating lot status codes, driving inventory availability logic, and reporting on the disposition of lots across warehouses and periods. Because many tables hold a LOT_STATUS column that references this table, a common reporting pattern is to join transactional records back to IC_LOTS_STS to obtain the status description and its behavioral indicators.

A representative query retrieves lot statuses that permit shipping:

  • SELECT LOT_STATUS, STATUS_DESC FROM IC_LOTS_STS WHERE SHIPPING_IND = 'Y' AND DELETE_MARK = 0;
  • Joining inventory by location: SELECT l.LOT_STATUS, s.STATUS_DESC FROM IC_LOCT_INV l, IC_LOTS_STS s WHERE l.LOT_STATUS = s.LOT_STATUS;
  • Identifying quarantined lots: SELECT * FROM IC_LOTS_STS WHERE QCHOLD_RES_CODE IS NOT NULL;

Analysts also use the table to profile nettable versus non-nettable inventory and to explain variance in period balances, since IC_PERD_BAL stores LOT_STATUS.

Related Objects

IC_LOTS_STS participates in a wide web of referential relationships. It references two tables and is referenced by many more.

  • IC_TEXT_HDR — Referenced by IC_LOTS_STS.TEXT_CODE for extended status text.
  • QC_HRES_MST — Referenced by IC_LOTS_STS.QCHOLD_RES_CODE for quality hold resource definitions.
  • IC_LOCT_INV — Inventory by location; joins on LOT_STATUS to inherit status attributes.
  • IC_PERD_BAL — Period balances; joins on LOT_STATUS for status-based balance reporting.
  • IC_ITEM_MST and IC_ITEM_MST_B — Item master tables that carry a default or assigned LOT_STATUS.
  • IC_TRAN_PND, IC_TRAN_CMP, and IC_TRAN_ARC — Pending, completed, and archived transaction tables, each storing LOT_STATUS for transaction history.
  • IC_ADJS_JNL — Adjustment journal; records LOT_STATUS for lot adjustments.
  • IC_XFER_MST — Transfer master; references LOT_STATUS on transfer documents.

Together these relationships confirm IC_LOTS_STS as a foundational reference table whose keys propagate across the process manufacturing inventory and quality domains.