DBA Data[Home] [Help] [Dependency Information]

TABLE: ENI.ENI_DBI_ITEM_COST_F

Object Details
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.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ENI_DBI_ITEM_COST_F_U1 NORMAL UNIQUE TablespaceAPPS_TS_SUMMARY ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnEFFECTIVE_DATE
Columns
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.
Query Text

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;

Dependencies

[top of page]

ENI.ENI_DBI_ITEM_COST_F does not reference any database object

ENI.ENI_DBI_ITEM_COST_F is referenced by following:

SchemaAPPS
SynonymENI_DBI_ITEM_COST_F