Search Results opportunity_number

Overview

AST_LS_QUOTES_V is a TeleSales (AST) module view shipped with Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a consolidated, reporting-oriented projection of quote header and quote line information drawn from the Oracle Advanced Pricing/Order Capture quote schema (ASO_QUOTE_HEADERS_ALL and its dependent entities). The view is intended to support TeleSales agent-facing inquiries and downstream reporting where a denormalized view of quote status, customer identity, sales representative, and quoted line items is required without navigating the normalized quote model directly.

The view is documented in ETRM metadata as "Not implemented in this database," meaning it is referenced in documentation and dependent view text but is not instantiated in every environment; administrators should confirm its presence before authoring dependent queries. Its principal value lies in joining the quote header to the party (customer) record, the sales representative person record, the quote status lookup, and the quote lines in a single queryable object.

Underlying Base Objects

ETRM metadata for this object documents no referenced base objects, however the view text itself identifies the following sources:

• ASO_QUOTE_HEADERS_ALL (aliased ASO_QUOTES) — the driving quote header table.
• AST_LS_QUOTES_LINES_V (aliased QUOTE_LINES) — a companion TeleSales view supplying quote line detail.
• PER_ALL_PEOPLE_F (aliased I_PPF) — the HR person record for the employee acting as sales representative, date-effectively joined.
• HZ_PARTIES (aliased I_PARTIES) — the trading community party (customer) record.
• ASO_I_ORG_CONTACT_NW_V (aliased I_CONTACT) — organization contact information used when the party is an organization.
• ASO_QUOTE_STATUSES_VL (aliased I_STATUS) — the translatable quote status lookup supplying the status meaning.

All joins to PER_ALL_PEOPLE_F, HZ_PARTIES, ASO_I_ORG_CONTACT_NW_V, and ASO_QUOTE_STATUSES_VL are outer joins, ensuring quote headers are retained even where related master data is absent. The PER_ALL_PEOPLE_F join is additionally constrained by the effective date range around SYSDATE.

Key Columns

• QUOTE_HEADER_ID / QUOTE_LINE_ID / ROW_ID — primary identifiers for headers, lines, and the header row.
• QUOTE_NUMBER, QUOTE_NAME, QUOTE_VERSION — quote business identifiers.
• QUOTE_STATUS / QUOTE_STATUS_ID — decoded status meaning and its identifier.
• PARTY_ID, PARTY_TYPE, ORGANIZATION_NAME — customer identity.
• PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME — decoded contact names; for organizations these are drawn from I_CONTACT, otherwise from HZ_PARTIES person attributes. This explains the "person_middle_name" search term.
• EMPLOYEE_PERSON_ID, SALESREP_FIRST_NAME, SALESREP_LAST_NAME — assigned sales representative.
• OPPORTUNITY_NUMBER, ORIG_CAMPAIGN_ID, CAMPAIGN_ID — opportunity and marketing source linkage.
• TOTAL_LIST_PRICE, TOTAL_ADJUSTED_AMOUNT, TOTAL_ADJUSTED_PERCENT, TOTAL_TAX, SURCHARGE, TOTAL_SHIPPING_CHARGE, TOTAL_QUOTE_PRICE — pricing and monetary totals.
• INVENTORY_ITEM_ID, INVENTORY_ITEM, ITEM_DESCRIPTION — quoted line item detail.

Common Use Cases and Queries

Typical usage includes TeleSales dashboards listing open quotes by representative, customer-facing quote summaries, and extracts joining quote headers to lines for pricing analysis.

Example — quotes and contact names for a given sales representative:

SELECT QUOTE_NUMBER, QUOTE_STATUS, ORGANIZATION_NAME, PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME, TOTAL_QUOTE_PRICE FROM AST_LS_QUOTES_V WHERE EMPLOYEE_PERSON_ID = :p_person_id ORDER BY QUOTE_NUMBER;

Example — searching for quotes by contact middle name:

SELECT QUOTE_NUMBER, QUOTE_NAME, PERSON_FIRST_NAME, PERSON_MIDDLE_NAME, PERSON_LAST_NAME FROM AST_LS_QUOTES_V WHERE UPPER(PERSON_MIDDLE_NAME) LIKE UPPER('%' || :p_middle_name || '%');

Because the view is documented as not implemented in all databases, developers should verify its existence via ALL_VIEWS before embedding it in custom reports or concurrent programs.