[Home] [Help] [Dependency Information]
Object Name: | CST_EAM_HIERARCHY_SNAPSHOT |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_EAM_HIERARCHY_SNAPSHOT |
Subobject Name: | |
Status: | VALID |
This temporary table contains a snapshot of hierarchies for which a cost rollup is required. Each hierarchy is denoted by a unique GROUP_ID.
There are multiple hierarchy types that can be inserted into this table: Asset Hierarchy, Work Order Hierarchy, CMRO Execution Schedule and CMRO summary tasks. The hierarchy types are differentiated by the type of nodes that they consist of. For example, Asset Hierarchies consist of Asset nodes (OBJECT_TYPE of 1) while CMRO Execution Schedules consist of Work Order nodes (OBJECT_TYPE of 2) and Summary Tasks (OBJECT_TYPE of NULL).
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_EAM_HIERARCHY_SNAPSHOT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE |
GROUP_ID
OBJECT_ID OBJECT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GROUP_ID | NUMBER | Yes | An identifier for the hierarchy that this record makes up | |
OBJECT_ID | NUMBER | Yes | The entity id of the current node | |
PARENT_OBJECT_ID | NUMBER | Yes | The entity id of the current node's parent | |
LEVEL_NUM | NUMBER | Yes | A relative depth indicator of the hierarchy. The root node is indicated by level 0. | |
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 | |
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
OBJECT_TYPE | NUMBER | (15) | The entity type of the current node | |
PARENT_OBJECT_TYPE | NUMBER | (15) | The entity type of the current node's parent |
Cut, paste (and edit) the following text to query this object:
SELECT GROUP_ID
, OBJECT_ID
, PARENT_OBJECT_ID
, LEVEL_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, LAST_UPDATE_LOGIN
, OBJECT_TYPE
, PARENT_OBJECT_TYPE
FROM BOM.CST_EAM_HIERARCHY_SNAPSHOT;
BOM.CST_EAM_HIERARCHY_SNAPSHOT does not reference any database object
BOM.CST_EAM_HIERARCHY_SNAPSHOT is referenced by following:
|
|
|