[Home] [Help] [Dependency Information]
Object Name: | ENI_DBI_ITEM_COST_STG |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
Staging table to hold the item costs during collection
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_DATE | DATE | Date on which the cost is applicable | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
ITEM_COST | NUMBER | Item 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 | ||
CURRENCY_CODE | VARCHAR2 | (15) | Transactional Currency | |
CONVERSION_RATE | NUMBER | Conversion rate from transactional currency to DBI global primary currency as of the effective date |
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
, CURRENCY_CODE
, CONVERSION_RATE
FROM ENI.ENI_DBI_ITEM_COST_STG;
ENI.ENI_DBI_ITEM_COST_STG does not reference any database object
ENI.ENI_DBI_ITEM_COST_STG is referenced by following:
|
|
|