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

TABLE: AZ.AZ_API_PREFERENCES_TL

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

This table stores multi-lingual info for az_api_preferences.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_APIS_PREFERENCES_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREFERENCE_CODE
ColumnUSER_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_CODE VARCHAR2 (45) Yes Unique Identifier of Preference
PREFERENCE_NAME VARCHAR2 (45) Yes Unique Name identifier against the user
PREFERENCE_DESC VARCHAR2 (1800)
description of the Preference
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
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 row
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
USER_ID NUMBER (15) Yes Tracks the user_id created the preference
Query Text

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


SELECT PREFERENCE_CODE
,      PREFERENCE_NAME
,      PREFERENCE_DESC
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      USER_ID
FROM AZ.AZ_API_PREFERENCES_TL;

Dependencies

[top of page]

AZ.AZ_API_PREFERENCES_TL does not reference any database object

AZ.AZ_API_PREFERENCES_TL is referenced by following:

SchemaAPPS
SynonymAZ_API_PREFERENCES_TL