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


VIEW: APPS.BIM_SUMV_SALES_CYCLE

Object Details
Object Name: BIM_SUMV_SALES_CYCLE
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIM.BIM_SUMV_SALES_CYCLE
Subobject Name:
Status: VALID

View Type

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
.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.BIM_SUMV_SALES_CYCLE references the following:

SchemaAPPS
ViewBIM_DIMV_MARKET_SGMTS
ViewBIM_DIMV_MEDIA_CHANNELS
ViewBIM_DIMV_SALES_CHANNELS
SynonymBIM_OPPR_CYCLE_SUMM
SynonymBIM_SALES_CYCLE_SUMM
PL/SQL PackageFND_GLOBAL - show dependent code

APPS.BIM_SUMV_SALES_CYCLE is not referenced by any database object