[Home] [Help]
[Dependency Information]
Object Name: | OKL_RV_INTERFACE_ALL |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
Interface table used to import Item Residual Values.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NUMBER | VARCHAR2 | (30) | Yes | Used to uniquely identify an imported set item residual values |
STATUS | VARCHAR2 | (30) | Yes | Allowable values - New, Failed, Validated, Loaded, and Error. |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
DATE_CREATED | DATE | Yes | Standard WHO column | |
DATE_CREATED_IN_OKL | DATE | The date on which values were imported into OKL | ||
ITEM_ID | NUMBER | Yes | Foreign Key column to Inventory Item ID | |
ORG_ID | NUMBER | Yes | Inventory Organisation identifier | |
RESIDUAL_VALUE_PERCENT | NUMBER | (18) | Yes | Residual Value Percentage of Inventory Item |
TERM_IN_MONTHS | NUMBER | Yes | Term (in months) for which the Residual Value is applicable | |
START_DATE | DATE | Yes | Date record becomes active | |
END_DATE | DATE | Date record becomes Inactive. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUMBER
, STATUS
, CREATED_BY
, DATE_CREATED
, DATE_CREATED_IN_OKL
, ITEM_ID
, ORG_ID
, RESIDUAL_VALUE_PERCENT
, TERM_IN_MONTHS
, START_DATE
, END_DATE
FROM OKL.OKL_RV_INTERFACE_ALL;
OKL.OKL_RV_INTERFACE_ALL does not reference any database object
OKL.OKL_RV_INTERFACE_ALL is referenced by following:
|
|
|