Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - AMS Tables and Views

TABLE - AMS.AML_BUSINESS_EVENT_TYPES_B

TABLE - AMS.AML_BUSINESS_EVENT_TYPES_TL

TABLE - AMS.AML_DATA_MIGRATION

TABLE - AMS.AML_INTERACTION_LEADS

TABLE - AMS.AML_MONITOR_CONDITIONS

TABLE - AMS.AML_MONITOR_LOG

TABLE - AMS.AML_RULE_APPLIED_ATTRS

TABLE - AMS.AML_SALES_LEAD_TIMEFRAMES

TABLE - AMS.AMS_ACT_ACCESS

TABLE - AMS.AMS_ACT_ACCESS_DENORM

TABLE - AMS.AMS_ACT_CATEGORIES

TABLE - AMS.AMS_ACT_CHANGE_REQ_ITEMS

TABLE - AMS.AMS_ACT_COMMUNICATIONS

TABLE - AMS.AMS_ACT_CONTACT_POINTS

TABLE - AMS.AMS_ACT_DELIVERY_METHODS

TABLE - AMS.AMS_ACT_DISCOVERER_ALL

TABLE - AMS.AMS_ACT_FORECASTS_ALL

TABLE - AMS.AMS_ACT_GEO_AREAS

TABLE - AMS.AMS_ACT_LISTS

TABLE - AMS.AMS_ACT_LIST_GROUPS

TABLE - AMS.AMS_ACT_LOGS

TABLE - AMS.AMS_ACT_MARKET_SEGMENTS

TABLE - AMS.AMS_ACT_MESSAGES

TABLE - AMS.AMS_ACT_METRICS_ALL

TABLE - AMS.AMS_ACT_METRICS_ALL_DENORM

TABLE - AMS.AMS_ACT_METRIC_FACTS_ALL

TABLE - AMS.AMS_ACT_METRIC_FORMULAS

TABLE - AMS.AMS_ACT_METRIC_FORM_ENT

TABLE - AMS.AMS_ACT_METRIC_HST

TABLE - AMS.AMS_ACT_OBJECTIVES

TABLE - AMS.AMS_ACT_OBJ_METRICS

TABLE - AMS.AMS_ACT_PARTNERS

TABLE - AMS.AMS_ACT_PERSONS

TABLE - AMS.AMS_ACT_PRODUCTS

TABLE - AMS.AMS_ACT_PROGRAMS

TABLE - AMS.AMS_ACT_QA_CHECKS

TABLE - AMS.AMS_ACT_RESOURCES

TABLE - AMS.AMS_ACT_SCRIPTS

TABLE - AMS.AMS_ACT_SIZES

TABLE - AMS.AMS_ACT_SKILLS

TABLE - AMS.AMS_ACT_TYPE_TASK_TPLS

TABLE - AMS.AMS_ACT_WEB_RULE_TYPES

TABLE - AMS.AMS_ACT_WF_REQUESTS

TABLE - AMS.AMS_ADI_CAMPAIGNS_INTERFACE

TABLE - AMS.AMS_ADI_MEDIA_PLANNER

TABLE - AMS.AMS_ADI_OBJECTS_EXPORT_LIST

TABLE - AMS.AMS_AGENDAS_B

TABLE - AMS.AMS_AGENDAS_TL

TABLE - AMS.AMS_APPROVAL_DETAILS

TABLE - AMS.AMS_APPROVAL_DETAILS_TL

TABLE - AMS.AMS_APPROVAL_HISTORY

TABLE - AMS.AMS_APPROVAL_RULES

TABLE - AMS.AMS_APPROVERS

TABLE - AMS.AMS_ATTACHMENT_PROPERTIES

TABLE - AMS.AMS_ATTB_LOV_B

TABLE - AMS.AMS_ATTB_LOV_TL

TABLE - AMS.AMS_ATTB_LOV_VALUES_B

TABLE - AMS.AMS_ATTB_LOV_VALUES_TL

TABLE - AMS.AMS_BASE_SALES_VOL_ALL

TABLE - AMS.AMS_CALENDAR_CRITERIA

TABLE - AMS.AMS_CAMPAIGNS_ALL_B

TABLE - AMS.AMS_CAMPAIGNS_ALL_TL

TABLE - AMS.AMS_CAMPAIGN_RELATIONS

TABLE - AMS.AMS_CAMPAIGN_SCHEDULES

TABLE - AMS.AMS_CAMPAIGN_SCHEDULES_B

TABLE - AMS.AMS_CAMPAIGN_SCHEDULES_TL

TABLE - AMS.AMS_CATEGORIES_B

TABLE - AMS.AMS_CATEGORIES_TL

TABLE - AMS.AMS_CAT_ACTIVITIES

TABLE - AMS.AMS_CELLS_ALL_B

TABLE - AMS.AMS_CELLS_ALL_TL

TABLE - AMS.AMS_CHANNELS_B

TABLE - AMS.AMS_CHANNELS_TL

TABLE - AMS.AMS_CLIK_THRU_ACTIONS_B

TABLE - AMS.AMS_CLIK_THRU_ACTIONS_TL

TABLE - AMS.AMS_CLIK_THRU_ACT_PARAMS_B

TABLE - AMS.AMS_CLIK_THRU_ACT_PARAMS_TL

TABLE - AMS.AMS_CLIK_THRU_USAGES

TABLE - AMS.AMS_COLUMNS_METADATA

TABLE - AMS.AMS_COLUMN_RULES

TABLE - AMS.AMS_COMPETITOR_PRODUCTS_B

TABLE - AMS.AMS_COMPETITOR_PRODUCTS_TL

TABLE - AMS.AMS_COND_STRUCT_RESTRICT_VALUE

TABLE - AMS.AMS_CONTENT_RULES_B

TABLE - AMS.AMS_CONTENT_RULES_TL

TABLE - AMS.AMS_CPAG_ANSWERS_B

TABLE - AMS.AMS_CPAG_DLG_RESPONS_B

TABLE - AMS.AMS_CPAG_DLG_WGHT_TOTL

TABLE - AMS.AMS_CPAG_QUERIES

TABLE - AMS.AMS_CPAG_QUERY_USAGES

TABLE - AMS.AMS_CPAG_QUESTIONS_B

TABLE - AMS.AMS_CTDS

TABLE - AMS.AMS_CTD_ADHOC_PARAM_VALUES

TABLE - AMS.AMS_CTD_ASSOCIATIONS

TABLE - AMS.AMS_CTD_PARAM_VALUES

TABLE - AMS.AMS_CUSTOM_SETUPS_B

TABLE - AMS.AMS_CUSTOM_SETUPS_BK

TABLE - AMS.AMS_CUSTOM_SETUPS_TL

TABLE - AMS.AMS_CUSTOM_SETUP_ATTR

TABLE - AMS.AMS_CUSTOM_SETUP_ATTR_BK

TABLE - AMS.AMS_CUSTOM_SETUP_PURPOSE

TABLE - AMS.AMS_DELIVERABLES_ALL_B

