AMS Tables (333)

AMS - Marketing — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
AML_BUSINESS_EVENT_TYPES_B	12	Defines mapping of business event types with actions and action items
AML_BUSINESS_EVENT_TYPES_TL	12	Defines meaning and description of table AML_BUSINESS_EVENT_TYPES_B
AML_DATA_MIGRATION	6	Migration table for sales leads
AML_INTERACTION_LEADS	16	Defines relation of interactions, responses, and leads
AML_MONITOR_CONDITIONS	44	Monitor rules may have conditions which are stored in this table
AML_MONITOR_LOG	33	Monitor log keeps the transaction history of the monitor rule usage. This also allows to find out how leads are using a specific monitor.
AML_RULE_APPLIED_ATTRS	18	AML_RULE_APPLIED_ATTRS is used to store winning rule log for lead evaluation
AML_SALES_LEAD_TIMEFRAMES	11	Defines the various timeframe mappings
AMS_ACT_ACCESS	18	Holds access information for all marketing objects.
AMS_ACT_ACCESS_DENORM	12	Access Association Denorm
AMS_ACT_CATEGORIES	27	Generic category table used to hold categories an acticity can belong to, for reporting and search capability.
AMS_ACT_CHANGE_REQ_ITEMS	13	This table is populated when an activity (Promotion, Event etc.) is active andt some information must be changed which requires a change req
AMS_ACT_COMMUNICATIONS	29	Stores communications for a specific activity (e.g. Registration).
AMS_ACT_CONTACT_POINTS	32	Stores all contact points for Marketing objects.
AMS_ACT_DELIVERY_METHODS	27	Stores information for the various activity delivery methods
AMS_ACT_DISCOVERER_ALL	15	Store all workbooks/sheets that together define a Cell.
AMS_ACT_FORECASTS_ALL	63	This table stores the Forecasts planned for a Marketing Activity.
AMS_ACT_GEO_AREAS	28	Holds the geographical regions in which a campaign or an event is active
AMS_ACT_LISTS	15	This Table Stores the information of Target Group/Invite Lists and its lists
AMS_ACT_LIST_GROUPS	24	Target Groups could be subdivided into many small groups. This table stores the information regarding them.
AMS_ACT_LOGS	18	Stores the runtime logs generated during transactions
AMS_ACT_MARKET_SEGMENTS	32	Stores what Market Segment are used by what Activity.
AMS_ACT_MESSAGES	11	Association table for messages to a campaign/event.
AMS_ACT_METRICS_ALL	79	This table stores the value for a metrics being tracked against a marketing entity e.g. the current value for metrics 'ROI' for a specific m
AMS_ACT_METRICS_ALL_DENORM	61	Metrics Denorm table
AMS_ACT_METRIC_FACTS_ALL	103	Store metric values to allow for forecasting over time by certain dimensions.
AMS_ACT_METRIC_FORMULAS	12	Stores the formulas to be executed at each hierarchy level for a metric.
AMS_ACT_METRIC_FORM_ENT	14	Stores the set of entries to be executed for a formula.
AMS_ACT_METRIC_HST	82	This table stores the historical value for a metrics being tracked against a marketing entity e.g. date and value for metrics 'ROI' for a s
AMS_ACT_OBJECTIVES	29	Stores objectives for a specific activity (e.g. Promotion, Media, Event).
AMS_ACT_OBJ_METRICS	11	Store what Metrics will be used to measure Objectives set up for an activity.
AMS_ACT_PARTNERS	33	Holds the information about the participating partners for a marketing activity.
AMS_ACT_PERSONS	29	Stores information about the staff working at a venue.
AMS_ACT_PRODUCTS	43	Stores information about the products that are promoted as part of a promotion event.
AMS_ACT_PROGRAMS	28	Stores programs for a specific activity such as an event.
AMS_ACT_QA_CHECKS	16	Stores all quality assurance checks that should be run for a certain activity.
AMS_ACT_RESOURCES	34	Stores business parties for a specific activity such as an event.
AMS_ACT_SCRIPTS	28	Stores the Scripts ( Inbound / Outbound ) used by a marketing activity.
AMS_ACT_SIZES	12	This table maintains the history of segments size.
AMS_ACT_SKILLS	12	Stores pre-requisite and archived skills for an event
AMS_ACT_TYPE_TASK_TPLS	11	An intersection table that specifies what task templates are available for a certain activity type.
AMS_ACT_WEB_RULE_TYPES	27	This table stores the rule type for the schedule of type product recommendation.
AMS_ACT_WF_REQUESTS	20	Stores all requests that have been submitted to Oracle Workflow inside Oracle Marketing for the apprkoval Process.
AMS_ADI_CAMPAIGNS_INTERFACE	102	Interface Table that captures data for marketing objects during desktop integration upload
AMS_ADI_MEDIA_PLANNER	192	Web ADI interface table for uploading metrics association data for marketing objects.
AMS_ADI_OBJECTS_EXPORT_LIST	8	A temporary table that stores the activities that need to be exported in a given flow.
AMS_AGENDAS_B	36	Stores all the agenda information contains track and sessions.
AMS_AGENDAS_TL	11	Holds the trnslatable information for an agenda
AMS_APPROVAL_DETAILS	25	Table Holds Approval Rule Information
AMS_APPROVAL_DETAILS_TL	12	This table stores all the translatable details of Approval Details (like name).
AMS_APPROVAL_HISTORY	19	Stores Approval History for Marketing Objects
AMS_APPROVAL_RULES	17	Stores what kind of approvals are needed when a major activity is changing status.
AMS_APPROVERS	19	This Table contains the information about approvers for an approval rule
AMS_ATTACHMENT_PROPERTIES	15	Stores properties specific to a attachment type
AMS_ATTB_LOV_B	19	This table stores the user created and seeded lovs associated with data source columns in Audience Workbench.
AMS_ATTB_LOV_TL	11	This table stores the names of user created and seeded lovs associated with data source columns in Audience Workbench.
AMS_ATTB_LOV_VALUES_B	16	This table stores the values for lovs based on manually entered values created in Audience Workbench.
AMS_ATTB_LOV_VALUES_TL	10	This table stores the value meanings for lovs based on manually entered values created in Audience Workbench.
AMS_BASE_SALES_VOL_ALL	44	This table stores the base sale volumes for a product prior to application of any promotions.
AMS_CALENDAR_CRITERIA	19	Stores criteria for displaying Marketing Objects on Calendar.
AMS_CAMPAIGNS_ALL_B	113	Base table to store the details of a campaign.
AMS_CAMPAIGNS_ALL_TL	12	This table stores all the translatable details of marketing campaigns (like name, message).
AMS_CAMPAIGN_RELATIONS	11	Originally created for OSM upgrade.
AMS_CAMPAIGN_SCHEDULES	50	This table is obsoleted and no longer in use.
AMS_CAMPAIGN_SCHEDULES_B	102	Stores all Campaign Schedules
AMS_CAMPAIGN_SCHEDULES_TL	14	This table contains the schedule attributes which need to be translated.
AMS_CATEGORIES_B	32	This table stores the definition for categories and is used by Events, Metrics and the Deliverables area.
AMS_CATEGORIES_TL	12	This table stores all translated columns for category definition.
AMS_CAT_ACTIVITIES	26	This table stores the activities associated with a category if the category is being created for budgets.
AMS_CELLS_ALL_B	20	This table stores the definition of marketing cells (Segments). A cell is made up of one to many discoverer workbooks/worksheets. It is be
AMS_CELLS_ALL_TL	11	This table stores all translated columns for marketing Cells definition.
AMS_CHANNELS_B	39	This table stores the details about what Media Channels are available to be used in Oracle Marketing.
AMS_CHANNELS_TL	11	This table stores all translated columns for Channel definition.
AMS_CLIK_THRU_ACTIONS_B	22	This table holds the Metadata information about Click Through Destination Actions.
AMS_CLIK_THRU_ACTIONS_TL	12	Repository to store the Click Thru Actions Metadata information that needs to be translated.
AMS_CLIK_THRU_ACT_PARAMS_B	17	This table holds the Metadata information about Click Through Destination Action Parameters.
AMS_CLIK_THRU_ACT_PARAMS_TL	12	Repository to store the Click Thru Action Parameters Metadata information that needs to be translated.
AMS_CLIK_THRU_USAGES	11	Table to store the usages of CTD
AMS_COLUMNS_METADATA	44	This table is used to store metadata for Locking
AMS_COLUMN_RULES	22
AMS_COMPETITOR_PRODUCTS_B	35	This table stores information telling what are the competing products in the market for a given product .
AMS_COMPETITOR_PRODUCTS_TL	11	This table stores information telling what are the competing products in the market for a given product .
AMS_COND_STRUCT_RESTRICT_VALUE	17	This table stores the restricted LOV values in a query template condition, if any, in Audience Workbench.
AMS_CONTENT_RULES_B	19	This table stores all the content rules for marketing objecs
AMS_CONTENT_RULES_TL	10	Translation table for the Content rules defined for objects.
AMS_CPAG_ANSWERS_B	15	Holds Possible Answers for Marketing Questionnaire Questions.
AMS_CPAG_DLG_RESPONS_B	19	This table holds the Responses received from Customers when they respond to Marketing Questionnaires.
AMS_CPAG_DLG_WGHT_TOTL	12	This table is designed to hold the Running Totals of Weights after each Dialog Run step for each Dialog execution.
AMS_CPAG_QUERIES	12	This table holds the Queries used by Content Pages or Data Source Fields used by Content Pages in Questionnaires.
AMS_CPAG_QUERY_USAGES	11	This table captures the Query Usages by different objects such as Questions or Data Source Fields.
AMS_CPAG_QUESTIONS_B	41	This table holds the Questions Definition for Questions Sections in Content Pages.
AMS_CTDS	14	Stores CTD definition information
AMS_CTD_ADHOC_PARAM_VALUES	11	Table to store adhoc parameters for a CTD
AMS_CTD_ASSOCIATIONS	15	This table describes the association between marketing object and click through destination
AMS_CTD_PARAM_VALUES	11	This table captures value of a CTD parameter
AMS_CUSTOM_SETUPS_B	18	Stores all the custom setups.
AMS_CUSTOM_SETUPS_BK	16
AMS_CUSTOM_SETUPS_TL	12	Stores all translated columns.
AMS_CUSTOM_SETUP_ATTR	23	Store all the setup attributes of a custom setup.
AMS_CUSTOM_SETUP_ATTR_BK	22
AMS_CUSTOM_SETUP_PURPOSE	13	Stores Custom Setup, Purpose and Default List Template Association
AMS_DELIVERABLES_ALL_B	79	This table stores the details about marketing deliverables/collaterals, collaterals are uniquely identified by deliverable name, language an
AMS_DELIVERABLES_ALL_TL	11	This table stores all translated columns for marketing deliverable definition.
AMS_DELIV_KIT_ITEMS	28	This table stores the details about marketing deliverable kits, the information captured include the collaterals included in the kit.
AMS_DELIV_PRODUCTS	12	This table stores information about the products related to a existing deliverable(collateral).
AMS_DIALOGS_ALL_B	52	This stores the dialog object
AMS_DISCOVERER_SQL	14	This table stores all SQL statements saved into the database by the Discoverer tool, these SQL statements correspond to specific worksheets/
AMS_DLG_COMP_TYPES_B	10	Stores the Dialog Component Types
AMS_DLG_CONTEXT_FIELDS	13	This table provides the context fields need to be set by the component in the dialog context during dialog execution
AMS_DLG_CTX_FIELD_USES	9	This table captures the context fields used by different components
AMS_DLG_FLOW_COMPS_B	54	Stores Dialog Flow Component Properties
AMS_DLG_FLOW_COMP_REL	12	Stores the Dialog Flow Component Relationships
AMS_DLG_IDENTIFY_ITEMS	13	This table stores the fields associated with identification rules
AMS_DLG_IDENTIFY_RULES_B	10	This table stores the rules to identify a user
AMS_DLG_INTERACTIONS	23	This table captures all user interactions that happens during course of a dialog execution
AMS_DLG_RUN_STEP_DETAILS	16	This table captures how each step in the dialog flow is getting executed
AMS_DM_AGG_STG	25	Container for the aggregated details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack
AMS_DM_APPLY_STG	3	Staging table to hold scoring run results from the data mining engine.
AMS_DM_BIC_STG	60	Container for the customer intelligence specific details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mi
AMS_DM_BIN_VALUES	13	Definitions of buckets for data source fields.
AMS_DM_CATEGORICAL_BB	14	Bin boundary definitions for categorical columns in the data mining data source.
AMS_DM_DRV_STG	1	Container for the list of PARTY_IDs for which data is being collected. This table is used by mining collection pack. This is a staging ta
AMS_DM_FINNUM_STG	22	Container for the financial details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack.
AMS_DM_GEN_STG	102	Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack.
AMS_DM_IMP_ATTRIBUTES	12	Importance ranking of attributes used in model building.
AMS_DM_INTER_SOURCE_STG	6	Container for the target value for a party for a model, contains details for rows in AMS_DM_DRV_STG. This table is used by Score and Model
AMS_DM_LIFT	20	Result table for the output of lift data. The lift data is used for generation of lift charts.
AMS_DM_MODELS_ALL_B	54	Container for the model definition in the model building process.
AMS_DM_MODELS_ALL_TL	11	Container for translated columns.
AMS_DM_NUMERICAL_BB	13	Bin boundary definitions for numerical columns in the data mining data source.
AMS_DM_OPT_TGT_METRICS	16	Container for the costs and revenues associated with an Optimal Targeting Chart for a Scoring Run.
AMS_DM_ORG_CONTACTS	6	Container for the mapping of org contacts vs org for a party, contains details for rows in AMS_DM_TARGET_STG. This table is used by Score a
AMS_DM_PARTY_DETAILS	170	Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack.
AMS_DM_PARTY_DETAILS_TIME	92	Container for the generic details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection pack.
AMS_DM_PARTY_PROFILE_STG	12	Container for the profile specific details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collectio
AMS_DM_PERFORMANCE	13	Result table for the output of the performance matrix report.
AMS_DM_PERINT_STG	10	Container for the interest/hobby details for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by mining collection
AMS_DM_SCORES_ALL_B	46	Container for capturing statistics of a scoring instance.
AMS_DM_SCORES_ALL_TL	11	Container for translated columns for model scoring instances.
AMS_DM_SCORE_LISTS	11	Container for the association between scoring run and generatic lists.
AMS_DM_SCORE_PCT_RESULTS	15	Container for the summarized percentile results of a scored population.
AMS_DM_SCORE_RESULTS	14	Container for the summarized results of a scoring instance of a model.
AMS_DM_SOURCE	19	Container for the parties to be used for either model building or scoring, and the results and target values for the data mining engine.
AMS_DM_TARGETS_B	14	Target column definitions for data mining models.
AMS_DM_TARGETS_TL	12	Multi-lingual support table for data mining targets.
AMS_DM_TARGET_SOURCES	11	Association of data sources with data mining targets
AMS_DM_TARGET_STG	6	Container for the target value for a party, contains details for rows in AMS_DM_DRV_STG. This table is used by Score and Model selection AP
AMS_DM_TARGET_VALUES_B	13	Target values represent positive values for a given target field.
AMS_DM_TARGET_VALUES_TL	11	Translation table for data mining target values.
AMS_DS_TCA_ENTITY	10	This table stores the entity name.
AMS_DS_TCA_ENTITY_COLS	15	This table stores the column for each entity.
AMS_DS_TCA_ENTITY_COLS_TL	11	This table stores the column for each entity.
AMS_DS_TCA_ENTITY_TL	11	This table stores the entity name.
AMS_EVENT_HEADERS_ALL_B	88	Stores the definition of a Marketing Event. (Master Event or Event Template)
AMS_EVENT_HEADERS_ALL_TL	12	Stores all translated columns.
AMS_EVENT_OFFERS_ALL_B	130	Stores information about an Event Offering. .This table also holds the data for all the Agenda Items for the Event Offerings.
AMS_EVENT_OFFERS_ALL_TL	12	Stores all translated columns.
AMS_EVENT_REGISTRATIONS	75	Stores all enrollment information for an event, who got registered, who will be attending and their status.
AMS_GENERATED_CODES	11	This table helps generate non-conflicting source codes for Campaigns & Events.
AMS_HIERARCHIES_ALL_B	13	Stores all hierarchies supported by Oracle Marketing
AMS_IBA_CAMPAIGN_RULES	13	Table to associate campaign to rules
AMS_IBA_CAMP_POSTINGS	11	Postings associated with campaigns.
AMS_IBA_CPN_ITEMS_DENORM	12	Denormalized table to store schedules and associated items.
AMS_IBA_DISPLAY_RULES	12	This table stores the display rules content and context for use displaying ads in the stored. This table used by i-marketing development tea
AMS_IBA_MS_ITEMS_DENORM	14	Denormalized table to store Minisite information for iStore.
AMS_IBA_PAGE_LOCATION	10	Posting location on the html page
AMS_IBA_PL_PAGES_B	13	Stores Page definitions per site
AMS_IBA_PL_PAGES_TL	13	This table contains the translation details of page
AMS_IBA_PL_PARAMETERS_B	13	Stores Parameter definitions per site
AMS_IBA_PL_PARAMETERS_TL	13	Stores language specific information for Parameter definitions per site
AMS_IBA_PL_PARAM_VALS	14	Stores Values for Page Parameters per Placement
AMS_IBA_PL_PG_PARAMS	15	Stores Parameters relevant to a Page
AMS_IBA_PL_PLACEMENTS_B	38	Stores Placement Definition
AMS_IBA_PL_PLACEMENTS_TL	12	Stores language specific information for Placements definition
AMS_IBA_PL_SITES_B	13	Stores the Definiton of a Site
AMS_IBA_PL_SITES_TL	13	Stores the translation details of sites
AMS_IBA_PL_STYLESHTS_B	12	Stores Definition of Stylesheets
AMS_IBA_PL_STYLESHTS_TL	13	This table stores the translation details of style sheets.
AMS_IBA_POSTINGS_B	42	Storing posting information
AMS_IBA_POST_SUM_ALL	14	Summary information about posting
AMS_IBA_PS_CNDCLSES_B	12	Stores information about all Predicate Conditions
AMS_IBA_PS_CNDCLSES_TL	12	Stores translatable data.
AMS_IBA_PS_FILTERS_B	12	Stores Filters that can be applied before returning Contents
AMS_IBA_PS_FILTERS_TL	12	Stores Filter Name
AMS_IBA_PS_POSTINGS_B	29	Stores Posting Information
AMS_IBA_PS_POSTINGS_TL	13	Posting Translation Table
AMS_IBA_PS_RL_ST_FLTRS	11	Information about Filters in a Strategy
AMS_IBA_PS_RL_ST_PARAMS	11	Stores information about Strategy Parameter values
AMS_IBA_PS_RULEGRPS_B	11	Base table to hold rules for all the postings.
AMS_IBA_PS_RULEGRPS_TL	12	Table holds translatable data
AMS_IBA_PS_RULES	29	Stores condition of a rule in ams_iba_ps_rulegroups_b
AMS_IBA_PS_STRATS_B	14	Stores all Strategies. User defined and predefined.
AMS_IBA_PS_STRATS_TL	13	Table holds translatable data
AMS_IBA_TRACKING_ALL	15	Tracking of actions on posting
AMS_IMP_COL_MAPPING	13	This table stores the column mappings used for list import.
AMS_IMP_CONFIG_COMPONENTS	13	This table stores the import configurable information.
AMS_IMP_CONFIG_IMPORT_TYPES	11	This table stores the configuration for import types.
AMS_IMP_DEFAULT_MAPPING	12	This table stores the default mapping.
AMS_IMP_DOCUMENTS	13	This table stores the information of imported document.
AMS_IMP_DOC_CONTENT	10	This table stores the information of the imported document
AMS_IMP_LIST_HEADERS_ALL	93	This table stores the user entered name and other details about lists imported into Oracle Marketing from external sources.
AMS_IMP_LIST_HEADERS_ALL_TL	11	This table stores all the translatable details of list import header (like name,description).
AMS_IMP_LIST_IMPORT_TYPES	13	This table stores the import types used for list import.
AMS_IMP_SOURCE_LINES	417	This table stores Persons or Organizations (Prospects) imported from external sources.
AMS_IMP_XML_ATTRIBUTES	16	This store the attribute information from a xml document.
AMS_IMP_XML_ELEMENTS	16	This store the element level information from a xml document.
AMS_ITEM_ATTRIBUTES	17	This table will store Oracle Inventory Information and OMO information.
AMS_LIST_CONT_RESTRICTIONS	14	Do not Contact List Information
AMS_LIST_DELETE_TMP_ENTRIES	15	This table is temporarily filled with data during the list generation process, before the records are inserted into the List Entry table
AMS_LIST_ENTRIES	423	This table stores all target prospects generated for a list, to be used for mailshots, telemarketing etc. This table is populated by Oracle
AMS_LIST_ENTRIES_PURGE	2	Table used in Concurrent program deleting disabled list entries
AMS_LIST_ENTRY_USAGES	35	This table stores the assignment of list entries to the sales person and the promotion.
AMS_LIST_FIELDS_B	15	This table stores all database fields that should be available in the application as reference data for purposes like de-duplication and lis
AMS_LIST_FIELDS_TL	11	This table stores all translated columns for list fields.
AMS_LIST_HEADERS_ALL	128	This table stores the name and other details about a target list.
AMS_LIST_HEADERS_ALL_TL	12	This table stores all the translatable details of list header (like name,description).
AMS_LIST_IMPORT_ERRORS	367	This table stores the errors occured during the import process.
AMS_LIST_QUERIES_ALL	29	This table stores the predefined criteria for list creation.
AMS_LIST_QUERIES_PARAM	15	This table stores the parameters associated with list queries defined in audience workbench.
AMS_LIST_QUERIES_PARAM_TL	10	This table stores the parameter display names associated with list queries defined in audience workbench.
AMS_LIST_QUERIES_TL	11	This table stores the name and description of predefined SQL criteria for list creation.
AMS_LIST_RULES_ALL	19	This table stores details about user-defined rules for identifying account or contact duplicates in a generated or imported list.
AMS_LIST_RULES_ALL_TL	12	This table stores rule names of user-defined rules for identifying account or contact duplicates in a generated or imported list.
AMS_LIST_RULE_FIELDS	17	This table stores the details about fields used by any rule for identifying the duplicates.
AMS_LIST_RULE_USAGES	13	This table stores the information about the deduplication rules to be used against a generated or imported list.
AMS_LIST_SELECT_ACTIONS	32	This table stores the set of discoverer workbook, target segments and existing lists which are used to generate the set of list entries.
AMS_LIST_SRC_FIELDS	37	This table stores all fields associated to a certain list source type.
AMS_LIST_SRC_FIELDS_TL	11	This table stores all the translatable details of list source fields (like name,description).
AMS_LIST_SRC_TYPES	26	This table stores all different list source types that may be used for list generation.
AMS_LIST_SRC_TYPES_TL	12	This table stores all the translatable details of list source types (like name,description).
AMS_LIST_SRC_TYPE_ASSOCS	15	This table stores the association between different list source types.
AMS_LIST_SRC_TYPE_USAGES	12	This table stores what source type has been identified as part of the SQL statement for a specific list.
AMS_LIST_TMP_ENTRIES	15	This table is temporarily filled with data during the list generation process, before the records are inserted into the List Entry table.
AMS_LIST_WORD_FIELDS	15	This table stores what words that can be used in a de-duplication process of a certain field.
AMS_LIST_WORD_REPLACES	12	This table holds what word should replace another word in a list deduplication process.
AMS_MEDIA_B	29	Specifies all different media that can be used by an activity.
AMS_MEDIA_CHANNELS	12	Stores what channel can handle what kind of media.
AMS_MEDIA_TL	12	Stores all translated columns.
AMS_MESSAGES_B	31	Stores all the Marketing messges to be used by marketing activities.
AMS_MESSAGES_TL	11	Stores all translated columns.
AMS_METRICS_ALL_B	32	This table stores all the flexible metric definitions.
AMS_METRICS_ALL_TL	13	This table stores all translated columns for flexible metrics definition.
AMS_METRIC_ACCRUALS	11	This table stores the metrics registered for accrual accross Marketing objects.
AMS_METRIC_FORMULAS	18	Metric Formula Definitions
AMS_MET_SCENARIOS	26	This table stores the different scenarios that a metrics could belong to.
AMS_MET_TPL_ASSOCS	13	This table stores Metric Template Associations to Custom Setups and Object Types.
AMS_MET_TPL_DETAILS	12	This table stores the details on the metrics contained inside a metrics grouping.
AMS_MET_TPL_HEADERS	13	AMS_MET_TPL_HEADERS has been obsoleted and replaced with AMS_MET_TPL_HEADERS_B/TL.
AMS_MET_TPL_HEADERS_B	15	This table stores the Metric Template Header for default metrics
AMS_MET_TPL_HEADERS_TL	12	This table stores Metric Template Header language dependent information.
AMS_MISC_COST_DIS_ALL_B	42	Table for storing various costs for Customer.
AMS_MTL_CATEGORIES_DENORM_B	9	Stores the inventory categories with concatenated description and concatenated ids.
AMS_MTL_CATEGORIES_DENORM_TL	10	Stores the inventory categories with concatenated description and concatenated ids.
AMS_OBJECT_ASSOCIATIONS	40	AMS_OBJECT_ASSOCIATIONS is the cross reference between the Campaigns or Events or Creatives the that are running.
AMS_OBJECT_ATTRIBUTES	14	This table is obsoleted and no longer in use.
AMS_OBJECT_RULES_B	37	Stores all the object rules
AMS_OBJECT_RULES_TL	12	stores all the translatable columns for the object rules
AMS_OFFER_PARTIES	9	This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online
AMS_OFFER_PARTIES_TEMP	9	This table stores all the parties eligible for the request only active offers created through Oracle Marketing Online temporarily when full
AMS_OFFER_PRODUCTS	9	This table stores all the products defined for the request only active offers created through Oracle Marketing Online.
AMS_OFFER_PRODUCTS_TEMP	9	This table stores all the products defined for the request only active offers created through Oracle Marketing Online temporarily when full
AMS_PARTY_DEDUPE	9	This table is used to hold the key data information from HZ_PARTIES, which in turn gets used when processing imported external data to ident
AMS_PARTY_MARKET_SEGMENTS	26	This is an intersection table to allow a party to be associated to multiple market segments.
AMS_PARTY_SOURCES	268	This table stores the information regarding the source of newly added party in the HZ table.
AMS_PORTAL_CACHE	20	Table to store cached information for Marketing Portal categories
AMS_PRETTY_URL	8	This table captures pretty url definition
AMS_PRETTY_URL_ASSOC	10	This table maintains associations between pretty url and other marketing objects
AMS_PROD_TEMPLATES_B	10	This table stores the templates used in product creation from OMO.
AMS_PROD_TEMPLATES_TL	12	This table stores the translated data of templates used in product creation from OMO.
AMS_PROD_TEMPLATE_ATTR	16	This table stores the Oracle Inventory attributes which can be configured using OMO UI.
AMS_PROGRAMS_ALL_B	26	A generic Program table, used to group activities such channels or events together.
AMS_PROGRAMS_ALL_TL	11	Stores all translated columns.
AMS_QUERY_ALIAS	16	This table stores the information about the data source which was cloned (self-join) in Audience Workbench.
AMS_QUERY_CONDITION	26	This table stores the basic skeleton of a query template condition in Audience Workbench.
AMS_QUERY_CONDITION_VALUE	17	This table stores the values; default in case of admin and user supplied in case of an end user in Audience Workbench.
AMS_QUERY_COND_DISP_STRUCT_ALL	24	This table contains the body of the condition or in other words, has the non-variant information (condition parts that don't change between
AMS_QUERY_COND_DISP_STRUCT_TL	10	This table contains the body of the condition or in other words, has the non-variant information (condition parts that don't change between
AMS_QUERY_TEMPLATE_ALL	26	This table stores the query template information in Audience Workbench.
AMS_QUERY_TEMPLATE_INSTANCE	18	This table stores the query template instance information in Audience Workbench. There can be only one admin instance and every time the tem
AMS_QUERY_TEMPLATE_TL	11	This table stores the query template information in Audience Workbench.
AMS_QUERY_TEMP_INST_COND_ASSOC	18	This table provides condition selectivity within an INSTANCE. If the INSTANCE is for Admin, this table will have as many rows as template c
AMS_QUERY_TEMP_PURPOSE_ASSOC	15	This table stores the purpose values associated with a query template in Audience Workbench.
AMS_REQUEST_HISTORY	10	This table captures the cover letter associated with the physical collateral requests placed from telesales. It also captures the order_id a
AMS_RULE_MEDIA_ASSOC	15	Stores the default deduplication rule associated with the campaign schedule media.
AMS_SCHEDULER	11	This table stores the scheduling information for marketing objects
AMS_SEARCH_IDS	3	Advanced search ID results. This is a temporary table.
AMS_SETUP_TYPES	26	This table stores the set types required by custom setups.
AMS_SOURCE_CODES	16	This table records the source codes for all objects in the system.
AMS_STATUS_ORDER_RULES	16	Stores the next available status(es) the user can select.
AMS_SYSTEM_PRETTY_URL	12	This table captures system URL associated with pretty url
AMS_TCOP_CHANNEL_SUMMARY	11	This table captures summarized contact information per channel
AMS_TCOP_CHANNEL_SUM_DTL	9	This table captures information about the list of schedules considered for contact summarization
AMS_TCOP_CONTACTS	11	This table keeps track of the contacts made through fatiguing schedules
AMS_TCOP_CONTACT_SUMMARY	10	Fatigue Contact Summary information for a period
AMS_TCOP_CONTACT_SUM_DTL	9	This table stores information about the list of schedules considered for summarized counts
AMS_TCOP_FATIGUED_BY	9	This table captures information about the list of schedules fatigued a party
AMS_TCOP_FR_PERIODS_B	11	Base Table for storing periods associated with Fatigue Rules
AMS_TCOP_FR_PERIODS_TL	12	Translation Table for storing periods associated with Fatigue Rules
AMS_TCOP_FR_RULES_SETUP	13	This table stores the definition of Fatigue Rules to be used by the Rules Engine.
AMS_TCOP_PRVW_CONTACTS	11	This table temporarily captures fatiguing contact details to generate preview
AMS_TCOP_PRVW_FATIGUE	10	This table stores fatigue count projections on a date
AMS_TCOP_PRVW_FTG_BY	9	This table captures information about the schedules which can lead to the fatiguing of the parties
AMS_TCOP_PRVW_FTG_DTLS	9	This table stores the list of parties projected to be fatigued on a day
AMS_TCOP_PRVW_REQUESTS	13	This table captures preview generation status
AMS_TCOP_REQUESTS	13	This table stores requests that need scheduling to apply fatigue rules
AMS_TEMPL_RESPONSIBILITY	11	This table stores the aasociation between product templates and responsibility.
AMS_TEMP_MAPPING	5
AMS_TEMP_MAPPING_SEQ	3
AMS_TERR_LEVELS_ALL	35	This table stores the levels that corrospond to territory types in JTF.
AMS_TRIGGERS	35	AMS_TRIGGERS stores Triggers to start execution of certain Activity at a certain time.
AMS_TRIGGERS_TL	11	Stores all translated columns for triggers.
AMS_TRIGGER_ACTIONS	28	AMS_TRIGGER_ACTIONS stores all actions that can be peformed when a particular Trigger Fires.
AMS_TRIGGER_CHECKS	31	AMS_TRIGGER_CHECKS stores all checks that should be run when a datetime(specified in the AMS_TRIGGERS table) is reached.
AMS_TRIGGER_RESULTS	19	Stores the results after a threshold check or action has been run.
AMS_UPGRADE	24	This table is solely used while upgrading data from the pervious release of the marketing application.
AMS_UPGRADE_ENTRIES	1
AMS_UPGRADE_TRACK_ERROR	8	Tracks any error occurred during upgrade process
AMS_USER_STATUSES_B	17	Stores User status information
AMS_USER_STATUSES_TL	12	Translation columns for User Statuses
AMS_VENUES_B	45	Stores places that can be used to hold an event at.
AMS_VENUES_TL	11	Stores all translated columns.
AMS_VENUE_RATES_B	33	Stores the rate for the venue
AMS_VENUE_RATES_TL	10	Stores the rate for Venue.
AMS_WEB_PLACEMENTS_B	42	This table stores the web placements. Placement is a user defined area on a web page.
AMS_WEB_PLACEMENTS_TL	12	This table stores tranlated columns for web placements
AMS_WEB_PLCE_CITEM_ASSOC	27	This table stores the placement and content association for a given schedule.
AMS_WEB_PLCE_CTYPE_ASSOC	28	This table is used to store the placements and default content type association
AMS_WEB_PLCE_MP_B	33	This table is used to store the placements associated to a marketing object.
AMS_WEB_PLCE_MP_TL	11	This table is used to store translated data
AMS_WEB_RECOMMS	30	This table used to store tracking data for web dynamic schedules
AMS_WEB_RULES_B	30	This table is used to store rules for web mamagement
AMS_WEB_RULES_TL	11	This table stores the translated data for web rules
AMS_WEB_TRACKING	29	This table is used to store tracking data for web advertisement and offer type schedules