AMS | ORACLE APPS COMMUNITY

You are browsing the archive for AMS.

by oracleguru

Oracle Marketing Tables

ORACLE APPS COMMUNITY > Tutorial > AMS

Oracle Marketing module important tables

AML_BUSINESS_EVENT_TYPES_B
AML_BUSINESS_EVENT_TYPES_TL
AML_DATA_MIGRATION
AML_INTERACTION_LEADS
AML_MONITOR_CONDITIONS
AML_MONITOR_LOG
AML_RULE_APPLIED_ATTRS
AML_SALES_LEAD_TIMEFRAMES
AMS_ACT_ACCESS
AMS_ACT_ACCESS_DENORM
AMS_ACT_BUDGETS
AMS_ACT_CATEGORIES
AMS_ACT_CHANGE_REQ_ITEMS
AMS_ACT_COMMUNICATIONS
AMS_ACT_CONTACT_POINTS
AMS_ACT_DELIVERY_METHODS
AMS_ACT_DISCOVERER_ALL
AMS_ACT_FORECASTS_ALL
AMS_ACT_GEO_AREAS
AMS_ACT_LISTS
AMS_ACT_LIST_GROUPS
AMS_ACT_LOGS
AMS_ACT_MARKET_SEGMENTS
AMS_ACT_MESSAGES
AMS_ACT_METRICS_ALL
AMS_ACT_METRICS_ALL_DENORM
AMS_ACT_METRIC_FACTS_ALL
AMS_ACT_METRIC_FORMULAS
AMS_ACT_METRIC_FORM_ENT
AMS_ACT_METRIC_HST
AMS_ACT_OBJECTIVES
AMS_ACT_OBJ_METRICS
AMS_ACT_OFFERS
AMS_ACT_PARTNERS
AMS_ACT_PERSONS
AMS_ACT_PRODUCTS
AMS_ACT_PROGRAMS
AMS_ACT_QA_CHECKS
AMS_ACT_RESOURCES
AMS_ACT_SCRIPTS
AMS_ACT_SIZES
AMS_ACT_SKILLS
AMS_ACT_TYPE_TASK_TPLS
AMS_ACT_WEB_RULE_TYPES
AMS_ACT_WF_REQUESTS
AMS_ADI_CAMPAIGNS_INTERFACE
AMS_ADI_MEDIA_PLANNER
AMS_ADI_OBJECTS_EXPORT_LIST
AMS_AGENDAS_B
AMS_AGENDAS_TL
AMS_APPROVAL_DETAILS
AMS_APPROVAL_DETAILS_TL
AMS_APPROVAL_HISTORY
AMS_APPROVAL_RULES
AMS_APPROVERS
AMS_ATTACHMENT_PROPERTIES
AMS_ATTB_LOV_B
AMS_ATTB_LOV_TL
AMS_ATTB_LOV_VALUES_B
AMS_ATTB_LOV_VALUES_TL
AMS_BASE_SALES_VOL_ALL
AMS_CALENDAR_CRITERIA
AMS_CAMPAIGNS_ALL_B
AMS_CAMPAIGNS_ALL_TL
AMS_CAMPAIGN_RELATIONS
AMS_CAMPAIGN_SCHEDULES
AMS_CAMPAIGN_SCHEDULES_B
AMS_CAMPAIGN_SCHEDULES_TL
AMS_CATEGORIES_B
AMS_CATEGORIES_TL
AMS_CAT_ACTIVITIES
AMS_CELLS_ALL_B
AMS_CELLS_ALL_TL
AMS_CHANNELS_B
AMS_CHANNELS_TL
AMS_CLIK_THRU_ACTIONS_B
AMS_CLIK_THRU_ACTIONS_TL
AMS_CLIK_THRU_ACT_PARAMS_B
AMS_CLIK_THRU_ACT_PARAMS_TL
AMS_CLIK_THRU_USAGES
AMS_COLUMNS_METADATA
AMS_COLUMN_RULES
AMS_COMPETITOR_PRODUCTS_B
AMS_COMPETITOR_PRODUCTS_TL
AMS_COND_STRUCT_RESTRICT_VALUE
AMS_CONTENT_RULES_B
AMS_CONTENT_RULES_TL
AMS_CPAG_ANSWERS_B
AMS_CPAG_ANSWERS_TL
AMS_CPAG_DLG_RESPONS_B
AMS_CPAG_DLG_RESPONS_TL
AMS_CPAG_DLG_WGHT_TOTL
AMS_CPAG_QUERIES
AMS_CPAG_QUERY_USAGES
AMS_CPAG_QUESTIONS_B
AMS_CPAG_QUESTIONS_TL
AMS_CTDS
AMS_CTD_ADHOC_PARAM_VALUES
AMS_CTD_ASSOCIATIONS
AMS_CTD_PARAM_VALUES
AMS_CUSTOM_SETUPS_B
AMS_CUSTOM_SETUPS_BK
AMS_CUSTOM_SETUPS_TL
AMS_CUSTOM_SETUP_ATTR
AMS_CUSTOM_SETUP_ATTR_BK
AMS_CUSTOM_SETUP_PURPOSE
AMS_DELIVERABLES_ALL_B
AMS_DELIVERABLES_ALL_TL
AMS_DELIV_KIT_ITEMS
AMS_DELIV_PRODUCTS
AMS_DENORM_QUERIES
AMS_DIALOGS_ALL_B
AMS_DIALOGS_ALL_TL
AMS_DISCOVERER_SQL
AMS_DLG_BRANCHES_B
AMS_DLG_BRANCHES_TL
AMS_DLG_BRANCH_VALUES
AMS_DLG_COMP_TYPES_B
AMS_DLG_COMP_TYPES_TL
AMS_DLG_COMP_TYPE_OUTCOME_B
AMS_DLG_COMP_TYPE_OUTCOME_TL
AMS_DLG_COMP_TYPE_PARAMS_B
AMS_DLG_COMP_TYPE_PARAMS_TL
AMS_DLG_CONTEXT_FIELDS
AMS_DLG_CTX_FIELD_USES
AMS_DLG_FLOW_COMPS_B
AMS_DLG_FLOW_COMPS_TL
AMS_DLG_FLOW_COMP_PARAM_MAP
AMS_DLG_FLOW_COMP_REL
AMS_DLG_IDENTIFY_ITEMS
AMS_DLG_IDENTIFY_RULES_B
AMS_DLG_IDENTIFY_RULES_TL
AMS_DLG_INTERACTIONS
AMS_DLG_REGISTERED_INTERESTS
AMS_DLG_RUN_CONTEXTS
AMS_DLG_RUN_STEP_DETAILS
AMS_DLG_URL_PARAMS_B
AMS_DLG_URL_PARAMS_TL
AMS_DLG_URL_PARAM_ASSOCIATIONS
AMS_DM_AGG_STG
AMS_DM_APPLY_STG
AMS_DM_BIC_STG
AMS_DM_BIN_VALUES
AMS_DM_CATEGORICAL_BB
AMS_DM_DRV_STG
AMS_DM_FINNUM_STG
AMS_DM_GEN_STG
AMS_DM_IMP_ATTRIBUTES
AMS_DM_INTER_SOURCE_STG
AMS_DM_LIFT
AMS_DM_MODELS_ALL_B
AMS_DM_MODELS_ALL_TL
AMS_DM_NUMERICAL_BB
AMS_DM_OPT_TGT_METRICS
AMS_DM_ORG_CONTACTS
AMS_DM_PARTY_DETAILS
AMS_DM_PARTY_DETAILS_TIME
AMS_DM_PARTY_PROFILE_STG
AMS_DM_PERFORMANCE
AMS_DM_PERINT_STG
AMS_DM_SCORES_ALL_B
AMS_DM_SCORES_ALL_TL
AMS_DM_SCORE_LISTS
AMS_DM_SCORE_PCT_RESULTS
AMS_DM_SCORE_RESULTS
AMS_DM_SOURCE
AMS_DM_TARGETS_B
AMS_DM_TARGETS_TL
AMS_DM_TARGET_SOURCES
AMS_DM_TARGET_STG
AMS_DM_TARGET_VALUES_B
AMS_DM_TARGET_VALUES_TL
AMS_DS_TCA_ENTITY
AMS_DS_TCA_ENTITY_COLS
AMS_DS_TCA_ENTITY_COLS_TL
AMS_DS_TCA_ENTITY_TL
AMS_EVENT_HEADERS_ALL_B
AMS_EVENT_HEADERS_ALL_TL
AMS_EVENT_OFFERS_ALL_B
AMS_EVENT_OFFERS_ALL_TL
AMS_EVENT_REGISTRATIONS
AMS_EXP_LIST_HEADERS_ALL
AMS_EXP_LIST_HEADERS_ALL_TL
AMS_EXP_MODIFIED_TEMPLATE
AMS_EXP_TEMPLATE
AMS_FORECAST_CUSTOMERS
AMS_FORECAST_DIMENTIONS
AMS_FORECAST_PERIODS
AMS_FORECAST_PRODUCTS
AMS_FORECAST_PROD_EXCLUSIONS
AMS_GENERATED_CODES
AMS_HIERARCHIES_ALL_B
AMS_HIERARCHIES_ALL_TL
AMS_IBA_CAMPAIGN_RULES
AMS_IBA_CAMP_POSTINGS
AMS_IBA_CPN_ITEMS_DENORM
AMS_IBA_DISPLAY_RULES
AMS_IBA_MS_ITEMS_DENORM
AMS_IBA_OP_PROMPT_B
AMS_IBA_OP_PROMPT_TL
AMS_IBA_OP_RECO_SETTING
AMS_IBA_OP_RE_SETUP
AMS_IBA_OP_SETUP
AMS_IBA_PAGE_LOCATION
AMS_IBA_PL_PAGES_B
AMS_IBA_PL_PAGES_TL
AMS_IBA_PL_PARAMETERS_B
AMS_IBA_PL_PARAMETERS_TL
AMS_IBA_PL_PARAM_VALS
AMS_IBA_PL_PG_PARAMS
AMS_IBA_PL_PLACEMENTS_B
AMS_IBA_PL_PLACEMENTS_TL
AMS_IBA_PL_SITES_B
AMS_IBA_PL_SITES_TL
AMS_IBA_PL_STYLESHTS_B
AMS_IBA_PL_STYLESHTS_TL
AMS_IBA_POSTINGS_B
AMS_IBA_POSTINGS_TL
AMS_IBA_POST_SUM_ALL
AMS_IBA_PS_CNDCLSES_B
AMS_IBA_PS_CNDCLSES_TL
AMS_IBA_PS_FILTERS_B
AMS_IBA_PS_FILTERS_TL
AMS_IBA_PS_POSTINGS_B
AMS_IBA_PS_POSTINGS_TL
AMS_IBA_PS_RL_ST_FLTRS
AMS_IBA_PS_RL_ST_PARAMS
AMS_IBA_PS_RULEGRPS_B
AMS_IBA_PS_RULEGRPS_TL
AMS_IBA_PS_RULES
AMS_IBA_PS_STRATS_B
AMS_IBA_PS_STRATS_TL
AMS_IBA_TRACKING_ALL
AMS_IMP_COL_MAPPING
AMS_IMP_CONFIG_COMPONENTS
AMS_IMP_CONFIG_IMPORT_TYPES
AMS_IMP_DEFAULT_MAPPING
AMS_IMP_DOCUMENTS
AMS_IMP_DOC_CONTENT
AMS_IMP_LIST_HEADERS_ALL
AMS_IMP_LIST_HEADERS_ALL_TL
AMS_IMP_LIST_IMPORT_TYPES
AMS_IMP_SOURCE_LINES
AMS_IMP_XML_ATTRIBUTES
AMS_IMP_XML_ELEMENTS
AMS_INTL_DATES
AMS_ITEM_ATTRIBUTES
AMS_LIST_CONT_RESTRICTIONS
AMS_LIST_DELETE_TMP_ENTRIES
AMS_LIST_ENTRIES
AMS_LIST_ENTRY_USAGES
AMS_LIST_FIELDS_B
AMS_LIST_FIELDS_TL
AMS_LIST_HEADERS_ALL
AMS_LIST_HEADERS_ALL_TL
AMS_LIST_IMPORT_ERRORS
AMS_LIST_QUERIES_ALL
AMS_LIST_QUERIES_PARAM
AMS_LIST_QUERIES_PARAM_TL
AMS_LIST_QUERIES_TL
AMS_LIST_RULES_ALL
AMS_LIST_RULES_ALL_TL
AMS_LIST_RULE_FIELDS
AMS_LIST_RULE_USAGES
AMS_LIST_SELECT_ACTIONS
AMS_LIST_SRC_FIELDS
AMS_LIST_SRC_FIELDS_TL
AMS_LIST_SRC_TYPES
AMS_LIST_SRC_TYPES_TL
AMS_LIST_SRC_TYPE_ASSOCS
AMS_LIST_SRC_TYPE_USAGES
AMS_LIST_TMP_ENTRIES
AMS_LIST_WORD_FIELDS
AMS_LIST_WORD_REPLACES
AMS_MEDIA_B
AMS_MEDIA_CHANNELS
AMS_MEDIA_TL
AMS_MESSAGES_B
AMS_MESSAGES_TL
AMS_METRICS_ALL_B
AMS_METRICS_ALL_TL
AMS_METRIC_ACCRUALS
AMS_METRIC_FORMULAS
AMS_MET_SCENARIOS
AMS_MET_TPL_ASSOCS
AMS_MET_TPL_DETAILS
AMS_MET_TPL_HEADERS
AMS_MET_TPL_HEADERS_B
AMS_MET_TPL_HEADERS_TL
AMS_MISC_COST_DIS_ALL_B
AMS_MISC_COST_DIS_ALL_TL
AMS_MTL_CATEGORIES_DENORM_B
AMS_MTL_CATEGORIES_DENORM_TL
AMS_OBJECT_ASSOCIATIONS
AMS_OBJECT_ATTRIBUTES
AMS_OBJECT_RULES_B
AMS_OBJECT_RULES_TL
AMS_OFFERS
AMS_OFFER_ADJUSTMENTS_B
AMS_OFFER_ADJUSTMENTS_TL
AMS_OFFER_ADJUSTMENT_LINES
AMS_OFFER_ADJUSTMENT_TIERS
AMS_OFFER_PARTIES
AMS_OFFER_PARTIES_TEMP
AMS_OFFER_PERFORMANCES
AMS_OFFER_PRODUCTS
AMS_OFFER_PRODUCTS_TEMP
AMS_PARTY_DEDUPE
AMS_PARTY_MARKET_SEGMENTS
AMS_PARTY_SOURCES
AMS_PORTAL_CACHE
AMS_PRETTY_URL
AMS_PRETTY_URL_ASSOC
AMS_PRICE_LIST_ATTRIBUTES
AMS_PROD_TEMPLATES_B
AMS_PROD_TEMPLATES_TL
AMS_PROD_TEMPLATE_ATTR
AMS_PROGRAMS_ALL_B
AMS_PROGRAMS_ALL_TL
AMS_QUERY_ALIAS
AMS_QUERY_CONDITION
AMS_QUERY_CONDITION_VALUE
AMS_QUERY_COND_DISP_STRUCT_ALL
AMS_QUERY_COND_DISP_STRUCT_TL
AMS_QUERY_TEMPLATE_ALL
AMS_QUERY_TEMPLATE_INSTANCE
AMS_QUERY_TEMPLATE_TL
AMS_QUERY_TEMP_INST_COND_ASSOC
AMS_QUERY_TEMP_PURPOSE_ASSOC
AMS_RELATED_DEAL_LINES
AMS_REP_HISTORY
AMS_REQUEST_HISTORY
AMS_RULE_MEDIA_ASSOC
AMS_R_CAMP_DAILY_FACTS
AMS_R_CAMP_WEEKLY_FACTS
AMS_R_EVEN_DAILY_FACTS
AMS_R_EVEN_WEEKLY_FACTS
AMS_R_FDSP_DAILY_FACTS
AMS_R_FDSP_WEEKLY_FACTS
AMS_R_FUND_DAILY_FACTS
AMS_R_FUND_WEEKLY_FACTS
AMS_SCHEDULER
AMS_SEARCH_IDS
AMS_SETUP_TYPES
AMS_SOURCE_CODES
AMS_STATUS_ORDER_RULES
AMS_SYSTEM_PRETTY_URL
AMS_TCOP_CHANNEL_SUMMARY
AMS_TCOP_CHANNEL_SUM_DTL
AMS_TCOP_CONTACTS
AMS_TCOP_CONTACT_SUMMARY
AMS_TCOP_CONTACT_SUM_DTL
AMS_TCOP_FATIGUED_BY
AMS_TCOP_FR_PERIODS_B
AMS_TCOP_FR_PERIODS_TL
AMS_TCOP_FR_RULES_SETUP
AMS_TCOP_PRVW_CONTACTS
AMS_TCOP_PRVW_FATIGUE
AMS_TCOP_PRVW_FTG_BY
AMS_TCOP_PRVW_FTG_DTLS
AMS_TCOP_PRVW_REQUESTS
AMS_TCOP_REQUESTS
AMS_TEMPL_RESPONSIBILITY
AMS_TEMP_MAPPING
AMS_TEMP_MAPPING_SEQ
AMS_TERR_LEVELS_ALL
AMS_TRIGGERS
AMS_TRIGGERS_TL
AMS_TRIGGER_ACTIONS
AMS_TRIGGER_CHECKS
AMS_TRIGGER_RESULTS
AMS_UPGRADE
AMS_UPGRADE_ENTRIES
AMS_UPGRADE_TRACK_ERROR
AMS_USER_STATUSES_B
AMS_USER_STATUSES_TL
AMS_VENUES_B
AMS_VENUES_TL
AMS_VENUE_RATES_B
AMS_VENUE_RATES_TL
AMS_VOLUME_OFFER_TIERS
AMS_WEB_PLACEMENTS_B
AMS_WEB_PLACEMENTS_TL
AMS_WEB_PLCE_CITEM_ASSOC
AMS_WEB_PLCE_CTYPE_ASSOC
AMS_WEB_PLCE_MP_B
AMS_WEB_PLCE_MP_TL
AMS_WEB_RECOMMS
AMS_WEB_RULES_B
AMS_WEB_RULES_TL
AMS_WEB_TRACKING

