eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: AMS_DISCOVERER_SQL

Product:	AMS - Marketing
Description:	This table stores all SQL statements saved into the database by the Discoverer tool, these SQL statements correspond to specific worksheets/workbooks created through the tool. This table is used by target list generation and the cell defi
Implementation/DBA Data:	AMS.AMS_DISCOVERER_SQL

Primary Key: AMS_DISCOVERER_SQL_PK

DISCOVERER_SQL_ID

Primary Key: AMS_DISCOVERER_SQL_UK1

WORKBOOK_OWNER_NAME
WORKBOOK_NAME
WORKSHEET_NAME
SEQUENCE_ORDER

Foreign Keys

Table		Foreign Table	Foreign Key Column
AMS_ACT_DISCOVERER_ALL		AMS_DISCOVERER_SQL	AMS_ACT_DISCOVERER_ALL.DISCOVERER_SQL_ID
AMS_LIST_SELECT_ACTIONS		AMS_DISCOVERER_SQL	AMS_LIST_SELECT_ACTIONS.INCL_OBJECT_ID