TABLE - AMS.AMS_DELIVERABLES_ALL_TL

TABLE - AMS.AMS_DELIV_KIT_ITEMS

TABLE - AMS.AMS_DELIV_PRODUCTS

TABLE - AMS.AMS_DIALOGS_ALL_B

TABLE - AMS.AMS_DISCOVERER_SQL

TABLE - AMS.AMS_DLG_COMP_TYPES_B

TABLE - AMS.AMS_DLG_CONTEXT_FIELDS

TABLE - AMS.AMS_DLG_CTX_FIELD_USES

TABLE - AMS.AMS_DLG_FLOW_COMPS_B

TABLE - AMS.AMS_DLG_FLOW_COMP_REL

TABLE - AMS.AMS_DLG_IDENTIFY_ITEMS

TABLE - AMS.AMS_DLG_IDENTIFY_RULES_B

TABLE - AMS.AMS_DLG_INTERACTIONS

TABLE - AMS.AMS_DLG_RUN_STEP_DETAILS

TABLE - AMS.AMS_DM_AGG_STG

TABLE - AMS.AMS_DM_APPLY_STG

TABLE - AMS.AMS_DM_BIC_STG

TABLE - AMS.AMS_DM_BIN_VALUES

TABLE - AMS.AMS_DM_CATEGORICAL_BB

TABLE - AMS.AMS_DM_DRV_STG

TABLE - AMS.AMS_DM_FINNUM_STG

TABLE - AMS.AMS_DM_GEN_STG

TABLE - AMS.AMS_DM_IMP_ATTRIBUTES

TABLE - AMS.AMS_DM_INTER_SOURCE_STG

TABLE - AMS.AMS_DM_LIFT

TABLE - AMS.AMS_DM_MODELS_ALL_B

TABLE - AMS.AMS_DM_MODELS_ALL_TL

TABLE - AMS.AMS_DM_NUMERICAL_BB

TABLE - AMS.AMS_DM_OPT_TGT_METRICS

TABLE - AMS.AMS_DM_ORG_CONTACTS

TABLE - AMS.AMS_DM_PARTY_DETAILS

TABLE - AMS.AMS_DM_PARTY_DETAILS_TIME

TABLE - AMS.AMS_DM_PARTY_PROFILE_STG

TABLE - AMS.AMS_DM_PERFORMANCE

TABLE - AMS.AMS_DM_PERINT_STG

TABLE - AMS.AMS_DM_SCORES_ALL_B

TABLE - AMS.AMS_DM_SCORES_ALL_TL

TABLE - AMS.AMS_DM_SCORE_LISTS

TABLE - AMS.AMS_DM_SCORE_PCT_RESULTS

TABLE - AMS.AMS_DM_SCORE_RESULTS

TABLE - AMS.AMS_DM_SOURCE

TABLE - AMS.AMS_DM_TARGETS_B

TABLE - AMS.AMS_DM_TARGETS_TL

TABLE - AMS.AMS_DM_TARGET_SOURCES

TABLE - AMS.AMS_DM_TARGET_STG

TABLE - AMS.AMS_DM_TARGET_VALUES_B

TABLE - AMS.AMS_DM_TARGET_VALUES_TL

TABLE - AMS.AMS_DS_TCA_ENTITY

TABLE - AMS.AMS_DS_TCA_ENTITY_COLS

TABLE - AMS.AMS_DS_TCA_ENTITY_COLS_TL

TABLE - AMS.AMS_DS_TCA_ENTITY_TL

TABLE - AMS.AMS_EVENT_HEADERS_ALL_B

TABLE - AMS.AMS_EVENT_HEADERS_ALL_TL

TABLE - AMS.AMS_EVENT_OFFERS_ALL_B

TABLE - AMS.AMS_EVENT_OFFERS_ALL_TL

TABLE - AMS.AMS_EVENT_REGISTRATIONS

TABLE - AMS.AMS_GENERATED_CODES

TABLE - AMS.AMS_HIERARCHIES_ALL_B

TABLE - AMS.AMS_IBA_CAMPAIGN_RULES

TABLE - AMS.AMS_IBA_CAMP_POSTINGS

TABLE - AMS.AMS_IBA_CPN_ITEMS_DENORM

TABLE - AMS.AMS_IBA_DISPLAY_RULES

TABLE - AMS.AMS_IBA_MS_ITEMS_DENORM

TABLE - AMS.AMS_IBA_PAGE_LOCATION

TABLE - AMS.AMS_IBA_PL_PAGES_B

TABLE - AMS.AMS_IBA_PL_PAGES_TL

TABLE - AMS.AMS_IBA_PL_PARAMETERS_B

TABLE - AMS.AMS_IBA_PL_PARAMETERS_TL

TABLE - AMS.AMS_IBA_PL_PARAM_VALS

TABLE - AMS.AMS_IBA_PL_PG_PARAMS

TABLE - AMS.AMS_IBA_PL_PLACEMENTS_B

TABLE - AMS.AMS_IBA_PL_PLACEMENTS_TL

TABLE - AMS.AMS_IBA_PL_SITES_B

TABLE - AMS.AMS_IBA_PL_SITES_TL

TABLE - AMS.AMS_IBA_PL_STYLESHTS_B

TABLE - AMS.AMS_IBA_PL_STYLESHTS_TL

TABLE - AMS.AMS_IBA_POSTINGS_B

TABLE - AMS.AMS_IBA_POST_SUM_ALL

TABLE - AMS.AMS_IBA_PS_CNDCLSES_B

TABLE - AMS.AMS_IBA_PS_CNDCLSES_TL

TABLE - AMS.AMS_IBA_PS_FILTERS_B

TABLE - AMS.AMS_IBA_PS_FILTERS_TL

TABLE - AMS.AMS_IBA_PS_POSTINGS_B

TABLE - AMS.AMS_IBA_PS_POSTINGS_TL

TABLE - AMS.AMS_IBA_PS_RL_ST_FLTRS

TABLE - AMS.AMS_IBA_PS_RL_ST_PARAMS

TABLE - AMS.AMS_IBA_PS_RULEGRPS_B

TABLE - AMS.AMS_IBA_PS_RULEGRPS_TL

TABLE - AMS.AMS_IBA_PS_RULES

TABLE - AMS.AMS_IBA_PS_STRATS_B

TABLE - AMS.AMS_IBA_PS_STRATS_TL

TABLE - AMS.AMS_IBA_TRACKING_ALL

TABLE - AMS.AMS_IMP_COL_MAPPING

TABLE - AMS.AMS_IMP_CONFIG_COMPONENTS

TABLE - AMS.AMS_IMP_CONFIG_IMPORT_TYPES

TABLE - AMS.AMS_IMP_DEFAULT_MAPPING

TABLE - AMS.AMS_IMP_DOCUMENTS

TABLE - AMS.AMS_IMP_DOC_CONTENT

TABLE - AMS.AMS_IMP_LIST_HEADERS_ALL

TABLE - AMS.AMS_IMP_LIST_HEADERS_ALL_TL

TABLE - AMS.AMS_IMP_LIST_IMPORT_TYPES