Tags: AML, AMS, Marketing No Comments »

by oracleguru

Marketing Profile Options

ORACLE APPS COMMUNITY > Tutorial > AMS

Oracle Marketing Profile Options:

PROFILE OPTION SHORT CODE	PROFILE OPTION NAME
AMS_DEFAULT_CUST_VIEW	AMS : Default_Cust_View
AMS_ENCRYPTION_KEY	AMS : Encryption Key
AMS_CLAIM_WRITE_OFF_THRESHOLD	AMS : Claim Write Off Threshold
AMS_CLAIM_CREDIT_METHOD_RULE	AMS : AR Credit Method For Rule
AMS_CAMPAIGN_DISPLAY_VERSION	AMS : Campaign Display Version
AMS_CAMPAIGN_DEFAULT_CALENDER	AMS : Marketing Calendar
AMS_SRCGEN_DATE_PATTERN	AMS : Source code Date format
AMS_SRCGEN_SEQUENCE_LENGTH	AMS : Source Code sequence length
AMS_DEFAULT_CURR_CODE	AMS : Default Currency Code
AMS_SYSTEM_TIMEZONE_ID	AMS : System Timezone
AMS_SRCGEN_USER_CITY	AMS : User Country
AMS_UOM_TIME	AMS : Uom Time
AMS_UOM_LENGTH	AMS : Uom Length
AMS_UOM_QUANTITY	AMS : Uom Quantity
AMS_UOM_AREA	AMS : Uom Area
AMS_USER_TIMEZONE_ID	AMS : User Timezone
AMS_PRICELIST_HEADER_NAME	AMS : Pricelist Header Name for Events
AMS_USER_DEFAULT_TEAM	AMS : Default Team For User
AMS_DEFAULT_TIMEOUT	AMS : Default time out used for tasks
AMS_APPROVAL_CUTOFF_PERCENT	AMS : Cut off percentage for Approvals
AMS_PROFILE_SEARCH_SET_SIZE	AMS : AMS_PROFILE_SEARCH_SET_SIZE
AMS_INV_API_CALLOUT	AMS : Should Call to Inventory Modules be Made?
AMS_DEFAULT_TASK_RULE	AMS : Default task rule
AMS_LOWEST_NOTFICATION_LEVEL	AMS : Lowest importance level for task notifications
AMS_QP_PRICING_CALLOUT	AMS : Should Call to Pricing Modules be Made
AMS_ADMIN_GROUP	AMS : Admin Group
AMS_METR_SEEDED_CALC_EXP	AMS : Metric Seeded Calculation Expiration in Days
AMS_METR_INFERRED_PERIOD	AMS : Inferred Metric Active Period in Days
AMS_NUM_CSCH_REPORT	AMS: Number of Activities in Repeating Activities Report
AMS_MONITOR_DEBUG_INTERVAL	AMS: Debug Interval for Monitors and Repeating Schedules
AMS_CAMPAIGNS_RECENT_DATERANGE	AMS: Campaigns Recent Date Range
AMS_ACTIVITIES_RECENT_DATERANGE	AMS: Activities Recent Date Range
AMS_TIME_FORMAT	AMS : TIME FORMAT
AMS_OVERVIEW_RECORDS	AMS : Overview Records
AMS_NUMERIC_FORMAT	AMS : Numeric Format
AMS_DATA_ENTRY_ROWS	AMS : Data Entry Rows
AMS_DATE_FORMAT	AMS : DATE FORMAT
AMS_IMP_CTL_PATH	AMS : Import Control File Path
AMS_IMP_DATA_PATH	AMS : Import Data File Path
AMS_IMP_DEDUPE_RULES	AMS : Import Interface Dedupe Rules
AMS_CALL_CENTER_ENABLED	AMS : Call Center Enabled
AMS_HZ_DEDUPE_RULE	AMS : HZ Dedupe Rule
AMS_CONF_CODE_PREFIX	AMS : Prefix to Registration Confirmation Code
AMS_AUTO_REGISTER_FLAG	AMS : Auto Register for Events upon Cancellation
AMS_ITEM_ORGANIZATION_ID	AMS : Item Validation Master Organization
AMS_CURR_CONVERSION_TYPE	AMS : Currency Conversion Type
AMS_COPY_EVH_TO_EVO	AMS : COPY EVENT DETAILS TO EVENT SCHEDULES
AMS_THEME_APPROVAL	AMS : Theme Approval Enabled
AMS_NUM_BIN_ITEMS	AMS : Number of Items in Bin
AMS_STOCK_SYMBOLS	AMS : Stock Symbols
AMS_NEWS_PER_COMPANY	AMS : News Items per Company
AMS_OA_MEDIA_PATH	AMS : OA_MEDIA Path
AMS_ROOT_SECTION	AMS : Root Section for Price List Report
AMS_PRICING_PHASE_LINE	AMS : Default phase for Line level discounts
AMS_BUDGET_ADJ_ALLOW_RECAL	AMS : Allow Recalculation of Committed Budget
AMS_SOURCE_FROM_PARENT	AMS : Source From Parent Object
AMS_ODM_DBLINK	AMS : Marketing to ODM Database Link
AMS_ODM_OUTPUT_SCHEMA	AMS : Data Mining Engine Output Schema
AMS_ALLOW_QP_PRICE_LIST_UPDATES	AMS : Allow updates to Price Lists created in Advanced Pricing from Oracle Marketing Online
AMS_POST_RUNTIME_UTIL_CLASS	AMS : Posting Runtime Util Class
AMS_DEFAULT_PARTNER_BUDGET	AMS : Default Partner Budget
AMS_ACR_BUDGET_DEFAULT_CAMP_SETUP_TYPE	AMS: Default Campaign Custom Setup Type for Fully Accrued budgets
AMS_CLAIM_AR_BATCH_SOURCE	AMS : Default Transaction (Receivables) Batch Source
AMS_UPGRADE_RUN_FLAG	AMS : Upgrade Complete Flag
AMS_POST_RUNTIME_SHCRT_CURRENCY	AMS : Posting Runtime Shopping Cart Currency
AMS_ENABLE_TIP_TEXT	AMS : Enable Tip Text
AMS_EMAIL_FTR_BANNER	AMS : Email Footer Banner
AMS_BUDGET_ADJ_GRACE_PERIOD	AMS : Budget Adjustment Grace Period in Days
AMS_LIST_WB_B2C_PREFIX	AMS : List Workbook B2C Prefix
AMS_LIST_WB_B2B_PREFIX	AMS : List Workbook B2B Marketing
AMS_CUSTOM_CONDITION_CLASS	AMS : Custom Condition Class
AMS_MERCHANT_PARTY_ID	AMS : Merchant Party ID
AMS_ALLOW_INVENTORY_UPDATE	AMS : Inventory Item Update Allowed
AMS_PRICING_PHASE_ORDER	AMS : Default phase for Order level discounts
AMS_EMAIL_HDR_BANNER	AMS : Email Header Banner
AMS_OFFER_FORMULA	AMS : Default Offer Formula
AMS_COMM_BUDGET_EXCEED	AMS : Allow committed budget to exceed total budget
AMS_DEFAULT_PRODUCT_STYLESHEET	AMS : Default Product Stylesheet
AMS_SERVER_URL	AMS : Server URL
AMS_PRINT_ON_INVOICE	AMS : Default value for print on invoice flag
AMS_PRICING_GROUP_SEQUENCE	AMS : Default Bucket for discount rules
AMS_DEFAULT_SCHEDULE_STYLESHEET	AMS : Default Schedule Stylesheet
AMS_DEFAULT_OFFER_STYLESHEET	AMS : Default Offer Stylesheet
AMS_PRODUCT_PRECEDENCE	AMS : Default value for product precedence
AMS_PRICING_PHASE_LINEGROUP	AMS : Default phase for Line Group level discounts
AMS_SHOW_DATE_QUALIFIER	AMS : Choose Date Qualifier Regions
AMS_DEFAULT_HOME_PAGE	AMS : Default Home Page
AMS_VALIDATION_LEVEL	AMS : Validation Level
AMS_IMPLEMENT_AP_INTEGRATIONS	AMS : Implement Payables Integrations
AMS_CLAIM_CREDIT_METHOD_INSTALLMENT	AMS : AR Credit Method For Installment
IEU_QOR_MARKETING_LISTS_-_MANUAL_ASSIGNMENTS	AMS : Queue Order : Marketing Lists – Manual Assignments
AMS_CLAIM_UPDATE_ACCESS	AMS : Claim Update Access
AMS_CLAIM_UR_SHIPTO	AMS : Allow Un-Related ShipTo On Claims
AMS_CONF_URL	AMS : Confirmation Url
AMS_IMPLEMENT_CONTRA_CHARGE	AMS : Implement Contra Charge payment method
AMS_UNIV_CURR_CODE	AMS : Universal Currency for Budget Rollup View
AMS_FORECAST_DEFAULT_UOM	AMS : Default Forecast UOM
AMS_WEBCACHE_ENABLED	AMS : WebCache Enabled
AMS_ORDER_TYPE	AMS : Default Collateral Order Type
AMS_AUTO_APPROVAL_AMOUNT	AMS : Automatic Approval Amount
AMS_DIALOG_SERVER_URL	AMS : Dialog Server URL
AMS_IMP_CLIENT_FILE_SIZE	AMS : Import Client File Size
IEU_QEN_MARKETING_LISTS_-_MANUAL_ASSIGNMENTS	AMS : Queue : Marketing Lists – Manual Assignments
AMS_CHECK_MKTG_PROD_ELIG	AMS : Validate market and product eligibility between object and budget
AMS_DEFAULT_EXCH_CURR_DATE	AMS : Currency Conversion Date for Budget Rollup View.
AMS_DEFAULT_OFFER_TEAM	AMS : Default Team for Offers
AMS_FULFILL_ENABLE_FLAG	AMS : Enable Fulfillment
AMS_IMPLEMENT_GL_INTEGRATIONS	AMS : Show GL Accounts On Screen
AMS_IMPLEMENT_ASSIGNMENT_MANAGER	AMS : Implement Assignment Manager for Claims
AMS_DEFAULT_TASK_STATUS_ID	AMS : Default Task Status for creating Task Templates
AMS_THRDPTY_PRCDIFF_BUDGET	AMS : Price Difference Budget
AMS_OFFR_CONFIDENTIAL_FLAG	AMS : Offer Confidential Flag
AMS_CLAIM_USE_OM_AUTOMATION	AMS : Automate RMA Settlement
AMS_BATCH_SIZE	AMS : Batch Size
AMS_IFRAME_URL_SETTING	AMS : Iframe Image Url Setting
AMS_CLAIM_SCAN_ADJUST_WORKFLOW	AMS : Invoke Workflow for Manual Scan Data Adjustment
AMS_SIDE_NAV_LOOK	AMS : Side Navigation look
AMS_ODM_ENGINE_DEBUG	AMS : Data Mining ODM Debug Enabled
AMS_OFFR_DFLT_ACTIVITY	AMS : Default Offer Activity
AMS_DEFAULT_AMOUNT_FORMULA	AMS : Default Amount Formula
AMS_LOG_INTERACTION	AMS : Interaction Logging Enabled
AMS_CLAIM_USE_AR_AUTOMATION	AMS : Automate Deduction/Overpayment Settlement
AMS_OFFR_OVERRIDE_FLAG	AMS : Offer Override Flag in QP
AMS_STORE_DATE_IN_QUALIFIERS	AMS : Store Date in Qualifiers
AMS_SCANDATA_DEFAULT_UOM	AMS : Scan Data UOM
AMS_HAS_GRACE_PERIOD	AMS : Budget has Grace Period
AMS_CLAIM_SETL_ACCT_BG	AMS : Derive Accrual Account during Claims Settlement
AMS_CLAIM_PRICE_LIST_ID	AMS : RMA Default Price List
AMS_OFFR_DISC_LEVEL	AMS : Offer Discount Level
AMS_DEFAULT_PERCENT_FORMULA	AMS : Default Percent Formula
AMS_HIDE_EDIT_METRICS	AMS : Hide Edit Metrics
AMS_DM_ODM_PROP_FILE	AMS : Data Mining Engine Property File
AMS_INCOMPATIBILITY_GROUP	AMS : Default value for incompatibility group
AMS_BUDGET_ADJ_RECAL_PERIOD	AMS : Default Period In Days for recalculating committed budget
AMS_OP_ENABLED	AMS : Oracle Personalization Enabled
AMS_MIN_SEARCH_QUERY_CHAR	AMS : Minimum number of characters required to search
AMS_CLAIM_DEFAULT_OWNER	AMS : Default Owner assigned to Claim
AMS_DEFAULT_OWNER_BUDGET	AMS : Default Budget For a Person
AMS_UPGRADE_IMRKTNG	AMS : Upgrade iMarketing
AMS_PARTY_RELATIONS_TYPE	AMS : Relationship Type for Buying Group
AMS_CAMPAIGNS_START_DATERANGE	AMS: Campaigns Start Date Range
AMS_ACTIVITIES_START_DATERANGE	AMS: Activities Start Date Range
AMS_CURRENT_MONITOR_DEFN	AMS: Current monitor definition
AMS_ADI_BATCH_SIZE	AMS: Batch Size For ADI Bulk Fetch
AMS_LIST_QT_SAMPLE_PCT	AMS: Sampling percentage for list recalculation
AMS_LIST_QT_SAMPLE_SIZE	AMS: Master datasource record size to trigger sampling for list recalculation
AMS_ENABLE_RECALC_AND_PREVIEW	AMS: Enable List Recalculation
AMS_ROW_NUM_QUERY_TEMP_LOV	AMS: Number of rows to retrieve for Query Template LOVs
AMS_ENABLE_LIST_SPLIT_PREVIEW	AMS: List Size Threshold
AMS_ORDER_LOOK_BACK_PRD_DAYS	AMS: Orders look back period for Query Template Processing (Days)
AMS_ADI_MAX_ERRORS_PER_ROW	AMS: Max Error Messages to show in each Spreadsheet Row
AMS_ALLOW_ACTUAL_UPDATE	AMS : Allow Update of Actuals Before Active.
AMS_DM_OPTTGT_FIXED_COST	AMS: Default Fixed Cost for Optimal Targeting
AMS_DM_OPTTGT_VAR_COST	AMS: Default Cost per Contact for Optimal Targeting
AMS_DM_OPTTGT_ORDER_MARGIN	AMS: Default Margin per Order for Optimal Targeting
AMS_DM_OPTTGT_CONV_PCT	AMS: Default Conversion to Order Percentage for Optimal Targeting
AMS_PRICING_SIMULATION_EVENT	AMS: Event for Pricing Simulation
AMS_OP_NO_OF_RECO	AMS : No Of Recommendations from OP
AMS_DEFAULT_AUTOPAY_METHOD	AMS : Default Autopay Method
AMS_DEFAULT_AUTOPAY_DAYS	AMS : Default Autopay Days
AMS_OP_CACHE_SIZE	AMS: Oracle Personalization Cache Size
AMS_OP_REFRESH_INTERVAL	AMS: Oracle Personalization Refresh Interval
AMS_DEFAULT_DATA_SOURCE	AMS : Default Data Source
AMS_ODM_TO_APPS_DBLINK	AMS : ODM to Marketing Database Link
AMS_DM_USE_DBLINK	AMS : Data Mining Across Database Link
AMS_ODM_JDBC_URL	AMS : Data Mining Server JDBC URL
AMS_DEFAULT_CAMPAIGN_HIERARCHY_RANGE	AMS: Default Campaign Hierarchy Time Range
AMS_MY_RECENT_OBJECTS_TIME_RANGE	AMS: My Recent Objects Time Range

