AMS Views (319)

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

View	Description
`AML_BUSINESS_EVENT_TYPES_VL`	This view returns information about business event types.
`AML_LEAD_PROCESSING_STAGES_V`	This view returns meaning of the evaluation stage
`AML_LEAD_PROCESS_REPT_V`	This view returns lead and its processing rules
`AMS_ACCTSITE_BILL_TO_CONTACT_V`	This view returns primary bill to contact for an account site. Used for list generation.
`AMS_ACCTSITE_SHIP_TO_CONTACT_V`	This view returns primary ship to contact for an account site. Used for list generation.
`AMS_ACCT_BILL_TO_CONTACT_V`	This view returns primary bill to contact for an account . Used for list generation.
`AMS_ACCT_CONTACT_V`	This view returns all account contacts . Used for list generation.
`AMS_ACCT_INTEREST_V`	This view is used by Discoverer Business Area:List generation Folders.It is a user view of Customer and sites
`AMS_ACCT_SHIP_TO_CONTACT_V`	This view returns primary ship to contact for an account . Used for list generation.
`AMS_ACCT_SITE_CONTACT_V`	This view returns all account site contacts . Used for list generation.
`AMS_ACT_ATTACHMENTS_V`	This view returns attachments associated to an activity.
`AMS_ACT_CAMPAIGNS_V`	This view returns all marketing campaigns promoting marketing events.
`AMS_ACT_DELIVERABLES_V`	This view returns all marketing deliverables, including collaterals.
`AMS_ACT_DELIVERY_METHODS_V`	This view returns marketing activity delivery methods.
`AMS_ACT_GEO_AREAS_V`	This view returns information of Marketing activities and the geographic area they are available / used.
`AMS_ACT_METRIC_FACTS_ALL_V`	This View returns all allocation amounts made from a fund on a sales territory hierarchy.
`AMS_ACT_METRIC_FORMULAS_V`	This View returns all formula details for an activity metric.
`AMS_ACT_MKT_SEGMENTS_VL`	This view returns the market segments associated with a marketing activity.
`AMS_ACT_PRODUCTS_V`	This view returns products / product categories associated to marketing objects like Events, campaigns.
`AMS_ACT_RESOURCES_V`	This view returns information on associations of resources to marketing objects like Events, Campaigns.
`AMS_AGENDAS_V`	Holds the information for an agenda
`AMS_APPROVAL_DETAILS_V`	This view returns Approval detail information with appropriate lookup meanings
`AMS_APPROVAL_DETAILS_VL`	This view returns information about Approval rules
`AMS_AP_CHECKS_V`	Payables Checks
`AMS_AP_INVOICES_V`	Payables Invoices
`AMS_AP_PAYMENTS_V`	Invoice payments
`AMS_AR_DEDUCTIONS_V`	Deductions
`AMS_AR_TRANSACTION_V`	Receivables Transactions
`AMS_ASO_CAMPAIGN_OFFERS_V`
`AMS_ATTB_LOV_VALUES_VL`	This view stores the value meanings for lovs based on manually entered values created in Audience Workbench.
`AMS_ATTB_LOV_VL`	This view stores the lovs created in Audience Workbench.
`AMS_CAMPAIGNS_V`	This view returns all marketing campaigns and related information.
`AMS_CAMPAIGNS_VL`	This is the view for marketing campaigns.
`AMS_CAMPAIGN_FORECASTS_ALL_V`	Contains all forecast information for a campaign.
`AMS_CAMPAIGN_PRODUCTS_V`	This view returns the products associated to the campaigns.
`AMS_CAMPAIGN_PRODUCT_VOLUMES_V`
`AMS_CAMPAIGN_SCHEDULES_VL`	This is the view for marketing campaign Schedules.
`AMS_CAMPAIGN_TEAM_V`	This view returns the team ( access ) information associated to marketing activity..
`AMS_CATEGORIES_V`	This view returns the marketing categories used in marketing deliverables / marketing events.
`AMS_CATEGORIES_VL`	This view returns the marketing categories used in marketing deliverables / marketing events.
`AMS_CELLS_SEL_ALL_V`	Segment selection view definition
`AMS_CELLS_VL`	This view returns the cells ( segment ) information.
`AMS_CHANNELS_V`	This view returns the channel details.
`AMS_CHANNELS_VL`	This view returns Marketing communication channel information.
`AMS_CLIK_THRU_ACTIONS_VL`	View on top of AMS_CLIK_THRU_ACTIONS_B and AMS_CLIK_THRU_ACTIONS_TL.
`AMS_CLIK_THRU_ACT_PARAMS_VL`	This view is on AMS_CLIK_THRU_ACT_PARAMS_B andAMS_CLIK_THRU_ACT_PARAMS_ TL
`AMS_COMPETITOR_PRODUCTS_VL`	This view provides the details about what are the competing products in the market for a given products
`AMS_CONTACT_INTEREST_V`	This view is used by Discoverer Business Area:List Generation Folders.It retrieves all Contacts on the system along with their addresses and
`AMS_CONTACT_PRODUCTS_V`	This view is used by Contact Preferences. This view store the interest Types and interet type codes
`AMS_CONTACT_RESTRICTIONS_V`
`AMS_CONTENT_RULES_VL`	This view returns all the Content Rules defined in Marketing.
`AMS_CPAG_ANSWERS_VL`	Content Page Answers VL View.
`AMS_CPAG_DLG_RESPONS_VL`	Dialog / Questionnaire Responses VL View.
`AMS_CPAG_QUESTIONS_VL`	Content Page Questions VL View.
`AMS_CTD_ASSOC_V`	This view is on top of ams_clik_thru_actions_vl and
`AMS_CUSTOM_SETUPS_VL`	This view returns all the custom setups details.
`AMS_CUSTOM_SETUP_SCR_V`	This view returns all the custom setups details.
`AMS_DATASRC_ATTBINFO_VL`	This view is used to construct the data source Hgrid in the audience administration workbench.
`AMS_DELIVERABLES_INFO_V`
`AMS_DELIVERABLES_VL`	This view returns the marketing deliverable information.
`AMS_DIALOGS_VL`	This is the view for dialog and it's also striped by language.
`AMS_DLG_COMP_TYPES_VL`	This view returns all Dialog Component Types
`AMS_DLG_COMP_TYPE_OUTCOME_VL`
`AMS_DLG_COMP_TYPE_PARAMS_VL`
`AMS_DLG_EVENT_INFO_VL`
`AMS_DLG_EVENT_REGISTRATIONS_VL`
`AMS_DLG_FLOW_COMPS_VL`
`AMS_DLG_IDENTIFY_RULES_VL`	This view lists all the Identification Rules and the language specific columns are striped by language
`AMS_DLG_URL_PARAMS_VL`
`AMS_DM_MODELS_V`	View of data mining models with denormalized reference objects.
`AMS_DM_MODELS_VL`	Multi-lingual view for data mining models.
`AMS_DM_MODEL_TEST_V`	This is a dummy view created to grant access to the ODM (data mining schema)
`AMS_DM_MODEL_TRAINING_V`	This is a dummy view created to grant access to the ODM (data mining schema)
`AMS_DM_ORGANIZATIONS_V`	This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for organizations and orga
`AMS_DM_ORG_PROFIT_V`	Not used. Stubbed out with dummy column.
`AMS_DM_PARTY_ATTRIBUTES_V`	View used by the seeded data mining data source for parties in the Trading Community Architecture.
`AMS_DM_PARTY_PROFIT_V`	View used by the seeded data mining profitability data source for parties in the Trading Community Architecture.
`AMS_DM_PERSONS_V`	This view is no longer used for seeded data sources. (15-Jul-2004)View used by the seeded data mining data source for persons in the Trading
`AMS_DM_SCORES_V`	View of data mining scoring runs with denormalized reference objects.
`AMS_DM_SCORES_VL`	Multi-lingual view for data mining scoring runs.
`AMS_DM_SCORE_APPLY_V`	This is a dummy view created to grant access to the ODM (data mining schema)
`AMS_DM_SCORE_HISTORY_V`	View to be used to identify the score and the model used for a scoring run for a specific party.
`AMS_DM_SOURCE_MODEL_BUS_V`	Obseleted view.
`AMS_DM_SOURCE_MODEL_CON_V`	Obseleted view.
`AMS_DM_SOURCE_SCORE_BUS_V`	Obseleted view.
`AMS_DM_SOURCE_SCORE_CON_V`	Obseleted view.
`AMS_DM_TARGETS_VL`	Multi-lingual view for data mining alternative data source targets.
`AMS_DM_TARGET_VALUES_VL`	Multi-lingual view for data mining alternative data source target values.
`AMS_DS_ACCESSES_ALL_V`
`AMS_DS_GROUP_ACCESSES_ALL_V`	This view gives details regarding sales group access.
`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`	This view returns the general information about marketing event headers agenda.
`AMS_EVENT_HEADERS_V`	This view returns the general information about marketing events (headers).
`AMS_EVENT_HEADERS_VL`	This view returns the general information about marketing events (headers).
`AMS_EVENT_MAPPING_V`	This view returns evnts Mapping information
`AMS_EVENT_MARKET_SEGMENTS_V`	This view returns the general information about market segments associated with events.
`AMS_EVENT_OFFERS_AGENDA_V`	This view returns the general information about marketing event offering agenda.
`AMS_EVENT_OFFERS_ONLY_V`	This view returns the general information about marketing event offerings without event header information.
`AMS_EVENT_OFFERS_OV_V`	This view returns the general information about marketing event offerings .
`AMS_EVENT_OFFERS_REG_V`	This view returns registration information about event schedules
`AMS_EVENT_OFFERS_V`	This view returns the general information about marketing event offerings .
`AMS_EVENT_OFFERS_VL`	This view returns the general information about marketing event offerings.
`AMS_EVENT_REGISTRATIONS_V`	This view returns the registration details of the participants to a marketing event.
`AMS_EXP_LIST_HEADERS_VL`	Stores the export header information.
`AMS_FORECAST_PRODUCT_SPREADS_V`	This View stores the results of a product forecast.
`AMS_FUND_ALLOCATIONS_V`
`AMS_GEOAREA_SCR_V`	This view returns geographic area details such as name, location and code.
`AMS_HIERARCHIES_VL`	Stores all hierarchies supported by Oracle Marketing
`AMS_HZ_B2B_MAPPING_V`	This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
`AMS_HZ_B2C_MAPPING_V`	This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
`AMS_IBA_EMPLOYEE_ORG_V`	This view selects organization details of employees. It is used to create segments for business tobusiness users in iMarketing.
`AMS_IBA_EMPLOYEE_V`	This view selects employee details of organizations. It is used to create segments for business tobusiness users in iMarketing.
`AMS_IBA_OP_CATEGORY_V`	It lists out all the categories in a catalogue
`AMS_IBA_OP_CUSTOMER_V`	It provides a list of all eligible customers in Oracle Applications and their personal information
`AMS_IBA_OP_ITEM_V`	It provides the items candidate for Personalization
`AMS_IBA_OP_PROMPT_VL`	Lists the explicit rating prompts
`AMS_IBA_OP_PROXY_V`	Lists out the item can be used as proxy for other items
`AMS_IBA_OP_PURCHASING_DETAIL_V`	It contains the purchasing information of customers
`AMS_IBA_OP_TAXONOMY_CATEGORY_V`	It provides information about categories that are part of different taxonomies
`AMS_IBA_OP_TAXONOMY_V`	This lists out the taxonomies in a catalogue. Here, the taxonomy is a top node in a catalogue
`AMS_IBA_OP_TXNMY_CATEGORY_ITEM`	It provides the information about the relationship among item,category and taxonomy
`AMS_IBA_PL_PAGES_VL`	This view lists all pages per site.
`AMS_IBA_PL_PARAMETERS_VL`	This view lists all parameters
`AMS_IBA_PL_PLACEMENTS_VL`	This view lists all placements
`AMS_IBA_PL_SITES_VL`	This view lists all sites
`AMS_IBA_PL_STYLESHTS_VL`	This view lists all stylesheets
`AMS_IBA_POSTINGS_RUN_VL`	View that joins affiliate posting information and translable fields.
`AMS_IBA_POSTINGS_VL`	View that joins posting information and translable fields.
`AMS_IBA_PS_CNDCLSES_VL`	This view is used to display extended conditions.
`AMS_IBA_PS_FILTERS_VL`	This view is used for filter definition
`AMS_IBA_PS_POSTINGS_VL`	This view is used for Posting name in overview screen
`AMS_IBA_PS_RULEGRPS_VL`	This view is used to display Rules rule overview screen
`AMS_IBA_PS_STRATS_VL`	This view is used to display pre-defined and custom strategies.
`AMS_IBA_RULESETS_V`	view for ruleset
`AMS_IMP_LIST_HEADERS_ALL_V`	This view returns the import list header information.
`AMS_IMP_LIST_HEADERS_VL`	This view stores all the translatable details of list import header (like name,description).
`AMS_INSTANCE_PARTY_B2B_V`	Business to Business Views for Install Base
`AMS_INSTANCE_PARTY_B2C_V`	Business to Consumer Views for Install Base
`AMS_JTF_RS_EMP_V`	This view is created to give the details of the Marketing resources
`AMS_LEAD_ACCOUNTS_V`	This view is used by Discoverer Business Area : List Generation Folders to retrieve customers and sites linked to an opportunity.
`AMS_LEAD_CONTACTS_V`	This view is used by Discoverer Business Area: List generation folders.Contains contacts linked to sales opportunities
`AMS_LEAD_MAPPING_V`	This view stores the mapping of ams_imp_source_lines table. This is used to populate the data from the data file.
`AMS_LIST_ENTRIES_UWQ_V`	This view is used by Universal Work Queue
`AMS_LIST_FIELDS_VL`	This view returns the translated fields for the list.
`AMS_LIST_HEADERS_VL`
`AMS_LIST_QUERIES_PARAM_VL`	This view stores the parameters associated with list queries along with their display meanings.
`AMS_LIST_QUERIES_VL`	This view stores the list queries.
`AMS_LIST_RULES_ALL_VL`	This view stores the list rules.
`AMS_LIST_SCH_UWQ_V`	This view is used by Universal Work Queue
`AMS_LIST_SRC_FIELDS_VL`	Muti Lingual view based for list source fields
`AMS_LIST_SRC_TYPES_VL`	Muti Lingual view based for list source types
`AMS_LOOKUPS`	This view filters and returns only records created for Oracle Marketing.
`AMS_LOOKUP_SALES_V`	This view is used by Discoverer Business Area:List generation LOV folders.
`AMS_LT_HZ_CITIZENSHIP`	Data Source view based on hz_citizenship
`AMS_LT_HZ_EDUCATION`	Data Source view based on hz_education
`AMS_LT_HZ_EMPLOYMENT_HISTORY`	Data Source view based on hz_employement_history
`AMS_LT_HZ_LOCATIONS`	Data Source view based on hz_locations
`AMS_LT_HZ_PERSON_PROFILES`	Data Source view based on hz_person_profiles
`AMS_LT_HZ_PHONE_1`	Data Source view based on hz_contact_points to get primary identify phone number
`AMS_LT_ORG_CONTACT_DETAILS_V`	Data Source view to get information about b2b contacts
`AMS_LT_ORG_CONTACT_V`	Data Source view to get information about b2b contacts
`AMS_LT_ORG_PROFILES_V`	Data Source view based on hz_organization_profiles
`AMS_LT_PERSON_DETAILS_V`	Data Source view to get information about b2c contacts
`AMS_MEDIA_CHANNELS_VL`	This view returns the details of all the medias and the Channels attached to them.
`AMS_MEDIA_VL`	This view returns all media that can be used by an activity.
`AMS_MESSAGES_V`	This view returns details of marketing messages.
`AMS_MESSAGES_VL`	This view returns marketing message details.
`AMS_METRICS_INFO_V`
`AMS_METRICS_VL`	This view returns the details of Metrics measures that can be used by an activity.
`AMS_MET_TPL_HEADERS_VL`	This view returns the metric template headers name and description in the current language.
`AMS_MISC_COST_DIS_ALL_VL`	Table for storing various costs for Customer
`AMS_MISC_COST_DIS_VL`	Table for storing various costs for Customer
`AMS_MTL_CATEGORIES_DENORM_VL`	This view provides description for each segment of a inventory category, concatenated together.
`AMS_OBJECT_RULES_VL`	This view returns object rules details.
`AMS_OE_ORDER_HEADERS_V`	Order Headers
`AMS_OE_ORDER_LINES_V`	Order Lines
`AMS_OE_RETURNS_V`	Order Returns
`AMS_OFFERS_V`	This view stores offers' detail along with the header infomation.
`AMS_OFFER_ADJUSTMENTS_VL`	This view returns details of offer adjustments.
`AMS_OFFER_PRODUCTS_V`	Offer Products
`AMS_ORGANIZATION_V`	This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
`AMS_ORG_ACCT_ROLES_V`	Roles that parties perform in customer accounts
`AMS_ORG_ACCT_V`	Customer account information
`AMS_ORG_CONTACT_DETAILS_V`	This view lists the details of organization contacts
`AMS_ORG_CONTACT_ROLES_V`	Roles played by organization contacts
`AMS_ORG_DETAILS_V`	This view list the details of an Organization
`AMS_ORG_DM_SOURCE_V`
`AMS_ORG_EMPS_V`	This view stores the details of contacts who are employees
`AMS_ORG_FINANCIAL_NUMS_V`	Details of financial reports
`AMS_ORG_FINANCIAL_RPT_V`	Financial reports of parties
`AMS_ORG_INTERACTIONS_V`	A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resourc
`AMS_ORG_INTERACTION_ACT_V`	An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Med
`AMS_ORG_LOCATIONS_V`
`AMS_ORG_PHONE1_V`	Electronic methods of communicating with parties
`AMS_ORG_PHONE2_V`	Electronic methods of communicating with parties
`AMS_ORG_PHONE3_V`	Electronic methods of communicating with parties
`AMS_ORG_PHONE4_V`	Electronic methods of communicating with parties
`AMS_ORG_PHONE5_V`	Electronic methods of communicating with parties
`AMS_ORG_PHONE6_V`	Electronic methods of communicating with parties
`AMS_ORG_PROFILES_V`	This public view returns an organization profile for an organization. Used for list generation.
`AMS_ORG_SITES_V`
`AMS_ORG_SITE_USES_V`
`AMS_PARTIES_V`
`AMS_PARTY_CUSTOMERS_V`	This view retuns all the parties(both Persons and Organizations)
`AMS_PARTY_INSTANCE_V`	Data source view for install base
`AMS_PERSONS_V`	Information about parties such as people.
`AMS_PERSON_ACCT_ROLES_V`	Roles that persons perform in customer accounts.
`AMS_PERSON_ACCT_V`
`AMS_PERSON_CITIZENSHIP_V`	Person's claimed nationality
`AMS_PERSON_DETAILS_V`	Information about parties such as people.
`AMS_PERSON_DM_SOURCE_V`
`AMS_PERSON_EDUCATION_V`	Person's education information
`AMS_PERSON_EMP_HIST_V`	Person's employment information
`AMS_PERSON_INTERACTIONS_V`
`AMS_PERSON_INTERACT_ACT_V`
`AMS_PERSON_INTEREST_V`	Information about a person's personal interests
`AMS_PERSON_LANG_V`	Languages that a person speaks, reads, or writes
`AMS_PERSON_LOCATIONS_V`
`AMS_PERSON_PHONE1_V`	Electronic methods of communicating with parties
`AMS_PERSON_PHONE2_V`	Electronic methods of communicating with parties
`AMS_PERSON_PHONE3_V`	Electronic methods of communicating with parties
`AMS_PERSON_PHONE4_V`	Electronic methods of communicating with parties
`AMS_PERSON_PHONE5_V`	Electronic methods of communicating with parties
`AMS_PERSON_PHONE6_V`	Electronic methods of communicating with parties
`AMS_PERSON_PROFILES_V`	Provides Profile of a Person
`AMS_PERSON_RELATIONSHIPS_V`	Relationships between entities
`AMS_PERSON_SITES_V`	Links person to physical locations
`AMS_PERSON_SITE_USES_V`	The way that a person uses a particular site or address
`AMS_PRICE_LISTS_V`
`AMS_PRICE_LIST_LINES_V`
`AMS_PRODUCT_MAPPING_V`	Product view for import.
`AMS_PRODUCT_OFFERS_V`
`AMS_PRODUCT_PRICING_V`
`AMS_PRODUCT_PRL_IMP_V`	This view returns price list line of a given inventory item.
`AMS_PROD_TEMPLATES_VL`	This view returns translationed template names and description.
`AMS_PROGRAMS_VL`	This view is created to give general information about marketing Programs
`AMS_PROGRAM_COMPONENTS_V`	This view is created for giving general information about progam Components
`AMS_P_ACCT_BILL_TO_V`	This view returns the primary bill to address for an account. Used for List generation only.
`AMS_P_ACCT_CONTACT_V`	This view returns the primary contact for an account. Used for list generation only.
`AMS_P_ACCT_GUARANTOR_V`	This view returns the primary guarantor for an account. Used for list generation only.
`AMS_P_ACCT_SHIP_TO_V`	This view returns the primary ship to address for an account. Used for list generation only.
`AMS_P_ACCT_V`	This view returns all entries from the HZ_CUST_ACCOUNTS_ALL table. Used for list generation only.
`AMS_P_ACT_ATTACHMENTS_V`	This Public view returns the attachement associated with marketing activity.
`AMS_P_ACT_METRICS_V`	This public view returns the metrics that will be tracked for marketing activities.
`AMS_P_CAMPAIGNS_V`	This public view returns all marketing campaigns and related information.
`AMS_P_CAMPAIGN_GEO_AREAS_V`	This public view returns information of Marketing campaign and the geographic area they are available / used.
`AMS_P_CAMPAIGN_MKT_SEGMENTS_V`	This public view returns the market segments associated with a marketing campaigns.
`AMS_P_CAMPAIGN_OFFERS_V`	This public view returns the promotional offers associated with campaigns.
`AMS_P_CAMPAIGN_PRODUCTS_V`	This public view returns products / product categories associated to marketing campaigns.
`AMS_P_CAMPAIGN_SCHEDS_V`	This public view returns the campaign schedule information..
`AMS_P_CELLS_V`
`AMS_P_CONTACT_BILL_TO_V`	This view returns the primary bill to address for an Organization Contact. Used for list generation.
`AMS_P_CONTACT_EMAIL_V`	This view returns the primary email address for an Organization Contact. Used for list generation.
`AMS_P_CONTACT_FAX_V`	This view returns the primary fax for an Organization Contact. Used for list generation.
`AMS_P_CONTACT_ORG_V`	This view selects the organization details for a contact.
`AMS_P_CONTACT_PHONE_V`	This view returns the primary phone for an Organization Contact. Used for list generation.
`AMS_P_CONTACT_SHIP_TO_V`	This view selects the primary shipping address for an Organization Contact. Used for list generation.
`AMS_P_CONTACT_V`	This view returns all Contacts for an Organization. Used for list generation.
`AMS_P_DELIVERABLES_V`	This public view returns the marketing deliverable information.
`AMS_P_DELIV_KIT_ITEMS_V`	This public view returns the collateral items associated to collateral kits.
`AMS_P_DISCOVERER_SQL_V`	This public view returns the distinct set of WorkBook and WorkSheet names which are stored in the AMS_DISCOVERER_SQL table.
`AMS_P_DO_NOT_CONTACT_V`	This public view returns organization contacts which are not to be contacted. Used for list generation.
`AMS_P_DO_NOT_EMAIL_V`	This public view returns organization contacts which are not to be emailed. Used for list generation.
`AMS_P_DO_NOT_MAIL_V`	This public view returns organization contacts which are not to be mailed. Used for list generation.
`AMS_P_DO_NOT_PHONE_V`	This public view returns organization contacts which are not to be phoned. Used for list generation.
`AMS_P_EMAIL_V`	This public view returns primary email for a party. Used for list generation.
`AMS_P_EVENT_CAMPAIGNS_V`	This public view returns all marketing campaigns promoting marketing events.
`AMS_P_EVENT_DELIVERABLES_V`	This public view returns all marketing deliverables, including collaterals associated marketing events.
`AMS_P_EVENT_OFFERS_V`	This public view returns the general information about marketing event offerings.
`AMS_P_EVENT_REG_CONTACTS_V`	This public view returns the registration contact details of the participants to a marketing event.
`AMS_P_EVENT_REG_ROSTER_V`	This public view returns the registration details of the participants to a marketing event.
`AMS_P_FAX_V`	This public view returns primary fax for a party. Used for list generation.
`AMS_P_LIST_ENTRIES_V`	This public view returns all customers/contacts/target prospectsgenerated for a list, to be used for mailshots, telemarketing etc.
`AMS_P_LIST_HEADERS_V`	This public view returns the general information about marketing list.
`AMS_P_LIST_RULES_V`	This public view returns information on user-defined rules for identifying account or contact duplicates in lists, and what priority reules
`AMS_P_METRICS_V`	This public view returns the details of Metrics measures that can be used by an activity.
`AMS_P_OFFER_MKT_SEGMENTS_V`	This public view returns the market segments associated with a marketing offers.
`AMS_P_OFFER_PRODUCTS_V`	This public view returns the products associated with a marketing offers.
`AMS_P_ORGANIZATION_V`	This View returns all entries from the HZ_PARTIES table which have a party_type of ORGANIZATION. Used for list generation.
`AMS_P_ORG_PROFILES_V`	This public view returns an organization profile for an organization. Used for list generation.
`AMS_P_OSO_SOURCE_CODES_V`	This public view shows the information related to Marketing Source code.
`AMS_P_PARTY_CONTACT_V`	This view returns all party contacts . Used for list generation.
`AMS_P_PERSON_PROFILES_V`
`AMS_P_PERSON_V`	This public view returns all entries from the HZ_PARTIES table which have a party_type of PERSON. Used for list generation.
`AMS_P_PHONE_V`	This public view returns primary phone for a party. Used for list generation.
`AMS_P_SOURCE_CODES_V`	This public view shows the information related to Marketing Source code.
`AMS_QUERY_COND_DISP_STRUCT_VL`	This view stores the body of the condition or in other words, has the non-variant information (condition parts that don't change between Adm
`AMS_QUERY_TEMPLATE_VL`	This view stores the query template information in Audience Workbench.
`AMS_QUERY_TMPL_CONDITION_VL`	This view stores the information on the query template conditions in Audience Workbench.
`AMS_SEARCH_IDS_V`	This view returns search result rows only for the current users session.
`AMS_SITE_DONOT_MAIL_V`	This view returns sites which are not to be mailed. Used for list generation.
`AMS_SOURCE_CODES_DETAILS_V`
`AMS_TAR_ACCOUNT_V`	This View shows the information stored for an "AMS_ACCOUNT" List source type.
`AMS_TAR_CONTACT_V`	This View shows the information stored for an "AMS_CONTACT" List source type.
`AMS_TAR_ORGANIZATION_V`	This View shows the information stored for an "AMS_ORGANIZATION" List source type.
`AMS_TAR_PERSON_V`	This View shows the information stored for an "AMS_PERSON" List source type.
`AMS_TASKS_V`	This view returns the task and task assignment details.
`AMS_TCOP_FR_PERIODS_VL`	This is a view for Periods in Fatigue Rules
`AMS_TERR_HIER_V`
`AMS_TERR_V`
`AMS_TERR_VALUES_V`
`AMS_TRIGGERS_V`	This view returns all the Trigger details and the checks and Actions associated with it.
`AMS_TRIGGERS_VL`	This view is created to give general information about Marketing triggers.
`AMS_USER_ORG_V`	This view is used by Discoverer Business Area:List Generation Folders to show the Organizations which an user has been assigned to.
`AMS_USER_STATUSES_V`	This view returns information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..)
`AMS_USER_STATUSES_VL`	This view returns information on User statuses defined for System Statuses for Marketing Objects(Event,Registration,Campaign etc..)
`AMS_VENUES_V`	This view retrives venue information
`AMS_VENUES_VL`	This view returns information on Venues
`AMS_VENUE_RATES_VL`	View returns the rate information in Venus
`AMS_WEB_PLACEMENTS_VL`	This view returns the placement information
`AMS_WEB_PLCE_MP_VL`	This view returns the placement and related object detail information
`AMS_WEB_RULES_VL`	This view returns the web rules information