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: ABM.ABM_TAGS

Object Details

Object Name:	ABM_TAGS
Object Type:	TABLE
Owner:	ABM
Subobject Name:
Status:	VALID

List of all Attribute Values and their descriptions.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: ABM_TAGS_PK

I02_TAG_SET_ID
I01_TAG_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
ABM_TAGS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	I02_TAG_SET_ID I01_TAG_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
ABM_TAGS	ABM_TAG_SETS	ABM_TAGS I02_TAG_SET_ID
ABM_BORS	ABM_TAGS	ABM_BORS I02_TAG_SET_ID ABM_BORS I01_TAG_ID
ABM_MLS_RES	ABM_TAGS	ABM_MLS_RES SYN_I02_RE_TYPE_ID ABM_MLS_RES SYN_I01_RE_TYPE_ID
ABM_MLS_RESOURCES	ABM_TAGS	ABM_MLS_RESOURCES I02_TAG_SET_ID ABM_MLS_RESOURCES I01_TAG_ID
ABM_PDS	ABM_TAGS	ABM_PDS SYN_I02_PDS_CLASS_ID ABM_PDS SYN_I01_PDS_CLASS_ID
ABM_PDS	ABM_TAGS	ABM_PDS SYN_I02_PDS_TYPE_ID ABM_PDS SYN_I01_PDS_TYPE_ID
ABM_PERIODS	ABM_TAGS	ABM_PERIODS SYN_I02_PERIOD_ID ABM_PERIODS SYN_I01_PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
I02_TAG_SET_ID	VARCHAR2	(30)	Yes	Attribute Id
I01_TAG_ID	VARCHAR2	(30)	Yes	Attribute Value
I01_NAME	VARCHAR2	(60)	Yes	Attribute Name
DESCRIPTION_TEXT	VARCHAR2	(750)		Attribute Description
MAINT_USER_ID	VARCHAR2	(11)		Legacy column. No longer used in ABM 11i.
MAINT_EFFECT_CODE	VARCHAR2	(1)		Legacy column. No longer used in ABM 11i.
MAINT_TIMESTAMP	DATE			Legacy column. No longer used in ABM 11i.
I01_EFFECTIVE_BEGIN_DATE	DATE			Effective Begin Date
I02_TYPE_DENORM	VARCHAR2	(3)	Yes	Attribute Type denormalized
RE_ACT_HIER_STRUCT_TAG_SET_ID	VARCHAR2	(30)		Department Activity Hierarchy Structure Attribute
RE_ACT_HIER_STRUCT_TAG_ID	VARCHAR2	(30)		Department Activity Hierarchy Structure Attribute Value
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT I02_TAG_SET_ID
,      I01_TAG_ID
,      I01_NAME
,      DESCRIPTION_TEXT
,      MAINT_USER_ID
,      MAINT_EFFECT_CODE
,      MAINT_TIMESTAMP
,      I01_EFFECTIVE_BEGIN_DATE
,      I02_TYPE_DENORM
,      RE_ACT_HIER_STRUCT_TAG_SET_ID
,      RE_ACT_HIER_STRUCT_TAG_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM ABM.ABM_TAGS;

Dependencies

[top of page]

ABM.ABM_TAGS does not reference any database object

ABM.ABM_TAGS is not referenced by any database object