Product: | BIM - Marketing Intelligence |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_EVENT_PERF |
SELECT BEP.EVENT_ID EVENT_ID
, BEP.EVENT_OFFERING_ID EVENT_OFFERING_ID
, BEH.EVENT_NAME EVENT_NAME
, BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME
, BEH.EVENT_TYPE_CODE EVENT_TYPE
, BEP.CAMPAIGN_ID CAMPAIGN_ID
, BEP.PERIOD_NAME PERIOD_NAME
, BEP.PERIOD_START_DATE START_DATE
, BEP.PERIOD_END_DATE END_DATE
, BEP.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BEP.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BEP.INTEREST_TYPE_ID INTEREST_TYPE_ID
, BPR.INTEREST_TYPE INTEREST_TYPE
, BEP.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, BPR.PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE
, BEP.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, BPR.SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE
, BEP.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE
, BEP.LEAD_ID LEAD_ID
, BEP.INITIATED_REVENUE INITIATED_REVENUE
FROM BIM_EVENT_PERF_SUMM BEP
, BIM_DIMV_EVENT_HIER BEH
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
, BIM_DIMV_PROD_LOV BPR
WHERE BEP.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID
AND BEP.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BEP.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE
AND BEP.INTEREST_TYPE_ID = BPR.INTEREST_TYPE_ID
AND BEP.PRIMARY_INTEREST_CODE_ID = BPR.PRIMARY_INTEREST_CODE_ID
AND BEP.SECONDARY_INTEREST_CODE_ID = BPR.SECONDARY_INTEREST_CODE_ID WITH READ ONLY