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_LIST_ENTRIES

Product:	AMS - Marketing
Description:	This table stores all target prospects generated for a list, to be used for mailshots, telemarketing etc. This table is populated by Oracle Marketing's list generation engine.
Implementation/DBA Data:	AMS.AMS_LIST_ENTRIES

Primary Key: AMS_LIST_ENTRIES_PK

LIST_HEADER_ID
LIST_ENTRY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AMS_LIST_ENTRIES	AMS_LIST_HEADERS_ALL	AMS_LIST_ENTRIES.LIST_HEADER_ID
AMS_LIST_ENTRIES	HZ_PARTIES	AMS_LIST_ENTRIES.PARTY_ID
AMS_LIST_ENTRIES	HZ_CONTACT_POINTS	AMS_LIST_ENTRIES.CONTACT_POINT_ID
AMS_LIST_ENTRIES	HZ_LOCATIONS	AMS_LIST_ENTRIES.LOCATION_ID
AMS_LIST_ENTRY_USAGES	AMS_LIST_ENTRIES	AMS_LIST_ENTRY_USAGES.LIST_HEADER_ID AMS_LIST_ENTRY_USAGES.LIST_ENTRY_ID