You are browsing the archive for Sales & Marketing.

Views in Marketing module

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

Sales Online Descriptive Flex Fields

Oracle Sales Online module DFF list

DFF View DFF CODE NAME DFF name
ASF_USER_PREFERENCE_DFV ASF_USER_PREFERENCE ASF User Preference

Sales Foundation Descriptive Flex Fields

Oracle Sales Foundation module DFF list:

DFF View DFF CODE NAME DFF name
AS_ACCESSES_ALL_ALL_DFV AS_ACCESSES Accesses
AS_CURRENT_ENVIRONMENT_DFV AS_CURRENT_ENVIRONMENT Current Environment
AS_FORECAST_PROB_ALL_B_DFV AS_FORECAST_PROBABILITIES Win Probabilities
AS_INTERESTS_ALL_DFV AS_INTERESTS Interests
AS_LEADS_ALL_DFV AS_LEADS Opportunities
AS_LEAD_COMPETITORS_DFV AS_LEAD_COMPETITORS Opportunity Competitors
AS_LEAD_CONTACTS_ALL_DFV AS_LEAD_CONTACTS Opportunity Contacts
AS_LEAD_LINES_ALL_DFV AS_LEAD_LINES Opportunity Lines
AS_LEAD_OBSTACLES_DFV AS_LEAD_OBSTACLES Opportunity Obstacles
AS_LEAD_ORDERS_DFV AS_LEAD_ORDERS Lead Orders
AS_SALES_CREDITS_DFV AS_SALES_CREDITS Sales Credits
AS_SALES_STAGES_ALL_B_DFV AS_SALES_STAGES Sales Stages
AS_SALES_LEADS_DFV AS_SALES_LEADS Sales Leads
AS_SALES_LEAD_CONTACTS_DFV AS_SALES_LEAD_CONTACTS Sales Lead Contacts
AS_SALES_LEAD_LINES_DFV AS_SALES_LEAD_LINES Sales Lead Lines
AS_SALES_LEAD_OPPORTUNITY_DFV AS_SALES_LEAD_OPP Sales Lead Opportunity
AS_SALES_LEAD_OPP_LINES_DFV AS_SALES_LEAD_OPP_LINES Sales Lead Opp Lines
AS_STATUSES_B_DFV AS_STATUSES Statuses
AS_AP_ACCOUNT_PLANS_DFV AS_AP_ACCOUNT_PLANS Sales Account Plan
AS_AP_BUSINESS_DRIVERS_DFV AS_AP_BUSINESS_DRIVERS Sales Account Plan Business Drivers
AS_AP_STRTGC_OBJECTIVES_DFV AS_AP_STRTGC_OBJECTIVES Sales Account Plan Strategic Objectives
AS_AP_TRACKING_OBJECTIVES_DFV AS_AP_TRACKING_OBJECTIVES Sales Account Plan Tracking Objectives
AS_INTEREST_CODES_B_DFV AS_INTEREST_CODES Interest Codes