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

TABLE: AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_API_SRC_ATTRIBUTE_T_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREFERENCE_CODE
ColumnDATA_SOURCE
ColumnATTRIBUTE_CODE
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_CODE VARCHAR2 (45) Yes Unique identifier for Preference
DATA_SOURCE VARCHAR2 (255) Yes Source for a given preference code
ATTRIBUTE_CODE VARCHAR2 (255) Yes Attribute for a given Souce of a Preference Code
DISPLAY_NAME VARCHAR2 (255)
Display Name for an attribute
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 Records the user_id updating this row
LAST_UPDATE_DATE DATE
Yes Records the date row got updated
Query Text

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


SELECT PREFERENCE_CODE
,      DATA_SOURCE
,      ATTRIBUTE_CODE
,      DISPLAY_NAME
,      LANGUAGE
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL;

Dependencies

[top of page]

AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL does not reference any database object

AZ.AZ_API_PREF_SRC_ATTRIBUTES_TL is referenced by following:

SchemaAPPS
SynonymAZ_API_PREF_SRC_ATTRIBUTES_TL