Product: | BIM - Marketing Intelligence |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_CAMP_RESP |
SELECT BCR.CAMPAIGN_ID CAMPAIGN_ID
, BCR.PERIOD_NAME PERIOD_NAME
, BCR.PERIOD_START_DATE START_DATE
, BCR.PERIOD_END_DATE END_DATE
, BCR.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BCR.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BCR.SOURCE_LIST_ID SOURCE_LIST_ID
, BSL.SOURCE_LIST_NAME SOURCE_LIST_NAME
, BCR.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BCR.TARGET_SEGMENT_ID TARGET_SEGMENT_ID
, BTS.TARGET_SEGMENT_NAME TARGET_SEGMENT_NAME
, BCR.GEOGRAPHY_CODE
, BCR.NUM_TARGETED NUM_TARGETED
, BCR.NUM_RESPONDED NUM_RESPONDED
FROM BIM_CMPGN_RESP_SUMM BCR
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_SOURCE_LISTS BSL
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_TARGET_SGMTS BTS
WHERE BCR.MEDIA_ID = BMC.MEDIA_ID
AND BCR.CHANNEL_ID = BMC.CHANNEL_ID
AND BCR.SOURCE_LIST_ID = BSL.SOURCE_LIST_ID
AND BCR.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BCR.TARGET_SEGMENT_ID = BTS.TARGET_SEGMENT_ID WITH READ ONLY