TABLE - AMS.AMS_IMP_SOURCE_LINES

TABLE - AMS.AMS_IMP_XML_ATTRIBUTES

TABLE - AMS.AMS_IMP_XML_ELEMENTS

TABLE - AMS.AMS_ITEM_ATTRIBUTES

TABLE - AMS.AMS_LIST_CONT_RESTRICTIONS

TABLE - AMS.AMS_LIST_DELETE_TMP_ENTRIES

TABLE - AMS.AMS_LIST_ENTRIES

TABLE - AMS.AMS_LIST_ENTRIES_PURGE

TABLE - AMS.AMS_LIST_ENTRY_USAGES

TABLE - AMS.AMS_LIST_FIELDS_B

TABLE - AMS.AMS_LIST_FIELDS_TL

TABLE - AMS.AMS_LIST_HEADERS_ALL

TABLE - AMS.AMS_LIST_HEADERS_ALL_TL

TABLE - AMS.AMS_LIST_IMPORT_ERRORS

TABLE - AMS.AMS_LIST_QUERIES_ALL

TABLE - AMS.AMS_LIST_QUERIES_PARAM

TABLE - AMS.AMS_LIST_QUERIES_PARAM_TL

TABLE - AMS.AMS_LIST_QUERIES_TL

TABLE - AMS.AMS_LIST_RULES_ALL

TABLE - AMS.AMS_LIST_RULES_ALL_TL

TABLE - AMS.AMS_LIST_RULE_FIELDS

TABLE - AMS.AMS_LIST_RULE_USAGES

TABLE - AMS.AMS_LIST_SELECT_ACTIONS

TABLE - AMS.AMS_LIST_SRC_FIELDS

TABLE - AMS.AMS_LIST_SRC_FIELDS_TL

TABLE - AMS.AMS_LIST_SRC_TYPES

TABLE - AMS.AMS_LIST_SRC_TYPES_TL

TABLE - AMS.AMS_LIST_SRC_TYPE_ASSOCS

TABLE - AMS.AMS_LIST_SRC_TYPE_USAGES

TABLE - AMS.AMS_LIST_TMP_ENTRIES

TABLE - AMS.AMS_LIST_WORD_FIELDS

TABLE - AMS.AMS_LIST_WORD_REPLACES

TABLE - AMS.AMS_MEDIA_B

TABLE - AMS.AMS_MEDIA_CHANNELS

TABLE - AMS.AMS_MEDIA_TL

TABLE - AMS.AMS_MESSAGES_B

TABLE - AMS.AMS_MESSAGES_TL

TABLE - AMS.AMS_METRICS_ALL_B

TABLE - AMS.AMS_METRICS_ALL_TL

TABLE - AMS.AMS_METRIC_ACCRUALS

TABLE - AMS.AMS_METRIC_FORMULAS

TABLE - AMS.AMS_MET_SCENARIOS

TABLE - AMS.AMS_MET_TPL_ASSOCS

TABLE - AMS.AMS_MET_TPL_DETAILS

TABLE - AMS.AMS_MET_TPL_HEADERS

TABLE - AMS.AMS_MET_TPL_HEADERS_B

TABLE - AMS.AMS_MET_TPL_HEADERS_TL

TABLE - AMS.AMS_MISC_COST_DIS_ALL_B

TABLE - AMS.AMS_MTL_CATEGORIES_DENORM_B

TABLE - AMS.AMS_MTL_CATEGORIES_DENORM_TL

TABLE - AMS.AMS_OBJECT_ASSOCIATIONS

TABLE - AMS.AMS_OBJECT_ATTRIBUTES

TABLE - AMS.AMS_OBJECT_RULES_B

TABLE - AMS.AMS_OBJECT_RULES_TL

TABLE - AMS.AMS_OFFER_PARTIES

TABLE - AMS.AMS_OFFER_PARTIES_TEMP

TABLE - AMS.AMS_OFFER_PRODUCTS

TABLE - AMS.AMS_OFFER_PRODUCTS_TEMP

TABLE - AMS.AMS_PARTY_DEDUPE

TABLE - AMS.AMS_PARTY_MARKET_SEGMENTS

TABLE - AMS.AMS_PARTY_SOURCES

TABLE - AMS.AMS_PORTAL_CACHE

TABLE - AMS.AMS_PRETTY_URL

TABLE - AMS.AMS_PRETTY_URL_ASSOC

TABLE - AMS.AMS_PROD_TEMPLATES_B

TABLE - AMS.AMS_PROD_TEMPLATES_TL

TABLE - AMS.AMS_PROD_TEMPLATE_ATTR

TABLE - AMS.AMS_PROGRAMS_ALL_B

TABLE - AMS.AMS_PROGRAMS_ALL_TL

TABLE - AMS.AMS_QUERY_ALIAS

TABLE - AMS.AMS_QUERY_CONDITION

TABLE - AMS.AMS_QUERY_CONDITION_VALUE

TABLE - AMS.AMS_QUERY_COND_DISP_STRUCT_ALL

TABLE - AMS.AMS_QUERY_COND_DISP_STRUCT_TL

TABLE - AMS.AMS_QUERY_TEMPLATE_ALL

TABLE - AMS.AMS_QUERY_TEMPLATE_INSTANCE

TABLE - AMS.AMS_QUERY_TEMPLATE_TL

TABLE - AMS.AMS_QUERY_TEMP_INST_COND_ASSOC

TABLE - AMS.AMS_QUERY_TEMP_PURPOSE_ASSOC

TABLE - AMS.AMS_REQUEST_HISTORY

TABLE - AMS.AMS_RULE_MEDIA_ASSOC

TABLE - AMS.AMS_SCHEDULER

TABLE - AMS.AMS_SEARCH_IDS

TABLE - AMS.AMS_SETUP_TYPES

TABLE - AMS.AMS_SOURCE_CODES

TABLE - AMS.AMS_STATUS_ORDER_RULES

TABLE - AMS.AMS_SYSTEM_PRETTY_URL

TABLE - AMS.AMS_TCOP_CHANNEL_SUMMARY

TABLE - AMS.AMS_TCOP_CHANNEL_SUM_DTL

TABLE - AMS.AMS_TCOP_CONTACTS

TABLE - AMS.AMS_TCOP_CONTACT_SUMMARY

TABLE - AMS.AMS_TCOP_CONTACT_SUM_DTL

TABLE - AMS.AMS_TCOP_FATIGUED_BY

TABLE - AMS.AMS_TCOP_FR_PERIODS_B

TABLE - AMS.AMS_TCOP_FR_PERIODS_TL

TABLE - AMS.AMS_TCOP_FR_RULES_SETUP

TABLE - AMS.AMS_TCOP_PRVW_CONTACTS

TABLE - AMS.AMS_TCOP_PRVW_FATIGUE

TABLE - AMS.AMS_TCOP_PRVW_FTG_BY

TABLE - AMS.AMS_TCOP_PRVW_FTG_DTLS

TABLE - AMS.AMS_TCOP_PRVW_REQUESTS

