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_INV

Object Details

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

Warehouse rules table. Contains item/warehouse rules used by MRP and
Physical Inventory.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_WHSE_INV_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	WHSEINV_ID
IC_WHSE_INV_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_ID WHSE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
WHSEINV_ID	NUMBER	(15)	Yes	Used for Warehouse ID rules
ITEM_ID	NUMBER	(10)	Yes	Surrogate key for the item for which warehouse rules are defined.
WHSE_CODE	VARCHAR2	(4)		Warehouse for which the rules are defined. Contains NULLs, denotes "ALL" condition.
SAFETY_STOCK	NUMBER		Yes	Safety stock of the item in the warehouse. MRP will plan to maintain this stock level.
REORDER_POINT	NUMBER		Yes	If inventory drops below this level, the item will appear on the Reorder Point report.
FIXED_LEADTIME	NUMBER		Yes	Fixed component of leadtime for purchases, in days.
VARIABLE_LEADTIME	NUMBER		Yes	Variable component of leadtime for purchases, in days. This is added for each multiple of the std_qty.
MIN_QTY	NUMBER			Minimum qty that can be suggested in one MRP purchase suggestion.
MAX_QTY	NUMBER			Macimum qty that can be suggested in one MRP purchase suggestion.
STD_QTY	NUMBER		Yes	Standard purchase qty.
INNER_TIMEFENCE	NUMBER		Yes	Inner fence in days. MRP will not make purchase suggestions within this period.
OUTER_TIMEFENCE	NUMBER		Yes	Outer fence in days. MRP will not make purchase suggestions after this point.
DAYS_SUPPLY	NUMBER		Yes	When MRP comes to the first net safety stock requirement, it sum all demand out this many days from the day of the safety stock requirement and make suggestions to cover that demand
SCRAP_FACTOR	NUMBER		Yes	Not currently used.
PURCHASE_IND	NUMBER	(5)	Yes	Purchase indicator. 0=Item is not purchased, 1=Item is replenished in this warehouse through purchases.
TRANSFER_IND	NUMBER	(5)	Yes	Transfer indicator. 0=Item is not transferred, 1=Item is replenished in this warehouse through warehouse transfers.
PRODUCTION_IND	NUMBER	(5)	Yes	0=Item is not produced, 1=Item is replenished in this warehouse through production.
RESCHEDULE_PERIOD	NUMBER		Yes	Number of days purchase orders can be rescheduled.
RULE_TYPE	NUMBER	(5)	Yes	Reorder rule for purchases. 0=Manual planning, 1=Lot for lot, 2=Economic order quantity.
WHSE_ABCCODE	VARCHAR2	(4)		ABC code for the item in this warehouse.
CYCLECOUNT_DAYS	NUMBER	(5)	Yes	Number of days defining how often the item should be counted in this warehouse for cycle counts.
LASTCOUNT_DATE	DATE			Last date the item was counted in this warehouse.
COUNT_CLASS	VARCHAR2	(8)		Count class for the item in this warehouse.
GL_CLASS	VARCHAR2	(8)		GL class.
SHIP_CLASS	VARCHAR2	(8)		Ship class.
FRT_CLASS	VARCHAR2	(8)		Freight class.
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
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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
FRT_CATEGORY_ID	NUMBER			Category Id for FRT_CLASS
GL_CATEGORY_ID	NUMBER			Category Id for GL_CLASS
SHIP_CATEGORY_ID	NUMBER			Category Id for SHIP_CLASS

Query Text

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


SELECT WHSEINV_ID
,      ITEM_ID
,      WHSE_CODE
,      SAFETY_STOCK
,      REORDER_POINT
,      FIXED_LEADTIME
,      VARIABLE_LEADTIME
,      MIN_QTY
,      MAX_QTY
,      STD_QTY
,      INNER_TIMEFENCE
,      OUTER_TIMEFENCE
,      DAYS_SUPPLY
,      SCRAP_FACTOR
,      PURCHASE_IND
,      TRANSFER_IND
,      PRODUCTION_IND
,      RESCHEDULE_PERIOD
,      RULE_TYPE
,      WHSE_ABCCODE
,      CYCLECOUNT_DAYS
,      LASTCOUNT_DATE
,      COUNT_CLASS
,      GL_CLASS
,      SHIP_CLASS
,      FRT_CLASS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      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
,      LAST_UPDATE_LOGIN
,      FRT_CATEGORY_ID
,      GL_CATEGORY_ID
,      SHIP_CATEGORY_ID
FROM GMI.IC_WHSE_INV;

Dependencies

[top of page]

GMI.IC_WHSE_INV does not reference any database object

GMI.IC_WHSE_INV is referenced by following:

APPS: IC_WHSE_INV