Product: | BIM - Marketing Intelligence |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_LEAD_CONV |
SELECT BLC.CAMPAIGN_ID CAMPAIGN_ID
, BLC.PERIOD_NAME PERIOD_NAME
, BLC.PERIOD_START_DATE START_DATE
, BLC.PERIOD_END_DATE END_DATE
, BLC.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BLC.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BLC.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BLC.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BLC.GEOGRAPHY_CODE
, BLC.NUM_OF_ORDERS NUM_OF_ORDERS
, BLC.NUM_OF_LEADS NUM_OF_LEADS
, BLC.NUM_OF_OPPORTUNITIES NUM_OF_OPPORTUNITIES
, BLC.NUM_OF_ORDERS_FROM_LEADS NUM_OF_ORDERS_FROM_LEADS
, BLC.NUM_OF_ORDERS_FROM_OPPS NUM_OF_ORDERS_FROM_OPPS
FROM BIM_LEAD_CONV_SUMM BLC
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
WHERE BLC.MEDIA_ID = BMC.MEDIA_ID
AND BLC.CHANNEL_ID = BMC.CHANNEL_ID
AND BLC.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BLC.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE WITH READ ONLY