TABLE - AMS.AMS_TCOP_REQUESTS

TABLE - AMS.AMS_TEMPL_RESPONSIBILITY

TABLE - AMS.AMS_TEMP_MAPPING

TABLE - AMS.AMS_TEMP_MAPPING_SEQ

TABLE - AMS.AMS_TERR_LEVELS_ALL

TABLE - AMS.AMS_TRIGGERS

TABLE - AMS.AMS_TRIGGERS_TL

TABLE - AMS.AMS_TRIGGER_ACTIONS

TABLE - AMS.AMS_TRIGGER_CHECKS

TABLE - AMS.AMS_TRIGGER_RESULTS

TABLE - AMS.AMS_UPGRADE

TABLE - AMS.AMS_UPGRADE_ENTRIES

TABLE - AMS.AMS_UPGRADE_TRACK_ERROR

TABLE - AMS.AMS_USER_STATUSES_B

TABLE - AMS.AMS_USER_STATUSES_TL

TABLE - AMS.AMS_VENUES_B

TABLE - AMS.AMS_VENUES_TL

TABLE - AMS.AMS_VENUE_RATES_B

TABLE - AMS.AMS_VENUE_RATES_TL

TABLE - AMS.AMS_WEB_PLACEMENTS_B

TABLE - AMS.AMS_WEB_PLACEMENTS_TL

TABLE - AMS.AMS_WEB_PLCE_CITEM_ASSOC

TABLE - AMS.AMS_WEB_PLCE_CTYPE_ASSOC

TABLE - AMS.AMS_WEB_PLCE_MP_B

TABLE - AMS.AMS_WEB_PLCE_MP_TL

TABLE - AMS.AMS_WEB_RECOMMS

TABLE - AMS.AMS_WEB_RULES_B

TABLE - AMS.AMS_WEB_RULES_TL

TABLE - AMS.AMS_WEB_TRACKING

VIEW - APPS.AML_BUSINESS_EVENT_TYPES_VL

VIEW - APPS.AML_LEAD_PROCESSING_STAGES_V

VIEW - APPS.AML_LEAD_PROCESS_REPT_V

VIEW - APPS.AMS_ACCT_INTEREST_V

VIEW - APPS.AMS_ACT_ATTACHMENTS_V

VIEW - APPS.AMS_ACT_CAMPAIGNS_V

VIEW - APPS.AMS_ACT_DELIVERABLES_V

VIEW - APPS.AMS_ACT_DELIVERY_METHODS_V

VIEW - APPS.AMS_ACT_GEO_AREAS_V

VIEW - APPS.AMS_ACT_METRIC_FACTS_ALL_V

VIEW - APPS.AMS_ACT_METRIC_FORMULAS_V

VIEW - APPS.AMS_ACT_MKT_SEGMENTS_VL

VIEW - APPS.AMS_ACT_PRODUCTS_V

VIEW - APPS.AMS_ACT_RESOURCES_V

VIEW - APPS.AMS_AGENDAS_V

VIEW - APPS.AMS_APPROVAL_DETAILS_V

VIEW - APPS.AMS_APPROVAL_DETAILS_VL

VIEW - APPS.AMS_ASO_CAMPAIGN_OFFERS_V

VIEW - APPS.AMS_ATTB_LOV_VALUES_VL

VIEW - APPS.AMS_ATTB_LOV_VL

VIEW - APPS.AMS_CAMPAIGNS_V

VIEW - APPS.AMS_CAMPAIGNS_VL

VIEW - APPS.AMS_CAMPAIGN_FORECASTS_ALL_V

VIEW - APPS.AMS_CAMPAIGN_PRODUCTS_V

VIEW - APPS.AMS_CAMPAIGN_PRODUCT_VOLUMES_V

VIEW - APPS.AMS_CAMPAIGN_SCHEDULES_VL

VIEW - APPS.AMS_CAMPAIGN_TEAM_V

VIEW - APPS.AMS_CATEGORIES_V

VIEW - APPS.AMS_CATEGORIES_VL

VIEW - APPS.AMS_CELLS_SEL_ALL_V

VIEW - APPS.AMS_CELLS_VL

VIEW - APPS.AMS_CHANNELS_V

VIEW - APPS.AMS_CHANNELS_VL

VIEW - APPS.AMS_CLIK_THRU_ACTIONS_VL

VIEW - APPS.AMS_CLIK_THRU_ACT_PARAMS_VL

VIEW - APPS.AMS_COMPETITOR_PRODUCTS_VL

VIEW - APPS.AMS_CONTACT_PRODUCTS_V

VIEW - APPS.AMS_CONTACT_RESTRICTIONS_V

VIEW - APPS.AMS_CONTENT_RULES_VL

VIEW - APPS.AMS_CTD_ASSOC_V

VIEW - APPS.AMS_CUSTOM_SETUPS_VL

VIEW - APPS.AMS_CUSTOM_SETUP_SCR_V

VIEW - APPS.AMS_DATASRC_ATTBINFO_VL

VIEW - APPS.AMS_DELIVERABLES_INFO_V

VIEW - APPS.AMS_DELIVERABLES_VL

VIEW - APPS.AMS_DM_MODELS_V

VIEW - APPS.AMS_DM_MODELS_VL

VIEW - APPS.AMS_DM_MODEL_TEST_V

VIEW - APPS.AMS_DM_MODEL_TRAINING_V

VIEW - APPS.AMS_DM_ORGANIZATIONS_V

VIEW - APPS.AMS_DM_ORG_PROFIT_V

VIEW - APPS.AMS_DM_PARTY_ATTRIBUTES_V

VIEW - APPS.AMS_DM_PERSONS_V

VIEW - APPS.AMS_DM_SCORES_V

VIEW - APPS.AMS_DM_SCORES_VL

VIEW - APPS.AMS_DM_SCORE_APPLY_V

VIEW - APPS.AMS_DM_SCORE_HISTORY_V

VIEW - APPS.AMS_DM_SOURCE_MODEL_BUS_V

VIEW - APPS.AMS_DM_SOURCE_MODEL_CON_V

VIEW - APPS.AMS_DM_SOURCE_SCORE_BUS_V

VIEW - APPS.AMS_DM_SOURCE_SCORE_CON_V

VIEW - APPS.AMS_DM_TARGETS_VL

VIEW - APPS.AMS_DM_TARGET_VALUES_VL

VIEW - APPS.AMS_DS_ACCESSES_ALL_V

VIEW - APPS.AMS_DS_GROUP_ACCESSES_ALL_V

VIEW - APPS.AMS_DS_INSTALL_BASE_V

VIEW - APPS.AMS_DS_INTERACTIONS_V

VIEW - APPS.AMS_DS_ORDERS_V

VIEW - APPS.AMS_DS_ORIG_SYS_REFERENCES_V

VIEW - APPS.AMS_DS_SALES_LEADS_V

VIEW - APPS.AMS_DS_SCORES_V

VIEW - APPS.AMS_DS_TCA_ENTITY_COLS_VL

VIEW - APPS.AMS_DS_TCA_ENTITY_VL

