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

TABLE: AMS.AMS_DISCOVERER_SQL

Object Details
Object Name: AMS_DISCOVERER_SQL
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DISCOVERER_SQL
Subobject Name:
Status: VALID


AMS_DISCOVERER_SQL stores all SQL statements saved into the database by Discoverer. This is used by Oracle Marketing to get the sql statement built in Discoverer and use it under the list generation process. This table is only filled by the Discoverer product calling a function registered by Oracle Marketing inside Discoverer.
A SQL statement may be split over several rows in this table, this happens when the SQL statement is longer than 2000 characters. If the SQL is shorter than 2000, the sequence will contain value 0, if longer it will start at 1 for the first part of the SQL.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DISCOVERER_SQL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDISCOVERER_SQL_ID
AMS_DISCOVERER_SQL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKBOOK_OWNER_NAME
ColumnWORKBOOK_NAME
ColumnWORKSHEET_NAME
ColumnSEQUENCE_ORDER
Columns
Name Datatype Length Mandatory Comments
DISCOVERER_SQL_ID NUMBER
Yes Unique Identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER (9)
This column is used for locking purposes.
WORKBOOK_OWNER_NAME VARCHAR2 (100) Yes Oracle application owner id.
WORKBOOK_NAME VARCHAR2 (254) Yes Name of discoverer workbook.
WORKSHEET_NAME VARCHAR2 (254) Yes Name of discoverer worksheet.
SEQUENCE_ORDER NUMBER (15) Yes sequence of creation.
SQL_STRING VARCHAR2 (4000) Yes SQL text from discoverer.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
SOURCE_TYPE_CODE VARCHAR2 (30)
Denormalized column for mapping the source type code to the specific workbook. Only workbooks and worksheets mapped to a marketing source type will have a source type code.
Query Text

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


SELECT DISCOVERER_SQL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      WORKBOOK_OWNER_NAME
,      WORKBOOK_NAME
,      WORKSHEET_NAME
,      SEQUENCE_ORDER
,      SQL_STRING
,      SECURITY_GROUP_ID
,      SOURCE_TYPE_CODE
FROM AMS.AMS_DISCOVERER_SQL;

Dependencies

[top of page]

AMS.AMS_DISCOVERER_SQL does not reference any database object

AMS.AMS_DISCOVERER_SQL is referenced by following:

SchemaAPPS
SynonymAMS_DISCOVERER_SQL