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


VIEW: APPS.BIL_DIMV_OPTY_STATUSES

Object Details
Object Name: BIL_DIMV_OPTY_STATUSES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIL.BIL_DIMV_OPTY_STATUSES
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


BIL_DIMV_OPTY_STATUSES - view used to determine the status of a sales
opportunity.
.
Source is Oracle Sales Online schema.
.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
STATUS_CODE_PK VARCHAR2 (30)
status code for the opportunity status
MEANING VARCHAR2 (240)
Name of the opportunity status
DESCRIPTION VARCHAR2 (240)
Description of the opportunity status
ENABLED_FLAG VARCHAR2 (1)
indicates the status is enabled or not
LEAD_FLAG VARCHAR2 (1)
Flag to indicate that this status is for sales leads
OPP_FLAG VARCHAR2 (1)
Flag to indicate that this status is for sales opportunity
OPP_OPEN_STATUS_FLAG VARCHAR2 (1)
Flag to indicate that this status is for open opportunity
OPP_DECISION_DATE_FLAG VARCHAR2 (1)
Not used currently
STATUS_RANK NUMBER

Not used currently
FORECAST_ROLLUP_FLAG VARCHAR2 (1)
Flag to indicate opportunity with this status will appear in forecast. Valid values are 'Y' and 'N'
WIN_LOSS_INDICATOR VARCHAR2 (1)
Indicates whether the opportunity or lead is Won and Closed or Lost and Closed or just Closed because it is not an opportunity anymore. Validation will be made against Open Flag. Possible values are 'W', 'L', 'N' (neither equivalent to NULL)
USAGE_INDICATOR VARCHAR2 (30)
Indicates to whom the data will be exposed to. valid values are "OS" ,"PRM","ALL"
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
CREATION_DATE DATE

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
Query Text

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


SELECT STATUS_CODE_PK
,      MEANING
,      DESCRIPTION
,      ENABLED_FLAG
,      LEAD_FLAG
,      OPP_FLAG
,      OPP_OPEN_STATUS_FLAG
,      OPP_DECISION_DATE_FLAG
,      STATUS_RANK
,      FORECAST_ROLLUP_FLAG
,      WIN_LOSS_INDICATOR
,      USAGE_INDICATOR
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.BIL_DIMV_OPTY_STATUSES;

Dependencies

[top of page]

APPS.BIL_DIMV_OPTY_STATUSES references the following:

SchemaAPPS
SynonymAS_STATUSES_B
SynonymAS_STATUSES_TL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS

APPS.BIL_DIMV_OPTY_STATUSES is not referenced by any database object