FND Design Data [Home] [Help]

Table: IC_LOTS_STS

Product: GMI - Process Manufacturing Inventory
Description: Lot status table.
Implementation/DBA Data: TableGMI.IC_LOTS_STS
Primary Key: IC_LOTS_STS_PK
  1. ColumnLOT_STATUS
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_LOTS_STS FK Joins to TableIC_TEXT_HDR IC_LOTS_STS.TEXT_CODE
IC_LOTS_STS FK Joins to TableQC_HRES_MST IC_LOTS_STS.QCHOLD_RES_CODE
TableIC_ADJS_JNL FK Joins to IC_LOTS_STS IC_ADJS_JNL.LOT_STATUS
TableIC_ITEM_MST_B FK Joins to IC_LOTS_STS IC_ITEM_MST_B.LOT_STATUS
TableIC_ITEM_MST FK Joins to IC_LOTS_STS IC_ITEM_MST.LOT_STATUS
TableIC_LOCT_INV FK Joins to IC_LOTS_STS IC_LOCT_INV.LOT_STATUS
TableIC_PERD_BAL FK Joins to IC_LOTS_STS IC_PERD_BAL.LOT_STATUS
TableIC_TRAN_ARC FK Joins to IC_LOTS_STS IC_TRAN_ARC.LOT_STATUS
TableIC_TRAN_CMP FK Joins to IC_LOTS_STS IC_TRAN_CMP.LOT_STATUS
TableIC_TRAN_PND FK Joins to IC_LOTS_STS IC_TRAN_PND.LOT_STATUS
TableIC_XFER_MST FK Joins to IC_LOTS_STS IC_XFER_MST.LOT_STATUS