VIEW - APPS.AMS_EVENT_HEADERS_AGENDA_V

VIEW - APPS.AMS_EVENT_HEADERS_V

VIEW - APPS.AMS_EVENT_HEADERS_VL

VIEW - APPS.AMS_EVENT_MAPPING_V

VIEW - APPS.AMS_EVENT_MARKET_SEGMENTS_V

VIEW - APPS.AMS_EVENT_OFFERS_AGENDA_V

VIEW - APPS.AMS_EVENT_OFFERS_ONLY_V

VIEW - APPS.AMS_EVENT_OFFERS_OV_V

VIEW - APPS.AMS_EVENT_OFFERS_REG_V

VIEW - APPS.AMS_EVENT_OFFERS_V

VIEW - APPS.AMS_EVENT_OFFERS_VL

VIEW - APPS.AMS_EVENT_REGISTRATIONS_V

VIEW - APPS.AMS_FORECAST_PRODUCT_SPREADS_V

VIEW - APPS.AMS_FUND_ALLOCATIONS_V

VIEW - APPS.AMS_GEOAREA_SCR_V

VIEW - APPS.AMS_HZ_B2B_MAPPING_V

VIEW - APPS.AMS_HZ_B2C_MAPPING_V

VIEW - APPS.AMS_IBA_EMPLOYEE_ORG_V

VIEW - APPS.AMS_IBA_EMPLOYEE_V

VIEW - APPS.AMS_IBA_PL_PAGES_VL

VIEW - APPS.AMS_IBA_PL_PARAMETERS_VL

VIEW - APPS.AMS_IBA_PL_PLACEMENTS_VL

VIEW - APPS.AMS_IBA_PL_SITES_VL

VIEW - APPS.AMS_IBA_PL_STYLESHTS_VL

VIEW - APPS.AMS_IBA_PS_CNDCLSES_VL

VIEW - APPS.AMS_IBA_PS_FILTERS_VL

VIEW - APPS.AMS_IBA_PS_POSTINGS_VL

VIEW - APPS.AMS_IBA_PS_RULEGRPS_VL

VIEW - APPS.AMS_IBA_PS_STRATS_VL

VIEW - APPS.AMS_IBA_RULESETS_V

VIEW - APPS.AMS_IMP_LIST_HEADERS_ALL_V

VIEW - APPS.AMS_IMP_LIST_HEADERS_VL

VIEW - APPS.AMS_INSTANCE_PARTY_B2B_V

VIEW - APPS.AMS_INSTANCE_PARTY_B2C_V

VIEW - APPS.AMS_JTF_RS_EMP_V

VIEW - APPS.AMS_LEAD_ACCOUNTS_V

VIEW - APPS.AMS_LEAD_CONTACTS_V

VIEW - APPS.AMS_LEAD_MAPPING_V

VIEW - APPS.AMS_LIST_ENTRIES_UWQ_V

VIEW - APPS.AMS_LIST_FIELDS_VL

VIEW - APPS.AMS_LIST_HEADERS_VL

VIEW - APPS.AMS_LIST_QUERIES_PARAM_VL

VIEW - APPS.AMS_LIST_QUERIES_VL

VIEW - APPS.AMS_LIST_RULES_ALL_VL

VIEW - APPS.AMS_LIST_SCH_UWQ_V

VIEW - APPS.AMS_LIST_SRC_FIELDS_VL

VIEW - APPS.AMS_LIST_SRC_TYPES_VL

VIEW - APPS.AMS_LOOKUPS

VIEW - APPS.AMS_LOOKUP_SALES_V

VIEW - APPS.AMS_LT_HZ_CITIZENSHIP

VIEW - APPS.AMS_LT_HZ_EDUCATION

VIEW - APPS.AMS_LT_HZ_EMPLOYMENT_HISTORY

VIEW - APPS.AMS_LT_HZ_PERSON_PROFILES

VIEW - APPS.AMS_LT_HZ_PHONE_1

VIEW - APPS.AMS_LT_ORG_CONTACT_DETAILS_V

VIEW - APPS.AMS_LT_ORG_CONTACT_V

VIEW - APPS.AMS_LT_ORG_PROFILES_V

VIEW - APPS.AMS_LT_PERSON_DETAILS_V

VIEW - APPS.AMS_MEDIA_CHANNELS_VL

VIEW - APPS.AMS_MEDIA_VL

VIEW - APPS.AMS_MESSAGES_V

VIEW - APPS.AMS_MESSAGES_VL

VIEW - APPS.AMS_METRICS_INFO_V

VIEW - APPS.AMS_METRICS_VL

VIEW - APPS.AMS_MET_TPL_HEADERS_VL

VIEW - APPS.AMS_MTL_CATEGORIES_DENORM_VL

VIEW - APPS.AMS_OBJECT_RULES_VL

VIEW - APPS.AMS_OFFERS_V

VIEW - APPS.AMS_OFFER_ADJUSTMENTS_VL

VIEW - APPS.AMS_OFFER_PRODUCTS_V

VIEW - APPS.AMS_ORGANIZATION_V

VIEW - APPS.AMS_ORG_ACCT_ROLES_V

VIEW - APPS.AMS_ORG_ACCT_V

VIEW - APPS.AMS_ORG_CONTACT_DETAILS_V

VIEW - APPS.AMS_ORG_CONTACT_ROLES_V

VIEW - APPS.AMS_ORG_DETAILS_V

VIEW - APPS.AMS_ORG_DM_SOURCE_V

VIEW - APPS.AMS_ORG_EMPS_V

VIEW - APPS.AMS_ORG_FINANCIAL_NUMS_V

VIEW - APPS.AMS_ORG_FINANCIAL_RPT_V

VIEW - APPS.AMS_ORG_INTERACTIONS_V

VIEW - APPS.AMS_ORG_INTERACTION_ACT_V

VIEW - APPS.AMS_ORG_PHONE1_V

VIEW - APPS.AMS_ORG_PHONE2_V

VIEW - APPS.AMS_ORG_PHONE3_V

VIEW - APPS.AMS_ORG_PHONE4_V

VIEW - APPS.AMS_ORG_PHONE5_V

VIEW - APPS.AMS_ORG_PHONE6_V

VIEW - APPS.AMS_ORG_PROFILES_V

VIEW - APPS.AMS_ORG_SITES_V

VIEW - APPS.AMS_ORG_SITE_USES_V

VIEW - APPS.AMS_PARTIES_V

VIEW - APPS.AMS_PARTY_CUSTOMERS_V

VIEW - APPS.AMS_PARTY_INSTANCE_V

VIEW - APPS.AMS_PERSONS_V

VIEW - APPS.AMS_PERSON_ACCT_ROLES_V

VIEW - APPS.AMS_PERSON_ACCT_V

VIEW - APPS.AMS_PERSON_CITIZENSHIP_V

VIEW - APPS.AMS_PERSON_DETAILS_V

VIEW - APPS.AMS_PERSON_DM_SOURCE_V

VIEW - APPS.AMS_PERSON_EDUCATION_V

