FND Design Data [Home] [Help]

Table: IC_LOCT_MST

Product: GMI - Process Manufacturing Inventory
Description: This table contains location information for location controlled warehouses.
Implementation/DBA Data: TableGMI.IC_LOCT_MST
Primary Key: IC_LOCT_MST_PK
  1. ColumnWHSE_CODE
  2. ColumnLOCATION
Primary Key: IC_LOCT_MST_U1
  1. ColumnINVENTORY_LOCATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_LOCT_MST FK Joins to TableIC_TEXT_HDR IC_LOCT_MST.TEXT_CODE
IC_LOCT_MST FK Joins to TableIC_WHSE_MST IC_LOCT_MST.WHSE_CODE
IC_LOCT_MST FK Joins to TableSY_UOMS_MST IC_LOCT_MST.CAPACITY_UM
TableIC_TRAN_ARC FK Joins to IC_LOCT_MST IC_TRAN_ARC.WHSE_CODE
IC_TRAN_ARC.LOCATION
TableQC_RSLT_MST FK Joins to IC_LOCT_MST QC_RSLT_MST.WHSE_CODE
QC_RSLT_MST.LOCATION
TableQC_SPEC_MST FK Joins to IC_LOCT_MST QC_SPEC_MST.WHSE_CODE
QC_SPEC_MST.LOCATION