AS Views (285)

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

View	Description
`ASBV_INTEREST_CODES`
`ASBV_INTEREST_TYPES`
`ASBV_SALES_COMPETITORS`
`ASBV_SALES_CREDITS`
`ASBV_SALES_FORCE`
`ASBV_SALES_GROUPS`
`ASBV_SALES_GROUPS_DENORM`
`ASBV_SALES_OPPORTUNITIES`
`ASBV_SALES_OPPORTUNITY_LINES`
`ASBV_SALES_STAGES`
`ASBV_WIN_PROBABILITIES`
`ASFV_INTEREST_CODES`
`ASFV_INTEREST_TYPES`
`ASFV_SALES_COMPETITORS`
`ASFV_SALES_CREDITS`
`ASFV_SALES_FORCE`
`ASFV_SALES_GROUPS`
`ASFV_SALES_GROUPS_DENORM`
`ASFV_SALES_OPPORTUNITIES`
`ASFV_SALES_OPPORTUNITY_LINES`
`ASFV_SALES_STAGES`
`ASFV_WIN_PROBABILITIES`
`AS_ACCESSES`	Contains employee access records for accounts and opportunities (multi-org).
`AS_ACCESSES_ACTIVE_V`	Contains active access records
`AS_ACCESSES_ALL`
`AS_ACCESS_TERRITORIES_SUM_V`	Territory access summary
`AS_ACCESS_TYPES_ACTIVE_V`	Active access types
`AS_ACCOUNT_CODES_ACTIVE_V`	Account codes
`AS_ACCOUNT_CODES_V`	Account codes
`AS_ACCOUNT_CONTACTS_V`	Account contacts
`AS_ACCOUNT_LEADS_V`	Account leads
`AS_ACCOUNT_PRIM_PHONE_V`	Shows accounts and their primary phone number
`AS_ALL_CUSTOMERS_V`	All customers view
`AS_ALL_INTEREST_TYPES_V`
`AS_ASSIGNED_LIST_ENTRIES_V`	Assigned list entries view.
`AS_CATEGORIES`	Categories view (multi-org).
`AS_CHANGED_ACCOUNTS`	Changed accounts (multi-org)
`AS_CHANGED_TERRITORIES`	Obsolete. Changed territories (multi-org)
`AS_COLLATERAL_ACTIVE_V`	Active collateral pieces view
`AS_COLLATERAL_CAT`	Collateral categories (multi-org)
`AS_COLLATERAL_CATEGORIES_NEW_V`	Collateral categories
`AS_COLLATERAL_KITS`	Collateral kits (multi-org)
`AS_COLLATERAL_KITS_V`	Collateral kits
`AS_COLLATERAL_REQ`	Collateral requests (multi-org)
`AS_COLLATERAL_REQUESTS_V`	Collateral requests view
`AS_COLLATERAL_REQ_ITEMS_V`	Collateral request items
`AS_COLLATERAL_V`	Collateral view
`AS_CONTACTS_V`	Contacts view
`AS_CONTACT_ADDRESSES_V`	Contact addresses view
`AS_CONTACT_NAMES_V`	Contact names view
`AS_CURRENT_ENVIRONMENT_V`	Current Environment
`AS_CUSTOMER_ACCOUNTS_V`	Customer, accounts view used in Account form
`AS_CUSTOMER_CONTACTS_V`	Customer contacts view
`AS_CUSTOMER_LEADS_V`	Customer leads view
`AS_CUSTOMER_RELATIONSHIPS_V`	Customer relationships view
`AS_CUST_ACCOUNT_CODES_ACTIVE_V`
`AS_CUST_RELATIONSHIPS_V`	Customer relationships view
`AS_DEFAULT_PURCHASES`
`AS_DEFAULT_PURCHASES_V`	Currently not in use
`AS_DEMO_PRODUCTS_V`	AS_DEMO_PRODUCTS_V
`AS_DIST_SC_MEMBERS_V`	Distinct view of sales credit members
`AS_DOSSIER_ADDRESSES_V`	Order history addresses view
`AS_DOSSIER_HEADERS_DETAIL_V`	Order history header details view
`AS_DOSSIER_HEADERS_V`	Order history header summary view
`AS_DOSSIER_LINES_DETAIL_V`	Order history lines detail view
`AS_DOSSIER_LINES_SUMMARY_V`	Order history lines summary view
`AS_DOSSIER_PRODTOTALS_V`	Order history product totals view
`AS_DOSSIER_PRODUCT_LINES_V`	Order history product lines view
`AS_DOSSIER_REPS_UNIONALL_V`	Union all view of order history sales representatives
`AS_DOSSIER_SALESREPS_V`	Order history sales representatives view
`AS_DOSSIER_SERVTOTALS_V`	Order history service totals view
`AS_EMP_SALESFORCE_V`	Employees from salesforce view
`AS_EMP_SALESREPS_V`	Salesperson Definition View for Employee type salesreps
`AS_EVENTS_V`	Events view
`AS_EVENT_ENROLLMENTS`	Event enrollments (multi-org)
`AS_EVENT_ENROLLMENTS_V`	Event enrollments view
`AS_EVENT_FACILITIES`	Event facilities (multi-org)
`AS_EVENT_FACILITIES_V`	Event facilities view
`AS_EVENT_LETTERS`	Event letters (multi-org)
`AS_EVENT_LETTERS_V`	Event letters view
`AS_EVENT_MERGE_V`	Event merge view
`AS_EVENT_NAMES`	Event names (multi-org)
`AS_EXCHANGES_VL`	MLS Compliant view on _B and _TL tables.
`AS_FC_SALESFORCE_V`	This view shows all the salesforce from JTF resource manager
`AS_FC_SALES_GROUPS_V`	This view shows all sales groups information
`AS_FORECAST_CATEGORIES_VL`
`AS_FORECAST_PROB`	Forecast Probability (single org, no MLS columns)
`AS_FORECAST_PROB_ALL_VL`	Forecast Probability (all orgs, single language view)
`AS_FORECAST_PROB_VL`	Forecast probabilities (single-org, single language view)
`AS_FREIGHT_CARRIERS_ACTIVE_V`	Active freight carriers view
`AS_FST_SALES_CATEGORIES_V`	This view refers to AS_INTEREST_TYPES_TL instead of view AS_INTEREST_TYPES_VL for the performance tuning considerations. Every interest type
`AS_FUNDS_VL`	MLS Compliant view on _B and _TL tables.
`AS_FUND_CONTACTS_V`	View to show fund contact details.
`AS_FUND_DETAILS_V`
`AS_FUND_ISSUES_V`	This group displays Issues of a Fund.
`AS_IMP_SL_V`	Obsolete
`AS_INTERESTS`	Interests (multi-org)
`AS_INTERESTS_V`	Interests view
`AS_INTEREST_CATEGORY_SETS`	Interest category sets (multi-org)
`AS_INTEREST_CATEGORY_SETS_V`	Interest category sets view
`AS_INTEREST_CODES`	This is single-org only from _ALL table.
`AS_INTEREST_CODES_ALL_VL`	Interest Codes (all orgs, single language view)
`AS_INTEREST_CODES_MC_V`	View to show price and curreny code for a product family item associated with a secondary inyterest code.
`AS_INTEREST_CODES_V`	Interest Codes (single language, no org-specific information)
`AS_INTEREST_CODES_VL`	MLS Compliant view on _B and _TL tables.
`AS_INTEREST_STATUSES_ACTIVE_V`	Active interest statuses view
`AS_INTEREST_STATUSES_V`	Interest statuses view
`AS_INTEREST_TYPES`	This is a organization specific view based on AS_INTEREST_TYPES_ALL table.
`AS_INTEREST_TYPES_ALL_VL`	Interest Types (all orgs, single language view)
`AS_INTEREST_TYPES_V`	Interest Types (single language, no org-specific information)
`AS_INTEREST_TYPES_VL`	Interest types (single org, single language view)
`AS_INVALID_ADDR_ACCOUNT_V`	View of accounts with invalid addresses
`AS_INVALID_ADDR_CONTACT_V`	View of contacts with invalid addresses
`AS_INV_ITEM_LOV_V`	This view provides Inventory Item and associated Sales category IDs.
`AS_INV_UOM_V`	View to provide Inventory Item identifier and it's corresponding unit of measure(s).
`AS_ISSUES_VL`	MLS Compliant view on _B and _TL tables.
`AS_ISSUE_GROUPS_VL`	MLS Compliant view on _B and _TL tables.
`AS_ISSUE_GROUP_DETAILS_V`	THIS VIEW SHOWS ISSUE GROUP DETAILS
`AS_ISSUE_GROUP_ISSUES_V`	THIS VIEW DISPLAYS ALL THE ISSUES FOR THE ISSUE GROUPS
`AS_ISSUE_GROUP_PARTIES_V`	THIS VIEW DISPLAYS ALL THE PARTIES FOR THE ISSUE GROUPS
`AS_ISSUE_LISTING_VL`	MLS Compliant view on _B and _TL tables.
`AS_LANGUAGES_ACTIVE_V`	Active languages view
`AS_LEADS`	Sales opportunities (multi-org)
`AS_LEAD_CONTACTS`	Sales opportunity contacts (multi-org)
`AS_LEAD_LINES`	Sales opportunity lines (multi-org)
`AS_LEAD_LINE_ADJS_DENORM_V`
`AS_LETTER_MERGE_ENTRIES_V`	Displays the contacts to whom a letter is mailed.
`AS_LETTER_V`	Letters view
`AS_LISTS`	Lists (multi-org)
`AS_LISTS_V`
`AS_LIST_ENTRIES_V`	Displays the entries of a list.
`AS_LIST_RULES_V`	Displays all the rules for removing duplicates.
`AS_LIST_RULE_ENTRIES_V`	Displays the columns available to be used to define de-duplicate rules.
`AS_LIST_RULE_FIELDS_VL`	Displays the translated description of the list rule fields.
`AS_LOCATIONS_V`	Locations view
`AS_LOCATION_CONTACTS_V`	Location contacts view
`AS_LOOKUPS`	Lookup view
`AS_LOOKUP_TYPES`	Lookup type view
`AS_L_CUST_SITES_ACTIVE_V`	Customer account code
`AS_L_SITES_ACTIVE_V`	Account code
`AS_L_SITES_V`	Account code
`AS_MAIL_BLITZES_V`	Mail blitzes view
`AS_MAIL_BLITZ_LETTERS_ACTIVE_V`	Active mail blitzes view
`AS_MC_TYPE_MAPPINGS_V`	MC type mappings view
`AS_MERGE_FILES`	Merge files (multi-org)
`AS_MRP_INTERFACE_LINES_V`	Manufacturing resource planning interface lines view
`AS_OFL_SALES_GROUP_DENORM_V`
`AS_OPPORTUNITIES`	Sales opportunities (multi-org)
`AS_OPPORTUNITIES_LIST_V`	Sales Opportunities List View
`AS_OPPORTUNITIES_V`	view based on as_leads_all and hz_parties
`AS_OPPORTUNITY_ADJS_BASE_V`	Displays the base information of a lead.
`AS_OPPORTUNITY_ADJS_V`	Lead Adjustment view
`AS_OPPORTUNITY_COMPETITORS_V`	View based on hz_parties and as_lead_competitors
`AS_OPPORTUNITY_CONTACTS`	Sales opportunity contacts (multi-org)
`AS_OPPORTUNITY_CONTACTS_V`	View to provide opportunity contact details.
`AS_OPPORTUNITY_DETAILS_V`
`AS_OPPORTUNITY_DET_ADDR_V`
`AS_OPPORTUNITY_DET_PRM_V`
`AS_OPPORTUNITY_LINES`	Sales opportunity lines (multi-org)
`AS_OPPORTUNITY_LINES_V`
`AS_OPPORTUNITY_LINE_TOTALS_V`	Sales opportunity lines total view
`AS_OPPORTUNITY_OBSTACLES_V`	View to provide details about opportunity issues.
`AS_OPPORTUNITY_ORDERS_V`	Sales opportunity orders view
`AS_OPPORTUNITY_SUMMARY_V`	Sales opportunity summary view
`AS_OPP_CLASSIFICATION_V`	Sales opportunity classifications view
`AS_OPP_CONTACTS_V`	Opportunity contacts view
`AS_OPP_LINE_ADJS_BASE_V`	Displays the base information of a lead line
`AS_OPP_SALES_CREDIT_TOTALS_V`	Sales opportunity sales credit totals view
`AS_ORG_FREIGHT_ACTIVE_V`	Active shipment methods view
`AS_OTH_SALESREPS_V`	Salesperson Definition View for Others type salesreps
`AS_PARTY_ADDRESSES_V`	This view stores address information for organization, individual consumer or business contact, but without address_type column.
`AS_PARTY_CONTACTS_V`	It stores party contacts information. Party type = ?PERSON?
`AS_PARTY_CUSTOMERS_V`	This view is only a wrapper view of HZ_PARTIES
`AS_PARTY_ORG_CONTACTS_V`	It stores party/site org contacts without role type and person profile related information
`AS_PARTY_PHONES_V`	This view stores telephone and fax information for parties/sites
`AS_PARTY_RELATIONSHIPS_V`	Party relationship view
`AS_PERIOD_RATES_V`	Provides pseudo period rates for currency conversion.
`AS_PERSONS_ACTIVE_V`	Active sales representatives view
`AS_PE_INT_CATEGORIES_V`
`AS_PHONES_V`	Phones view
`AS_POLT_SC_MEMBERS_V`	Distinct sales credit members view
`AS_PRICE_LISTS_V`	Price lists view
`AS_PRIMARY_INTERESTS_ACTIVE_V`	Active primary interest codes view
`AS_PROGRAMS_V`	Promotions view
`AS_PROMOTIONS`	Promotions view (multi-org)
`AS_PROMOTIONS_ACTIVE_V`	Active promotions view
`AS_PROMOTION_CODES_V`	Promotion codes view
`AS_PROMOTION_LETTERS_V`	Promotion letters view
`AS_PROMOTION_RELATIONSHIPS_V`	Promotion relationships view
`AS_PROMOTION_SCRIPTS_V`	Promotion scripts view
`AS_PROMOTION_TYPES_ACTIVE_V`	Active promotion types view
`AS_PTR_SALESFORCE_V`	Partners from salesforce view
`AS_PTR_SALESREPS_V`	Salesperson Definition View for Partner type salesreps
`AS_QUOTAS_FORECASTS_V`	Sales quotas for forecast view
`AS_QUOTA_PROFILES_V`
`AS_QUOTES`	Quotations (multi-org)
`AS_QUOTES_V`	Quotations view
`AS_QUOTE_ITEMS_V`	Quote items view
`AS_QUOTE_LINES`	Quotation lines view (multi-org)
`AS_QUOTE_LINES_V`	Quotation lines view
`AS_QUOTE_PRICE_ITEMS_V`	Quote items pricing view
`AS_QUOTE_PRINT_V`	Quotes for printing view
`AS_QUOTE_VERSIONS_V`	Quote versions view
`AS_RA_SALESREPS`	View definition for RA_SALESREPS_ALL
`AS_REPORTING_MANAGERS_V`	Reporting managers view
`AS_ROLLING_PERIODS_V`	Rolling Periods view with periods' effective dates
`AS_RPT_ADMINS_V`	This view shows the sales reporting hierarchy information for admin
`AS_RPT_MANAGERS_V`	This view shows the sales reporting hierarchy information for manager
`AS_SALESFORCE_SUB_V`	This view shows all the salesforce from JTF resource manager who are members or managers
`AS_SALESFORCE_V`	This view shows all the salesforce from JTF resource manager
`AS_SALESGROUP_SUB_V`	This view shows all the first level sub-groups from JTF resource manager
`AS_SALESREP_JOBS_V`	Sales representative jobs view
`AS_SALES_CREDITS_V`	Provide details about sales credits for an opportunity
`AS_SALES_FORECAST_UWQ_V`	This view is used for Universal Work Queue
`AS_SALES_GROUPS_V`	This view shows all sales groups information
`AS_SALES_GROUP_ADMINS_V`	Sales group administrators view
`AS_SALES_GRP_DENORM_V`	This view shows the sales group hierarchy information
`AS_SALES_LEADS_LISTS_V`	Sales Leads List View
`AS_SALES_LEADS_V`	sales lead header details
`AS_SALES_LEAD_CONTACTS_V`	sales lead contact details
`AS_SALES_LEAD_LINES_V`	sales lead line foreign keys
`AS_SALES_LEAD_QUALS_VL`	Qualified columns ( single language view)
`AS_SALES_LEAD_RANKS_VL`	AS_SALES_LEAD_RANKS_VL is a view ofAS_SALES_LEAD_RANKS_B andAS_SALES_LEAD_RANKS_TL with MLScolumns (i.e.MEANING, DESCRIPTION)
`AS_SALES_LEAD_SCORECARD_RULE_V`
`AS_SALES_LEAD_SEED_QUAL_VL`	Qualified columns ( single language view)
`AS_SALES_LEAD_UWQ_V`	This view is used for Universal Work Queue
`AS_SALES_METHODOLOGY_VL`	Sales Methodology (Single Language View)
`AS_SALES_OPP_UWQ_V`	This view is used for Universal Work Queue
`AS_SALES_QUOTAS_V`	Sales quotas view
`AS_SALES_STAGES`	Sales stages (single org, no MLS columns)
`AS_SALES_STAGES_ALL_VL`	Sales stages (all orgs, single language view)
`AS_SALES_STAGES_VL`	Sales stages (single org, single language view)
`AS_SALES_TEAM_DISTINCT_V`	Distinct account sales team view
`AS_SALES_TEAM_EMP_V`	Sales team view for employee
`AS_SALES_TEAM_PTR_V`	Sales team view for partner
`AS_SALES_TEAM_V`	Sales team view
`AS_SCORECARD_RULES_QUAL_V`	obsolete
`AS_SCORECARD_RULES_V`	Scorecard rules
`AS_SCRIPTS_V`	Scripts view
`AS_SCRIPT_ACTUAL_ANSWERS_V`	Script actual answers view
`AS_SCRIPT_ACT_ANS_DISTINCT_Q_V`	Distinct questions from answers view
`AS_SCRIPT_ACT_ANS_DISTINCT_V`	Distinct actual answers view
`AS_SCRIPT_ANSWERS_ACTS_EXIST_V`	Script answers view
`AS_SCRIPT_ANSWER_ACTIONS`	Script answer actions (multi-org)
`AS_SCRIPT_ANSWER_ACTIONS_V`	Script actual answers view
`AS_SCRIPT_ANS_ACT_CL_V`	Create lead answer actions view
`AS_SCRIPT_ANS_ACT_EE_V`	Event answer actions view
`AS_SCRIPT_ANS_ACT_PI_V`	Product interest answer actions view
`AS_SCRIPT_ANS_ACT_SC_V`	Send collateral answer actions view
`AS_SCRIPT_CODES_V`	Script codes view
`AS_SCRIPT_PRE_DEF_ANSWERS_V`	Predefined answers view
`AS_SCRIPT_PRE_DEF_ANS_ACTIVE_V`	Active predefined answers view
`AS_SECOND_INTERESTS_ACTIVE_V`	Active secondary interests view
`AS_SF_PTR_V`	This view shows all PARTNER salesforce information
`AS_SG_ACTIVE_MGR_V`	This view shows all sales groups which has active manager information
`AS_SITE_CLASSIFICATION_V`	Site Classification View
`AS_STATUSES_VL`	MLS view to join as_statuses_b and as_statuses_tl
`AS_TAP_ACCOUNTS_V`	For TAP use
`AS_TAP_LEADS_V`	For TAP use
`AS_TAP_OPPORTUNITIES_V`	For TAP use
`AS_TAX_LINES_SUMMARY_V`	Tax lines summary view for sales tax calculation in quotes
`AS_TAX_LINES_SUMMARY_V_A`
`AS_TAX_LINES_SUMMARY_V_V`
`AS_TERRITORIES`	Obsolete. Territories (multi-org)
`AS_TERRITORIES_V`	Territories view
`AS_TERRITORY_ACCESSES_V`	Territory accesses view
`AS_TERRITORY_GROUPS`	Obsolete. Territory groups (multi-org)
`AS_TERRITORY_GROUPS_V`	Territory groups view
`AS_TERRITORY_TYPES`	Obsolete. Territory types (multi-org)
`AS_TERRITORY_TYPES_V`	Territory types view
`AS_TERRITORY_VALUES`	Obsolete. Territory values (multi-org)
`AS_TERRITORY_VALUES_V`	Territory values view
`AS_TERR_GRP_TYPE_V`	Territory information summary view
`AS_TERR_ROLLUPS_IMMEDIATE_V`	Territory rollups view
`AS_TERR_SEEDED_QUALIFIERS`	Obsolete. Territory Qualifiers (single org, no MLS columns)
`AS_TERR_SEEDED_QUALIFIERS_V`	Seeded territory qualifiers view
`AS_TERR_SEED_QUALIFIERS_ALL_VL`	Territory Qualifiers (all orgs, single language view)
`AS_TERR_SEED_QUALIFIERS_VL`	Seeded qualifiers view for multi-org purposes (single org, single language)
`AS_TERR_TYPE_QUALIFIERS_V`	Territory type qualifiers view
`AS_TODO_LISTS`	To do lists (multi-org)
`AS_TODO_LISTS_V`	To do lists view
`AS_VIEW_FORECAST_V`	Forecast detail view
`AS_WAREHOUSES_ACTIVE_V`	Active warehouses view
`AS_WORD_PROCESSORS`	Word Processors (multi-org)
`AS_WORD_PROCESSORS_ACTIVE_V`	Active word processors view