DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_OPP_WIN_PROB_V

Object Details
Object Name: OKX_OPP_WIN_PROB_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_OPP_WIN_PROB_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PROBABILITY_VALUE NUMBER
Yes Win probability value of sales opportunity in the range from 0 to 100
START_DATE_ACTIVE DATE
Yes Date which the win probability becomes active
ENABLED_FLAG VARCHAR2 (1) Yes Flag to indicate if the win probability is enabled
LEAD_STATUS_CHANGE_CODE VARCHAR2 (30)
After an opportunity win probability exceeds this record's value, the opportunity status changes to this value
END_DATE_ACTIVE DATE

Date which the win probability becomes inactive
MEANING VARCHAR2 (80)
Text description of the win probability
ORG_ID NUMBER

Operating unit which performed this transaction
USAGE_INDICATOR VARCHAR2 (30)
Usage Indicator
INTERNAL_UPGRADE_PROB_VALUE NUMBER

For internal use only on data migration- to keep the new probability value
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROBABILITY_VALUE
,      START_DATE_ACTIVE
,      ENABLED_FLAG
,      LEAD_STATUS_CHANGE_CODE
,      END_DATE_ACTIVE
,      MEANING
,      ORG_ID
,      USAGE_INDICATOR
,      INTERNAL_UPGRADE_PROB_VALUE
FROM APPS.OKX_OPP_WIN_PROB_V;

Dependencies

[top of page]

APPS.OKX_OPP_WIN_PROB_V references the following:

SchemaAPPS
SynonymAS_FORECAST_PROB_ALL_B
SynonymAS_FORECAST_PROB_ALL_TL

APPS.OKX_OPP_WIN_PROB_V is not referenced by any database object