Tags: AMS No Comments »

by oracleguru

Views in Marketing module

ORACLE APPS COMMUNITY > Tutorial > AMS

Views in Oracle Marketing module

AMS_ACCT_INTEREST_V

AMS_ACT_ATTACHMENTS_V

AMS_ACT_CAMPAIGNS_V

AMS_ACT_DELIVERABLES_V

AMS_ACT_DELIVERY_METHODS_V

AMS_ACT_GEO_AREAS_V

AMS_ACT_METRIC_FACTS_ALL_V

AMS_ACT_METRIC_FORMULAS_V

AMS_ACT_MKT_SEGMENTS_VL

AMS_ACT_PRODUCTS_V

AMS_ACT_RESOURCES_V

AMS_AGENDAS_V

AMS_APPROVAL_DETAILS_V

AMS_APPROVAL_DETAILS_VL

AMS_ASO_CAMPAIGN_OFFERS_V

AMS_ATTB_LOV_VALUES_VL

AMS_ATTB_LOV_VL

AMS_CAMPAIGN_FORECASTS_ALL_V

AMS_CAMPAIGN_PRODUCT_VOLUMES_V

AMS_CAMPAIGN_PRODUCTS_V

AMS_CAMPAIGN_SCHEDULES_B_DFV

AMS_CAMPAIGN_SCHEDULES_B1_DFV

