Results for “aso_quote_statuses_b”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO.ASO_QUOTE_STATUSES_B is the base table in the Oracle E-Business Suite (EBS) Order Capture (ASO) module that stores the pre-defined and user-definable statuses available for a quote header or a quote line. In the Quote-to-Order lifecycle, quote records progress through a configurable sequence of states — examples include draft, submitted, accepted, and expired — and this table acts as the master reference list of those states. Quote headers, quote lines, and the transition rules governing movement between states all resolve their status codes against this table.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as hub-leaning. It carries a single-column surrogate primary key (QUOTE_STATUS_ID) and descriptive attributes, which suggests it functions as a hub-style reference entity surrounded by descriptive satellite content. In practice, the table serves as a foundational lookup object in the ASO schema rather than a transactional table.

Although the table name carries a _B suffix — typically indicating a base table paired with a translation (_TL) table — the documented physical schema for 12.2.2 shows only the base table with 46 columns, and no companion translation table is enumerated. Organizations operating in a multi-language environment should verify whether translated status descriptions exist in their specific patch level.

Key Information Stored

The documented schema contains 46 columns, of which the following are most significant for development and reporting:

• QUOTE_STATUS_ID — the surrogate primary key, defined by constraint ASO_QUOTE_STATUSES_B_PK. Foreign keys in downstream tables reference this column.
• STATUS_CODE — the business-facing code for the status; a business-key candidate via unique index ASO_QUOTE_STATUSES_B_U1 (STATUS_CODE, ZD_EDITION_NAME).
• UPDATE_ALLOWED_FLAG — indicates whether a quote in this status may be modified.
• AUTO_VERSION_FLAG — controls automated version creation on status change.
• USER_MAINTAINABLE_FLAG — marks statuses that users may assign manually versus system-controlled statuses.
• ENABLED_FLAG and SEED_TAG — identify active statuses and Oracle-seeded (non-deletable) statuses respectively.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-range qualification for status validity.
• ALLOW_LOV_TO_FLAG, ALLOW_LOV_FROM_FLAG, ALLOW_NEW_TO_FLAG, ALLOW_NEW_FROM_FLAG — granular controls over which transition paths (to/from) are permitted.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enabling multi-tenant or organizational data segregation.
• ATTRIBUTE1–ATTRIBUTE20 — the standard EBS DFF/descriptive flexfield columns.
• Audit and concurrency columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER, and the request/program audit set.
• ZD_EDITION_NAME — the editioning column used by EBS 12.2 online patching to isolate edition-specific rows; both unique indexes include it as a suffix.

Common Use Cases and Queries

The table is typically queried to resolve status identifiers to human-readable codes, to populate LOVs on quote entry forms, and to drive status-transition validation. A common reporting pattern joins the header table to the status master:

• Active status list: SELECT quote_status_id, status_code FROM aso_quote_statuses_b WHERE enabled_flag = 'Y' AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
• Quote header enumeration: SELECT h.quote_number, s.status_code FROM aso_quote_headers_all h JOIN aso_quote_statuses_b s ON h.quote_status_id = s.quote_status_id;
• Valid transitions from a status: join ASO_QUOTE_STATUS_TRANSITIONS t on t.from_status_id = s.quote_status_id to list permissible next states.
• Seeded vs. custom statuses: filter on seed_tag to distinguish Oracle-delivered statuses from customer-extended ones.

Related Objects

• ASO_QUOTE_HEADERS_ALL — references this table via quote_status_id, holding the current status of each quote header.
• ASO_QUOTE_STATUS_TRANSITIONS — references this table twice, through FROM_STATUS_ID and TO_STATUS_ID, defining the permissible state-transition matrix.
• ASO_BI_QUOTE_LINES_ALL and ASO_BI_QUOTE_LINES_STG — line-level and staging tables that also reference quote_status_id.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for data-access control.

Together these objects form the status-management backbone of the ASO quote model, and any customization or integration touching quote state must reconcile against ASO_QUOTE_STATUSES_B.