eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: INV.MTL_CST_TXN_COST_DETAILS

Object Details

Object Name:	MTL_CST_TXN_COST_DETAILS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_CST_TXN_COST_DETAILS
Subobject Name:
Status:	VALID

MTL_CST_TXN_COST_DETAILS stores the cost of a transaction by element and level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_CST_TXN_COST_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID ORGANIZATION_ID COST_ELEMENT_ID LEVEL_TYPE

Columns

Name	Datatype	Mandatory	Comments
TRANSACTION_ID	NUMBER	Yes	Transaction identifier
ORGANIZATION_ID	NUMBER	Yes	Organization identifier
COST_ELEMENT_ID	NUMBER	Yes	Cost element identifier
LEVEL_TYPE	NUMBER	Yes	Level identifier
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATION_DATE	DATE	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
REQUEST_ID	NUMBER		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER		Standard Who column
PROGRAM_ID	NUMBER		Standard Who column
PROGRAM_UPDATE_DATE	DATE		Standard Who column
INVENTORY_ITEM_ID	NUMBER	Yes	Item identifier
TRANSACTION_COST	NUMBER		Transaction cost
NEW_AVERAGE_COST	NUMBER		New average cost of an item used only for average cost update
PERCENTAGE_CHANGE	NUMBER		Percentage change in average cost of an item used only for average cost update
VALUE_CHANGE	NUMBER		Change in inventory value of an item used only for average cost update

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      ORGANIZATION_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM_ID
,      TRANSACTION_COST
,      NEW_AVERAGE_COST
,      PERCENTAGE_CHANGE
,      VALUE_CHANGE
FROM INV.MTL_CST_TXN_COST_DETAILS;

Dependencies

[top of page]

INV.MTL_CST_TXN_COST_DETAILS does not reference any database object

INV.MTL_CST_TXN_COST_DETAILS is referenced by following:

INV: MTL_CST_TXN_COST_DETAILS#