[Home] [Help] [Dependency Information]
Object Name: | OPI_DBI_CURR_INV_EXP_F |
---|---|
Object Type: | TABLE |
Owner: | OPI |
Subobject Name: | |
Status: | VALID |
Fact table that contains the value and quantity of lot controlled inventory that has expired, and the total value and quantity of lot controlled inventory currently available.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OPI_DBI_CURR_INV_EXP_F_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
AGGREGATION_LEVEL_FLAG
ITEM_ORG_ID |
OPI_DBI_CURR_INV_EXP_F_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
AGGREGATION_LEVEL_FLAG
INV_CATEGORY_ID ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization ID. | |
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier. | ||
ITEM_ORG_ID | VARCHAR2 | (25) | Item Organization Identifier. | |
UOM_CODE | VARCHAR2 | (5) | Primary uom code for this item. | |
INV_CATEGORY_ID | NUMBER | Inventory Category identifier. | ||
FUNC_CURRENCY_CODE | VARCHAR2 | (4) | Functional Currency Code of organization. | |
AGGREGATION_LEVEL_FLAG | NUMBER | Level of summarization. 0 - Item level rows, 1 - Inventory Category level rows, 3 - Organization level rows. | ||
ONHAND_QTY | NUMBER | Quantity of lot-controlled inventory currently available on-hand in the item's primary unit of measure. | ||
EXPIRED_QTY | NUMBER | Quantity of lot-controlled inventory currently expired in the item's primary unit of measure. | ||
ONHAND_VAL_B | NUMBER | Value of lot-controlled inventory currently available on-hand in the functional currency. | ||
ONHAND_VAL_G | NUMBER | Value of lot-controlled inventory currently available on-hand in the global currency. | ||
ONHAND_VAL_SG | NUMBER | Value of lot-controlled inventory currently available on-hand in the secondary global currency. | ||
EXPIRED_VAL_B | NUMBER | Value of lot-controlled inventory currently expired in the functional currency. | ||
EXPIRED_VAL_G | NUMBER | Value of lot-controlled inventory currently expired in the global currency. | ||
EXPIRED_VAL_SG | NUMBER | Value of lot-controlled inventory currently expired in the secondary global currency. | ||
CONVERSION_RATE | NUMBER | Conversion rate to DBI global currency. | ||
SEC_CONVERSION_RATE | NUMBER | Conversion rate to DBI secondary global currency. | ||
CREATION_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
CREATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column. | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard WHO column. | |
PROGRAM_ID | NUMBER | Yes | Standard WHO column. | |
PROGRAM_LOGIN_ID | NUMBER | Yes | Standard WHO column. | |
PROGRAM_APPLICATION_ID | NUMBER | Yes | Standard WHO column. | |
REQUEST_ID | NUMBER | Yes | Standard WHO column. |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, ITEM_ORG_ID
, UOM_CODE
, INV_CATEGORY_ID
, FUNC_CURRENCY_CODE
, AGGREGATION_LEVEL_FLAG
, ONHAND_QTY
, EXPIRED_QTY
, ONHAND_VAL_B
, ONHAND_VAL_G
, ONHAND_VAL_SG
, EXPIRED_VAL_B
, EXPIRED_VAL_G
, EXPIRED_VAL_SG
, CONVERSION_RATE
, SEC_CONVERSION_RATE
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM OPI.OPI_DBI_CURR_INV_EXP_F;
OPI.OPI_DBI_CURR_INV_EXP_F does not reference any database object
OPI.OPI_DBI_CURR_INV_EXP_F is referenced by following:
|
|
|