VIEW - APPS.AMS_PERSON_EMP_HIST_V

VIEW - APPS.AMS_PERSON_INTERACTIONS_V

VIEW - APPS.AMS_PERSON_INTERACT_ACT_V

VIEW - APPS.AMS_PERSON_INTEREST_V

VIEW - APPS.AMS_PERSON_LANG_V

VIEW - APPS.AMS_PERSON_PHONE1_V

VIEW - APPS.AMS_PERSON_PHONE2_V

VIEW - APPS.AMS_PERSON_PHONE3_V

VIEW - APPS.AMS_PERSON_PHONE4_V

VIEW - APPS.AMS_PERSON_PHONE5_V

VIEW - APPS.AMS_PERSON_PHONE6_V

VIEW - APPS.AMS_PERSON_PROFILES_V

VIEW - APPS.AMS_PERSON_RELATIONSHIPS_V

VIEW - APPS.AMS_PERSON_SITES_V

VIEW - APPS.AMS_PERSON_SITE_USES_V

VIEW - APPS.AMS_PRICE_LISTS_V

VIEW - APPS.AMS_PRICE_LIST_LINES_V

VIEW - APPS.AMS_PRODUCT_MAPPING_V

VIEW - APPS.AMS_PRODUCT_OFFERS_V

VIEW - APPS.AMS_PRODUCT_PRICING_V

VIEW - APPS.AMS_PRODUCT_PRL_IMP_V

VIEW - APPS.AMS_PROD_TEMPLATES_VL

VIEW - APPS.AMS_PROGRAMS_VL

VIEW - APPS.AMS_PROGRAM_COMPONENTS_V

VIEW - APPS.AMS_P_ACCT_V

VIEW - APPS.AMS_P_ACT_ATTACHMENTS_V

VIEW - APPS.AMS_P_ACT_METRICS_V

VIEW - APPS.AMS_P_CAMPAIGNS_V

VIEW - APPS.AMS_P_CAMPAIGN_GEO_AREAS_V

VIEW - APPS.AMS_P_CAMPAIGN_MKT_SEGMENTS_V

VIEW - APPS.AMS_P_CAMPAIGN_OFFERS_V

VIEW - APPS.AMS_P_CAMPAIGN_PRODUCTS_V

VIEW - APPS.AMS_P_CAMPAIGN_SCHEDS_V

VIEW - APPS.AMS_P_CELLS_V

VIEW - APPS.AMS_P_DELIVERABLES_V

VIEW - APPS.AMS_P_DELIV_KIT_ITEMS_V

VIEW - APPS.AMS_P_DISCOVERER_SQL_V

VIEW - APPS.AMS_P_EMAIL_V

VIEW - APPS.AMS_P_EVENT_CAMPAIGNS_V

VIEW - APPS.AMS_P_EVENT_DELIVERABLES_V

VIEW - APPS.AMS_P_EVENT_OFFERS_V

VIEW - APPS.AMS_P_EVENT_REG_CONTACTS_V

VIEW - APPS.AMS_P_EVENT_REG_ROSTER_V

VIEW - APPS.AMS_P_FAX_V

VIEW - APPS.AMS_P_LIST_ENTRIES_V

VIEW - APPS.AMS_P_LIST_HEADERS_V

VIEW - APPS.AMS_P_LIST_RULES_V

VIEW - APPS.AMS_P_METRICS_V

VIEW - APPS.AMS_P_OFFER_MKT_SEGMENTS_V

VIEW - APPS.AMS_P_OFFER_PRODUCTS_V

VIEW - APPS.AMS_P_ORGANIZATION_V

VIEW - APPS.AMS_P_ORG_PROFILES_V

VIEW - APPS.AMS_P_OSO_SOURCE_CODES_V

VIEW - APPS.AMS_P_PERSON_PROFILES_V

VIEW - APPS.AMS_P_PERSON_V

VIEW - APPS.AMS_P_PHONE_V

VIEW - APPS.AMS_P_SOURCE_CODES_V

VIEW - APPS.AMS_QUERY_COND_DISP_STRUCT_VL

VIEW - APPS.AMS_QUERY_TEMPLATE_VL

VIEW - APPS.AMS_QUERY_TMPL_CONDITION_VL

VIEW - APPS.AMS_SEARCH_IDS_V

VIEW - APPS.AMS_SOURCE_CODES_DETAILS_V

VIEW - APPS.AMS_TAR_ACCOUNT_V

VIEW - APPS.AMS_TAR_CONTACT_V

VIEW - APPS.AMS_TAR_ORGANIZATION_V

VIEW - APPS.AMS_TAR_PERSON_V

VIEW - APPS.AMS_TASKS_V

VIEW - APPS.AMS_TCOP_FR_PERIODS_VL

VIEW - APPS.AMS_TERR_HIER_V

VIEW - APPS.AMS_TERR_V

VIEW - APPS.AMS_TERR_VALUES_V

VIEW - APPS.AMS_TRIGGERS_V

VIEW - APPS.AMS_TRIGGERS_VL

VIEW - APPS.AMS_USER_ORG_V

VIEW - APPS.AMS_USER_STATUSES_V

VIEW - APPS.AMS_USER_STATUSES_VL

VIEW - APPS.AMS_VENUES_V

VIEW - APPS.AMS_VENUES_VL

VIEW - APPS.AMS_VENUE_RATES_VL

VIEW - APPS.AMS_WEB_PLACEMENTS_VL

VIEW - APPS.AMS_WEB_PLCE_MP_VL

VIEW - APPS.AMS_WEB_RULES_VL

Table: AML_BUSINESS_EVENT_TYPES_B

Primary Key: AML_BUSINESS_EVENT_TYPES_PK

1. BUSINESS_EVENT_TYPE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AML_BUSINESS_EVENT_TYPES_B defines the mapping of business event types with actions(JTF_IH_ACTIONS_B) and action items(JTF_IH_ACTION_ITEMS_B)

Indexes

Columns

[top of page]

AMS.AML_BUSINESS_EVENT_TYPES_B does not reference any database object

AMS.AML_BUSINESS_EVENT_TYPES_B is referenced by following:

AMS

VIEW - AML_BUSINESS_EVENT_TYPES_B#

[top of page]

Table: AML_BUSINESS_EVENT_TYPES_TL

Primary Key: AML_BUSINESS_EVENT_TYPES_TL_PK

1. BUSINESS_EVENT_TYPE_ID
2. LANGUAGE

Primary Key: AML_BUSINESS_EVENT_TYPES_TL_UK

1. LANGUAGE
2. MEANING

Foreign Keys from this table:

Comments

Defines meaning and description of table AML_BUSINESS_EVENT_TYPES_B.

Indexes

Columns

[top of page]

AMS.AML_BUSINESS_EVENT_TYPES_TL does not reference any database object

AMS.AML_BUSINESS_EVENT_TYPES_TL is referenced by following:

AMS

VIEW - AML_BUSINESS_EVENT_TYPES_TL#

[top of page]

Table: AML_DATA_MIGRATION

Comments

