You are browsing the archive for ASO.

Oracle Order Capture Tables

Oracle Order Capture module data base tables:

  • ASO_APR_APPROVAL_DETAILS
  • ASO_APR_APPROVAL_DET_B
  • ASO_APR_APPROVAL_DET_TL
  • ASO_APR_FUNCTION
  • ASO_APR_OBJ_APPROVALS
  • ASO_APR_RULES
  • ASO_APR_RULES_B
  • ASO_APR_RULES_TL
  • ASO_APR_RULE_APPROVERS
  • ASO_APR_RULE_GROUPS_B
  • ASO_APR_RULE_GROUPS_TL
  • ASO_APR_RULE_GRP_MEMBER
  • ASO_APR_RULE_STEPS_B
  • ASO_APR_RULE_STEPS_TL
  • ASO_BI_LINE_IDS
  • ASO_BI_QUOTE_FACT_JOBS
  • ASO_BI_QUOTE_HDRS_ALL
  • ASO_BI_QUOTE_HDRS_STG
  • ASO_BI_QUOTE_IDS
  • ASO_BI_QUOTE_LINES_ALL
  • ASO_BI_QUOTE_LINES_STG
  • ASO_ER_BIN_RS_FACT
  • ASO_ER_DATA_BIN_FACT
  • ASO_ER_ORD_HDRS_FACT
  • ASO_ER_ORD_LINES_FACT
  • ASO_ER_QTE_HDRS_FACT
  • ASO_ER_QTE_LINES_FACT
  • ASO_ER_REFRESH_LOG
  • ASO_FREIGHT_CHARGES
  • ASO_HEADER_RELATIONSHIPS
  • ASO_LINE_RELATIONSHIPS
  • ASO_PARTY_RELATIONSHIPS
  • ASO_PAYMENTS
  • ASO_PRICE_ADJUSTMENTS
  • ASO_PRICE_ADJ_ATTRIBS
  • ASO_PRICE_ADJ_RELATIONSHIPS
  • ASO_PRICE_ATTRIBUTES
  • ASO_QUOTE_ACCESSES
  • ASO_QUOTE_HEADERS_ALL
  • ASO_QUOTE_LINES_ALL
  • ASO_QUOTE_LINE_ATTRIBS_EXT
  • ASO_QUOTE_LINE_DETAILS
  • ASO_QUOTE_PARTIES
  • ASO_QUOTE_RELATED_OBJECTS
  • ASO_QUOTE_STATUSES_B
  • ASO_QUOTE_STATUSES_TL
  • ASO_QUOTE_STATUS_TRANSITIONS
  • ASO_SALES_CREDITS
  • ASO_SHIPMENTS
  • ASO_SUP_COMPONENT_B
  • ASO_SUP_COMPONENT_TL
  • ASO_SUP_COMP_RESP_MAP
  • ASO_SUP_INSTANCE_VALUE
  • ASO_SUP_RESPONSE_B
  • ASO_SUP_RESPONSE_TL
  • ASO_SUP_SECTION_B
  • ASO_SUP_SECTION_TL
  • ASO_SUP_SECT_COMP_MAP
  • ASO_SUP_TEMPLATE_B
  • ASO_SUP_TEMPLATE_SCOPE
  • ASO_SUP_TEMPLATE_TL
  • ASO_SUP_TMPL_INSTANCE
  • ASO_SUP_TMPL_SECT_MAP
  • ASO_TAX_DETAILS
  • ASO_UPGRADE_ERRORS

Order Capture Profile Options