AMS_CAMPAIGN_SCHEDULES_VL

AMS_CAMPAIGN_TEAM_V

AMS_CAMPAIGNS_ALL_B_DFV

AMS_CAMPAIGNS_ALL_B1_DFV

AMS_CAMPAIGNS_V

AMS_CAMPAIGNS_VL

AMS_CATEGORIES_V

AMS_CATEGORIES_VL

AMS_CELLS_SEL_ALL_V

AMS_CELLS_VL

AMS_CHANNELS_V

AMS_CHANNELS_VL

AMS_CLIK_THRU_ACT_PARAMS_VL

AMS_CLIK_THRU_ACTIONS_VL

AMS_COMPETITOR_PRODUCTS_VL

AMS_CONTACT_PRODUCTS_V

AMS_CONTACT_RESTRICTIONS_V

AMS_CONTENT_RULES_VL

AMS_CTD_ASSOC_V

AMS_CUSTOM_SETUP_SCR_V

AMS_CUSTOM_SETUPS_VL

AMS_DATASRC_ATTBINFO_VL

AMS_DELIVERABLES_ALL_B_DFV

AMS_DELIVERABLES_INFO_V

AMS_DELIVERABLES_VL

AMS_DM_MODEL_TEST_V

AMS_DM_MODEL_TRAINING_V

AMS_DM_MODELS_ALL_B_DFV

AMS_DM_MODELS_V

AMS_DM_MODELS_VL

AMS_DM_ORG_PROFIT_V

AMS_DM_ORGANIZATIONS_V

AMS_DM_PARTY_ATTRIBUTES_V

AMS_DM_PARTY_PROFIT_V

AMS_DM_PERSONS_V

AMS_DM_SCORE_APPLY_V

AMS_DM_SCORE_HISTORY_V

AMS_DM_SCORES_ALL_B_DFV

AMS_DM_SCORES_V

AMS_DM_SCORES_VL

AMS_DM_SOURCE_MODEL_BUS_V

AMS_DM_SOURCE_MODEL_CON_V

AMS_DM_SOURCE_SCORE_BUS_V

AMS_DM_SOURCE_SCORE_CON_V

AMS_DM_TARGET_VALUES_VL

AMS_DM_TARGETS_VL

AMS_DS_ACCESSES_ALL_V

AMS_DS_GROUP_ACCESSES_ALL_V

AMS_DS_INSTALL_BASE_V

AMS_DS_INTERACTIONS_V

AMS_DS_ORDERS_V

AMS_DS_ORIG_SYS_REFERENCES_V

AMS_DS_SALES_LEADS_V

AMS_DS_SCORES_V

AMS_DS_TCA_ENTITY_COLS_VL

AMS_DS_TCA_ENTITY_VL

AMS_EVENT_HEADERS_AGENDA_V

AMS_EVENT_HEADERS_ALL_B_DFV

AMS_EVENT_HEADERS_V

AMS_EVENT_HEADERS_VL

AMS_EVENT_MAPPING_V

AMS_EVENT_MARKET_SEGMENTS_V

AMS_EVENT_OFFERS_AGENDA_V

AMS_EVENT_OFFERS_ALL_B_DFV

AMS_EVENT_OFFERS_ONLY_V

AMS_EVENT_OFFERS_OV_V

AMS_EVENT_OFFERS_REG_V

AMS_EVENT_OFFERS_V

AMS_EVENT_OFFERS_VL

AMS_EVENT_REGISTRATIONS_DFV

AMS_EVENT_REGISTRATIONS_V

AMS_FORECAST_PRODUCT_SPREADS_V

AMS_FUND_ALLOCATIONS_V

AMS_GEOAREA_SCR_V

AMS_HZ_B2B_MAPPING_V

AMS_HZ_B2C_MAPPING_V

AMS_IBA_EMPLOYEE_ORG_V

AMS_IBA_EMPLOYEE_V

AMS_IBA_PL_PAGES_VL

