Search Results salesrep_fk




Overview
Explore in AI Chat

Overview

BIL_FCTV_QUOTES is a reporting view belonging to the BIL — Sales Intelligence product family in Oracle E-Business Suite. Its documented purpose is to expose quantitative measures related to sales quotes, and it functions as a fact-style view within the Sales Intelligence reporting schema. In EBS 12.1.1 and 12.2.2 environments, objects of this type are typically consumed by Sales Intelligence dashboards, Discoverer workbooks, and ad hoc analytical queries that summarize quote activity, quote value, and quote-to-order conversion.

The view is documented in the ETRM metadata as "Not implemented in this database," meaning it exists as a defined object in the Sales Intelligence data model but is not necessarily deployed in every EBS instance. Where it is present, it presents a denormalized, query-optimized projection over the Oracle Advanced Supply Chain Planning / Oracle Quoting base tables, joined to sales representative data, and is defined WITH READ ONLY to prevent DML through the view.

Underlying Base Objects

The view text is defined over three base tables, joined through standard foreign key relationships:

  • ASO_QUOTE_HEADERS (aliased AQH) — the quote header master, providing quote number, party, sales channel, order reference, creation date, and status.
  • ASO_QUOTE_LINES (aliased AQL) — the quote line detail, providing the quote line identifier and inventory item reference.
  • JTF_RS_SALESREPS (aliased JRS) — the sales representative resource table, providing the resource identifier for the salesperson on the quote.

The join conditions are AQL.QUOTE_HEADER_ID = AQH.QUOTE_HEADER_ID and JRS.PERSON_ID = AQH.EMPLOYEE_PERSON_ID. The view text places literal NULL values in the positions of two columns, which correspond to SALES_GROUP_ID and ORG_FK — these are exposed as placeholders in the column list but not populated by the underlying query.

Key Columns

  • QUOTE_HEADER_ID and QUOTE_LINE_ID — primary keys of the header and line, forming the natural grain of the view.
  • QUOTE_NUMBER — the user-facing quote identifier.
  • CUSTOMER_FK — maps to AQH.PARTY_ID, the customer or prospect associated with the quote.
  • SALESREP_FK — maps to JRS.RESOURCE_ID, the sales representative responsible for the quote.
  • CHANNEL_FK — maps to AQH.SALES_CHANNEL_CODE, the sales channel through which the quote originated.
  • INVENTORY_ITEM_FK — maps to AQL.INVENTORY_ITEM_ID. This is the column referenced by the inventory_item_fk search. It is the foreign key to the inventory item master (MTL_SYSTEM_ITEMS_B) for the item quoted on each line, and is the primary join path when Sales Intelligence reporting must be linked to item attributes.
  • ORDER_ID — the order created from the quote, where conversion has occurred.
  • CREATION_DATE — the quote creation timestamp.
  • QUOTE_STATUS_ID — the current workflow or status of the quote.

Common Use Cases and Queries

A frequent requirement is to attribute quote activity to inventory items and their organizations. Because INVENTORY_ITEM_FK carries the item identifier, it can be joined to the item master:

SELECT q.QUOTE_NUMBER, q.INVENTORY_ITEM_FK, msib.SEGMENT1 ITEM_NUMBER, msib.DESCRIPTION, q.CREATION_DATE, q.QUOTE_STATUS_ID FROM BIL_FCTV_QUOTES q, MTL_SYSTEM_ITEMS_B msib WHERE q.INVENTORY_ITEM_FK = msib.INVENTORY_ITEM_ID;

Other typical scenarios include summarizing quote counts and conversion by sales representative or channel, trending quote creation over time, and correlating quotes to the orders they generated via ORDER_ID. Analysts should note that the employee-to-salesrep join restricts results to quotes whose EMPLOYEE_PERSON_ID resolves to a valid sales representative record, and that the view is read-only. Because the object is documented as not implemented in all databases, availability should be verified before reliance in production reporting.