[Home] [Help] [Dependency Information]
Object Name: | BIM_SUMV_SALES_CYCLE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIM.BIM_SUMV_SALES_CYCLE |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIM_SUMV_SALES_CYCLE is a view that joins the summary table to the dimension views. It is used by the following reports: Channel Sale Cycle Period, Market Segment Sale Cycle Period
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAMPAIGN_ID | NUMBER | campaign id | ||
PERIOD_NAME | VARCHAR2 | (25) | period name | |
START_DATE | DATE | start date | ||
END_DATE | DATE | end date | ||
MEDIA_ID | NUMBER | media id | ||
MEDIA_NAME | VARCHAR2 | (120) | media name | |
MEDIA_TYPE | VARCHAR2 | (30) | media type | |
MEDIA_TYPE_NAME | VARCHAR2 | (80) | media type name | |
CHANNEL_ID | VARCHAR2 | (80) | channel id | |
CHANNEL_NAME | VARCHAR2 | (240) | channel name | |
MARKET_SEGMENT_ID | NUMBER | market segment id | ||
MARKET_SEGMENT_NAME | VARCHAR2 | (120) | market segment name | |
GEOGRAPHY_CODE | VARCHAR2 | (240) | geography code | |
SALES_CHANNEL_CODE | VARCHAR2 | (30) | sales channel code | |
SALES_CHANNEL_NAME | VARCHAR2 | (80) | sales channel name | |
LEAD_TO_ORDER_CYCLE | NUMBER | lead to order cycle | ||
LEAD_TO_OPPR_CYCLE | NUMBER | lead to oppounities cycle | ||
OPPR_TO_ORDER_CYCLE | NUMBER | opportunities to order cycle |
Cut, paste (and edit) the following text to query this object:
SELECT CAMPAIGN_ID
, PERIOD_NAME
, START_DATE
, END_DATE
, MEDIA_ID
, MEDIA_NAME
, MEDIA_TYPE
, MEDIA_TYPE_NAME
, CHANNEL_ID
, CHANNEL_NAME
, MARKET_SEGMENT_ID
, MARKET_SEGMENT_NAME
, GEOGRAPHY_CODE
, SALES_CHANNEL_CODE
, SALES_CHANNEL_NAME
, LEAD_TO_ORDER_CYCLE
, LEAD_TO_OPPR_CYCLE
, OPPR_TO_ORDER_CYCLE
FROM APPS.BIM_SUMV_SALES_CYCLE;
APPS.BIM_SUMV_SALES_CYCLE is not referenced by any database object
|
|
|