Oracle Order Capture Profile Options:

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
ASO_AUTO_SALES_CREDIT ASO : Automatic Sales Credit Allocation
ASO_SALES_CREDIT_UPDATE ASO : Run Sales Credit Update for Quote Lines
ASO_PROJ_COMMISSION ASO : Calculate Projected Commission
ASO_DEFAULT_LAYOUT_TEMPLATE ASO: Default Layout Template
ASO_DISABLE_SIDEBAR_MENU ASO: Disable HTML UI SideBar Menu
ASO_UPDATE_MODEL_QTY ASO : Allow Quantity Updates for Top Level Model Item
ASO_AUTO_ACCOUNT_CREATE ASO : Auto Account Creation
ASO_CALCULATE_TAX ASO : Calculate Tax
ASO_CREDIT_CHECK_RULE ASO : Credit Check Rule
ASO_MAX_COUNT_FOR_QUERY ASO: Max Number of Results
ASO_ENFORCE_ACCOUNT_RELATIONSHIPS ASO: Enforce Account Relationships
ASO_ENABLE_BATCH_PROCESSING ASO : Enable Batch Processing
ASO_CALCULATE_PRICE ASO : Calculate Price
ASO_USE_INTERMEDIA_SEARCH ASO : Enable Intermedia Search
ASO_DEFAULT_IB_RELATIONSHIP ASO : Default Install Base Relationship
ASO_USE_NETWORK_CONTAINER ASO : Use Network Container
ASO_UPDATE_COMPONENT_QTY ASO : Allow Quantity Updates for Component Item
ASO_ENABLE_LINE_PAYMENTS ASO : Enable Line Level Payments
ASO_USE_DEAL ASO : Enable Deals
ASO_FILTER_SERVICE_RF_END_CUST ASO: Filter Service Reference By End Customer
ASO_QUOTE_APPROVER_RESP ASO: Quote Approver Responsibility
ASO_RISK_MANAGE_CC_AUTH ASO : Enable Risk Management on Credit Card Authorization
ASO_PRICING_CHANGE_ALERT ASO: Pricing Change Alert
ASO_DEFAULT_CHANGE_REASON ASO : Default Price Change Reason
ASO_MAX_DAYS_IN_EXP_DATE_RANGE ASO: Maximum Days in Expiration Date Range
ASO_OPER_OVERRIDE ASO : Operating Unit Override
ASO_ENABLE_DEFAULTING_RULE ASO: Enable Defaulting Rule
ASO_SHIP_FROM_ORG_ID ASO : Default Ship From Org
ASO_AUTO_NUMBERING ASO : Automatic Numbering
ASO_DEFAULT_STATUS_CODE ASO : Default Quote Status
ASO_QUOTE_DURATION ASO : Quote Duration
ASO_RESERVATION_LEVEL ASO : Reservation Level
ASO_TRX_SOURCE_TYPES ASO : Transaction Source Type
ASO_CC_AUTHORIZATION_ENABLED ASO : Credit Card Authorization
ASO_QUOTE_CONVERSION_TYPE ASO : Quote Conversion Type
ASO_DEFAULT_ORDER_STATE ASO : Default Order State
ASO_DEFAULT_QTY ASO : Default Ordered Quantity in OC UI
ASO_OM_DEFAULTING ASO : OM Defaulting
ASO_OF_RETENTION_TIME ASO : Order Feedback Queue Retention Time
ASO_VALIDATE_SALESREP ASO : Validate Salesrep
ASO_RET_REASON_CODE ASO : Default Return Reason
ASO_TCA_VALIDATE ASO : Enable TCA Changes
ASO_ATP_USE_SOURCING_RULE ASO : ATP Use Sourcing Rule
ASO_AST_DEFAULT_ORDER_FORM ASO : Default E-Business Order Screen
ASO_CREATE_CUST_ACCOUNT ASO : Create Customer Account
ASO_ENABLE_DEBUG ASO : Enable ASO Debug
ASO_ENABLE_DEBUG_EMAIL ASO : Enable Email for Debug
ASO_ENTER_CUSTOMER_ALLOWED ASO : Create New Customer
ASO_ENABLE_SAVE_ATP ASO : Enable Manual Warehouse Selection
ASO_ENABLE_LINE_TYPE ASO : Enable Line Type
ASO_AST_DEFAULT_QUOTE_FORM ASO : Default E-Business Quote screen
ASO_USE_CONTRACTS ASO : Enable Use Contracts
ASO_DEFAULT_SALES_CHANNEL ASO : Default Sales Channel
ASO_USE_PUBLISHING ASO : Enable Web Publishing
ASO_API_ENABLE_SECURITY ASO : Security Enable from API
ASO_MINUS_FOR_MANU_DIS ASO : Require Minus Sign For Manual Discount
ASO_UPDATE_CUSTOMER ASO : Update Customer
ASO_DEFAULT_EXP_GL_PERIOD ASO : Default Expiration GL Period Type
ASO_UPDATE_SALES_TEAM ASO : Update Sales Team
ASO_ENABLE_SALES_SUPPLEMENT ASO : Enable Sales Supplement
ASO_CATEGORY_SET ASO : Category Set
ASO_OM_ACCESS ASO : OM Access
ASO_DIAG_EMAIL_ADDRESS ASO : Email Address to send Diagnostic Messages
ASO_DISCOUNTING_PRIVILEGE ASO : Discounting Privilege
ASO_ENABLE_SUBMIT_BUTTON ASO : Enable Submit Button
ASO_GSA_PRICING ASO : GSA Pricing
ASO_ENABLE_SECURITY_CHECK ASO : Enable Security Check
ASO_PRICE_LIST_OVERRIDE ASO : Price List Override
ASO_USE_LINE_BILLING ASO : Enable Line Level Billing
ASO_API_MGR_ROLE_ACCESS ASO : Manager Role Access
ASO_USE_CREDIT_CHECK ASO : Enable Credit Check
ASO_WEB_ATTR_FILTER ASO : Filter Product Search By Web Attributes
ASO_COMP_LOGO ASO : Company Report Logo
ASO_STATUS_OVERRIDE ASO : Status Override
ASO_REQUIRE_SERVICE_REFERENCE ASO : Require Service Reference on Add to Quote
ASO_DEFAULT_EXP_GL_CAL ASO : Default Expiration GL Calendar
ASO_REQUIRE_GROUP ASO : Require Group
ASO_NEW_QUOTE_SECURITY ASO : New Quote Security
ASO_USE_APPROVAL ASO : Enable Approvals
ASO_SKIP_APPROVERS ASO : Allow Skip Approvers
ASO_DEF_SALES_SUPP_TEMPLATE ASO : Default Header Level Sales Supplement Template
ASO_INSTANTIATE_CONTRACT ASO : Enable Instantiate Contract When Default Terms and Conditions Needed
ASO_ADMIN_EMAIL ASO : Adminstrator Email Address
ASO_DEFAULT_IB_SEARCH ASO : Default IB Search Results
ASO_MAX_IB_SEARCH_RESULTS ASO: Max Number of IB Search Results
ASO_DISPLAY_IB_ATTRIBUTES ASO : Display Installed Base Attributes
ASO_DEF_LINE_SALES_SUPP_TEMPLATE ASO : Default Line Level Sales Supplement Template
ASO_ENABLE_LINE_ADJ_FOR_PRG ASO : Enable Promotional Good Price Override
ASO_MODIFY_SALES_CREDITS ASO : Modify Sales Credits
ASO_VIEW_SALES_CREDITS ASO : View Sales Credits
ASO_AUTO_TEAM_ASSIGN ASO : Automatic Sales Team Assignment

