DBA Data[Home] [Help] [Dependency Information]

TABLE: GMI.IC_WHSE_MST

Object Details
Object Name: IC_WHSE_MST
Object Type: TABLE
Owner: GMI
FND Design Data: TableGMI.IC_WHSE_MST
Subobject Name:
Status: VALID


Warehouse master.This table contains warehouse definition information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IC_WHSE_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWHSE_CODE
IC_WHSE_MST_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMTL_ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
WHSE_CODE VARCHAR2 (4) Yes Code for the warehouse.
WHSE_NAME VARCHAR2 (40) Yes Name of the warehouse.
ORGN_CODE VARCHAR2 (4) Yes Organization that owns the warehouse.
LOCT_CTL NUMBER (5) Yes Location control indicator. 0=Warehouse is not location controlled, 1=Validated location control, 2=Non-validated location control.
ADDR_ID NUMBER (10)
Surrogate key to the address of the warehouse.
CONSIGN_IND NUMBER (5) Yes Consignment indicator. 0=Not a consigment warehouse, 1=Consignment warehouse.
NONNET_IND NUMBER (5) Yes Not currently used.
REGION_CODE VARCHAR2 (8)
Region code.
WHSE_CLASS VARCHAR2 (8)
Warehouse class. Not currently validated.
WHSE_CONTACT VARCHAR2 (40)
Contact person at the warehouse.
WHSE_PHONE VARCHAR2 (20)
Phone number.
TAXLOC_CODE VARCHAR2 (10)
Tax location of warehouse.
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
TRANS_CNT NUMBER (10)
Not currently used
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
INGREDIENT_STAGE VARCHAR2 (16)
Staging location for ingredients.
PRODUCT_STAGE VARCHAR2 (16)
Staging location for products.
RECV_STAGE VARCHAR2 (16)
Staging location for receiving. Acts as default location for receiving allocations.
SHIP_STAGE VARCHAR2 (16)
Staging location for shipping. Acts as default location for shipment allocations.
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
MTL_ORGANIZATION_ID NUMBER

mtl_organization_id for the IC_WHSE_MST table
DISABLE_WAREHOUSE_IND VARCHAR2 (1)
Indicator for disable the existing inventory org for the warehouse. Y- Yes, N- No
MIGRATED_IND NUMBER (1)
Migrated Indicator. 0 - Not Migrated, 1 - Migrated
ORGANIZATION_ID NUMBER (15)
Organization Id under which the warehouse has been migrated as subinventory
SUBINVENTORY_IND_FLAG VARCHAR2 (1)
Indicator for migrating the warehouse as a subinventory. Y- Yes, N- No
COST_ORGANIZATION_ID NUMBER (15)
Organization under which costs have to be migrated to
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT WHSE_CODE
,      WHSE_NAME
,      ORGN_CODE
,      LOCT_CTL
,      ADDR_ID
,      CONSIGN_IND
,      NONNET_IND
,      REGION_CODE
,      WHSE_CLASS
,      WHSE_CONTACT
,      WHSE_PHONE
,      TAXLOC_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      TRANS_CNT
,      DELETE_MARK
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      INGREDIENT_STAGE
,      PRODUCT_STAGE
,      RECV_STAGE
,      SHIP_STAGE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ATTRIBUTE_CATEGORY
,      MTL_ORGANIZATION_ID
,      DISABLE_WAREHOUSE_IND
,      MIGRATED_IND
,      ORGANIZATION_ID
,      SUBINVENTORY_IND_FLAG
,      COST_ORGANIZATION_ID
FROM GMI.IC_WHSE_MST;

Dependencies

[top of page]

GMI.IC_WHSE_MST does not reference any database object

GMI.IC_WHSE_MST is referenced by following:

SchemaGMI
ViewIC_WHSE_MST#