Search Results marketing_code

Overview

BIL_FCTV_PIPELINE is a read-only reporting view in the Oracle E-Business Suite Sales Intelligence (BIL) module. As its documented description states, it presents "quantitative measures related to sales opportunities." In practice, the view flattens opportunity and sales-credit data into a single denormalized structure, exposing lead identity, customer, sales channel, item, currency, stage, win probability, revenue, credit, and quantity measures. This makes it a convenient source for pipeline reporting, forecasting analysis, and downstream integration where consumers expect opportunity facts in a single cursor rather than a multi-table join.

The view carries a WITH READ ONLY constraint in its definition, confirming it is intended strictly for query and reporting workloads. It is documented in the ETRM metadata at the 12.1.1 and 12.2.2 release levels. Notably, the metadata records "Not implemented in this database," indicating that the object may not be deployed in every environment and is typically present only where the Sales Intelligence / Sales Foundation schema has been installed.

Underlying Base Objects

The documented view text defines BIL_FCTV_PIPELINE over two base objects joined in the WHERE clause:

• AS_SALES_CREDITS_DENORM (alias ASCD) — the primary driver table, supplying lead, line, sales-credit, customer, item, currency, opportunity, and quantity columns.
• OE_SALES_CREDIT_TYPES (alias OSCT) — joined on CREDIT_TYPE_ID = OSCT.SALES_CREDIT_TYPE_ID to supply the QUOTA_FLAG attribute.

The join filters on ASCD.OPP_DELETED_FLAG = 'N', excluding logically deleted opportunities. Although ETRM records no documented base objects under the "Referenced base objects" heading, the view text itself explicitly references these two tables, which are the authoritative dependencies. The denormalized credit table already aggregates much of the underlying opportunity model, so the view is effectively a thin projection layer adding credit-type attributes.

Key Columns

The view exposes thirty-six columns. The most significant include:

• LEAD_ID, LEAD_NUMBER, LEAD_LINE_ID, SALES_CREDIT_ID — keys identifying the opportunity, its line, and the associated sales credit.
• ORG_ID, SALESFORCE_FK, SALES_GROUP_FK, CUSTOMER_FK, SALES_CHANNEL_FK — organizational and ownership dimensions.
• INTEREST_TYPE_FK, PRIMARY_INTEREST_CODE_FK, SECONDARY_INTEREST_CODE_FK, INVENTORY_ITEM_FK — product/interaction classification.
• SALES_STAGE_FK, STATUS_CODE_FK, WIN_PROBABILITY, DECISION_DATE — pipeline stage and likelihood measures.
• CURRENCY_CODE, REVENUE_AMOUNT, CREDIT_AMOUNT, LINE_TOTAL_AMOUNT — monetary measures; note the view text maps the credit amount column twice (as CREDIT_AMOUNT and, positionally, REVENUE-like values).
• LINE_QUANTITY, LINE_UOM_CODE, UOM_DESCRIPTION — the quantitative line measure, exposed as LINE_QUANTITY in the documented metadata and mapped from ASCD.QUANTITY in the view text. This is the column most relevant to users searching for "line_quantity."
• CREATION_DATE, SHIP_DATE, MARKETING_CODE, SALES_REP_NAME, CUSTOMER_NAME — reporting attributes.

Common Use Cases and Queries

Typical uses include pipeline value by stage, quota-credited revenue analysis, and product-level quantity reporting. Because LINE_QUANTITY maps from the opportunity line's quantity, aggregations frequently target that column.

Example: quantity and revenue by sales stage.

• SELECT SALES_STAGE_FK, SUM(LINE_QUANTITY) total_qty, SUM(REVENUE_AMOUNT) total_rev FROM BIL_FCTV_PIPELINE GROUP BY SALES_STAGE_FK;

Example: weighted pipeline using win probability.

• SELECT LEAD_NUMBER, CUSTOMER_NAME, WIN_PROBABILITY, LINE_QUANTITY, REVENUE_AMOUNT * WIN_PROBABILITY weighted_value FROM BIL_FCTV_PIPELINE ORDER BY weighted_value DESC;

Example: quota-bearing credits only.

• SELECT SALES_REP_NAME, SUM(CREDIT_AMOUNT) FROM BIL_FCTV_PIPELINE WHERE QUOTA_FLAG = 'Y' GROUP BY SALES_REP_NAME;

Consumers should confirm the view exists in the target instance, since the metadata documents it as not implemented in the reference database.