Search Results date_sent

Overview

The view ASO_APR_QUOTE_APPROVAL_V belongs to the ASO (Order Capture) module of Oracle E-Business Suite and exposes quote approval routing information generated by the Oracle Approval Management / Approval Routing framework. Its principal function is to present the approval workflow state of a quote or sales order object alongside reviewer identity and notification timing data, allowing administrators and reporting users to see who was asked to approve a given document, when the notification was dispatched, and whether a response was received.

The view is particularly relevant to the DATE_SENT column, which records the timestamp at which the approval notification was transmitted to the reviewer. Combined with DATE_RECEIVED, it enables calculation of approval turnaround time and identification of stalled or unacknowledged approval requests. Because the view joins approval detail rows in ASO_APR_APPROVAL_DET_B with workflow role and resource group definitions, it produces a self-describing approval audit trail rather than raw foreign key identifiers.

Per the ETRM metadata, this view is documented as not implemented in this database in the source instantiation, meaning that its presence and population depend on the specific ASO schema configuration and whether the Approval Routing objects have been deployed. In EBS 12.1.1 and 12.2.2, ASO is normally installed with the Order Capture/Quoting stack, and the view is created as part of the ASO database object set.

Underlying Base Objects

The ETRM metadata documents three base objects referenced by the view definition, although the "referenced base objects" list is empty in the supplied metadata. The view text itself identifies them explicitly:

• ASO_APR_APPROVAL_DET_B — the primary detail table holding one row per approval step, including the approval object identifier, sequence, status, and the DATE_SENT / DATE_RECEIVED timestamps. Aliased as A.
• WF_ROLES — the Oracle Workflow roles table, used to resolve the approver identifier into a display name (REVIEWER), e-mail address, and territory. Aliased as B.
• JTF_RS_GROUPS_B — the CRM resource group base table, providing the GROUP_NUMBER used to identify the approver resource group. Aliased as C.

Join conditions link C.GROUP_ID to A.JTF_RS_APPROVER_GROUP_ID, and resolve the reviewer through a concatenated role name of the form RS_GROUP:<approver_id or approver_group_id>. The NVL in that concatenation supports both individual approver and group-based approval routing.

Key Columns

• ASO_APR_OBJ_APPROVAL_ID — identifier of the approval step instance for the quote object.
• APPROVAL_SEQUENCE — ordinal position of the step in the approval routing sequence.
• APPROVAL_STATUS — current state of the step (for example, pending, approved, rejected, or more complex routing states).
• DATE_SENT — timestamp the approval notification was sent to the reviewer; central to aging and turnaround analysis.
• DATE_RECEIVED — timestamp the approval response was received; null while outstanding.
• REVIEWER — display name of the assigned reviewer or resource group from WF_ROLES.
• EMAIL_ADDRESS, TERRITORY — reviewer contact and territory attributes.
• GROUP_NUMBER — resource group number for the approver group.

Common Use Cases and Queries

Typical uses include approval aging reports, reviewer workload analysis, and SLA monitoring. To list pending approvals with elapsed time since notification:

• SELECT reviewer, approval_status, date_sent, date_received, (SYSDATE - date_sent) days_pending FROM aso_apr_quote_approval_v WHERE date_received IS NULL ORDER BY date_sent;
• Filtering by a specific window on DATE_SENT supports period reporting, for example WHERE date_sent BETWEEN :from_date AND :to_date.
• Aggregating turnaround: SELECT reviewer, AVG(date_received - date_sent) avg_days FROM aso_apr_quote_approval_v WHERE date_received IS NOT NULL GROUP BY reviewer;

Because the view depends on the ASO approval schema being populated, verify row counts and date ranges before relying on it for production reporting.