Results for “total_adjusted_amount”

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

Overview

The AST_QUOTES_UWQ_V view is an APPS-owned, VALID database object within the Oracle E-Business Suite TeleSales (AST) module. It is specifically designed to serve as the data source for the Quotes node within the Universal Work Queue (UWQ), presenting a consolidated, denormalized record set of quote header information enriched with customer, resource, and status attributes. In Oracle EBS 12.1.1 and 12.2.2, UWQ acts as a centralized work assignment and routing framework for the TeleSales and Advanced Outbound (IEX/ASO) products, and this view supplies the row-level payload that UWQ renders in its Quotes node for agents.

The view's primary structural role is to expose the quote header key as a UWQ-compatible parameter. It builds the IEU_OBJECT_PARAMETERS string as QUOTE_HEADER_ID=&ID AUTO_QUERY=T, and maps the object function to the ASO_QUOTE object code. This allows a UWQ agent selecting a row to launch the quote directly in the TeleSales application with an auto-query context. Because it synthesizes data from several core tables rather than storing data itself, it is a reporting and integration convenience object rather than a transactional table.

Underlying Base Objects

The view is defined over the following documented base objects:

• ASO_QUOTE_HEADERS_ALL — the primary quote header table (aliased QUOTE), supplying quote number, version, status, totals, currency, expiration, party and account references, and resource/employee identifiers.
• ASO_QUOTE_STATUSES_VL — the translated status lookup (aliased ISTATUS), joined via an outer join to provide the status code and meaning.
• HZ_PARTIES — the Trading Community Architecture party table (aliased PARTY), providing the customer name, first name, last name, and party type.
• HZ_CUST_ACCOUNTS — the customer account table (aliased IACC), providing the account number.
• JTF_OBJECTS_B — the object metadata table (aliased OBJB), filtered on OBJECT_CODE = 'ASO_QUOTE' to yield the UWQ object function.
• JTF_RS_RESOURCE_EXTNS — the resource extension table, used twice: once as RES to derive the resource type from category, and once as RS to resolve the last-updater's name.
• HZ_RELATIONSHIPS and FND_USER — referenced in the documented metadata object list, supporting party and user joins respectively.

All base objects are referenced in the APPS schema as synonyms; ASO_QUOTE_STATUSES_VL is a view. Join keys include PARTY_ID, CUST_ACCOUNT_ID, QUOTE_STATUS_ID, RESOURCE_ID, and LAST_UPDATED_BY = RS.USER_ID.

Key Columns

The view exposes UWQ control columns including IEU_OBJECT_FUNCTION, IEU_OBJECT_PARAMETERS, IEU_PARAM_PK_COL (set to QUOTE_HEADER_ID), and IEU_PARAM_PK_VALUE (the quote header ID as a character). Business columns include QUOTE_NUMBER (concatenated with version as number, Vversion), QUOTE_NAME, QUOTE_EXPIRATION_DATE, QUOTE_STATUS_ID, STATUS_CODE, and QUOTE_STATUS. Monetary and financial fields are TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_ADJUSTED_PERCENT, TOTAL_TAX, SURCHARGE, TOTAL_SHIPPING_CHARGE, and TOTAL_QUOTE_PRICE, alongside CURRENCY_CODE. Customer and resource columns include CUSTOMER_NAME, FIRST_NAME, LAST_NAME, PARTY_TYPE, ACCOUNT_NUMBER, RESOURCE_TYPE, RESOURCE_ID, and EMPLOYEE_PERSON_ID. Audit columns comprise CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATED_BYNAME. Note that TOTAL_SHIPPING_CHARGE correlates with the user's search term "total_shipping_charge".

Common Use Cases and Queries

Typical use cases include UWQ Quotes node rendering, custom quote worklists, shipping and tax analysis, and resource performance reporting. A representative query follows:

• A UWQ-style query joining quotes to customers, filtering active statuses and listing financial totals.
• A shipping analysis query aggregating TOTAL_SHIPPING_CHARGE by currency and status.

SELECT IEU_PARAM_PK_VALUE, QUOTE_NUMBER, CUSTOMER_NAME, CURRENCY_CODE,
TOTAL_SHIPPING_CHARGE, TOTAL_QUOTE_PRICE, QUOTE_STATUS
FROM APPS.AST_QUOTES_UWQ_V
WHERE NVL(TOTAL_SHIPPING_CHARGE,0) > 0
ORDER BY CREATION_DATE DESC;

Because the view applies no business filters of its own, callers must supply their own date, status, and resource predicates to constrain results.