Views in Orders Capture Module

Views in Oracle Orders Capture Module

ASO_AK_QUOTE_HEADER_V
ASO_AK_QUOTE_LINE_V
ASO_AK_QUOTE_OPPTY_V
ASO_AK_QUOTE_RELATED_RECORDS_V
ASO_APPROVAL_INSTANCES_ALL_V
ASO_APPROVAL_RULES_ALL_V
ASO_APPROVER_DETAILS_V
ASO_BI_PROSPECT_V
ASO_EXTENDED_ATTRIBS_BALI_V
ASO_I_ACCT_SITE_ADDR_V
ASO_I_AGREEMENTS_V
ASO_I_ATP_ERRORS_V
ASO_I_CAMPAIGN_GEO_AREAS_V
ASO_I_CAMPAIGNS_V
ASO_I_CONTACT_POINTS_V
ASO_I_COUNTRIES_V
ASO_I_CREDIT_CARDS_V
ASO_I_CURRENCIES_V
ASO_I_CUST_ACCOUNTS_V
ASO_I_FREIGHT_CODES_V
ASO_I_GL_CONV_TYPES_V
ASO_I_HR_PEOPLE_V
ASO_I_INVOICES_V
ASO_I_ITEM_UOMS_V
ASO_I_ITEMS_V
ASO_I_LINE_TYPES_V
ASO_I_MKTG_SRC_CODES_V
ASO_I_OE_ORDER_HEADERS_V
ASO_I_OE_ORDER_LINES_V
ASO_I_OE_SALES_CREDITS_V
ASO_I_ORDER_HEADERS_BALI_V
ASO_I_ORDER_HEADERS_V
ASO_I_ORDER_LINES_V
ASO_I_ORDER_PRICE_ADJS_V
ASO_I_ORDER_SOURCES_V
ASO_I_ORDER_TYPES_V
ASO_I_ORG_CONTACTS_V
ASO_I_PARTIES_V
ASO_I_PARTY_ADDRESSES_V
ASO_I_PARTY_SITES_V
ASO_I_PAYMENT_OPTIONS_V
ASO_I_PAYMENT_TERMS_V
ASO_I_PAYMENT_TYPES_V
ASO_I_PRICE_LIST_LINES_V
ASO_I_PRICE_LISTS_V
ASO_I_QUOTE_HEADERS_BALI_V
ASO_I_RA_SALESREPS_V
ASO_I_RECEIPT_METHODS_V
ASO_I_RELATED_ITEMS_V
ASO_I_RETURN_CODES_V
ASO_I_RETURN_TYPES_V
ASO_I_SALES_CHANNELS_V
ASO_I_SALES_CREDIT_TYPES_V
ASO_I_SEARCH_ORDERS_V
ASO_I_SERVICE_TYPES_V
ASO_I_SHIPPING_METHODS_V
ASO_I_TAX_CODES_V
ASO_I_TAX_EXEMPT_REASONS_V
ASO_I_TAX_STATUSES_V
ASO_LOOKUPS
ASO_OA_PAYMENTS_HDR_V
ASO_OA_PAYMENTS_LINE_V
ASO_OA_PRICE_ADJ_HDR_V
ASO_OA_PRICE_ADJ_LINE_V
ASO_OA_PRICE_ATTR_HDR_V
ASO_OA_PRICE_ATTR_LINE_V
ASO_OA_QUOTE_ACCESSES_V
ASO_OA_QUOTE_HEADERS_ALL_V
ASO_OA_QUOTE_LINE_DETAILS_V
ASO_OA_QUOTE_LINES_ALL_V
ASO_OA_SALES_CREDITS_HDR_V
ASO_OA_SALES_CREDITS_LINE_V
ASO_OA_SHIPMENTS_HDR_V
ASO_OA_SHIPMENTS_LINE_V
ASO_OA_TAX_DETAILS_HDR_V
ASO_OA_TAX_DETAILS_LINE_V
ASO_PAYMENTS_V
ASO_PRICE_ADJUSTMENTS_V
ASO_PVT_ACCT_RELATE_V
ASO_PVT_CUST_ACCOUNTS_V
ASO_PVT_CUST_ORDER_HDRS_BALI_V
ASO_PVT_CUST_QUOTE_HDRS_BALI_V
ASO_PVT_CUSTOMER_CONT_FIND_V
ASO_PVT_CUSTOMER_ORG_FIND_V
ASO_PVT_CUSTOMER_PER_FIND_V
ASO_PVT_HDR_PRICE_ADJ_UI_V
ASO_PVT_HEADER_CHARGES_UI_V
ASO_PVT_INSTALL_BASE_BALI_V
ASO_PVT_LINE_CHARGES_UI_V
ASO_PVT_LINE_PRICE_ADJ_UI_V
ASO_PVT_LOCATIONS_V
ASO_PVT_PARTIES_V
ASO_PVT_PARTY_RLTN_V
ASO_PVT_PARTY_SITE_USES_V
ASO_PVT_PARTY_SITES_V
ASO_PVT_PENDING_ORDERS_BALI_V
ASO_PVT_PHONES_V
ASO_PVT_PRODUCT_CATALOG_BALI_V
ASO_PVT_QTE_LINES_PRINT_NUM_V
ASO_PVT_QTE_LINES_PRNT_BALI_V
ASO_PVT_QUOTE_HEADERS_UI_V
ASO_PVT_QUOTE_HEADERS_V
ASO_PVT_QUOTE_LINES_BALI_V
ASO_PVT_QUOTE_LINES_BALIVIEW_V
ASO_PVT_QUOTE_LINES_NUM_V
ASO_PVT_QUOTE_LINES_SORT_V
ASO_PVT_QUOTE_LINES_UI_V
ASO_PVT_QUOTE_LINES_V
ASO_PVT_QUOTE_SEARCH_V
ASO_PVT_RELATED_ITEMS_BALI_V
ASO_PVT_SHIPMENTS_V
ASO_PVT_VIEW_SALESCREDIT_UI_V
ASO_QUOTE_HEADERS_ALL_DFV
ASO_QUOTE_HEADERS_ALL_V
ASO_QUOTE_HEADERS_V
ASO_QUOTE_LINE_DETAILS_V
ASO_QUOTE_LINES_ALL_DFV
ASO_QUOTE_LINES_ALL_V
ASO_QUOTE_LINES_V
ASO_QUOTE_RELATED_OBJECTS_V
ASO_QUOTE_STATUSES_VL
ASO_QUOTE_VERSIONS_V
ASO_RETURNS_V
ASO_SALES_CREDITS_V
ASO_SALESREP_ROLES_V
ASO_SEARCH_QUOTES_V
ASO_SHIPMENTS_BALI_V
ASO_SHIPMENTS_V
ASO_SOURCE_NAME_V
ASO_STATUS_TRANSITIONS_V
ASO_SUP_COMP_RESP_MAP_V
ASO_SUP_COMPONENT_V
ASO_SUP_COMPONENT_VL
ASO_SUP_RESPONSE_VL
ASO_SUP_SECT_COMP_V
ASO_SUP_SECTION_VL
ASO_SUP_TEMPLATE_VL
ASO_SUP_TMPL_SECT_V
ASO_TAX_DETAILS_V