[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_ITEM_COST_F |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
Item Cost Fact table which stores the item cost history.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ENI_DBI_ITEM_COST_F_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
ORGANIZATION_ID
INVENTORY_ITEM_ID EFFECTIVE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_DATE | DATE | Yes | Date on which the cost is applicable | |
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
ITEM_COST | NUMBER | Unit Cost | ||
MATERIAL_COST | NUMBER | Material Cost | ||
MATERIAL_OVERHEAD_COST | NUMBER | Material Overhead Cost | ||
RESOURCE_COST | NUMBER | Resource Cost | ||
OUTSIDE_PROCESSING_COST | NUMBER | Outside Processing Cost | ||
OVERHEAD_COST | NUMBER | Overhead Cost | ||
LAST_UPDATE_DATE | DATE | Last Update Date | ||
LAST_UPDATED_BY | NUMBER | Last Updated By | ||
CREATION_DATE | DATE | Creation Date | ||
CREATED_BY | NUMBER | Created by | ||
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
PRIMARY_CURRENCY_RATE | NUMBER | Primary Currency Conversion rate that should be applied to the costs. | ||
SECONDARY_CURRENCY_RATE | NUMBER | Secondary Currency Conversion Rate that should be applied to the costs. |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_DATE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ITEM_COST
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, RESOURCE_COST
, OUTSIDE_PROCESSING_COST
, OVERHEAD_COST
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PRIMARY_CURRENCY_RATE
, SECONDARY_CURRENCY_RATE
FROM ENI.ENI_DBI_ITEM_COST_F;
ENI.ENI_DBI_ITEM_COST_F does not reference any database object
ENI.ENI_DBI_ITEM_COST_F is referenced by following:
|
|
|