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

TABLE: AZ.AZ_API_PREF_SRC_ATTRIBUTES_B

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_API_PREF_SRC_ATTRIBUTE_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPREFERENCE_CODE
ColumnDATA_SOURCE
ColumnATTRIBUTE_CODE
Columns
Name Datatype Length Mandatory Comments
PREFERENCE_CODE VARCHAR2 (45) Yes Unique Identifier for Preferences
DATA_SOURCE VARCHAR2 (255) Yes Source for a given Preference
ATTRIBUTE_CODE VARCHAR2 (255) Yes Attribute for a given preferences
PARAM1 VARCHAR2 (255)
Column for future use
PARAM2 VARCHAR2 (255)
Column for future use
PARAM3 VARCHAR2 (255)
Column for future use
PARAM4 VARCHAR2 (255)
Column for future use
PARAM5 VARCHAR2 (255)
Column for future use
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
KEY_FLAG VARCHAR2 (1)
Indicates if the attribute is part of unique key
ENABLE_REPORT_FLAG VARCHAR2 (1)
Indicates if the attribute is selected for reporting
Query Text

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


SELECT PREFERENCE_CODE
,      DATA_SOURCE
,      ATTRIBUTE_CODE
,      PARAM1
,      PARAM2
,      PARAM3
,      PARAM4
,      PARAM5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      KEY_FLAG
,      ENABLE_REPORT_FLAG
FROM AZ.AZ_API_PREF_SRC_ATTRIBUTES_B;

Dependencies

[top of page]

AZ.AZ_API_PREF_SRC_ATTRIBUTES_B does not reference any database object

AZ.AZ_API_PREF_SRC_ATTRIBUTES_B is referenced by following:

SchemaAPPS
SynonymAZ_API_PREF_SRC_ATTRIBUTES_B