Search Results aso_approval_instance_status

Overview

The APPS.ASO_APPROVAL_INSTANCES_ALL_V view exposes approval instance information for Oracle Quoting (ASO) quote headers within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary purpose is to present the approval workflow state of a quote alongside denormalized lookup text and requester identity data, so that reports, forms, and integrations can query a single object rather than joining the underlying approval, lookup, and resource tables directly.

The view is owned by the APPS schema and is defined by joining the quote header, the object approval record, and the seeded lookup ASO_APPROVAL_INSTANCE_STATUS. It therefore serves as the canonical reporting surface for approval instance status per quote version, and is frequently reached by users searching for "aso_approval_instance_status" because that is exactly the lookup type that drives the decoded status column.

Underlying Base Objects

Per the documented metadata, the view is defined over the following objects:

• ASO_QUOTE_HEADERS (SYNONYM) — supplies quote_header_id, quote_number, and quote_version.
• ASO_APR_OBJ_APPROVALS (SYNONYM) — the core approval instance table providing object approval identifiers, approval instance identifier, requester, comments, dates, and raw status code.
• ASO_LOOKUPS (VIEW) — the lookup view filtered to lookup_type = 'ASO_APPROVAL_INSTANCE_STATUS' to translate the status code into a meaning.
• JTF_RS_RESOURCE_EXTNS (SYNONYM) — used in a correlated subquery to resolve the requester's resource name.
• PER_ALL_PEOPLE_F and FND_USER (SYNONYMs) — used together in a fallback subquery to resolve the requester's full name when no active resource extension exists.

The join is qha.quote_header_id = aoa.object_id, meaning the approval record is keyed to the quote header by object identifier. The status code is matched to the lookup via aoa.approval_status = al.lookup_code.

Key Columns

• quote_header_id, quote_number, quote_version — identify the quote and its version to which the approval instance belongs.
• object_approval_id, object_id, object_type — the approval object identifiers and the type of object under approval.
• approval_instance_id — the approval workflow instance identifier.
• meaning — the decoded text for the approval status, sourced from ASO_LOOKUPS for lookup type ASO_APPROVAL_INSTANCE_STATUS.
• approval_status — the raw lookup code corresponding to the meaning.
• full_name — the requester's name, resolved first from active resource extensions, then from person/user records.
• requester_comments, start_date, end_date — requester notes and the approval instance timing.
• creation_date, created_by, last_update_date, last_updated_by, last_update_login — standard audit columns.

Common Use Cases and Queries

This view supports approval status reporting for quotes, dashboards of pending versus completed approvals, and integration extracts needing status and requester details.

Listing current approvals for a quote:

• SELECT quote_number, quote_version, meaning, full_name, start_date, end_date FROM apps.aso_approval_instances_all_v WHERE quote_number = :quote_number ORDER BY quote_version;

Filtering by decoded status:

• SELECT quote_number, approval_instance_id, approval_status, meaning FROM apps.aso_approval_instances_all_v WHERE meaning = 'Pending Approval';

Aggregating counts by status:

• SELECT meaning, COUNT(*) FROM apps.aso_approval_instances_all_v GROUP BY meaning;

Because the view performs lookups and correlated name resolution, queries should filter on indexed identifiers such as quote_header_id or approval_instance_id where possible to limit full scans across the approval and lookup objects.