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: AMW.AMW_ENTITY_HIERARCHIES

Object Details

Object Name:	AMW_ENTITY_HIERARCHIES
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_ENTITY_HIERARCHIES
Subobject Name:
Status:	VALID

Organization hierarchies within the process certification, the financial certiification, and
the engagement.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_ENTITY_HIERARCHIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_ID OBJECT_TYPE
AMW_ENTITY_HIERARCHIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OBJECT_ID PARENT_OBJECT_TYPE
AMW_ENTITY_HIERARCHIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ENTITY_HIERARCHY_ID	NUMBER		Yes	entity hierarchy identifier
ENTITY_TYPE	VARCHAR2	(30)		entity type
ENTITY_ID	NUMBER			entity identifier
OBJECT_TYPE	VARCHAR2	(30)		object type
OBJECT_ID	NUMBER			object identifier
PARENT_OBJECT_TYPE	VARCHAR2	(30)		parent object type
PARENT_OBJECT_ID	NUMBER			parent identifer
LEVEL_ID	NUMBER			what level the object belongs to
CREATED_BY	NUMBER			Standard who column
CREATION_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER			Standard who column
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
OBJECT_VERSION_NUMBER	NUMBER			Object version number for locking.
DELETE_FLAG	VARCHAR2	(1)		deletion indicator

Query Text

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


SELECT ENTITY_HIERARCHY_ID
,      ENTITY_TYPE
,      ENTITY_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      PARENT_OBJECT_TYPE
,      PARENT_OBJECT_ID
,      LEVEL_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DELETE_FLAG
FROM AMW.AMW_ENTITY_HIERARCHIES;

Dependencies

[top of page]

AMW.AMW_ENTITY_HIERARCHIES does not reference any database object

AMW.AMW_ENTITY_HIERARCHIES is referenced by following:

APPS: AMW_ENTITY_HIERARCHIES