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_ACTUAL_COST_SUBELEMENT

Object Details

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

MTL_ACTUAL_COST_SUBELEMENT stores the material overhead
subelements that are charged for a given transaction. This is a child
table of MTL_CST_ACTUAL_COST_DETAILS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_ACTUAL_COST_SUBELEMENT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID ORGANIZATION_ID LAYER_ID COST_ELEMENT_ID LEVEL_TYPE RESOURCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LAYER_ID	NUMBER		Yes	Layer Identifier
TRANSACTION_ID	NUMBER		Yes	Transaction Identifier
ORGANIZATION_ID	NUMBER		Yes	Organization Identifier
COST_ELEMENT_ID	NUMBER		Yes	Cost Element Identifier
LEVEL_TYPE	NUMBER		Yes	Cost Element Identifier
RESOURCE_ID	NUMBER		Yes	Resource 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
ACTUAL_COST	NUMBER			Actual Cost of the Subelement
USER_ENTERED	VARCHAR2	(1)	Yes	Specifies whether this row is entered by the user or the cost processor.

Query Text

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


SELECT LAYER_ID
,      TRANSACTION_ID
,      ORGANIZATION_ID
,      COST_ELEMENT_ID
,      LEVEL_TYPE
,      RESOURCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ACTUAL_COST
,      USER_ENTERED
FROM INV.MTL_ACTUAL_COST_SUBELEMENT;

Dependencies

[top of page]

INV.MTL_ACTUAL_COST_SUBELEMENT does not reference any database object

INV.MTL_ACTUAL_COST_SUBELEMENT is referenced by following:

INV: MTL_ACTUAL_COST_SUBELEMENT#