Results for “probability_meaning”

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

Overview

IEU_UWQ_OPP_V is a reporting view owned by the IEU (Universal Work Queue) product in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to serve as the UWQ selector SpreadTable view, meaning it supplies the flattened, presentation-ready record set that the Universal Work Queue user interface consumes when displaying opportunity-related work items in a spread-table layout. The view joins sales opportunity data to JTF object metadata so that each row carries both the business content of the opportunity and the object-function navigation attributes UWQ requires to open the underlying record.

The view is a read-only construct intended for query and integration rather than transactional use. It exposes a stable, denormalized projection of opportunity header information, including sales stage, status, win probability, and forecast amounts, which makes it suitable for embedding in UWQ dashboards, saved searches, and downstream extracts. Note that the ETRM metadata records it as "Not implemented in this database," so it may exist only in environments where the relevant UWQ and opportunity selectors have been configured.

Underlying Base Objects

The view text defines two sources: AST_SALES_OPP_UWQ_V (aliased A) and JTF_OBJECTS_VL (aliased B). AST_SALES_OPP_UWQ_V is the opportunity-facing base view that carries lead, resource, party, stage, status, probability, and financial attributes. JTF_OBJECTS_VL is the JTF object metadata view translated by language, supplying OBJECT_FUNCTION and OBJECT_PARAMETERS for the object identified by OBJECT_CODE. The two are joined on OBJECT_CODE, which is not projected in the select list; it is used solely to attach the correct navigation function and parameter string to each opportunity row. The metadata lists no other documented base objects, so all business columns trace to AST_SALES_OPP_UWQ_V.

Key Columns

• IEU_OBJECT_FUNCTION / IEU_OBJECT_PARAMETERS — navigation function and parameter values used by UWQ to launch the opportunity record.
• IEU_PARAM_PK_COL / IEU_PARAM_PK_VALUE — fixed primary-key column name ('LEAD_ID') and the character-converted LEAD_ID identifying each row.
• WIN_PROBABILITY / PROBABILITY_MEANING — numeric win probability and its decoded meaning, the combination users most often filter on.
• SALES_STAGE_ID / SALES_STAGE_NAME — the current sales stage of the opportunity.
• STATUS_CODE / STATUS_MEANING — opportunity status and its display text.
• PARTY_ID / PARTY_NAME — the customer or prospect associated with the lead.
• TOTAL_AMOUNT / CUSTOMER_BUDGET / CURRENCY_CODE — forecast value, stated budget, and currency.
• DECISION_DATE / DECISION_TIMEFRAME_CODE / DECISION_TIMEFRAME — expected decision timing.
• RESOURCE_ID / RESOURCE_TYPE / RESOURCE_GROUP_ID — owning sales resource and group.
• LEAD_NUMBER, CHANNEL_CODE, SALES_CHANNEL, PARENT_PROJECT — identification and channel attributes. Audit columns include LAST_UPDATE_DATE, LAST_UPDATE_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical usage includes UWQ selector configuration validation, pipeline reports keyed on probability meaning, and extracts feeding external CRM or forecasting tools.

• Filter by decoded probability: SELECT LEAD_NUMBER, PARTY_NAME, WIN_PROBABILITY, PROBABILITY_MEANING, TOTAL_AMOUNT FROM IEU_UWQ_OPP_V WHERE PROBABILITY_MEANING = :p_meaning;
• Resource pipeline: SELECT RESOURCE_ID, SALES_STAGE_NAME, SUM(TOTAL_AMOUNT) FROM IEU_UWQ_OPP_V GROUP BY RESOURCE_ID, SALES_STAGE_NAME;
• UWQ navigation test: SELECT IEU_PARAM_PK_VALUE, IEU_OBJECT_FUNCTION, IEU_OBJECT_PARAMETERS FROM IEU_UWQ_OPP_V WHERE ROWNUM <= 25;

Because the view is not implemented universally, availability should be confirmed against each target instance before relying on it in concurrent programs or integrations.