ASO Tables (44)
ASO - Order Capture — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
ASO_APR_APPROVAL_DETAILS |
45 | This table stores detailed approval instance information. |
ASO_APR_APPROVAL_DETAILS_TEMP |
23 | |
ASO_APR_OBJ_APPROVALS |
39 | This table stores information about all instances of approvals for each approval object. |
ASO_APR_RULES |
32 | This table stores information regarding the approval rules. |
ASO_CHANGED_QUOTES |
11 | This table is used to store the Changed Quotes for Territory Access program |
ASO_DEPENDENCY_MAPPINGS |
17 | This table stores Dependency Mappings for Defaulting Triggers |
ASO_FREIGHT_CHARGES |
31 | ASO_FREIGHT_CHARGES stores charge amount(s) for each quote shipment depending on freight charge type |
ASO_HEADER_RELATIONSHIPS |
16 | ASO_HEADER_RELATIONSHIPS links one quote to another and records the type of relationship. |
ASO_LINE_RELATIONSHIPS |
16 | ASO_LINE_RELATIONSHIPS links one quote line to another and records the type of relationship. |
ASO_PARTY_RELATIONSHIPS |
17 | ASO_PARTY_RELATIONSHIPS links one quote or a quote line to a party and records the type of relationship. |
ASO_PAYMENTS |
50 | ASO_PAYMENTS holds payment related information for the quote |
ASO_PRICE_ADJUSTMENTS |
94 | Table to Store the Price Adjustments |
ASO_PRICE_ADJ_ATTRIBS |
19 | This table stores information on qualifiers and pricing attributes, which the corresponding price adjustment line qualified for. |
ASO_PRICE_ADJ_RELATIONSHIPS |
16 | This table stores the relationships between Quote lines and price adjustments and also between price adjustments. One adjustment may be a |
ASO_PRICE_ATTRIBUTES |
138 | This table stores information on qualifiers and pricing attributes, which the corresponding price adjustment line qualified for. |
ASO_QUOTE_ACCESSES |
42 | Stores quote sales team information |
ASO_QUOTE_HEADERS_ALL |
109 | This table holds header level Order Capture quotation data. |
ASO_QUOTE_LINES_ALL |
87 | ASO_QUOTE_LINES_ALL stores information for a typical quote or an order line |
ASO_QUOTE_LINE_ATTRIBS_EXT |
23 | ASO_QUOTE_LINE_ATTRIBS_EXT is a attribute-value table that provides storage for line attributes not captured in ASO_QUOTE_LINES_ALL and ASO_ |
ASO_QUOTE_LINE_DETAILS |
82 | ASO_QUOTE_LINE_DETAILS_ALL stores information specific to certain types of quote lines |
ASO_QUOTE_PARTIES |
37 | party information related to quotes |
ASO_QUOTE_RELATED_OBJECTS |
18 | ASO_QUOTE_RELATED_OBJECTS stores the relationship between a quote or a quote line to any entity in the schema and records the type of relati |
ASO_QUOTE_STATUSES_B |
46 | ASO_QUOTE_STATUSES_B stores the pre-defined and user-definable statuses for a quote header or a quote line. |
ASO_QUOTE_STATUSES_TL |
17 | ASO_QUOTE_STATUSES_TL is a translated table of ASO_QUOTE_STATUSES_B. |
ASO_QUOTE_STATUS_TRANSITIONS |
38 | ASO_QUOTE_STATUS_TRANSITIONS stores transition rules for quote statuses. |
ASO_SALES_CREDITS |
42 | This table contains information about sales credits for the salesrep. |
ASO_SHIPMENTS |
61 | ASO_SHIPMENTS store shipping information for a quote at header level or line level. |
ASO_SUP_COMPONENT_B |
32 | Table for Components |
ASO_SUP_COMPONENT_TL |
13 | This is the translation table for name and description for Component table. |
ASO_SUP_COMP_RESP_MAP |
32 | This table for Components and Response mapping purpose. As per the business need a component can have one or many predefined responses. |
ASO_SUP_INSTANCE_VALUE |
36 | This table is to store the instance value of the template. |
ASO_SUP_RESPONSE_B |
29 | This is the base table for Response used for Sales Supplement functionality. |
ASO_SUP_RESPONSE_TL |
12 | This is the translation table for name and description for Response table. |
ASO_SUP_SECTION_B |
29 | This is the base table for Section used for Sales Supplement functionality. |
ASO_SUP_SECTION_TL |
12 | This is the translation table for name and description for Section table. |
ASO_SUP_SECT_COMP_MAP |
37 | This table for Section and Component mapping purpose. |
ASO_SUP_TEMPLATE_B |
31 | This is the base table for Template used for Sales Supplement functionality. |
ASO_SUP_TEMPLATE_SCOPE |
31 | This table is to define the scope of the template. |
ASO_SUP_TEMPLATE_TL |
12 | This is the translation table for name and description for Template table. |
ASO_SUP_TMPL_INSTANCE |
32 | This table is to store the instance of the template. |
ASO_SUP_TMPL_SECT_MAP |
32 | This table is for Section and Template mapping purpose. |
ASO_TAX_DETAILS |
46 | Tables for Storing the Tax Details for Quotes |
ASO_TERRITORY_ACCESSES |
12 | This table stores the Territory Access information |
ASO_UPGRADE_ERRORS |
8 | This tables is used to log messages during the migration in Order Capture. |