You are browsing the archive for AST.

Oracle TeleSales Tables

Oracle Tele Sales module database tables:

  • AST_ASSISTS
  • AST_CGI_SWITCHES
  • AST_ENTITY_REFRESH_LOG
  • AST_GRP_CAMPAIGNS
  • AST_PHONE_ASSISTS
  • AST_QUERY_STRINGS
  • AST_RS_CAMPAIGNS
  • AST_SALES_GROUPS_TEMP
  • AST_SWITCH_DATA
  • AST_WEB_ASSISTS
  • AST_WEB_SEARCHES

TeleSales Profile Options

Oracle TeleSales Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
AST_AT_A_GLANCE_DISPLAY_MENU OTS: At a Glance Display Menu
AST_CUORD_DEFAULT_MONTHS_TO_VIEW_ORDER OTS: Order History – Number of Months to Display Orders
AST_AT_A_GLANCE_EXPAND_HGRID OTS: At a Glance Dashboard HGrid Expanded Display
AST_MV_REFRESH_EXECUTE_CALLOUTS OTS: At a Glance – Execute User Callouts For Data Refresh
AST_SERVICE_REQ_ACTIVITY OTS: Interactions-Generate Service Request Activity
AST_AT_A_GLANCE_DASHBOARD_REFRESH OTS: At a Glance – Enable Dashboard Data Refresh at form startup
AST_CUORD_DEFAULT_FILTER_BY OTS: Order History – Default value for Filter
AST_MAX_INTERACTIONS OTS: Interactions – Maximum multiple interactions
AST_SOURCE_UWQ_OPP OTS: UWQ – Display Source Code and Name for Opportunity Nodes
AST_CUTSK_QUERY_TYPE OTS: Task Details – Query Task By
AST_IN_ACTIVE_LOV_PARTY OTS: Customer – Display Inactive Records For Party List Of Values
AST_SCRIPT_LANG OTS: Script Language
AST_USE_EMAIL_CENTER OTS: Enable Email Center Integration
AST_CU_CONCAT_ADDR_STYLE OTS: Customer – Include Address Style In Concatenated Format
AST_WP_USE_ADDRESS_FOR_LEAD OTS: Use Primary Address To Create Lead in UWQ
AST_IDENTIFYING_ADDRESS_FLAG OTS: Identifying Address
AST_MLIST_ALL_CAMPAIGNS OTS: Marketing List All Campaigns
AST_DEFAULT_GROUP OTS: Default User Sales Group
AST_ADV_OUTBOUND OTS: Advanced Outbound Installation
AST_NOTES_REL_SUBJECT OTS: Auto-relate Relationship note to Subject
AST_ENABLE_RELATIONSHIP_PLAN OTS: Relationship Plans – Enable Relationship Plans
AST_WP_USE_ADDRESS_FOR_OPP OTS: Use Primary Address To Create Opportunity in UWQ
AST_TASK_ACCOUNT OTS: Relate Account to Tasks and Notes
AST_DEFAULT_PRIOR_DAYS OTS: Number of Days Prior to View
IEU_QEN_PERSONAL_LIST_-_OPPORTUNITIES IEU: Queue: Personal List – Opportunities
IEU_QOR_PERSONAL_LIST_-_OPPORTUNITIES IEU: Queue Order: Personal List – Opportunities
AST_ACTIVE_SAVED_LIST OTS: Number of Active Saved Lists
AST_NO_REC_PER_SAVELIST OTS: Number of Records per Saved List
AST_DEFAULT_SCRIPT OTS:Scripting-Default Script.
AST_SUSPENDED_SCRIPT_SECURITY OTS:Scripting-Apply Security for Suspended Scripts.
AST_COLLATERAL_ORGANIZATION OTS: Collateral Organization
AST_QEN_LEADS OTS: Queue : Leads(1)
AST_QOR_LEADS OTS: Queue Order : Leads(1)
AST_QEN_OPPORTUNITIES OTS: Queue : Opportunities(1)
AST_QOR_OPPORTUNITIES OTS: Queue Order : Opportunities(1)
AST_QEN_FORECASTS OTS: Queue : Forecasts(1)
AST_QOR_FORECASTS OTS: Queue Order : Forecasts(1)
AST_CC_INTEGRATED_TELEPHONY_LOGIN OTS: Enable Integrated Telephony Login
AST_CALL_TYPE_EBC OTS: Calendar Type in EBC
AST_SALES_ORD_SALESREP_DEFAULT OTS: Sales Order Default Salesrep from OM
AST_SALES_ORD_ADD_DEFAULT OTS: Sales Order Default Address Source
AST_LEAD_OPPOR_REL_INTERACTION OTS: Lead and Opportunity Center Party Relationship Interaction
AST_INTERACTION_FOR_CTI OTS: Honor Interaction Profiles when CTI is enabled
IEU_QEN_PERSONAL_LIST_-_CONTACTS IEU: Queue: Personal List – Contacts
IEU_QOR_PERSONAL_LIST_-_CONTACTS IEU: Queue Order: Personal List – Contacts
AST_NOTES_LEAD_CUSTOMER OTS: Auto-relate Lead note to Customer
AST_DEFAULT_ROLE_AND_GROUP OTS: Default User Role and Sales Group
AST_QEN_Opportunities OTS: Queue : Opportunities
AST_QEN_Forecasts OTS: Queue : Forecasts
AST_SHOW_ALL_LIST OTS: Show All List
AST_CL_SUBJECT_LINE OTS: Default Collateral Subject Line
AST_DEFAULT_MONTHS_TO_VIEW OTS: Number of Months to view Notes and Interactions for
AST_NOTES_DEFAULT_TYPE OTS: Default Note Type
AST_SLC_DEFAULT_TAB OTS: Default Tab in Sales Lead Center
AST_DEFAULT_UNIVERSAL_SEARCH_TYPE OTS: Default Universal Search Type
AST_SHOW_CAMPAIGN_OFFER_NAMES OTS: Show Campaign and Offer Names instead of Codes
AST_MATCH_CAMP_DNIS OTS: Match DNIS for Source Code
AST_INTERACTIONS_ON_QUERY OTS: Interactions-Start On Query
AST_SCRIPT_ON_DELIVERY OTS: Script Launch on UWQ Delivery
AST_TASK_ACTIVITY OTS: Interactions-Generate Task Activity
AST_ADDRESS_URL OTS: URL to display a map of the address
AST_NOTES_REL_OBJECT OTS: Auto-relate Relationship note to Object
AST_DEFAULT_ACTIONITEM OTS: Interactions-Default Action Item
IEU_MYTEAM_QEN_LEADS IEU: Queue: My Team Leads
AST_SCRIPT_ON_INTERACTION OTS: Script Launch on Interaction
AST_QOR_QUOTES IEU: Queue Order: Quotes
AST_DEFAULT_OUTCOME OTS: Interactions-Default Outcome
AST_DEFAULT_ACTION OTS: Interactions-Default Action
IEU_MYTEAM_QEN_OPPORTUNITIES IEU: Queue: My Team Opportunities
AST_QEN_QUOTES IEU: Queue: Quotes
AST_DEFAULT_UNIVERSAL_SEARCH_TAB OTS: Default Universal Search Tab
AST_INTERACTION_AUTO_WRAPUP OTS: Interactions-Enable Auto Wrapup
AST_EBC_DEFAULT_TAB OTS: Default Tab in eBusiness Center
AST_SCRIPTING_JNDI OTS: Scripting JNDI
AST_DUP_OPPTY_CURRENCY OTS: Currency define dupe opportunity
AST_COLLATERAL_ACTIVITY OTS: Interactions-Generate Collateral Activity
AST_NOTES_ACTIVITY OTS: Interactions-Generate Notes Activity
AST_DUP_OPPTY_OPP_NUM OTS: Opportunity number define dupe opportunity
AST_AGING_ABANDON_ACTIONS OTS: Lead Aging Abandon – Action
AST_DEFAULT_QUOTE_SCREEN OTS: Default Quote Form
AST_SCALING_FACTOR OTS: Amount Scaling Factor
AST_DEFAULT_RELATIONSHIP OTS: Default Relationship
AST_EXTERNAL_REF_DD_PARAM OTS: External Ref Drill Down Param
AST_DFLT_COLL_COVER_LETTER OTS: Default Cover Letter for Collateral Requests.
AST_CU_ENABLE_CUST_STD OTS: Enable Customer Standard Navigation
IEU_MYTEAM_QOR_OPPORTUNITIES IEU: Queue Order: My Team Opportunities
IEU_QOR_MLISTS IEU: Queue Order: Marketing Lists
AST_EXTERNAL_REF_DD OTS: External Ref Drill Down
AST_FORM_JSP_DETAILS OTS: JSP Details from OTS
AST_DEFAULT_SOURCE_CODE OTS: UWQ Default Source Code
AST_CHG_INT_ACTIVITY OTS: Interactions-Enable Change Activity
AST_SL_DEBUG_VALID_LEVEL OTS: Validation Level for Sales Leads
AST_MEDIAITEM_INTERACTION OTS: Interactions-Record Media Item ID
AST_NO_MEDIAITEM_INTERACTION OTS: Interactions-Record Media Item ID-old
AST_DEFAULT_TASK_DATE_TYPE OTS: Default Task Date Type
AST_DEFAULT_ROLE OTS: Default User Role
AST_LAUNCH_OPP_LEAD OTS: UWQ – auto launch lead and oppty center
AST_DEFAULT_OPP_CENTER_TAB OTS: Default Tab in Opportunity Center
AST_APPLICATION_ID OTS : Application Id for TCA V2 API Input Parameter
AST_INTERACTION_HISTORY_EXP OTS: Display Interaction History in an expanded mode
AST_OPP_HISTORY_EXPANDED OTS: Opportunity History Expanded Display
AST_QUERY_ACTIVITY OTS: Interactions: Generate Query Activity
AST_CUORD_CROSS_ORG_DETAILS OTS: Order History View Orders across Operating Units
AST_INT_WRAPUP_PROMPT OTS: Interactions – Prompt for Wrapup
AST_MV_NUM_OF_MONTH_DATA OTS: At a Glance – Number of Months of Data to Show
AST_DEFAULT_COLL_PRINTER OTS: Default Collateral Printer Name.
AST_ENABLE_WEB_COLLABORATE OTS: Enable Web Collaboration.
AST_WEB_COLLABORATE_URL OTS: URL Web Collaboration Start Page.
AST_CTI_DIAL_ALLOWED OTS: Enable dialing from eBusiness Center
AST_COLLTRL_SOURCE_CODE OTS: Order Source Code
AST_DEBUG OTS: Debug
AST_SCRIPTING_PORT OTS: Scripting Port
AST_DUP_OPPTY_PROMO OTS: Promotion define dupe opportunity
AST_DUP_OPPTY_CREATE_DT OTS: Creation Date define dupe opportunity
AST_SCRIPTING_USES_AOL_USER OTS: Scripting Uses AOL User
AST_DEFAULT_SITE_USE_CODE OTS: Default Site Usage
AST_EVENT_CREATE_ORDER OTS: Create Order for Event
AST_LEAD_ASSIGN_MANUAL OTS: Assign New Lead Manually
AST_CU_CREATE_REL_ADDR_FOR_ORG OTS: Associate Relationship Location with Organization
AST_CU_ENABLE_ADDR_VAL OTS: Enable Address Validation
AST_LOOKUP_EXPORT_PATH OTS: Lookup Export Directory Path
AST_MIN_LKUP_CHARS OTS: Minimum Number of Characters for Lookup
AST_CONTACT_ACTIVITY OTS: Generate Contact Activity
AST_EVENT_ACTIVITY OTS: Interactions-Generate Event Activity
AST_LEAD_ACTIVITY OTS: Interactions-Generate Lead Activity
AST_OPP_ACTIVITY OTS: Interactions-Generate Opportunity Activity
AST_ADV_INBOUND OTS: Advanced Inbound Installation
AST_SCRIPTING_INSTALLED OTS: Scripting Installation
AST_SCRIPTING_EMBED OTS: Scripting Embedded
AST_IH_MAX_INTERACTIONS OTS: Max Interactions Displayed
AST_SCRIPTING_SERVER OTS: Scripting Server Host Name
AST_SCRIPTING_SID OTS: Scripting Database SID
AST_DUP_OPPTY_CNTCT_NAME OTS: Contact Name Required to define dupe opportunity
AST_DUP_OPPTY_ROLE OTS: Dup opportunity role
AST_DUP_OPPTY_PRJCT_NAME OTS: Project name define dupe opportunity
AST_DUP_OPPTY_TOTAL_AMT OTS: Total amount define dupe opportunity
AST_AGING_DAYS_ABANDON OTS: Lead Aging Days to abandon
AST_AGING_DAYS_NOACT OTS: Leads Aging No Action
AST_AGING_NOACT_ACTIONS OTS: Lead Aging No Action – Action
AST_CONTACT_ROLE OTS: Contact Role
AST_SHOW_PROFILE OTS: Display Customer Profile
AST_PRIMARY_CONTACT_ROLE_FLAG OTS: Primary Contact Role Flag
AST_DEFAULT_PARTY_TYPE OTS: Default Party Type
AST_RANK_LEAD_OPTION OTS: Rank Lead Option
AST_NOHANGUP_ON_END OTS: NOHANGUP_ON_END
AST_DEFAULT_COUNTRY OTS: Default Country
AST_DEFAULT_PERSON_TITLE OTS: Default Person Title
AST_DEFAULT_PHONE_TYPE OTS: Default Phone Line Type
AST_ENABLE_TRACE OTS: Enable SQL Tracing
AST_INTERACTIONS OTS: Interactions-Enable Automatic Start
AST_SCRIPTING_THREE_TIER OTS: Scripting Three Tier
AST_CUSTOMER_ACTIVITY OTS: Interactions-Generate Customer Activity
AST_DEFAULT_TASK_STATUS OTS: Default Task Status
AST_DUMP_PARAMS OTS: Dump UWQ Params
AST_DFLT_HARD_SHIP_METHOD OTS: Default Shipping Method for Physical collateral
IEU_MYTEAM_QOR_LEADS IEU: Queue Order: My Team Leads
IEU_QEN_MLISTS IEU: Queue: Marketing Lists
AST_DFLT_SOFT_SHIP_METHOD OTS: Default Shipping Method for Electronic collateral
AST_HANGUP_ON_END OTS: Hang Up On End
AST_QEN_Leads OTS: Queue : Leads
AST_QOR_Opportunities OTS: Queue Order : Opportunities
AST_EV_REPLY_TO OTS: Default Event Reply to Email Address
AST_DEFAULT_NOTE_MONTHS OTS: Number of Months to view Notes for
AST_NOTES_LEAD_CONTACT OTS: Auto-relate Lead note to Primary Contact
AST_NOTES_REL_ORG OTS: Auto-relate Relationship note to Organization
AST_DEFAULT_ORDER_SCREEN OTS: Default Order Form
AST_ANI_WITHOUT_AREACODE OTS: ANI with No Area Code
AST_QOR_Leads OTS: Queue Order : Leads
AST_CL_REPLY_TO OTS: Default Collateral Reply To Email Address
AST_NOTES_OPP_CONTACT OTS: Auto-relate Opportunity note to Primary Contact
AST_NOTES_OPP_CUSTOMER OTS: Auto-relate Opportunity note to Customer
AST_QOR_Forecasts OTS: Queue Order : Forecasts
AST_EV_SUBJECT_LINE OTS: Default Event Subject Line

