[Home] [Help] [Dependency Information]
Object Name: | OKL_FE_ITEM_RESIDUAL_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_FE_ITEM_RESIDUAL_ALL |
Subobject Name: | |
Status: | VALID |
OKL_FE_ITEM_RESIDUAL_ALL is the header table for Item residuals.
Header details like Category type, Residual type and currency code are stored here.
The table accepts data when the category type is of Item or Item category or a Residual category set.
The primary key for an item residual is the ITEM_RESIDUAL_ID.
Foreign key references are attached to MTL_SYSTEM_ITEMS table on the columns INVENTORY_ITEM_ID and ORGANIZATION_ID for Items in Inventory. The columns CATEGORY_ID and CATEGORY_SET_ID are used as references for Inventory Item categories.
The RESI_CATEGORY_SET_ID column is used to link to the OKL_FE_RESI_CAT_ALL_B table for referencing the residual category set which is part of this item residual.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_FE_ITEM_RESIDUAL_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ITEM_RESIDUAL_ID |
OKL_FE_ITEM_RESIDUAL_ALL_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CATEGORY_TYPE_CODE |
OKL_FE_ITEM_RESIDUAL_ALL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESIDUAL_TYPE_CODE |
OKL_FE_ITEM_RESIDUAL_ALL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | EFFECTIVE_FROM_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_RESIDUAL_ID | NUMBER | Yes | Item residual Identifier | |
ORIG_ITEM_RESIDUAL_ID | NUMBER | Original Item residual Identifier. Traces the source when an Item residual is duplicated. | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Object version number tracks row updates |
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier | ||
ORGANIZATION_ID | NUMBER | Organization identifier | ||
CATEGORY_ID | NUMBER | Category identifier | ||
CATEGORY_SET_ID | NUMBER | Category set identifier | ||
RESI_CATEGORY_SET_ID | NUMBER | Residual category Set Identifier | ||
CATEGORY_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup Type "OKL_SOURCE_TYPES" |
RESIDUAL_TYPE_CODE | VARCHAR2 | (30) | Yes | Lookup Type "OKL_RESIDUAL_TYPES" |
CURRENCY_CODE | VARCHAR2 | (15) | Indicates the currency in which the amounts are stored | |
STS_CODE | VARCHAR2 | (30) | Yes | Status code of the latest version of Item residual. Lookup Type "OKL_PRC_STATUS" |
EFFECTIVE_FROM_DATE | DATE | Yes | Effective From date of the latest version of Item residual | |
EFFECTIVE_TO_DATE | DATE | Effective To date of the latest version of Item residual | ||
ORG_ID | NUMBER | Yes | Operating unit unique identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_RESIDUAL_ID
, ORIG_ITEM_RESIDUAL_ID
, OBJECT_VERSION_NUMBER
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, CATEGORY_ID
, CATEGORY_SET_ID
, RESI_CATEGORY_SET_ID
, CATEGORY_TYPE_CODE
, RESIDUAL_TYPE_CODE
, CURRENCY_CODE
, STS_CODE
, EFFECTIVE_FROM_DATE
, EFFECTIVE_TO_DATE
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM OKL.OKL_FE_ITEM_RESIDUAL_ALL;
OKL.OKL_FE_ITEM_RESIDUAL_ALL does not reference any database object
OKL.OKL_FE_ITEM_RESIDUAL_ALL is referenced by following:
|
|
|