ASO Views (103)

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

View	Description
`ASO_APPROVAL_INSTANCES_ALL_V`
`ASO_APPROVAL_RULES_ALL_V`
`ASO_APPROVER_DETAILS_V`
`ASO_APR_APPROVAL_DET_VL`
`ASO_APR_FUNCTION_VL`
`ASO_APR_JTF_SALES_APPROVERS_V`
`ASO_APR_QUOTE_APPROVAL_V`
`ASO_APR_QUOTE_HEADERS_V`
`ASO_APR_RULES_VL`
`ASO_APR_RULE_APPROVERS_V`
`ASO_APR_RULE_GROUPS_VL`
`ASO_APR_RULE_GRP_MEMBER_V`
`ASO_APR_RULE_STEPS_VL`
`ASO_I_ACCT_SITE_ADDR_V`	view gives the address information of customers
`ASO_I_AGREEMENTS_V`	Customer Agreements
`ASO_I_ATP_ERRORS_V`
`ASO_I_CAMPAIGNS_V`	View based on Campaigns
`ASO_I_CAMPAIGN_GEO_AREAS_V`	This view returns compiled information of geographic areas and associated activities.
`ASO_I_CONTACT_POINTS_V`	view based on hz_contact_points
`ASO_I_COUNTRIES_V`	view retrieves the country information
`ASO_I_CREDIT_CARDS_V`	gives credit card information
`ASO_I_CURRENCIES_V`
`ASO_I_CUST_ACCOUNTS_V`	view gives information regarding customer accounts
`ASO_I_FREIGHT_CODES_V`	ASO_I_FREIGHT_CODES_V is based on view ORG_FREIGHT_VL. It is used to select the freight carrier and method from LOV
`ASO_I_GL_CONV_TYPES_V`	view retrieves valid conversion types from General Ledger
`ASO_I_HR_PEOPLE_V`	This view has all columns from PER_ALL_PEOPLE_F which is a DateTracked table holding personal information for employees, applicants and othe
`ASO_I_INVOICES_V`	View related to Invoice Information in OC
`ASO_I_ITEMS_V`	This is a view based on MTL_SYSTEM_ITEMS_VL which has System Items multilingual view with concatenated segments column
`ASO_I_ITEM_UOMS_V`	This is a view on MTL_ITEMS_UOMS_VIEW which gets valid UOMs for items, considering the conversions that are defined
`ASO_I_LINE_TYPES_V`	This is a view on OE_TRANSACTION_TYPES_VL with Transaction_type_code = 'LINE'
`ASO_I_MKTG_SRC_CODES_V`	This view shows the information related to a source code.
`ASO_I_OE_ORDER_HEADERS_V`	This view includes all columns from the Oracle Order Management tables and is currently used by Oracle Sales Compensation only.
`ASO_I_OE_ORDER_LINES_V`	This view includes all columns from the Oracle Order Management order lines tables and is currently used by Oracle Sales Compensation only.
`ASO_I_OE_SALES_CREDITS_V`	view retrieves sales credit information from Order Management
`ASO_I_ORDER_HEADERS_BALI_V`
`ASO_I_ORDER_HEADERS_V`	view provides order related information
`ASO_I_ORDER_LINES_V`	Order lines
`ASO_I_ORDER_PRICE_ADJS_V`	view based on oe_price_adjustments and gives the price adjustment information for orders
`ASO_I_ORDER_SOURCES_V`	view based on oe_order_sources and gives information of the order source
`ASO_I_ORDER_TYPES_V`	view gives information regarding valid order types recognized by Order Management
`ASO_I_ORG_CONTACTS_V`	It gives the information about Party Name,Party Type etc.
`ASO_I_PARTIES_V`	based on hz_parties. this view retrieves party information
`ASO_I_PARTY_ADDRESSES_V`	Stores the Information about the party addresses
`ASO_I_PARTY_SITES_V`
`ASO_I_PAYMENT_OPTIONS_V`	based on fnd_lookup_values. retrieves information related to payment types
`ASO_I_PAYMENT_TERMS_V`	View Based on RA_TERMS_VL
`ASO_I_PAYMENT_TYPES_V`	view gives the various payment types available
`ASO_I_PRICE_LISTS_V`	It stores the Price lists ,Name and Description
`ASO_I_PRICE_LIST_LINES_V`	Gives the Information about Price List Lines from Pricing
`ASO_I_QUOTE_HEADERS_BALI_V`
`ASO_I_RA_SALESREPS_V`
`ASO_I_RECEIPT_METHODS_V`	gives information regarding receipt methods available in AR
`ASO_I_RELATED_ITEMS_V`	View showing Item Relationships
`ASO_I_RETURN_CODES_V`	views is used as an LOV for return reasons
`ASO_I_RETURN_TYPES_V`	view is used as an LOV for available return references
`ASO_I_SALES_CHANNELS_V`	view can used as an LOV for the available sales channels
`ASO_I_SALES_CREDIT_TYPES_V`	view used to retrieve all valid sales credit types
`ASO_I_SEARCH_ORDERS_V`
`ASO_I_SERVICE_TYPES_V`	view gives the reference information for service supported by Order Management
`ASO_I_SHIPPING_METHODS_V`	view used to retrieve all valid shipping methods
`ASO_I_TAX_CODES_V`	view gives information of all the tax codes recognized by AR
`ASO_I_TAX_EXEMPT_REASONS_V`	view based on AR_LOOKUPS and gives information regarding the exemption reasons
`ASO_I_TAX_STATUSES_V`	View based on AR lookups
`ASO_LOOKUPS`	Order Capture QuickCodes values
`ASO_PAYMENTS_V`	view based on aso_payments
`ASO_PRICE_ADJUSTMENTS_V`	view based on aso_price_adjustments
`ASO_PVT_ACCT_RELATE_V`
`ASO_PVT_CUST_ACCOUNTS_V`
`ASO_PVT_LOCATIONS_V`
`ASO_PVT_PARTIES_V`
`ASO_PVT_PARTY_RLTN_V`
`ASO_PVT_PARTY_SITES_V`
`ASO_PVT_PARTY_SITE_USES_V`
`ASO_PVT_PHONES_V`
`ASO_PVT_QUOTE_HEADERS_V`
`ASO_PVT_QUOTE_LINES_BALIVIEW_V`
`ASO_PVT_QUOTE_LINES_BALI_V`
`ASO_PVT_QUOTE_LINES_V`
`ASO_PVT_RELATED_ITEMS_BALI_V`
`ASO_PVT_SHIPMENTS_V`
`ASO_QUOTE_HEADERS_ALL_V`	quotations
`ASO_QUOTE_HEADERS_V`	quotations
`ASO_QUOTE_LINES_ALL_V`	quote lines
`ASO_QUOTE_LINES_V`	quote lines
`ASO_QUOTE_LINE_DETAILS_V`	view based on quote line details
`ASO_QUOTE_RELATED_OBJECTS_V`	view based on aso_quote_related_objects
`ASO_QUOTE_STATUSES_VL`	ASO_QUOTE_STATUSES_VL is a view with most of the columns from ASO_QUOTE_STATUSES_B & few columns from ASO_QUOTE_STATUSES_TL
`ASO_QUOTE_VERSIONS_V`	ASO_QUOTE_VERSIONS_V is a join view of aso_quote_headers_all quote,aso_quote_statuses_tl status &fnd_user
`ASO_RETURNS_V`	view lists all the return orders in Order Management
`ASO_SALES_CREDITS_V`
`ASO_SEARCH_QUOTES_V`	ASO_SEARCH_QUOTES_V is a view with all the columns in this view coming from Aso_Quote_Headers_V.
`ASO_SHIPMENTS_BALI_V`
`ASO_SHIPMENTS_V`
`ASO_STATUS_TRANSITIONS_V`	Transition Rules for Quote Statuses
`ASO_SUP_COMPONENT_V`
`ASO_SUP_COMPONENT_VL`
`ASO_SUP_COMP_RESP_MAP_V`
`ASO_SUP_RESPONSE_VL`
`ASO_SUP_SECTION_VL`
`ASO_SUP_SECT_COMP_V`
`ASO_SUP_TEMPLATE_VL`
`ASO_SUP_TMPL_SECT_V`
`ASO_TAX_DETAILS_V`	view based on aso_tax_details