FND Design Data [Home] [Help]

Table: IC_LOCT_INV

Product: GMI - Process Manufacturing Inventory
Description: Location inventory table.
Implementation/DBA Data: TableGMI.IC_LOCT_INV
Primary Key: IC_LOCT_INV_PK
  1. ColumnITEM_ID
  2. ColumnWHSE_CODE
  3. ColumnLOT_ID
  4. ColumnLOCATION
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_LOCT_INV FK Joins to TableIC_LOTS_MST IC_LOCT_INV.ITEM_ID
IC_LOCT_INV.LOT_ID
IC_LOCT_INV FK Joins to TableIC_LOTS_STS IC_LOCT_INV.LOT_STATUS
IC_LOCT_INV FK Joins to TableIC_TEXT_HDR IC_LOCT_INV.TEXT_CODE
IC_LOCT_INV FK Joins to TableIC_WHSE_MST IC_LOCT_INV.WHSE_CODE
IC_LOCT_INV FK Joins to TableQC_HRES_MST IC_LOCT_INV.QCHOLD_RES_CODE