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_ALOT_PRM

Object Details

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

Automatic lot allocation parameters for use in Production Management.
Contains allocation parameters by warehouse and allocation class.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IC_ALOT_PRM_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ALLOC_CLASS WHSE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
ALLOC_CLASS	VARCHAR2	(8)	Yes	The allocation class for which allocation parameters are defined.
WHSE_CODE	VARCHAR2	(4)	Yes	The warehouse in which the allocation parameters apply.
ALLOC_METHOD	NUMBER	(5)	Yes	Allocation method. 0=FIFO, 1=FEFO.
ALLOC_TYPE	NUMBER	(5)	Yes	Allocation type. 0=User initiated, 1=Fully automatic.
SHELF_DAYS	NUMBER		Yes	Expiration buffer. Lots which expire within this number of days will not be allocated.
ALLOC_HORIZON	NUMBER		Yes	Allocation horizon. Batches which begin this many days or more in the future will not be auto-allocated.
LOT_QTY	NUMBER	(5)	Yes	Single lot indicator. 0=Can allocate from multiple lots, 1=Must allocate from only one lot.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		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
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
ALLOC_CATEGORY_ID	NUMBER			Category Id for ALLOC_CLASS

Query Text

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


SELECT ALLOC_CLASS
,      WHSE_CODE
,      ALLOC_METHOD
,      ALLOC_TYPE
,      SHELF_DAYS
,      ALLOC_HORIZON
,      LOT_QTY
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      TRANS_CNT
,      TEXT_CODE
,      LAST_UPDATE_LOGIN
,      ALLOC_CATEGORY_ID
FROM GMI.IC_ALOT_PRM;

Dependencies

[top of page]

GMI.IC_ALOT_PRM does not reference any database object

GMI.IC_ALOT_PRM is referenced by following:

APPS: IC_ALOT_PRM