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

TABLE: ENI.ENI_DBI_ITEM_COST_STG

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


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
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
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
,      CURRENCY_CODE
,      CONVERSION_RATE
FROM ENI.ENI_DBI_ITEM_COST_STG;

Dependencies

[top of page]

ENI.ENI_DBI_ITEM_COST_STG does not reference any database object

ENI.ENI_DBI_ITEM_COST_STG is referenced by following:

SchemaAPPS
SynonymENI_DBI_ITEM_COST_STG