Search Results aso_quote_statuses_b




Overview
Explore in AI Chat

Overview

The ASO_QUOTE_STATUSES_B table is a core master data table within the Oracle E-Business Suite (EBS) Order Capture (ASO) module. It serves as the central repository for all status codes that can be applied to a sales quote, both at the header and line levels. This table stores a mix of system-predefined statuses, such as "Draft," "In Progress," or "Accepted," and user-definable statuses, enabling organizations to model their unique quote lifecycle workflows. Its primary role is to provide a controlled list of valid statuses, ensuring data integrity and consistency across the quote management process. The statuses defined in this table are fundamental to tracking the progression of a quote from initial creation through negotiation to final acceptance or rejection.

Key Information Stored

While the provided metadata does not list specific columns, the structure of the table can be inferred from its relationships and standard EBS design patterns. The primary column is QUOTE_STATUS_ID, a unique numeric identifier for each status code, which serves as the primary key. Other typical columns would include a STATUS_CODE (a short, unique character identifier), a NAME or DESCRIPTION for the status, and columns to indicate its applicability (e.g., for header, line, or both). Additional control columns like START_DATE_ACTIVE, END_DATE_ACTIVE, and ENABLED_FLAG are standard for such lookup tables, allowing for the activation and deactivation of statuses over time. The table likely also contains a USER_DEFINED_FLAG to distinguish system-provided statuses from those created by the user.

Common Use Cases and Queries

A primary use case is reporting and analyzing the distribution and lifecycle of quotes. For instance, a manager may run a report to list all quotes currently in a "Pending Approval" status. Another critical use is within custom workflows or integrations, where the valid status IDs from this table are referenced to update quote records via APIs or direct SQL. A common query pattern is to join this table to the quote headers or lines to translate the status ID into a meaningful name for reports.

  • Sample Query: SELECT qh.quote_number, qs.status_code, qh.creation_date FROM aso_quote_headers_all qh, aso_quote_statuses_b qs WHERE qh.quote_status_id = qs.quote_status_id AND qs.status_code = 'DRAFT';
  • Use Case: Configuring the status transition rules in the ASO_QUOTE_STATUS_TRANSITIONS table requires valid FROM_STATUS_ID and TO_STATUS_ID values, which must exist in ASO_QUOTE_STATUSES_B.

Related Objects

The ASO_QUOTE_STATUSES_B table has defined foreign key relationships with several key transactional tables in the ASO module, as documented in the metadata.

  • ASO_QUOTE_HEADERS_ALL: This is the main quote header table. Its QUOTE_STATUS_ID column references ASO_QUOTE_STATUSES_B.QUOTE_STATUS_ID to indicate the current status of the entire quote.
  • ASO_QUOTE_STATUS_TRANSITIONS: This table defines the allowed workflow paths between statuses. It references ASO_QUOTE_STATUSES_B twice: once via its FROM_STATUS_ID column (the starting status) and once via its TO_STATUS_ID column (the target status).

These relationships enforce that a quote's status and all defined status transitions must point to valid, predefined records in the ASO_QUOTE_STATUSES_B master table.