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


TABLE: BOM.CST_ELEMENTAL_COSTS

Object Details
Object Name: CST_ELEMENTAL_COSTS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_ELEMENTAL_COSTS
Subobject Name:
Status: VALID


CST_ELEMENTAL_COSTS stores the elemental item cost history for every
cost update. One record is inserted for each cost element for each
item. You can view this information in the Standard Cost History
window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_ELEMENTAL_COSTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_UPDATE_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnCOST_ELEMENT_ID
CST_ELEMENTAL_COSTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
COST_UPDATE_ID NUMBER
Yes Cost update session identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
COST_ELEMENT_ID NUMBER
Yes Cost element 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
STANDARD_COST NUMBER

Elemental cost for the cost element after cost update
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
Query Text

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


SELECT COST_UPDATE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      COST_ELEMENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_COST
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_ELEMENTAL_COSTS;

Dependencies

[top of page]

BOM.CST_ELEMENTAL_COSTS does not reference any database object

BOM.CST_ELEMENTAL_COSTS is referenced by following:

SchemaBOM
ViewCST_ELEMENTAL_COSTS#