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:

[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:

[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

[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:

[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

[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

[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

[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

[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:

[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:

[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:

[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:

[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:

[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

[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:

[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:

[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:

[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:

[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:

[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

[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:

[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:

[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:

[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:

[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

[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:

[top of page]

AMS.AMS_ACT_METRIC_FACTS_ALL does not reference any database object

AMS.AMS_ACT_METRIC_FACTS_ALL is referenced by following:

AMS

VIEW - AMS_ACT_METRIC_FACTS_ALL#

[top of page]

Table: AMS_ACT_METRIC_FORMULAS

Primary Key: AMS_ACT_METRIC_FORMULAS_PK

1. FORMULA_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_ACT_METRIC_FORMULAS does not reference any database object

AMS.AMS_ACT_METRIC_FORMULAS is referenced by following:

AMS

VIEW - AMS_ACT_METRIC_FORMULAS#

[top of page]

Table: AMS_ACT_METRIC_FORM_ENT

Primary Key: AMS_ACT_METRIC_FORM_ENT_PK1

1. FORMULA_ENTRY_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_METRIC_FORM_ENT does not reference any database object

AMS.AMS_ACT_METRIC_FORM_ENT is referenced by following:

AMS

VIEW - AMS_ACT_METRIC_FORM_ENT#

[top of page]

Table: AMS_ACT_METRIC_HST

Primary Key: AMS_ACT_METRIC_HST_PK

1. ACT_MET_HST_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_METRIC_HST does not reference any database object

AMS.AMS_ACT_METRIC_HST is referenced by following:

AMS

VIEW - AMS_ACT_METRIC_HST#

[top of page]

Table: AMS_ACT_OBJECTIVES

Primary Key: AMS_ACT_OBJECTIVES_PK

1. ACTIVITY_OBJECTIVE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_ACT_OBJECTIVES does not reference any database object

AMS.AMS_ACT_OBJECTIVES is referenced by following:

AMS

VIEW - AMS_ACT_OBJECTIVES#

[top of page]

Table: AMS_ACT_OBJ_METRICS

Primary Key: AMS_ACT_OBJ_METRICS_PK

1. ACTIVITY_OBJECTIVE_METRIC_ID

Primary Key: AMS_ACT_OBJ_METRICS_UK1

1. ACTIVITY_METRIC_ID
2. ACTIVITY_OBJECTIVE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_OBJ_METRICS does not reference any database object

AMS.AMS_ACT_OBJ_METRICS is referenced by following:

AMS

VIEW - AMS_ACT_OBJ_METRICS#

[top of page]

Table: AMS_ACT_PARTNERS

Primary Key: AMS_ACT_PARTNERS_PK

1. ACTIVITY_PARTNER_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_PARTNERS does not reference any database object

AMS.AMS_ACT_PARTNERS is referenced by following:

AMS

VIEW - AMS_ACT_PARTNERS#

[top of page]

Table: AMS_ACT_PERSONS

Primary Key: AMS_ACT_PERSONS_PK

1. ACTIVITY_PERSON_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_PERSONS does not reference any database object

AMS.AMS_ACT_PERSONS is referenced by following:

AMS

VIEW - AMS_ACT_PERSONS#

[top of page]

Table: AMS_ACT_PRODUCTS

Primary Key: AMS_ACT_PRODUCTS_PK

1. ACTIVITY_PRODUCT_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_ACT_PRODUCTS does not reference any database object

AMS.AMS_ACT_PRODUCTS is referenced by following:

AMS

VIEW - AMS_ACT_PRODUCTS#

[top of page]

Table: AMS_ACT_PROGRAMS

Primary Key: AMS_ACT_PROGRAMS_PK

1. ACTIVITY_PROGRAM_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_PROGRAMS does not reference any database object

AMS.AMS_ACT_PROGRAMS is referenced by following:

AMS

VIEW - AMS_ACT_PROGRAMS#

[top of page]

Table: AMS_ACT_QA_CHECKS

Primary Key: AMS_ACT_QA_CHECKS_PK

1. ACTIVITY_QA_CHECK_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_QA_CHECKS does not reference any database object

AMS.AMS_ACT_QA_CHECKS is referenced by following:

AMS

VIEW - AMS_ACT_QA_CHECKS#

[top of page]

Table: AMS_ACT_RESOURCES

Primary Key: AMS_ACT_RESOURCES_PK

1. ACTIVITY_RESOURCE_ID

Primary Key: AMS_ACT_RESOURCES_UK1

1. ACT_RESOURCE_USED_BY_ID
2. ARC_ACT_RESOURCE_USED_BY
3. RESOURCE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_RESOURCES does not reference any database object

AMS.AMS_ACT_RESOURCES is referenced by following:

AMS

VIEW - AMS_ACT_RESOURCES#

[top of page]

Table: AMS_ACT_SCRIPTS

Primary Key: AMS_ACT_SCRIPTS_PK

1. ACTIVITY_SCRIPT_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_SCRIPTS does not reference any database object

AMS.AMS_ACT_SCRIPTS is referenced by following:

AMS

VIEW - AMS_ACT_SCRIPTS#

[top of page]

Table: AMS_ACT_SIZES

Primary Key: AMS_ACT_SIZES_PK1

1. ACTIVITY_SIZE_ID

[top of page]

AMS.AMS_ACT_SIZES does not reference any database object

AMS.AMS_ACT_SIZES is referenced by following:

AMS

VIEW - AMS_ACT_SIZES#

[top of page]

Table: AMS_ACT_SKILLS

Primary Key: AMS_ACT_SKILLS_PK

1. ACTIVITY_SKILL_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_ACT_SKILLS does not reference any database object

AMS.AMS_ACT_SKILLS is referenced by following:

AMS

VIEW - AMS_ACT_SKILLS#

[top of page]

Table: AMS_ACT_TYPE_TASK_TPLS

Primary Key: AMS_ACT_TYPE_TASK_TPLS_PK

1. ACTIVITY_TYPE_TASK_TPL_ID

[top of page]

AMS.AMS_ACT_TYPE_TASK_TPLS does not reference any database object

AMS.AMS_ACT_TYPE_TASK_TPLS is referenced by following:

AMS

VIEW - AMS_ACT_TYPE_TASK_TPLS#

[top of page]

Table: AMS_ACT_WEB_RULE_TYPES

Primary Key: AAE_PK

1. ACTIVITY_RULE_ID

[top of page]

AMS.AMS_ACT_WEB_RULE_TYPES does not reference any database object

AMS.AMS_ACT_WEB_RULE_TYPES is referenced by following:

AMS

VIEW - AMS_ACT_WEB_RULE_TYPES#

[top of page]

Table: AMS_ACT_WF_REQUESTS

Primary Key: AMS_ACT_WF_REQUESTS_PK

1. ACTIVITY_WF_REQUEST_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_ACT_WF_REQUESTS does not reference any database object

AMS.AMS_ACT_WF_REQUESTS is referenced by following:

AMS

VIEW - AMS_ACT_WF_REQUESTS#

[top of page]

Table: AMS_ADI_CAMPAIGNS_INTERFACE

[top of page]

AMS.AMS_ADI_CAMPAIGNS_INTERFACE does not reference any database object

AMS.AMS_ADI_CAMPAIGNS_INTERFACE is referenced by following:

AMS

VIEW - AMS_ADI_CAMPAIGNS_INTERFACE#

[top of page]

Table: AMS_ADI_MEDIA_PLANNER

[top of page]

AMS.AMS_ADI_MEDIA_PLANNER does not reference any database object

AMS.AMS_ADI_MEDIA_PLANNER is referenced by following:

AMS

VIEW - AMS_ADI_MEDIA_PLANNER#

[top of page]

Table: AMS_ADI_OBJECTS_EXPORT_LIST

[top of page]

AMS.AMS_ADI_OBJECTS_EXPORT_LIST does not reference any database object

AMS.AMS_ADI_OBJECTS_EXPORT_LIST is referenced by following:

AMS

VIEW - AMS_ADI_OBJECTS_EXPORT_LIST#

[top of page]

Table: AMS_AGENDAS_B

Primary Key: AMS_AGENDAS_B_PK

1. AGENDA_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_AGENDAS_B does not reference any database object

AMS.AMS_AGENDAS_B is referenced by following:

AMS

VIEW - AMS_AGENDAS_B#

[top of page]

Table: AMS_AGENDAS_TL

Primary Key: AMS_AGENDAS_TL_PK

1. AGENDA_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_AGENDAS_TL does not reference any database object

AMS.AMS_AGENDAS_TL is referenced by following:

AMS

VIEW - AMS_AGENDAS_TL#

[top of page]

Table: AMS_APPROVAL_DETAILS

Primary Key: AMS_APPROVAL_DETAILS_PK

1. APPROVAL_DETAIL_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_APPROVAL_DETAILS does not reference any database object

AMS.AMS_APPROVAL_DETAILS is referenced by following:

AMS

VIEW - AMS_APPROVAL_DETAILS#

[top of page]

Table: AMS_APPROVAL_DETAILS_TL

Primary Key: AMS_APPROVAL_DETAILS_TK_PK1

1. APPROVAL_DETAIL_ID
2. LANGUAGE

Primary Key: AMS_APPROVAL_DETAILS_TL_UK1

1. NAME
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_APPROVAL_DETAILS_TL does not reference any database object

AMS.AMS_APPROVAL_DETAILS_TL is referenced by following:

AMS

VIEW - AMS_APPROVAL_DETAILS_TL#

[top of page]

Table: AMS_APPROVAL_HISTORY

[top of page]

AMS.AMS_APPROVAL_HISTORY does not reference any database object

AMS.AMS_APPROVAL_HISTORY is referenced by following:

AMS

VIEW - AMS_APPROVAL_HISTORY#

[top of page]

Table: AMS_APPROVAL_RULES

Primary Key: AMS_APPROVAL_RULES_PK

1. APPROVAL_RULE_ID

[top of page]

AMS.AMS_APPROVAL_RULES does not reference any database object

AMS.AMS_APPROVAL_RULES is referenced by following:

AMS

VIEW - AMS_APPROVAL_RULES#

[top of page]

Table: AMS_APPROVERS

Primary Key: AMS_APPROVERS_PK

1. APPROVER_ID

[top of page]

AMS.AMS_APPROVERS does not reference any database object

AMS.AMS_APPROVERS is referenced by following:

AMS

VIEW - AMS_APPROVERS#

[top of page]

Table: AMS_ATTACHMENT_PROPERTIES

Primary Key: AMS_ATTACHMENT_PROPERTIES_PK1

1. LOOKUP_CODE
2. LOOKUP_TYPE

[top of page]

AMS.AMS_ATTACHMENT_PROPERTIES does not reference any database object

AMS.AMS_ATTACHMENT_PROPERTIES is referenced by following:

AMS

VIEW - AMS_ATTACHMENT_PROPERTIES#

[top of page]

Table: AMS_ATTB_LOV_B

Primary Key: AMS_ATTB_LOV_B_UK

1. ATTB_LOV_ID

[top of page]

AMS.AMS_ATTB_LOV_B does not reference any database object

AMS.AMS_ATTB_LOV_B is referenced by following:

AMS

VIEW - AMS_ATTB_LOV_B#

[top of page]

Table: AMS_ATTB_LOV_TL

Primary Key: AMS_ATTB_LOV_TL_PK

1. ATTB_LOV_ID

[top of page]

AMS.AMS_ATTB_LOV_TL does not reference any database object

AMS.AMS_ATTB_LOV_TL is referenced by following:

AMS

VIEW - AMS_ATTB_LOV_TL#

[top of page]

Table: AMS_ATTB_LOV_VALUES_B

Primary Key: AMS_ATTB_LOV_VALUES_B_PK

1. ATTB_LOV_VALUE_ID

[top of page]

AMS.AMS_ATTB_LOV_VALUES_B does not reference any database object

AMS.AMS_ATTB_LOV_VALUES_B is referenced by following:

AMS

VIEW - AMS_ATTB_LOV_VALUES_B#

[top of page]

Table: AMS_ATTB_LOV_VALUES_TL

Primary Key: AMS_ATTB_LOV_VALUES_TL_PK

1. ATTB_LOV_VALUE_ID

[top of page]

AMS.AMS_ATTB_LOV_VALUES_TL does not reference any database object

AMS.AMS_ATTB_LOV_VALUES_TL is referenced by following:

AMS

VIEW - AMS_ATTB_LOV_VALUES_TL#

[top of page]

Table: AMS_BASE_SALES_VOL_ALL

Primary Key: AMS_BASE_SALES_VOL_ALL

1. BASE_SALES_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_BASE_SALES_VOL_ALL does not reference any database object

AMS.AMS_BASE_SALES_VOL_ALL is referenced by following:

AMS

VIEW - AMS_BASE_SALES_VOL_ALL#

[top of page]

Table: AMS_CALENDAR_CRITERIA

Primary Key: AMS_CALENDAR_CRITERIA_PK

1. CRITERIA_ID

[top of page]

AMS.AMS_CALENDAR_CRITERIA does not reference any database object

AMS.AMS_CALENDAR_CRITERIA is referenced by following:

AMS

VIEW - AMS_CALENDAR_CRITERIA#

[top of page]

Table: AMS_CAMPAIGNS_ALL_B

Primary Key: AMS_CAMPAIGNS_ALL_B_PK

1. CAMPAIGN_ID

Primary Key: AMS_CAMPAIGNS_ALL_B_UK1

1. SOURCE_CODE

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CAMPAIGNS_ALL_B does not reference any database object

AMS.AMS_CAMPAIGNS_ALL_B is referenced by following:

AMS

VIEW - AMS_CAMPAIGNS_ALL_B#

[top of page]

Table: AMS_CAMPAIGNS_ALL_TL

Primary Key: AMS_CAMPAIGNS_ALL_TL_PK

1. CAMPAIGN_ID
2. LANGUAGE

Primary Key: AMS_CAMPAIGNS_ALL_TL_UK1

1. CAMPAIGN_NAME
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CAMPAIGNS_ALL_TL does not reference any database object

AMS.AMS_CAMPAIGNS_ALL_TL is referenced by following:

AMS

VIEW - AMS_CAMPAIGNS_ALL_TL#

[top of page]

Table: AMS_CAMPAIGN_RELATIONS

Primary Key: AMS_CAMPAIGN_RELATIONS_PK

1. CAMPAIGN_RELATION_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CAMPAIGN_RELATIONS does not reference any database object

AMS.AMS_CAMPAIGN_RELATIONS is referenced by following:

AMS

VIEW - AMS_CAMPAIGN_RELATIONS#

[top of page]

Table: AMS_CAMPAIGN_SCHEDULES

Primary Key: AMS_CAMPAIGN_SCHEDULES_PK

1. CAMPAIGN_SCHEDULE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CAMPAIGN_SCHEDULES does not reference any database object

AMS.AMS_CAMPAIGN_SCHEDULES is referenced by following:

AMS

VIEW - AMS_CAMPAIGN_SCHEDULES#

[top of page]

Table: AMS_CAMPAIGN_SCHEDULES_B

Primary Key: AMS_CAMPAIGN_SCHEDULES_B_PK

1. SCHEDULE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CAMPAIGN_SCHEDULES_B does not reference any database object

AMS.AMS_CAMPAIGN_SCHEDULES_B is referenced by following:

AMS

VIEW - AMS_CAMPAIGN_SCHEDULES_B#

[top of page]

Table: AMS_CAMPAIGN_SCHEDULES_TL

Primary Key: AMS_CAMPAIGN_SCHEDULES_TL_PK

1. SCHEDULE_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CAMPAIGN_SCHEDULES_TL does not reference any database object

AMS.AMS_CAMPAIGN_SCHEDULES_TL is referenced by following:

AMS

VIEW - AMS_CAMPAIGN_SCHEDULES_TL#

[top of page]

Table: AMS_CATEGORIES_B

Primary Key: AMS_CATEGORIES_B_PK

1. CATEGORY_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CATEGORIES_B does not reference any database object

AMS.AMS_CATEGORIES_B is referenced by following:

AMS

VIEW - AMS_CATEGORIES_B#

[top of page]

Table: AMS_CATEGORIES_TL

Primary Key: AMS_CATEGORIES_TL_PK

1. CATEGORY_ID
2. LANGUAGE

Primary Key: AMS_CATEGORIES_TL_UK1

1. LANGUAGE
2. CATEGORY_NAME

Foreign Keys from this table:

[top of page]

AMS.AMS_CATEGORIES_TL does not reference any database object

AMS.AMS_CATEGORIES_TL is referenced by following:

AMS

VIEW - AMS_CATEGORIES_TL#

[top of page]

Table: AMS_CAT_ACTIVITIES

Primary Key: AMS_CAT_ACTIVITIES_PK

1. CAT_ACTIVITY_ID

Primary Key: AMS_CAT_ACTIVITIES_UK1

1. ACTIVITY_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CAT_ACTIVITIES does not reference any database object

AMS.AMS_CAT_ACTIVITIES is referenced by following:

AMS

VIEW - AMS_CAT_ACTIVITIES#

[top of page]

Table: AMS_CELLS_ALL_B

Primary Key: AMS_CELLS_ALL_B_PK

1. CELL_ID

Primary Key: AMS_CELLS_ALL_B_UK1

1. CELL_CODE

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CELLS_ALL_B does not reference any database object

AMS.AMS_CELLS_ALL_B is referenced by following:

AMS

VIEW - AMS_CELLS_ALL_B#

[top of page]

Table: AMS_CELLS_ALL_TL

Primary Key: AMS_CELLS_ALL_TL_PK

1. LANGUAGE
2. CELL_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CELLS_ALL_TL does not reference any database object

AMS.AMS_CELLS_ALL_TL is referenced by following:

AMS

VIEW - AMS_CELLS_ALL_TL#

[top of page]

Table: AMS_CHANNELS_B

Primary Key: AMS_CHANNELS_B_PK

1. CHANNEL_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CHANNELS_B does not reference any database object

AMS.AMS_CHANNELS_B is referenced by following:

AMS

VIEW - AMS_CHANNELS_B#

[top of page]

Table: AMS_CHANNELS_TL

Primary Key: AMS_CHANNELS_TL_PK

1. LANGUAGE
2. CHANNEL_ID

Primary Key: AMS_CHANNELS_TL_UK1

1. CHANNEL_NAME
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CHANNELS_TL does not reference any database object

AMS.AMS_CHANNELS_TL is referenced by following:

AMS

VIEW - AMS_CHANNELS_TL#

[top of page]

Table: AMS_CLIK_THRU_ACTIONS_B

Primary Key: AMS_CLIK_THRU_ACTIONS_B_PK

1. ACTION_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_CLIK_THRU_ACTIONS_B does not reference any database object

AMS.AMS_CLIK_THRU_ACTIONS_B is referenced by following:

AMS

VIEW - AMS_CLIK_THRU_ACTIONS_B#

[top of page]

Table: AMS_CLIK_THRU_ACTIONS_TL

Primary Key: AMS_CLIK_THRU_ACTIONS_TL_PK

1. ACTION_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CLIK_THRU_ACTIONS_TL does not reference any database object

AMS.AMS_CLIK_THRU_ACTIONS_TL is referenced by following:

AMS

VIEW - AMS_CLIK_THRU_ACTIONS_TL#

[top of page]

Table: AMS_CLIK_THRU_ACT_PARAMS_B

Primary Key: AMS_CLIK_THRU_ACT_PARAMS_B_PK

1. ACTION_PARAM_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_CLIK_THRU_ACT_PARAMS_B does not reference any database object

AMS.AMS_CLIK_THRU_ACT_PARAMS_B is referenced by following:

AMS

VIEW - AMS_CLIK_THRU_ACT_PARAMS_B#

[top of page]

Table: AMS_CLIK_THRU_ACT_PARAMS_TL

Primary Key: AMS_CLIK_THRU_ACT_PARAMS_TL_PK

1. ACTION_PARAM_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CLIK_THRU_ACT_PARAMS_TL does not reference any database object

AMS.AMS_CLIK_THRU_ACT_PARAMS_TL is referenced by following:

AMS

VIEW - AMS_CLIK_THRU_ACT_PARAMS_TL#

[top of page]

Table: AMS_CLIK_THRU_USAGES

Primary Key: ACE_PK

1. USAGE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CLIK_THRU_USAGES does not reference any database object

AMS.AMS_CLIK_THRU_USAGES is referenced by following:

AMS

VIEW - AMS_CLIK_THRU_USAGES#

[top of page]

Table: AMS_COLUMNS_METADATA

Primary Key: ACMD_UK

1. OBJECT_ATTRIBUTE
2. OBJECT_TYPE
3. ACTIVITY_TYPE_CODE
4. HTML_FORM_PARAM
5. APPLICATION_ID

Primary Key: AMS_COLUMNS_METADATA_PK

1. COLUMNS_METADATA_ID

[top of page]

AMS.AMS_COLUMNS_METADATA does not reference any database object

AMS.AMS_COLUMNS_METADATA is referenced by following:

AMS

VIEW - AMS_COLUMNS_METADATA#

[top of page]

Table: AMS_COLUMN_RULES

Primary Key: ACRS_UK

1. OBJECT_TYPE
2. OBJECT_ATTRIBUTE
3. ACTIVITY_TYPE_CODE
4. HTML_FORM_PARAM
5. APPLICATION_ID
6. RULE_TYPE
7. SYSTEM_STATUS_CODE

Primary Key: AMS_COLUMN_RULES_PK

1. COLUMN_RULE_ID

[top of page]

AMS.AMS_COLUMN_RULES does not reference any database object

AMS.AMS_COLUMN_RULES is referenced by following:

AMS

VIEW - AMS_COLUMN_RULES#

[top of page]

Table: AMS_COMPETITOR_PRODUCTS_B

Primary Key: AMS_COMPETITOR_PRODUCTS_B_PK

1. COMPETITOR_PRODUCT_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_COMPETITOR_PRODUCTS_B does not reference any database object

AMS.AMS_COMPETITOR_PRODUCTS_B is referenced by following:

AMS

VIEW - AMS_COMPETITOR_PRODUCTS_B#

[top of page]

Table: AMS_COMPETITOR_PRODUCTS_TL

Primary Key: AMS_COMPETITOR_PRODUCTS_TL_PK

1. COMPETITOR_PRODUCT_ID
2. LANGUAGE

[top of page]

AMS.AMS_COMPETITOR_PRODUCTS_TL does not reference any database object

AMS.AMS_COMPETITOR_PRODUCTS_TL is referenced by following:

AMS

VIEW - AMS_COMPETITOR_PRODUCTS_TL#

[top of page]

Table: AMS_COND_STRUCT_RESTRICT_VALUE

Primary Key: AMS_CONDITION_RESTRICT_PK

1. COND_STRUCT_RESTRICT_ID

[top of page]

AMS.AMS_COND_STRUCT_RESTRICT_VALUE does not reference any database object

AMS.AMS_COND_STRUCT_RESTRICT_VALUE is referenced by following:

AMS

VIEW - AMS_COND_STRUCT_RESTRICT_VALU#

[top of page]

Table: AMS_CONTENT_RULES_B

Primary Key: AMS_COTNENT_RULES_B_PK

1. CONTENT_RULE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CONTENT_RULES_B does not reference any database object

AMS.AMS_CONTENT_RULES_B is referenced by following:

AMS

VIEW - AMS_CONTENT_RULES_B#

[top of page]

Table: AMS_CONTENT_RULES_TL

Primary Key: AMS_CONTENT_RULES_TL_PK

1. LANGUAGE
2. CONTENT_RULE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CONTENT_RULES_TL does not reference any database object

AMS.AMS_CONTENT_RULES_TL is referenced by following:

AMS

VIEW - AMS_CONTENT_RULES_TL#

[top of page]

Table: AMS_CPAG_ANSWERS_B

Primary Key: AMS_CPAG_ANSWERS_B_PK

1. ANSWER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CPAG_ANSWERS_B does not reference any database object

AMS.AMS_CPAG_ANSWERS_B is referenced by following:

AMS

VIEW - AMS_CPAG_ANSWERS_B#

[top of page]

Table: AMS_CPAG_DLG_RESPONS_B

Primary Key: AMS_CPAG_DLG_RESPONS_B_PK

1. RESPONSE_ITEM_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CPAG_DLG_RESPONS_B does not reference any database object

AMS.AMS_CPAG_DLG_RESPONS_B is referenced by following:

AMS

VIEW - AMS_CPAG_DLG_RESPONS_B#

[top of page]

Table: AMS_CPAG_DLG_WGHT_TOTL

Primary Key: AMS_CPAG_DLG_WGHT_TOTL_PK

1. DIALOG_ID
2. DIALOG_RUN_ID
3. WEIGHT_DIMENSION_ID
4. DIALOG_RUN_STEP_ID

[top of page]

AMS.AMS_CPAG_DLG_WGHT_TOTL does not reference any database object

AMS.AMS_CPAG_DLG_WGHT_TOTL is referenced by following:

AMS

VIEW - AMS_CPAG_DLG_WGHT_TOTL#

[top of page]

Table: AMS_CPAG_QUERIES

Primary Key: AMS_CPAG_QUERIES_PK1

1. QUERY_ID

[top of page]

AMS.AMS_CPAG_QUERIES does not reference any database object

AMS.AMS_CPAG_QUERIES is referenced by following:

AMS

VIEW - AMS_CPAG_QUERIES#

[top of page]

Table: AMS_CPAG_QUERY_USAGES

Primary Key: AMS_CPAG_QUERY_USAGES_PK1

1. QUERY_USAGE_ID

[top of page]

AMS.AMS_CPAG_QUERY_USAGES does not reference any database object

AMS.AMS_CPAG_QUERY_USAGES is referenced by following:

AMS

VIEW - AMS_CPAG_QUERY_USAGES#

[top of page]

Table: AMS_CPAG_QUESTIONS_B

Primary Key: AMS_CPAG_QUESTIONS_B_PK

1. QUESTION_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_CPAG_QUESTIONS_B does not reference any database object

AMS.AMS_CPAG_QUESTIONS_B is referenced by following:

AMS

VIEW - AMS_CPAG_QUESTIONS_B#

[top of page]

Table: AMS_CTDS

Primary Key: AMS_CTDS_PK1

1. CTD_ID

[top of page]

AMS.AMS_CTDS does not reference any database object

AMS.AMS_CTDS is referenced by following:

AMS

VIEW - AMS_CTDS#

[top of page]

Table: AMS_CTD_ADHOC_PARAM_VALUES

Primary Key: AMS_CTD_ADHOC_PARAM_VALUES_PK1

1. ADHOC_PARAM_ID

[top of page]

AMS.AMS_CTD_ADHOC_PARAM_VALUES does not reference any database object

AMS.AMS_CTD_ADHOC_PARAM_VALUES is referenced by following:

AMS

VIEW - AMS_CTD_ADHOC_PARAM_VALUES#

[top of page]

Table: AMS_CTD_ASSOCIATIONS

Primary Key: AMS_CTD_ASSOCIATIONS_PK1

1. ASSOCIATION_ID

[top of page]

AMS.AMS_CTD_ASSOCIATIONS does not reference any database object

AMS.AMS_CTD_ASSOCIATIONS is referenced by following:

AMS

VIEW - AMS_CTD_ASSOCIATIONS#

[top of page]

Table: AMS_CTD_PARAM_VALUES

Primary Key: AMS_CTD_PARAM_VALUES_PK1

1. ACTION_PARAM_VALUE_ID

[top of page]

AMS.AMS_CTD_PARAM_VALUES does not reference any database object

AMS.AMS_CTD_PARAM_VALUES is referenced by following:

AMS

VIEW - AMS_CTD_PARAM_VALUES#

[top of page]

Table: AMS_CUSTOM_SETUPS_B

Primary Key: AMS_CUSTOM_SETUPS_B_PK

1. CUSTOM_SETUP_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_CUSTOM_SETUPS_B does not reference any database object

AMS.AMS_CUSTOM_SETUPS_B is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUPS_B#

[top of page]

Table: AMS_CUSTOM_SETUPS_BK

[top of page]

AMS.AMS_CUSTOM_SETUPS_BK does not reference any database object

AMS.AMS_CUSTOM_SETUPS_BK is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUPS_BK#

[top of page]

Table: AMS_CUSTOM_SETUPS_TL

Primary Key: AMS_CUSTOM_SETUPS_TL_PK

1. CUSTOM_SETUP_ID
2. LANGUAGE

Primary Key: AMS_CUSTOM_SETUPS_TL_UK

1. SETUP_NAME
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_CUSTOM_SETUPS_TL does not reference any database object

AMS.AMS_CUSTOM_SETUPS_TL is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUPS_TL#

[top of page]

Table: AMS_CUSTOM_SETUP_ATTR

Primary Key: AMS_CUSTOM_SETUP_ATTR_PK

1. SETUP_ATTRIBUTE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_CUSTOM_SETUP_ATTR does not reference any database object

AMS.AMS_CUSTOM_SETUP_ATTR is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUP_ATTR#

[top of page]

Table: AMS_CUSTOM_SETUP_ATTR_BK

[top of page]

AMS.AMS_CUSTOM_SETUP_ATTR_BK does not reference any database object

AMS.AMS_CUSTOM_SETUP_ATTR_BK is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUP_ATTR_BK#

[top of page]

Table: AMS_CUSTOM_SETUP_PURPOSE

Primary Key: AMS_CUSTOM_SETUP_PURPOSE_PK

1. SETUP_PURPOSE_ID

[top of page]

AMS.AMS_CUSTOM_SETUP_PURPOSE does not reference any database object

AMS.AMS_CUSTOM_SETUP_PURPOSE is referenced by following:

AMS

VIEW - AMS_CUSTOM_SETUP_PURPOSE#

[top of page]

Table: AMS_DELIVERABLES_ALL_B

Primary Key: AMS_DELIVERABLES_ALL_B_PK

1. DELIVERABLE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DELIVERABLES_ALL_B does not reference any database object

AMS.AMS_DELIVERABLES_ALL_B is referenced by following:

AMS

VIEW - AMS_DELIVERABLES_ALL_B#

[top of page]

Table: AMS_DELIVERABLES_ALL_TL

Primary Key: AMS_DELIVERABLES_ALL_TL_PK

1. DELIVERABLE_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_DELIVERABLES_ALL_TL does not reference any database object

AMS.AMS_DELIVERABLES_ALL_TL is referenced by following:

AMS

VIEW - AMS_DELIVERABLES_ALL_TL#

[top of page]

Table: AMS_DELIV_KIT_ITEMS

Primary Key: AMS_DELIV_KIT_ITEMS_PK

1. DELIVERABLE_KIT_ITEM_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DELIV_KIT_ITEMS does not reference any database object

AMS.AMS_DELIV_KIT_ITEMS is referenced by following:

AMS

VIEW - AMS_DELIV_KIT_ITEMS#

[top of page]

Table: AMS_DELIV_PRODUCTS

Primary Key: AMS_DELIV_PRODUCTS_PK

1. DELIVERABLE_PRODUCT_ID

Primary Key: AMS_DELIV_PRODUCTS_UK1

1. DELIVERABLE_ID
2. INVENTORY_ITEM_ID
3. INVENTORY_ITEM_ORG_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DELIV_PRODUCTS does not reference any database object

AMS.AMS_DELIV_PRODUCTS is referenced by following:

AMS

VIEW - AMS_DELIV_PRODUCTS#

[top of page]

Table: AMS_DIALOGS_ALL_B

Primary Key: AMS_DIALOGS_ALL_B_PK

1. DIALOG_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DIALOGS_ALL_B does not reference any database object

AMS.AMS_DIALOGS_ALL_B is referenced by following:

AMS

VIEW - AMS_DIALOGS_ALL_B#

[top of page]

Table: AMS_DISCOVERER_SQL

Primary Key: AMS_DISCOVERER_SQL_PK

1. DISCOVERER_SQL_ID

Primary Key: AMS_DISCOVERER_SQL_UK1

1. WORKBOOK_OWNER_NAME
2. WORKBOOK_NAME
3. WORKSHEET_NAME
4. SEQUENCE_ORDER

Foreign Keys to this table:

[top of page]

AMS.AMS_DISCOVERER_SQL does not reference any database object

AMS.AMS_DISCOVERER_SQL is referenced by following:

AMS

VIEW - AMS_DISCOVERER_SQL#

[top of page]

Table: AMS_DLG_COMP_TYPES_B

Primary Key: AMS_DLG_COMP_TYPES_B_PK

1. COMPONENT_TYPE_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_DLG_COMP_TYPES_B does not reference any database object

AMS.AMS_DLG_COMP_TYPES_B is referenced by following:

AMS

VIEW - AMS_DLG_COMP_TYPES_B#

[top of page]

Table: AMS_DLG_CONTEXT_FIELDS

Primary Key: AMS_DLG_CONTEXT_FIELDS_PK1

1. CONTEXT_FIELD_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DLG_CONTEXT_FIELDS does not reference any database object

AMS.AMS_DLG_CONTEXT_FIELDS is referenced by following:

AMS

VIEW - AMS_DLG_CONTEXT_FIELDS#

[top of page]

Table: AMS_DLG_CTX_FIELD_USES

Primary Key: AMS_DLG_FIELD_USES_PK1

1. CONTEXT_FIELD_ID
2. USED_BY_FLOW_COMP_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DLG_CTX_FIELD_USES does not reference any database object

AMS.AMS_DLG_CTX_FIELD_USES is referenced by following:

AMS

VIEW - AMS_DLG_CTX_FIELD_USES#

[top of page]

Table: AMS_DLG_FLOW_COMPS_B

Primary Key: AMS_DLG_FLOW_COMPS_B_PK

1. FLOW_COMPONENT_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DLG_FLOW_COMPS_B does not reference any database object

AMS.AMS_DLG_FLOW_COMPS_B is referenced by following:

AMS

VIEW - AMS_DLG_FLOW_COMPS_B#

[top of page]

Table: AMS_DLG_FLOW_COMP_REL

Primary Key: AMS_DLG_FLOW_COMP_REL_PK

1. FLOW_COMP_RELATIONSHIP_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DLG_FLOW_COMP_REL does not reference any database object

AMS.AMS_DLG_FLOW_COMP_REL is referenced by following:

AMS

VIEW - AMS_DLG_FLOW_COMP_REL#

[top of page]

Table: AMS_DLG_IDENTIFY_ITEMS

Primary Key: ITEM_ID

1. ITEM_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DLG_IDENTIFY_ITEMS does not reference any database object

AMS.AMS_DLG_IDENTIFY_ITEMS is referenced by following:

AMS

VIEW - AMS_DLG_IDENTIFY_ITEMS#

[top of page]

Table: AMS_DLG_IDENTIFY_RULES_B

Primary Key: AMS_DLG_IDENTIFY_RULES_B_PK1

1. RULE_ID

Foreign Keys to this table:

[top of page]

AMS.AMS_DLG_IDENTIFY_RULES_B does not reference any database object

AMS.AMS_DLG_IDENTIFY_RULES_B is referenced by following:

AMS

VIEW - AMS_DLG_IDENTIFY_RULES_B#

[top of page]

Table: AMS_DLG_INTERACTIONS

Primary Key: INTERACTION_ID

1. INTERACTION_ID

[top of page]

AMS.AMS_DLG_INTERACTIONS does not reference any database object

AMS.AMS_DLG_INTERACTIONS is referenced by following:

AMS

VIEW - AMS_DLG_INTERACTIONS#

[top of page]

Table: AMS_DLG_RUN_STEP_DETAILS

Primary Key: AMS_DLG_RUN_STEP_DETAILS_PK

1. RUN_STEP_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DLG_RUN_STEP_DETAILS does not reference any database object

AMS.AMS_DLG_RUN_STEP_DETAILS is referenced by following:

AMS

VIEW - AMS_DLG_RUN_STEP_DETAILS#

[top of page]

Table: AMS_DM_AGG_STG

Primary Key: AMS_DM_AGG_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_AGG_STG does not reference any database object

AMS.AMS_DM_AGG_STG is referenced by following:

AMS

VIEW - AMS_DM_AGG_STG#

[top of page]

Table: AMS_DM_APPLY_STG

Primary Key: AMS_DM_APPLY_STG_UK1

1. SOURCE_ID

[top of page]

AMS.AMS_DM_APPLY_STG does not reference any database object

AMS.AMS_DM_APPLY_STG is referenced by following:

AMS

VIEW - AMS_DM_APPLY_STG#

[top of page]

Table: AMS_DM_BIC_STG

Primary Key: AMS_DM_BIC_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_BIC_STG does not reference any database object

AMS.AMS_DM_BIC_STG is referenced by following:

AMS

VIEW - AMS_DM_BIC_STG#

[top of page]

Table: AMS_DM_BIN_VALUES

Primary Key: AMS_DM_BIN_VALUES_PK

1. BIN_VALUE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_BIN_VALUES does not reference any database object

AMS.AMS_DM_BIN_VALUES is referenced by following:

AMS

VIEW - AMS_DM_BIN_VALUES#

[top of page]

Table: AMS_DM_CATEGORICAL_BB

Primary Key: AMS_DM_CATEGORICAL_BB_PK

1. CATEGORICAL_BB_ID

[top of page]

AMS.AMS_DM_CATEGORICAL_BB does not reference any database object

AMS.AMS_DM_CATEGORICAL_BB is referenced by following:

AMS

VIEW - AMS_DM_CATEGORICAL_BB#

[top of page]

Table: AMS_DM_DRV_STG

Primary Key: AMS_DM_DRV_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_DRV_STG does not reference any database object

AMS.AMS_DM_DRV_STG is referenced by following:

AMS

VIEW - AMS_DM_DRV_STG#

[top of page]

Table: AMS_DM_FINNUM_STG

Primary Key: AMS_DM_FINNUM_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_FINNUM_STG does not reference any database object

AMS.AMS_DM_FINNUM_STG is referenced by following:

AMS

VIEW - AMS_DM_FINNUM_STG#

[top of page]

Table: AMS_DM_GEN_STG

Primary Key: AMS_DM_GEN_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_GEN_STG does not reference any database object

AMS.AMS_DM_GEN_STG is referenced by following:

AMS

VIEW - AMS_DM_GEN_STG#

[top of page]

Table: AMS_DM_IMP_ATTRIBUTES

Primary Key: AMS_DM_IMP_ATTRIBUTES_PK

1. IMP_ATTRIBUTE_ID

Primary Key: AMS_DM_IMP_ATTRIBUTES_UK1

1. MODEL_ID
2. SOURCE_FIELD_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_IMP_ATTRIBUTES does not reference any database object

AMS.AMS_DM_IMP_ATTRIBUTES is referenced by following:

AMS

VIEW - AMS_DM_IMP_ATTRIBUTES#

[top of page]

Table: AMS_DM_INTER_SOURCE_STG

[top of page]

AMS.AMS_DM_INTER_SOURCE_STG does not reference any database object

AMS.AMS_DM_INTER_SOURCE_STG is referenced by following:

AMS

VIEW - AMS_DM_INTER_SOURCE_STG#

[top of page]

Table: AMS_DM_LIFT

Primary Key: AMS_DM_LIFT_PK

1. LIFT_ID

Primary Key: AMS_DM_LIFT_UK1

1. MODEL_ID
2. QUANTILE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_LIFT does not reference any database object

AMS.AMS_DM_LIFT is referenced by following:

AMS

VIEW - AMS_DM_LIFT#

[top of page]

Table: AMS_DM_MODELS_ALL_B

Primary Key: AMS_DM_MODELS_ALL_B_PK

1. MODEL_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DM_MODELS_ALL_B does not reference any database object

AMS.AMS_DM_MODELS_ALL_B is referenced by following:

AMS

VIEW - AMS_DM_MODELS_ALL_B#

[top of page]

Table: AMS_DM_MODELS_ALL_TL

Primary Key: AMS_DM_MODELS_ALL_TL_PK

1. LANGUAGE
2. MODEL_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_MODELS_ALL_TL does not reference any database object

AMS.AMS_DM_MODELS_ALL_TL is referenced by following:

AMS

VIEW - AMS_DM_MODELS_ALL_TL#

[top of page]

Table: AMS_DM_NUMERICAL_BB

Primary Key: AMS_DM_NUMERICAL_BB_PK

1. NUMERICAL_BB_ID

[top of page]

AMS.AMS_DM_NUMERICAL_BB does not reference any database object

AMS.AMS_DM_NUMERICAL_BB is referenced by following:

AMS

VIEW - AMS_DM_NUMERICAL_BB#

[top of page]

Table: AMS_DM_OPT_TGT_METRICS

Primary Key: AMS_DM_OPT_TGT_METRICS_PK

1. OPT_TGT_METRIC_ID

Primary Key: AMS_DM_OPT_TGT_METRICS_UK1

1. SCORE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_OPT_TGT_METRICS does not reference any database object

AMS.AMS_DM_OPT_TGT_METRICS is referenced by following:

AMS

VIEW - AMS_DM_OPT_TGT_METRICS#

[top of page]

Table: AMS_DM_ORG_CONTACTS

[top of page]

AMS.AMS_DM_ORG_CONTACTS does not reference any database object

AMS.AMS_DM_ORG_CONTACTS is referenced by following:

AMS

VIEW - AMS_DM_ORG_CONTACTS#

[top of page]

Table: AMS_DM_PARTY_DETAILS

Primary Key: AMS_DM_PARTY_DETAILS_PK

1. PARTY_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DM_PARTY_DETAILS does not reference any database object

AMS.AMS_DM_PARTY_DETAILS is referenced by following:

AMS

VIEW - AMS_DM_PARTY_DETAILS#

[top of page]

Table: AMS_DM_PARTY_DETAILS_TIME

Primary Key: AMS_DM_PARTY_DETAILS_TIME_PK

1. PARTY_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_PARTY_DETAILS_TIME does not reference any database object

AMS.AMS_DM_PARTY_DETAILS_TIME is referenced by following:

AMS

VIEW - AMS_DM_PARTY_DETAILS_TIME#

[top of page]

Table: AMS_DM_PARTY_PROFILE_STG

Primary Key: AMS_DM_PARTY_PROFILE_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_PARTY_PROFILE_STG does not reference any database object

AMS.AMS_DM_PARTY_PROFILE_STG is referenced by following:

AMS

VIEW - AMS_DM_PARTY_PROFILE_STG#

[top of page]

Table: AMS_DM_PERFORMANCE

Primary Key: AMS_DM_PERFORMANCE_PK

1. PERFORMANCE_ID

Primary Key: AMS_DM_PERFORMANCE_UK1

1. MODEL_ID
2. PREDICTED_VALUE
3. ACTUAL_VALUE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_PERFORMANCE does not reference any database object

AMS.AMS_DM_PERFORMANCE is referenced by following:

AMS

VIEW - AMS_DM_PERFORMANCE#

[top of page]

Table: AMS_DM_PERINT_STG

Primary Key: AMS_DM_PERINT_STG_PK

1. PARTY_ID

[top of page]

AMS.AMS_DM_PERINT_STG does not reference any database object

AMS.AMS_DM_PERINT_STG is referenced by following:

AMS

VIEW - AMS_DM_PERINT_STG#

[top of page]

Table: AMS_DM_SCORES_ALL_B

Primary Key: AMS_DM_SCORES_ALL_B_PK

1. SCORE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DM_SCORES_ALL_B does not reference any database object

AMS.AMS_DM_SCORES_ALL_B is referenced by following:

AMS

VIEW - AMS_DM_SCORES_ALL_B#

[top of page]

Table: AMS_DM_SCORES_ALL_TL

Primary Key: AMS_DM_SCORES_ALL_TL_PK

1. LANGUAGE
2. SCORE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_SCORES_ALL_TL does not reference any database object

AMS.AMS_DM_SCORES_ALL_TL is referenced by following:

AMS

VIEW - AMS_DM_SCORES_ALL_TL#

[top of page]

Table: AMS_DM_SCORE_LISTS

Primary Key: AMS_DM_SCORE_LISTS_PK

1. SCORE_LIST_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_SCORE_LISTS does not reference any database object

AMS.AMS_DM_SCORE_LISTS is referenced by following:

AMS

VIEW - AMS_DM_SCORE_LISTS#

[top of page]

Table: AMS_DM_SCORE_PCT_RESULTS

Primary Key: AMS_DM_SCORE_PCT_RESULTS_PK

1. SCORE_RESULT_ID

Primary Key: AMS_DM_SCORE_PCT_RESULTS_UK1

1. SCORE_ID
2. PERCENTILE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_SCORE_PCT_RESULTS does not reference any database object

AMS.AMS_DM_SCORE_PCT_RESULTS is referenced by following:

AMS

VIEW - AMS_DM_SCORE_PCT_RESULTS#

[top of page]

Table: AMS_DM_SCORE_RESULTS

Primary Key: AMS_DM_SCORE_RESULTS_PK

1. SCORE_RESULT_ID

Primary Key: AMS_DM_SCORE_RESULTS_UK1

1. SCORE_ID
2. DECILE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_SCORE_RESULTS does not reference any database object

AMS.AMS_DM_SCORE_RESULTS is referenced by following:

AMS

VIEW - AMS_DM_SCORE_RESULTS#

[top of page]

Table: AMS_DM_SOURCE

Primary Key: AMS_DM_SOURCE_PK

1. SOURCE_ID

Primary Key: AMS_DM_SOURCE_UK1

1. ARC_USED_FOR_OBJECT
2. USED_FOR_OBJECT_ID
3. PARTY_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_SOURCE does not reference any database object

AMS.AMS_DM_SOURCE is referenced by following:

AMS

VIEW - AMS_DM_SOURCE#

[top of page]

Table: AMS_DM_TARGETS_B

Primary Key: AMS_DM_TARGETS_B_PK

1. TARGET_ID

Primary Key: AMS_DM_TARGETS_B_UK1

1. MODEL_TYPE
2. SOURCE_FIELD_ID
3. TARGET_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DM_TARGETS_B does not reference any database object

AMS.AMS_DM_TARGETS_B is referenced by following:

AMS

VIEW - AMS_DM_TARGETS_B#

[top of page]

Table: AMS_DM_TARGETS_TL

Primary Key: AMS_DM_TARGETS_TL_PK

1. TARGET_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_TARGETS_TL does not reference any database object

AMS.AMS_DM_TARGETS_TL is referenced by following:

AMS

VIEW - AMS_DM_TARGETS_TL#

[top of page]

Table: AMS_DM_TARGET_SOURCES

Primary Key: AMS_DM_TARGET_SOURCES_PK

1. TARGET_SOURCE_ID

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_TARGET_SOURCES does not reference any database object

AMS.AMS_DM_TARGET_SOURCES is referenced by following:

AMS

VIEW - AMS_DM_TARGET_SOURCES#

[top of page]

Table: AMS_DM_TARGET_STG

[top of page]

AMS.AMS_DM_TARGET_STG does not reference any database object

AMS.AMS_DM_TARGET_STG is referenced by following:

AMS

VIEW - AMS_DM_TARGET_STG#

[top of page]

Table: AMS_DM_TARGET_VALUES_B

Primary Key: AMS_DM_TARGET_VALUES_B_PK

1. TARGET_VALUE_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_DM_TARGET_VALUES_B does not reference any database object

AMS.AMS_DM_TARGET_VALUES_B is referenced by following:

AMS

VIEW - AMS_DM_TARGET_VALUES_B#

[top of page]

Table: AMS_DM_TARGET_VALUES_TL

Primary Key: AMS_DM_TARGET_VALUES_TL_PK

1. TARGET_VALUE_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_DM_TARGET_VALUES_TL does not reference any database object

AMS.AMS_DM_TARGET_VALUES_TL is referenced by following:

AMS

VIEW - AMS_DM_TARGET_VALUES_TL#

[top of page]

Table: AMS_DS_TCA_ENTITY

[top of page]

AMS.AMS_DS_TCA_ENTITY does not reference any database object

AMS.AMS_DS_TCA_ENTITY is referenced by following:

AMS

VIEW - AMS_DS_TCA_ENTITY#

[top of page]

Table: AMS_DS_TCA_ENTITY_COLS

[top of page]

AMS.AMS_DS_TCA_ENTITY_COLS does not reference any database object

AMS.AMS_DS_TCA_ENTITY_COLS is referenced by following:

AMS

VIEW - AMS_DS_TCA_ENTITY_COLS#

[top of page]

Table: AMS_DS_TCA_ENTITY_COLS_TL

[top of page]

AMS.AMS_DS_TCA_ENTITY_COLS_TL does not reference any database object

AMS.AMS_DS_TCA_ENTITY_COLS_TL is referenced by following:

AMS

VIEW - AMS_DS_TCA_ENTITY_COLS_TL#

[top of page]

Table: AMS_DS_TCA_ENTITY_TL

[top of page]

AMS.AMS_DS_TCA_ENTITY_TL does not reference any database object

AMS.AMS_DS_TCA_ENTITY_TL is referenced by following:

AMS

VIEW - AMS_DS_TCA_ENTITY_TL#

[top of page]

Table: AMS_EVENT_HEADERS_ALL_B

Primary Key: AMS_EVENT_HEADERS_ALL_B_PK

1. EVENT_HEADER_ID

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_EVENT_HEADERS_ALL_B does not reference any database object

AMS.AMS_EVENT_HEADERS_ALL_B is referenced by following:

AMS

VIEW - AMS_EVENT_HEADERS_ALL_B#

[top of page]

Table: AMS_EVENT_HEADERS_ALL_TL

Primary Key: AMS_EVENT_HEADERS_ALL_TL_PK

1. EVENT_HEADER_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_EVENT_HEADERS_ALL_TL does not reference any database object

AMS.AMS_EVENT_HEADERS_ALL_TL is referenced by following:

AMS

VIEW - AMS_EVENT_HEADERS_ALL_TL#

[top of page]

Table: AMS_EVENT_OFFERS_ALL_B

Primary Key: AMS_EVENT_OFFERS_ALL_B_PK

1. EVENT_OFFER_ID

Primary Key: AMS_EVENT_OFFERS_ALL_B_UK1

1. SOURCE_CODE

Foreign Keys from this table:

Foreign Keys to this table:

[top of page]

AMS.AMS_EVENT_OFFERS_ALL_B does not reference any database object

AMS.AMS_EVENT_OFFERS_ALL_B is referenced by following:

AMS

VIEW - AMS_EVENT_OFFERS_ALL_B#

[top of page]

Table: AMS_EVENT_OFFERS_ALL_TL

Primary Key: AMS_EVENT_OFFERS_ALL_TL_PK

1. EVENT_OFFER_ID
2. LANGUAGE

Foreign Keys from this table:

[top of page]

AMS.AMS_EVENT_OFFERS_ALL_TL does not reference any database object

AMS.AMS_EVENT_OFFERS_ALL_TL is referenced by following:

AMS

VIEW - AMS_EVENT_OFFERS_ALL_TL#

[top of page]

Table: AMS_EVENT_REGISTRATIONS

Primary Key: AMS_EVENT_REGISTRATIONS_PK

1. EVENT_REGISTRATION_ID

Foreign Keys from this table: