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

TABLE: AZ.AZ_TAXONOMIES_TL

Object Details
Object Name: AZ_TAXONOMIES_TL
Object Type: TABLE
Owner: AZ
FND Design Data: TableAZ.AZ_TAXONOMIES_TL
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_TAXONOMIES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAXONOMY_CODE
ColumnUSER_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
TAXONOMY_CODE VARCHAR2 (45) Yes Unique identification for a Taxonomy
USER_ID NUMBER (15) Yes Tracks the user id owning the taxonomy
LANGUAGE VARCHAR2 (4) Yes Indicates the language owning the row is alloted for
SOURCE_LANG VARCHAR2 (4) Yes Indicates in which language the row is inserted
TAXONOMY_NAME VARCHAR2 (45) Yes Name of the Taxonomy
TAXONOMY_DESC VARCHAR2 (1800)
Description of the taxonomy
CREATED_BY NUMBER (15) Yes Records the user_id creating the row
CREATION_DATE DATE
Yes Records the date row got created
LAST_UPDATED_BY NUMBER (15) Yes Records the user_id updating this ro
LAST_UPDATE_DATE DATE
Yes Records the date row got updated
LAST_UPDATE_LOGIN NUMBER (15)
Records the operating system user_id updating this row
Query Text

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


SELECT TAXONOMY_CODE
,      USER_ID
,      LANGUAGE
,      SOURCE_LANG
,      TAXONOMY_NAME
,      TAXONOMY_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AZ.AZ_TAXONOMIES_TL;

Dependencies

[top of page]

AZ.AZ_TAXONOMIES_TL does not reference any database object

AZ.AZ_TAXONOMIES_TL is referenced by following:

SchemaAPPS
SynonymAZ_TAXONOMIES_TL