FND Design Data [Home] [Help]

Table: IC_WHSE_MST

Product: GMI - Process Manufacturing Inventory
Description: Warehouse master.This table contains warehouse definition information.
Implementation/DBA Data: TableGMI.IC_WHSE_MST
Primary Key: IC_WHSE_MST_PK
  1. ColumnWHSE_CODE
Primary Key: IC_WHSE_MST_U1
  1. ColumnMTL_ORGANIZATION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_WHSE_MST FK Joins to TableIC_TEXT_HDR IC_WHSE_MST.TEXT_CODE
IC_WHSE_MST FK Joins to TableSY_ADDR_MST IC_WHSE_MST.ADDR_ID
IC_WHSE_MST FK Joins to TableSY_ORGN_MST_B IC_WHSE_MST.ORGN_CODE
IC_WHSE_MST FK Joins to TableSY_ORGN_MST IC_WHSE_MST.ORGN_CODE
IC_WHSE_MST FK Joins to TableTX_TLOC_CDS IC_WHSE_MST.TAXLOC_CODE
TableCM_ACST_LED FK Joins to IC_WHSE_MST CM_ACST_LED.WHSE_CODE
TableCM_ADJS_DTL FK Joins to IC_WHSE_MST CM_ADJS_DTL.WHSE_CODE
TableCM_BRDN_DTL FK Joins to IC_WHSE_MST CM_BRDN_DTL.WHSE_CODE
TableCM_CMPT_DTL FK Joins to IC_WHSE_MST CM_CMPT_DTL.WHSE_CODE
TableCM_SCST_LED FK Joins to IC_WHSE_MST CM_SCST_LED.WHSE_CODE
TableCM_WHSE_ASC FK Joins to IC_WHSE_MST CM_WHSE_ASC.COST_WHSE_CODE
TableCM_WHSE_ASC FK Joins to IC_WHSE_MST CM_WHSE_ASC.WHSE_CODE
TableCM_WHSE_EFF FK Joins to IC_WHSE_MST CM_WHSE_EFF.COSTING_WHSE
TableCM_WHSE_SRC FK Joins to IC_WHSE_MST CM_WHSE_SRC.WHSE_CODE
TableFC_FCST_DTL FK Joins to IC_WHSE_MST FC_FCST_DTL.WHSE_CODE
TableGL_ACCT_MAP FK Joins to IC_WHSE_MST GL_ACCT_MAP.WHSE_CODE
TableGL_ACCU_MAP FK Joins to IC_WHSE_MST GL_ACCU_MAP.WHSE_CODE
TableGL_ALOC_BAS FK Joins to IC_WHSE_MST GL_ALOC_BAS.WHSE_CODE
TableGL_ITEM_CST FK Joins to IC_WHSE_MST GL_ITEM_CST.WHSE_CODE
TableGMF_BURDEN_PERCENTAGES FK Joins to IC_WHSE_MST GMF_BURDEN_PERCENTAGES.WHSE_CODE
TableGMP_FORM_EFF FK Joins to IC_WHSE_MST GMP_FORM_EFF.WHSE_CODE
TableGMP_ITEM_APS FK Joins to IC_WHSE_MST GMP_ITEM_APS.WHSE_CODE
TableGMP_ITEM_WPS FK Joins to IC_WHSE_MST GMP_ITEM_WPS.WHSE_CODE
TableIC_ADJS_JNL FK Joins to IC_WHSE_MST IC_ADJS_JNL.WHSE_CODE
TableIC_ALOT_PRM FK Joins to IC_WHSE_MST IC_ALOT_PRM.WHSE_CODE
TableIC_CYCL_HDR FK Joins to IC_WHSE_MST IC_CYCL_HDR.WHSE_CODE
TableIC_ITEM_WHS FK Joins to IC_WHSE_MST IC_ITEM_WHS.WHSE_CODE
TableIC_LOCT_INV FK Joins to IC_WHSE_MST IC_LOCT_INV.WHSE_CODE
TableIC_LOCT_MST FK Joins to IC_WHSE_MST IC_LOCT_MST.WHSE_CODE
TableIC_RANK_MST FK Joins to IC_WHSE_MST IC_RANK_MST.WHSE_CODE
TableIC_SUMM_INV FK Joins to IC_WHSE_MST IC_SUMM_INV.WHSE_CODE
TableIC_TRAN_ARC FK Joins to IC_WHSE_MST IC_TRAN_ARC.WHSE_CODE
TableIC_TRAN_CMP FK Joins to IC_WHSE_MST IC_TRAN_CMP.WHSE_CODE
TableIC_TRAN_PND FK Joins to IC_WHSE_MST IC_TRAN_PND.WHSE_CODE
TableIC_WHSE_INV FK Joins to IC_WHSE_MST IC_WHSE_INV.WHSE_CODE
TableIC_WHSE_REL FK Joins to IC_WHSE_MST IC_WHSE_REL.SOURCE_WHSE
TableIC_WHSE_REL FK Joins to IC_WHSE_MST IC_WHSE_REL.DEST_WHSE
TableIC_WHSE_STS FK Joins to IC_WHSE_MST IC_WHSE_STS.WHSE_CODE
TableIC_XFER_MST FK Joins to IC_WHSE_MST IC_XFER_MST.FROM_WAREHOUSE
TableIC_XFER_MST FK Joins to IC_WHSE_MST IC_XFER_MST.TO_WAREHOUSE
TableMR_ACTN_TBL FK Joins to IC_WHSE_MST MR_ACTN_TBL.WHSE_CODE
TableMR_ACTN_TBL FK Joins to IC_WHSE_MST MR_ACTN_TBL.WHSE_CODE_2
TableMR_MESG_TBL FK Joins to IC_WHSE_MST MR_MESG_TBL.WHSE_CODE1
TableMR_MESG_TBL FK Joins to IC_WHSE_MST MR_MESG_TBL.WHSE_CODE2
TableMR_TRAN_TBL FK Joins to IC_WHSE_MST MR_TRAN_TBL.WHSE_CODE
TableOP_CUST_ITM FK Joins to IC_WHSE_MST OP_CUST_ITM.WHSE_CODE
TableOP_CUST_MST_OPM FK Joins to IC_WHSE_MST OP_CUST_MST_OPM.FROM_WHSE
TableOP_CUST_MST_OPM FK Joins to IC_WHSE_MST OP_CUST_MST_OPM.TO_WHSE
TableOP_CUST_MST FK Joins to IC_WHSE_MST OP_CUST_MST.FROM_WHSE
TableOP_CUST_MST FK Joins to IC_WHSE_MST OP_CUST_MST.TO_WHSE
TableOP_CUST_SHP FK Joins to IC_WHSE_MST OP_CUST_SHP.WHSE_CODE
TableOP_ORDR_DTL FK Joins to IC_WHSE_MST OP_ORDR_DTL.TO_WHSE
TableOP_ORDR_DTL FK Joins to IC_WHSE_MST OP_ORDR_DTL.FROM_WHSE
TableOP_ORDR_HDR FK Joins to IC_WHSE_MST OP_ORDR_HDR.FROM_WHSE
TableOP_ORDR_HDR FK Joins to IC_WHSE_MST OP_ORDR_HDR.TO_WHSE
TableOP_PRCE_ITM FK Joins to IC_WHSE_MST OP_PRCE_ITM.WHSE_CODE
TableOP_PRSL_DTL FK Joins to IC_WHSE_MST OP_PRSL_DTL.FROM_WHSE
TableOP_PRSL_HDR FK Joins to IC_WHSE_MST OP_PRSL_HDR.FROM_WHSE
TableOP_PRSL_HDR FK Joins to IC_WHSE_MST OP_PRSL_HDR.TO_WHSE
TableOP_RELS_SCH FK Joins to IC_WHSE_MST OP_RELS_SCH.TO_WHSE
TableOP_RELS_SCH FK Joins to IC_WHSE_MST OP_RELS_SCH.FROM_WHSE
TablePM_BTCH_HDR FK Joins to IC_WHSE_MST PM_BTCH_HDR.WIP_WHSE_CODE
TablePM_HIST_HDR FK Joins to IC_WHSE_MST PM_HIST_HDR.ORIG_WIP_WHSE
TablePM_HIST_HDR FK Joins to IC_WHSE_MST PM_HIST_HDR.NEW_WIP_WHSE
TablePO_BPOS_DTL FK Joins to IC_WHSE_MST PO_BPOS_DTL.FROM_WHSE
TablePO_BPOS_DTL FK Joins to IC_WHSE_MST PO_BPOS_DTL.TO_WHSE
TablePO_ORDR_DTL FK Joins to IC_WHSE_MST PO_ORDR_DTL.FROM_WHSE
TablePO_ORDR_DTL FK Joins to IC_WHSE_MST PO_ORDR_DTL.TO_WHSE
TablePO_ORDR_HDR FK Joins to IC_WHSE_MST PO_ORDR_HDR.FROM_WHSE
TablePO_ORDR_HDR FK Joins to IC_WHSE_MST PO_ORDR_HDR.TO_WHSE
TablePO_RECV_DTL FK Joins to IC_WHSE_MST PO_RECV_DTL.TO_WHSE
TablePO_RECV_DTL FK Joins to IC_WHSE_MST PO_RECV_DTL.FROM_WHSE
TablePO_RECV_HDR FK Joins to IC_WHSE_MST PO_RECV_HDR.TO_WHSE
TablePO_RECV_HST FK Joins to IC_WHSE_MST PO_RECV_HST.TO_WHSE
TablePO_RELS_SCH FK Joins to IC_WHSE_MST PO_RELS_SCH.FROM_WHSE
TablePO_RELS_SCH FK Joins to IC_WHSE_MST PO_RELS_SCH.TO_WHSE
TablePO_VNIT_MST FK Joins to IC_WHSE_MST PO_VNIT_MST.WHSE_CODE
TablePS_WHSE_EFF FK Joins to IC_WHSE_MST PS_WHSE_EFF.WHSE_CODE
TableQC_RSLT_MST FK Joins to IC_WHSE_MST QC_RSLT_MST.WHSE_CODE
TableQC_SMPL_MST FK Joins to IC_WHSE_MST QC_SMPL_MST.WHSE_CODE
TableQC_SPEC_MST FK Joins to IC_WHSE_MST QC_SPEC_MST.WHSE_CODE