AMS_IBA_PL_PARAMETERS_VL

AMS_IBA_PL_PLACEMENTS_B_DFV

AMS_IBA_PL_PLACEMENTS_VL

AMS_IBA_PL_SITES_VL

AMS_IBA_PL_STYLESHTS_VL

AMS_IBA_PS_CNDCLSES_VL

AMS_IBA_PS_FILTERS_VL

AMS_IBA_PS_POSTINGS_B_DFV

AMS_IBA_PS_POSTINGS_VL

AMS_IBA_PS_RULEGRPS_VL

AMS_IBA_PS_STRATS_VL

AMS_IBA_RULESETS_V

AMS_IMP_LIST_HEADERS_ALL_V

AMS_IMP_LIST_HEADERS_VL

AMS_INSTANCE_PARTY_B2B_V

AMS_INSTANCE_PARTY_B2C_V

AMS_JTF_RS_EMP_V

AMS_LEAD_ACCOUNTS_V

AMS_LEAD_CONTACTS_V

AMS_LEAD_MAPPING_V

AMS_LIST_ENTRIES_UWQ_V

AMS_LIST_FIELDS_VL

AMS_LIST_HEADERS_ALL_DFV

AMS_LIST_HEADERS_VL

AMS_LIST_QUERIES_PARAM_VL

AMS_LIST_QUERIES_VL

AMS_LIST_RULES_ALL_VL

AMS_LIST_SCH_UWQ_V

AMS_LIST_SRC_FIELDS_VL

AMS_LIST_SRC_TYPES_VL

AMS_LOOKUP_SALES_V

AMS_LOOKUPS

AMS_LT_HZ_CITIZENSHIP

AMS_LT_HZ_EDUCATION

AMS_LT_HZ_EMPLOYMENT_HISTORY

AMS_LT_HZ_PERSON_PROFILES

AMS_LT_HZ_PHONE_1

AMS_LT_ORG_CONTACT_DETAILS_V

AMS_LT_ORG_CONTACT_V