Views in TeleSales Module

Views in Oracle TeleSales Module

AST_ACCOUNT_PARTIES_V
AST_ACCT_RELATIONSHIP_V
AST_ACCT_SITE_USES_V
AST_ACTIVITIES_V
AST_AGENT_SCRIPTS_V
AST_AVAIL_SCRIPTS_V
AST_BILLING_PREFERENCES_V
AST_BUSINESS_CONTACTS_V
AST_CAMP_DELV_ASSOCIATIONS_V
AST_CAMPAIGN_LOV_V
AST_CAMPAIGNS_LOV_V
AST_COLL_REVIEW_KITS_V
AST_COLLTRL_HISTORY_V
AST_CONT_CLASSIFICATION_INT_V
AST_CONTACT_CLASSIFICATION_V
AST_CONTACT_POINTS_V
AST_CONTACT_RESTRICTIONS_V
AST_CUST_ACCOUNTS_ROLES_V
AST_CUST_ACCT_BALI_V
AST_CUST_ACCT_OVERVIEW_V
AST_CUST_ACCT_SITES_V
AST_CUST_PROFILE_CREDIT_V
AST_CUST_SITE_USES_V
AST_CUSTOMER_UWQ_LOV_V
AST_EDUCATION_V
AST_EMPLOYMENT_HISTORY_V
AST_ENTY_ATTR_VALUES_SL_V
AST_ENTY_ATTR_VALUES_V
AST_EV_HIS_ORG_V
AST_EV_HIS_PER_V
AST_EVENT_DELIVERABLES_V
AST_EVENT_ENROLLEES_V
AST_EVENT_HISTORY_V
AST_FORECAST_UWQ_V
AST_GRP_CAMPAIGN_SCHEDS_V
AST_GRP_CAMPAIGNS_V
AST_IH_CAMP_RESULT_REASONS_VL
AST_IH_CAMPAIGNS_RESULTS_VL
AST_IH_OUTCOMES_CAMPAIGNS_VL
AST_INV_ITEM_LOV_V
AST_ITEM_RELATIONSHIPS_V
AST_L_CONTACT_ADDR_V
AST_L_CONTACT_POINTS_V
AST_LM_CKEY_ACCT_V
AST_LM_CKEY_CSI_V
AST_LM_CKEY_PARTY_V
AST_LM_CKEY_TAX_EREF_V
AST_LM_COLLATERAL_V
AST_LM_EVENTS_SRC_V
AST_LM_EVENTS_V
AST_LM_LEADS_QUICK_CAMPAIGN_V
AST_LM_LEADS_QUICK_GROUP_V
AST_LM_LEADS_QUICK_INT_PC_V
AST_LM_LEADS_QUICK_INTEREST_V
AST_LM_LEADS_QUICK_V
AST_LM_OPP_EXP_CR_TYPE_V
AST_LM_OPP_EXPANDED_V
AST_LM_OPP_QUICK_CAMP_V
AST_LM_OPP_QUICK_INTTYPES_V
AST_LM_OPP_QUICK_RESULTS_V
AST_LM_OPP_QUICK_SGRP_V
AST_LM_OPP_QUICK_SREP_V
AST_LM_ORG_EXP_V
AST_LM_ORG_EXPAND_ALL_V
AST_LM_ORG_EXPAND_V
AST_LM_ORG_EXPAND_W_ACC_V
AST_LM_ORG_FUZZY_V
AST_LM_ORG_QUICK_V
AST_LM_ORG_QUICK_W_ACC_V
AST_LM_ORG_SMARTSEARCH_V
AST_LM_PER_EXPAND_ALL_V
AST_LM_PER_EXPAND_V
AST_LM_PER_EXPAND_W_ACC_V
AST_LM_PER_FUZZY_V
AST_LM_PER_QUICK_V
AST_LM_PER_QUICK_W_ACC_V
AST_LM_PER_SMARTSEARCH_V
AST_LM_QUOTES_V
AST_LM_REL_EXPAND_ALL_V
AST_LM_REL_EXPAND_V
AST_LM_REL_EXPAND_W_ACC_V
AST_LM_REL_FUZZY_V
AST_LM_REL_FUZZYCNT_V
AST_LM_REL_QUICK_V
AST_LM_REL_SMARTSEARCH_V
AST_LOCATION_SITE_USE_V
AST_LOCATIONS_V
AST_LOOKUPS
AST_LS_CAMPAIGNS_V
AST_LS_LIST_HEADERS_V
AST_LS_SALES_LEADS_BSC_V
AST_LS_SALES_LEADS_CONTACT_V
AST_LS_SALES_LEADS_V
AST_LS_SAVED_QUERIES_V
AST_MLIST_ALL_UWQ_V
AST_MLIST_ALLSECURE_UWQ_V
AST_MLIST_SECURE_UWQ_V
AST_MLIST_UWQ_V
AST_MLIST1_ALL_UWQ_V
AST_MLIST1_UWQ_V
AST_MYTEAM_SALESLEAD_UWQ_REF_V
AST_MYTEAM_SALESLEAD_UWQ_S_V
AST_MYTEAM_SALESLEAD_UWQ_V
AST_MYTEAM_SALESOPP_CODE_UWQ_V
AST_MYTEAM_SALESOPP_NAME_UWQ_V
AST_MYTEAM_SALESOPP_UWQ_R_S_V
AST_MYTEAM_SALESOPP_UWQ_REF_V
AST_MYTEAM_SALESOPP_UWQ_V
AST_NOTES_BALI_VL
AST_NOTES_CONTEXTS_V
AST_NOTES_DETAILS_VL
AST_OFFER_ONLY_V
AST_OPPORTUNITIES_BALI_V
AST_OPPORTUNITY_BRIEF_V
AST_OPPORTUNITY_CONTACT_V
AST_OPPORTUNITY_DET_V
AST_OPPORTUNITY_LINES_V
AST_OPPORTUNITY_LOG_V
AST_OPPORTUNITY_LOGS_V
AST_OPPORTUNITY_V
AST_ORDER_HEADERS_V
AST_ORG_CONTACT_ROLES_V
AST_ORG_CONTACTS_V
AST_ORG_DUPLICATE_V
AST_ORG_PARTIES_V
AST_ORG_PROFILES_V
AST_ORG_V
AST_PARTNER_LOV_V
AST_PARTY_CLASSIFICATION_V
AST_PARTY_LOCATIONS_V
AST_PER_DUPLICATE_V
AST_PER_V
AST_PERSON_INTEREST_V
AST_PERSON_LANGUAGE_V
AST_PERSON_PARTIES_V
AST_PERSON_PROFILE_V
AST_PHONE_ASSISTS_V
AST_PLIST_NAMES_UWQ_V
AST_PLIST_OPP_UWQ_V
AST_PLIST_PERS_UWQ_V
AST_PLIST_REF_OPP_UWQ_V
AST_PLIST_REF_UWQ_V
AST_PLIST_REL_UWQ_V
AST_PTR_RELATION_ATTRIBS_V
AST_PTR_RELATION_DETAILS_V
AST_PURCH_LINES_V
AST_QUOTES_UWQ_V
AST_REL_V
AST_RELATIONSHIP_DETAILS_V
AST_RELATIONSHIP_V
AST_RES_TEAM_MEMBERS_V
AST_RESOURCE_TEAM_V
AST_RS_CAMPAIGN_SCHEDS_V
AST_RS_CAMPAIGNS_V
AST_RS_GRP_VALID_V
AST_RS_VALID_V
AST_SALES_CREDITS_V
AST_SALES_GROUP_ADMINS_V
AST_SALES_LEAD_CONTACTS_V
AST_SALES_LEAD_LINES_PC_V
AST_SALES_LEAD_LINES_V
AST_SALES_LEAD_UWQ_V
AST_SALES_LEADS_BALI_V
AST_SALES_LEADS_EBC_V
AST_SALES_LEADS_REL_BALI_V
AST_SALES_LEADS_V
AST_SALES_OPP_UWQ_V
AST_SALES_TEAM_EMP_V
AST_SALES_TEAM_PTR_V
AST_SALESLEAD_UWQ_REF_V
AST_SALESLEAD_UWQ_V
AST_SALESOPP_CODE_UWQ_V
AST_SALESOPP_NAME_UWQ_V
AST_SALESOPP_UWQ_REF_SUB_V
AST_SALESOPP_UWQ_REF_V
AST_SALESOPP_UWQ_V
AST_SALESREP_LOV_UWQ_V
AST_SALESREP_LOV_V
AST_SOURCE_AVAIL_SCRIPTS_V
AST_SOURCE_CODES_LOV_V
AST_SOURCE_ONLY_V
AST_SUBJECT_RELATIONSHIP_V
AST_SUSPENDED_SCRIPTS_V
AST_SUSPENSION_ACTIVITY_V
AST_TARGET_CAMPAIGNS_V
AST_TASK_ASSIGNMENTS_V
AST_TASKREF_V
AST_TASKS_MAIN_V
AST_TASKS_V
AST_WEB_ASSIST_DETAILS_V
AST_WEB_SWITCH_DETAILS_V
AST_WKQ_CONTACTS_V
AST_WKQ_PHONES_V