Columns

[top of page]

AMS.AML_DATA_MIGRATION does not reference any database object

AMS.AML_DATA_MIGRATION is referenced by following:

AMS

VIEW - AML_DATA_MIGRATION#

[top of page]

Table: AML_INTERACTION_LEADS

Primary Key: AML_INTERACTION_LEADS_PK

1. INTERACTION_LEAD_ID

Foreign Keys from this table:

Comments

AML_INTERACTION_LEADS defines the relation of interactions(JTF_IH_INTERACTIONS), responses(AS_IMPORT_INTERFACE), and leads(AS_SALES_LEADS).

Indexes

Columns

[top of page]

AMS.AML_INTERACTION_LEADS does not reference any database object

AMS.AML_INTERACTION_LEADS is referenced by following:

AMS

VIEW - AML_INTERACTION_LEADS#

[top of page]

Table: AML_MONITOR_CONDITIONS

Primary Key: AML_MONITOR_CONDITIONS_PK

1. MONITOR_CONDITION_ID

Comments

Monitor rules may have conditions which are stored in this table

Indexes

Columns

[top of page]

AMS.AML_MONITOR_CONDITIONS does not reference any database object

AMS.AML_MONITOR_CONDITIONS is referenced by following:

AMS

VIEW - AML_MONITOR_CONDITIONS#

[top of page]

Table: AML_MONITOR_LOG

Primary Key: AML_MONITOR_LOG_PK

1. MONITOR_LOG_ID

Comments

Monitor log keeps the transaction history of the monitor rule usage. This also allows to find out how leads are using a specific monitor.

Indexes

Columns

[top of page]

AMS.AML_MONITOR_LOG does not reference any database object

AMS.AML_MONITOR_LOG is referenced by following:

AMS

VIEW - AML_MONITOR_LOG#

[top of page]

Table: AML_RULE_APPLIED_ATTRS

Comments

AML_RULE_APPLIED_ATTRS is used to store winning rule log for lead evaluation

Columns

[top of page]

AMS.AML_RULE_APPLIED_ATTRS does not reference any database object

AMS.AML_RULE_APPLIED_ATTRS is referenced by following:

AMS

VIEW - AML_RULE_APPLIED_ATTRS#

[top of page]

Table: AML_SALES_LEAD_TIMEFRAMES

Primary Key: AML_SALES_LEAD_TIMEFRAMES_PK

1. TIMEFRAME_ID

Comments

AML_SALES_LEAD_TIMEFRAMES defines the mapping for the Decision time frame codes to the smart number of days it maps to

Indexes

Columns

[top of page]

AMS.AML_SALES_LEAD_TIMEFRAMES does not reference any database object

AMS.AML_SALES_LEAD_TIMEFRAMES is referenced by following:

AMS

VIEW - AML_SALES_LEAD_TIMEFRAMES#

[top of page]

Table: AMS_ACT_ACCESS

Primary Key: AMS_ACT_ACCESS_PK

1. ACTIVITY_ACCESS_ID

Primary Key: AMS_ACT_ACCESS_UK1

1. ARC_USER_OR_ROLE_TYPE
2. ARC_ACT_ACCESS_TO_OBJECT
3. ACT_ACCESS_TO_OBJECT_ID
4. USER_OR_ROLE_ID

Foreign Keys from this table:

Comments

AMS_ACT_ACCESS stores users/roles with admin/view privilege for all marketing objects like campaigns, events , collaterals and funds.
The responsibility together with the admin flag on this table handles most of the security in the application. That is, who can update,delete information pertaining to an object.

Indexes

Columns

[top of page]

AMS.AMS_ACT_ACCESS does not reference any database object

AMS.AMS_ACT_ACCESS is referenced by following:

AMS

VIEW - AMS_ACT_ACCESS#

[top of page]

Table: AMS_ACT_ACCESS_DENORM

Primary Key: AMS_ACT_ACCESS_DENORM_PK

1. ACCESS_DENORM_ID

Primary Key: AMS_ACT_ACCESS_DENORM_UK

1. OBJECT_TYPE
2. OBJECT_ID
3. RESOURCE_ID

Foreign Keys from this table:

Comments

This table stores the object access information denormalized to resource Level. Any resource assigned to an object will be inserted realtime into this table. Teams are update through concurrent programs. Two concurrent programs AMS: Refresh JTF access denorm and AMS: Refresh AMS access denorm will be provided. The first program will refresh the denorm for all the changes in groups, group relations and group members done through Resource Manager. The second program will handle the changes in AMS_ACT_ACCESS table.

Indexes

Columns

[top of page]

AMS.AMS_ACT_ACCESS_DENORM does not reference any database object

AMS.AMS_ACT_ACCESS_DENORM is referenced by following:

AMS

VIEW - AMS_ACT_ACCESS_DENORM#

[top of page]

Table: AMS_ACT_CATEGORIES

Primary Key: AMS_ACT_CATEGORIES_PK

1. ACTIVITY_CATEGORY_ID

Primary Key: AMS_ACT_CATEGORIES_UK1

1. ACT_CATEGORY_USED_BY_ID
2. ARC_ACT_CATEGORY_USED_BY
3. CATEGORY_ID

Foreign Keys from this table:

Comments

AMS_ACT_CATEGORIES is a generic intersection table, used to specify what categories an activity belongs to. This is used to allow for categorizing activities for reporting and search capability. For example, an Event could be classified as belonging to a 'technical' category as well as 'consulting' category.

Indexes

Columns

[top of page]

AMS.AMS_ACT_CATEGORIES does not reference any database object

AMS.AMS_ACT_CATEGORIES is referenced by following:

AMS

VIEW - AMS_ACT_CATEGORIES#

[top of page]

Table: AMS_ACT_CHANGE_REQ_ITEMS

Primary Key: AMS_ACT_CHANGE_REQ_ITEMS_PK

1. ACTIVITY_CHANGE_REQ_ITEM_ID

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

AMS.AMS_ACT_CHANGE_REQ_ITEMS does not reference any database object

AMS.AMS_ACT_CHANGE_REQ_ITEMS is referenced by following:

AMS

VIEW - AMS_ACT_CHANGE_REQ_ITEMS#

[top of page]

Table: AMS_ACT_COMMUNICATIONS

Primary Key: AMS_ACT_COMMUNICATIONS_PK

1. ACTIVITY_COMMUNICATIONS_ID

Foreign Keys from this table:

Comments

AMS_ACT_COMMUNICATIONS stores communication preferences for a specific activity such as registrations.

Indexes

Columns

[top of page]

AMS.AMS_ACT_COMMUNICATIONS does not reference any database object

AMS.AMS_ACT_COMMUNICATIONS is referenced by following:

AMS

VIEW - AMS_ACT_COMMUNICATIONS#

[top of page]

Table: AMS_ACT_CONTACT_POINTS

Primary Key: AMS_ACT_CONTACT_POINTS_PK

1. CONTACT_POINT_ID

Comments

This table stores the contact details of marketing objects. For ex. it stores the phone number, website URL, address etc. This table also stores the scripts to be used to contact the customer

