[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IC_ALOT_PRM_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ALLOC_CLASS
WHSE_CODE |
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 |
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;
GMI.IC_ALOT_PRM does not reference any database object
GMI.IC_ALOT_PRM is referenced by following:
|
|
|