eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMI.IC_WHSE_REL

Object Details

Object Name:	IC_WHSE_REL
Object Type:	TABLE
Owner:	GMI
FND Design Data:	GMI.IC_WHSE_REL
Subobject Name:
Status:	VALID

Warehouse transfer rules table. This table contains information on transfers between warehouses, it is used by MRP.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_WHSE_REL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	WHSEREL_ID
IC_WHSE_REL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SOURCE_WHSE DEST_WHSE ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WHSEREL_ID	NUMBER	(15)	Yes	Surrogate ID for this record
SOURCE_WHSE	VARCHAR2	(4)		Warehouse from which the item is transferred.
DEST_WHSE	VARCHAR2	(4)		Warehouse to which the item is transferred.
ITEM_ID	NUMBER	(10)		Surrogate key for the item transferred.
FIXED_LEADTIME	NUMBER		Yes	Fixed component of transfer leadtime, in days.
VARIABLE_LEADTIME	NUMBER		Yes	Variable component of transfer leadtime, in days. This is added for each multiple of the std_qty.
INNER_TIMEFENCE	NUMBER		Yes	Inner fence in days. MRP will not make transfer suggestions within this period.
OUTER_TIMEFENCE	NUMBER		Yes	Outer fence in days. MRP will not make transfer suggestions after this point.
MIN_QTY	NUMBER		Yes	Minimum qty that can be suggested in one MRP transfer suggestion.
MAX_QTY	NUMBER		Yes	Macimum qty that can be suggested in one MRP transfer suggestion.
STD_QTY	NUMBER		Yes	Standard transfer qty.
RULE_TYPE	NUMBER	(5)	Yes	Reorder rule type. 0=Manual planning, 1=Lot for lot, 2=Economic order quantity.
PREFERENCE	NUMBER	(5)	Yes	Preference indicator for selecting among different warehouse transfer rules for the item when it is required in the dest_whse.
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
DELETE_MARK	NUMBER	(5)	Yes	Standard: 0=Active record (default); 1=Marked for (logical) deletion.
TRANS_CNT	NUMBER	(10)		Not currently used
TEXT_CODE	NUMBER	(10)		ID which joins any rows of text in this table to the Text Table for this Module
TRANSFER_TYPE	NUMBER	(5)	Yes	Transfer type. 0=Transfer suggested only if entire required qty available in source_whse, 1=Forced transfer, 2=Partial transfer allowed.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT WHSEREL_ID
,      SOURCE_WHSE
,      DEST_WHSE
,      ITEM_ID
,      FIXED_LEADTIME
,      VARIABLE_LEADTIME
,      INNER_TIMEFENCE
,      OUTER_TIMEFENCE
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      RULE_TYPE
,      PREFERENCE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      TRANSFER_TYPE
,      LAST_UPDATE_LOGIN
FROM GMI.IC_WHSE_REL;

Dependencies

[top of page]

GMI.IC_WHSE_REL does not reference any database object

GMI.IC_WHSE_REL is referenced by following:

GMI: IC_WHSE_REL#