Indexes

Columns

[top of page]

AMS.AMS_ACT_CONTACT_POINTS does not reference any database object

AMS.AMS_ACT_CONTACT_POINTS is referenced by following:

AMS

VIEW - AMS_ACT_CONTACT_POINTS#

[top of page]

Table: AMS_ACT_DELIVERY_METHODS

Primary Key: AMS_ACT_DELIVERY_METHODS_PK

1. ACTIVITY_DELIVERY_METHOD_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMS_ACT_DELIVERY is the intersection table that connect a delivery method for an media type stored in the database to a certain activity. Some examples of activities that can have attachments:
- Events

Indexes

Columns

[top of page]

AMS.AMS_ACT_DELIVERY_METHODS does not reference any database object

AMS.AMS_ACT_DELIVERY_METHODS is referenced by following:

AMS

VIEW - AMS_ACT_DELIVERY_METHODS#

[top of page]

Table: AMS_ACT_DISCOVERER_ALL

Primary Key: AMS_ACT_DISCOVERER_ALL_PK

1. ACTIVITY_DISCOVERER_ID

Primary Key: AMS_ACT_DISCOVERER_ALL_UK1

1. ACT_DISCOVERER_USED_BY_ID
2. ARC_ACT_DISCOVERER_USED_BY
3. WORKBOOK_NAME

Foreign Keys from this table:

Comments

AMS_ACT_DISCOVERER_ALL hold all workbooks/sheets that together define a Cell.

Indexes

Columns

[top of page]

AMS.AMS_ACT_DISCOVERER_ALL does not reference any database object

AMS.AMS_ACT_DISCOVERER_ALL is referenced by following:

AMS

VIEW - AMS_ACT_DISCOVERER_ALL#

[top of page]

Table: AMS_ACT_FORECASTS_ALL

Primary Key: AMS_ACT_FORECASTS_ALL_PK

1. FORECAST_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns

[top of page]

AMS.AMS_ACT_FORECASTS_ALL does not reference any database object

AMS.AMS_ACT_FORECASTS_ALL is referenced by following:

AMS

VIEW - AMS_ACT_FORECASTS_ALL#

[top of page]

Table: AMS_ACT_GEO_AREAS

Primary Key: AMS_ACT_GEO_AREAS_PK

1. ACTIVITY_GEO_AREA_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMS_ACT_GEO_AREAS stores data regarding the geographical region in which a campaign or an event is running. For example. campaign X is running in USA.

Indexes

Columns

[top of page]

AMS.AMS_ACT_GEO_AREAS does not reference any database object

AMS.AMS_ACT_GEO_AREAS is referenced by following:

AMS

VIEW - AMS_ACT_GEO_AREAS#

[top of page]

Table: AMS_ACT_LISTS

Primary Key: AMS_ACT_LISTS_U1

1. ACT_LIST_HEADER_ID

Foreign Keys from this table:

Comments

This Table Stores the information of Target Group/Invite Lists and its lists

Indexes

Columns

[top of page]

AMS.AMS_ACT_LISTS does not reference any database object

AMS.AMS_ACT_LISTS is referenced by following:

AMS

VIEW - AMS_ACT_LISTS#

[top of page]

Table: AMS_ACT_LIST_GROUPS

Primary Key: AMS_ACT_LIST_GROUPS_U1

1. ACT_LIST_GROUP_ID

Comments

Target Groups could be subdivided into many small groups. This table stores the information regarding them.

Indexes

Columns

[top of page]

AMS.AMS_ACT_LIST_GROUPS does not reference any database object

AMS.AMS_ACT_LIST_GROUPS is referenced by following:

AMS

VIEW - AMS_ACT_LIST_GROUPS#

[top of page]

Table: AMS_ACT_LOGS

Primary Key: AMS_ACT_LOGS_PK

1. ACTIVITY_LOG_ID

Foreign Keys from this table:

Comments

AMS_ACT_LOGS stores the log generated during transactions like list generation, copy activities, metrics refresh.

Indexes

Columns

[top of page]

AMS.AMS_ACT_LOGS does not reference any database object

AMS.AMS_ACT_LOGS is referenced by following:

AMS

VIEW - AMS_ACT_LOGS#

[top of page]

Table: AMS_ACT_MARKET_SEGMENTS

Primary Key: AMS_ACT_MARKET_SEGMENTS_PK

1. ACTIVITY_MARKET_SEGMENT_ID

Foreign Keys from this table:

Comments

AMS_ACT_MARKET_SEGMENTS is the intersection table that stores what Market Segment are used by what Activity (Promotion etc.)

stores all the market segments that a party belongs to. A party
can belong to more than one market segment (eg. A party can live in california as well as a sports enthusiast).
This information is useful in identifying the promotions that can be applied to the party.

Indexes

Columns

[top of page]

AMS.AMS_ACT_MARKET_SEGMENTS does not reference any database object

AMS.AMS_ACT_MARKET_SEGMENTS is referenced by following:

AMS

VIEW - AMS_ACT_MARKET_SEGMENTS#

[top of page]

Table: AMS_ACT_MESSAGES

Primary Key: AMS_ACT_MESSAGES_PK

1. ACT_MESSAGE_ID

Foreign Keys from this table:

Comments

AMS_ACT_MESSAGES is the intersection table that stores the messages associated with campaign , event or any marketing object.

Indexes

Columns

[top of page]

AMS.AMS_ACT_MESSAGES does not reference any database object

AMS.AMS_ACT_MESSAGES is referenced by following:

AMS

VIEW - AMS_ACT_MESSAGES#

[top of page]

Table: AMS_ACT_METRICS_ALL

Primary Key: AMS_ACT_METRICS_ALL_PK

1. ACTIVITY_METRIC_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

AMS_ACT_METRICS_ALL stores the metrics that will be tracked for a particular activity. The forecasted, committed and actual value of the metric will be available here. The metric engine will calculate the actual values(unless manual metric is used). The committed value is set after purchase request/budget is approved. Forecasted is manually entered by the end user.

Indexes

Columns

[top of page]

AMS.AMS_ACT_METRICS_ALL does not reference any database object

AMS.AMS_ACT_METRICS_ALL is referenced by following:

AMS

VIEW - AMS_ACT_METRICS_ALL#

[top of page]

Table: AMS_ACT_METRICS_ALL_DENORM

Comments

This table holds the denormalized data for all associated metrics with Campaign/Schedules
/Lists etc. The data gets whown in Campaign/Audience Dashboard.

Indexes

Columns

[top of page]

AMS.AMS_ACT_METRICS_ALL_DENORM does not reference any database object

AMS.AMS_ACT_METRICS_ALL_DENORM is referenced by following:

AMS

VIEW - AMS_ACT_METRICS_ALL_DENORM#

[top of page]

Table: AMS_ACT_METRIC_FACTS_ALL

Primary Key: AMS_ACT_METRIC_FACTS_ALL_PK

1. ACTIVITY_METRIC_FACT_ID

Foreign Keys from this table:

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Indexes

Columns