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_TXN_COST_DET_INTERFACE

Object Details

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

MTL_TXN_COST_DET_INTERFACE stores transaction cost by element and by
level for transactions to be imported through the transaction
interface. This is a child table to MTL_TRANSACTIONS_INTERFACE.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_TXN_COST_DET_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	TRANSACTION_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_INTERFACE_ID	NUMBER		Yes	Interface transaction 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
ORGANIZATION_ID	NUMBER			Organization identifier
ORGANIZATION_NAME	VARCHAR2	(60)		Organization name
ORGANIZATION_CODE	VARCHAR2	(3)		Organization short name
COST_ELEMENT_ID	NUMBER			Cost element identifier
COST_ELEMENT	VARCHAR2	(30)		Cost element name
LEVEL_TYPE	NUMBER			Level type
LEVEL_NAME	VARCHAR2	(10)		Either this level or previous level
TRANSACTION_COST	NUMBER			Cost of the inventory transaction
NEW_AVERAGE_COST	NUMBER			Used in average cost update to specify the new average cost of the item
PERCENTAGE_CHANGE	NUMBER			Used in average cost update to indicate the percentage change in the cost of the item
VALUE_CHANGE	NUMBER			Used in average cost update to specify the change in inventory value
ERROR_CODE	VARCHAR2	(240)		Error code
ERROR_EXPLANATION	VARCHAR2	(240)		Error explanation.

Query Text

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


SELECT TRANSACTION_INTERFACE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      COST_ELEMENT_ID
,      COST_ELEMENT
,      LEVEL_TYPE
,      LEVEL_NAME
,      TRANSACTION_COST
,      NEW_AVERAGE_COST
,      PERCENTAGE_CHANGE
,      VALUE_CHANGE
,      ERROR_CODE
,      ERROR_EXPLANATION
FROM INV.MTL_TXN_COST_DET_INTERFACE;

Dependencies

[top of page]

INV.MTL_TXN_COST_DET_INTERFACE does not reference any database object

INV.MTL_TXN_COST_DET_INTERFACE is referenced by following:

INV: MTL_TXN_COST_DET_INTERFACE#