[Home] [Help] [Dependency Information]
Object Name: | BIL_DIMV_OPTY_STATUSES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIL.BIL_DIMV_OPTY_STATUSES |
Subobject Name: | |
Status: | VALID |
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.
.
.
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 |
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;
APPS.BIL_DIMV_OPTY_STATUSES is not referenced by any database object
|
|
|