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

TABLE: BIM.BIM_LEAD_CONV_SUMM

Object Details
Object Name: BIM_LEAD_CONV_SUMM
Object Type: TABLE
Owner: BIM
FND Design Data: TableBIM.BIM_LEAD_CONV_SUMM
Subobject Name:
Status: VALID


BIM_LEAD_CONV_SUMM contains summarized data by user-defined period.
.
The measures are number of lead, number of opportunities, number of orders, number of orders generated from leads, number of orders generated from opportunities.
.
These measures are dimensioned by campaigns, media, channels, market segments, sales channel and geographic locations.
.
Populated by BIM_LEAD_CONV_SUMM_PKG concurrent program.
.
.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_LEAD_CONV_SUMM_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnPERIOD_NAME
ColumnPERIOD_START_DATE
ColumnPERIOD_END_DATE
ColumnCAMPAIGN_ID
ColumnMEDIA_ID
ColumnCHANNEL_ID
ColumnMARKET_SEGMENT_ID
ColumnSALES_CHANNEL_CODE
ColumnGEOGRAPHY_CODE
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_ID NUMBER
Yes campaign id of a campaign. -999 for no campaign. Refer to view BIM_DIMV_CAMPAIGNS for campaign details.
PERIOD_NAME VARCHAR2 (25) Yes Name of period that the data is summarized to.
CREATION_DATE DATE
Yes standard WHO column
CREATED_BY NUMBER
Yes standard WHO column
LAST_UPDATE_DATE DATE
Yes standard WHO column
LAST_UPDATED_BY NUMBER
Yes standard WHO column
LAST_UPDATE_LOGIN NUMBER

standard WHO column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update record
PROGRAM_ID NUMBER

Identifier of last concurrent program to update record
PROGRAM_UPDATE_DATE DATE

Last date concurrent program updated record
PERIOD_START_DATE DATE
Yes Period start date.
PERIOD_END_DATE DATE
Yes Period end date.
MEDIA_ID NUMBER
Yes Marketing Media id. -999 if unknown. Refer to view BIM_DIMV_MEDIA for media details.
CHANNEL_ID VARCHAR2 (80) Yes Marketing channel id. -999 if unknown. Channels can be media channels, events or event offerings. Channel prefixes are: CHLS for media channels, EVEH for events, EVEO for event offerings. Refer to view BIM_DIMV_CHANNELS for channel details.
MARKET_SEGMENT_ID NUMBER
Yes Market segment id. -999 if unknown. Refer to view BIM_DIMV_MARKET_SGMTS for market segment details.
SALES_CHANNEL_CODE VARCHAR2 (30) Yes Sales channel. -999 if unknown. Refer to view BIM_DIMV_SALES_CHANNELS for sales channel details.
GEOGRAPHY_CODE VARCHAR2 (240) Yes Location code. -999 if unknown. Refer to view BIM_DIMV_GEOGRAPHY for location details.
NUM_OF_LEADS NUMBER

number of leads.
NUM_OF_OPPORTUNITIES NUMBER

number of opportunities.
NUM_OF_ORDERS NUMBER

number of orders.
NUM_OF_ORDERS_FROM_LEADS NUMBER

number of orders generated from leads.
NUM_OF_ORDERS_FROM_OPPS NUMBER

number of orders generated from opportunities.
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
Query Text

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


SELECT CAMPAIGN_ID
,      PERIOD_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      MEDIA_ID
,      CHANNEL_ID
,      MARKET_SEGMENT_ID
,      SALES_CHANNEL_CODE
,      GEOGRAPHY_CODE
,      NUM_OF_LEADS
,      NUM_OF_OPPORTUNITIES
,      NUM_OF_ORDERS
,      NUM_OF_ORDERS_FROM_LEADS
,      NUM_OF_ORDERS_FROM_OPPS
,      SECURITY_GROUP_ID
FROM BIM.BIM_LEAD_CONV_SUMM;

Dependencies

[top of page]

BIM.BIM_LEAD_CONV_SUMM does not reference any database object

BIM.BIM_LEAD_CONV_SUMM is referenced by following:

SchemaAPPS
SynonymBIM_LEAD_CONV_SUMM