AMS_LT_ORG_PROFILES_V

AMS_LT_PERSON_DETAILS_V

AMS_MEDIA_CHANNELS_VL

AMS_MEDIA_VL

AMS_MESSAGES_B_DFV

AMS_MESSAGES_V

AMS_MESSAGES_VL

AMS_MET_TPL_HEADERS_VL

AMS_METRICS_INFO_V

AMS_METRICS_VL

AMS_MTL_CATEGORIES_DENORM_VL

AMS_OBJECT_RULES_VL

AMS_OFFER_ADJUSTMENTS_VL

AMS_OFFER_PRODUCTS_V

AMS_OFFERS_V

AMS_ORG_ACCT_ROLES_V

AMS_ORG_ACCT_V

AMS_ORG_CONTACT_DETAILS_V

AMS_ORG_CONTACT_ROLES_V

AMS_ORG_DETAILS_V

AMS_ORG_DM_SOURCE_V

AMS_ORG_EMPS_V

AMS_ORG_FINANCIAL_NUMS_V

AMS_ORG_FINANCIAL_RPT_V

AMS_ORG_INTERACTION_ACT_V

AMS_ORG_INTERACTIONS_V

AMS_ORG_PHONE1_V

AMS_ORG_PHONE2_V

AMS_ORG_PHONE3_V

AMS_ORG_PHONE4_V

AMS_ORG_PHONE5_V

AMS_ORG_PHONE6_V

AMS_ORG_PROFILES_V

AMS_ORG_SITE_USES_V

AMS_ORG_SITES_V

AMS_ORGANIZATION_V

AMS_P_ACCT_V

AMS_P_ACT_ATTACHMENTS_V

AMS_P_ACT_METRICS_V

AMS_P_CAMPAIGN_GEO_AREAS_V

AMS_P_CAMPAIGN_MKT_SEGMENTS_V

AMS_P_CAMPAIGN_OFFERS_V

AMS_P_CAMPAIGN_PRODUCTS_V

AMS_P_CAMPAIGN_SCHEDS_V

AMS_P_CAMPAIGNS_V

AMS_P_CELLS_V

AMS_P_DELIV_KIT_ITEMS_V

AMS_P_DELIVERABLES_V

AMS_P_DISCOVERER_SQL_V

AMS_P_EMAIL_V

AMS_P_EVENT_CAMPAIGNS_V

AMS_P_EVENT_DELIVERABLES_V

AMS_P_EVENT_OFFERS_V

AMS_P_EVENT_REG_CONTACTS_V

AMS_P_EVENT_REG_ROSTER_V

AMS_P_FAX_V

AMS_P_LIST_ENTRIES_V

AMS_P_LIST_HEADERS_V

AMS_P_LIST_RULES_V

AMS_P_METRICS_V

AMS_P_OFFER_MKT_SEGMENTS_V

AMS_P_OFFER_PRODUCTS_V

AMS_P_ORG_PROFILES_V

AMS_P_ORGANIZATION_V

AMS_P_OSO_SOURCE_CODES_V

AMS_P_PERSON_PROFILES_V

AMS_P_PERSON_V

AMS_P_PHONE_V

AMS_P_SOURCE_CODES_V

AMS_PARTIES_V

AMS_PARTY_CUSTOMERS_V

AMS_PARTY_INSTANCE_V

AMS_PERSON_ACCT_ROLES_V

AMS_PERSON_ACCT_V

AMS_PERSON_CITIZENSHIP_V

AMS_PERSON_DETAILS_V

AMS_PERSON_DM_SOURCE_V

AMS_PERSON_EDUCATION_V

AMS_PERSON_EMP_HIST_V

AMS_PERSON_INTERACT_ACT_V

AMS_PERSON_INTERACTIONS_V

AMS_PERSON_INTEREST_V

AMS_PERSON_LANG_V

AMS_PERSON_PHONE1_V

AMS_PERSON_PHONE2_V

AMS_PERSON_PHONE3_V

AMS_PERSON_PHONE4_V

AMS_PERSON_PHONE5_V

AMS_PERSON_PHONE6_V

AMS_PERSON_PROFILES_V

AMS_PERSON_RELATIONSHIPS_V

AMS_PERSON_SITE_USES_V

AMS_PERSON_SITES_V

AMS_PERSONS_V

AMS_PRICE_LIST_LINES_V

AMS_PRICE_LISTS_V

AMS_PROD_TEMPLATES_VL

AMS_PRODUCT_MAPPING_V

AMS_PRODUCT_OFFERS_V

AMS_PRODUCT_PRICING_V

AMS_PRODUCT_PRL_IMP_V

AMS_PROGRAM_COMPONENTS_V

AMS_PROGRAMS_VL

AMS_QUERY_COND_DISP_STRUCT_VL

AMS_QUERY_TEMPLATE_VL

AMS_QUERY_TMPL_CONDITION_VL

AMS_SEARCH_IDS_V

AMS_SOURCE_CODES_DETAILS_V

AMS_TAR_ACCOUNT_V

AMS_TAR_CONTACT_V

AMS_TAR_ORGANIZATION_CONTACT_V

AMS_TAR_ORGANIZATION_V

AMS_TAR_PERSON_LIST_V

AMS_TAR_PERSON_V

AMS_TASKS_V

AMS_TCOP_FR_PERIODS_VL

AMS_TERR_HIER_V

AMS_TERR_V

AMS_TERR_VALUES_V

AMS_TRIGGERS_V

AMS_TRIGGERS_VL

AMS_USER_ORG_V

AMS_USER_STATUSES_V

AMS_USER_STATUSES_VL

AMS_VENUE_RATES_VL

AMS_VENUES_V

AMS_VENUES_VL

AMS_WEB_PLACEMENTS_VL

AMS_WEB_PLCE_MP_VL

AMS_WEB_RULES_VL

Tags: AMS, views No Comments »

You are browsing the archive for AMS.

Oracle Marketing Tables

Marketing Profile Options

Views in Marketing module

Sponsor

Tags