Product: | BIM - Marketing Intelligence |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_CAMP_MARGIN |
SELECT BCP.CAMPAIGN_ID CAMPAIGN_ID
, BCP.PERIOD_NAME PERIOD_NAME
, BCP.PERIOD_START_DATE START_DATE
, BCP.PERIOD_END_DATE END_DATE
, BCP.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BCP.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BCP.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BCP.HEADER_OFFER_ID HEADER_OFFER_ID
, BOFH.OFFER_NAME HEADER_OFFER_NAME
, BCP.LINE_OFFER_ID LINE_OFFER_ID
, BOFL.OFFER_NAME LINE_OFFER_NAME
, BCP.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BCP.INTEREST_TYPE_ID INTEREST_TYPE_ID
, BPR.INTEREST_TYPE INTEREST_TYPE
, BCP.PRIMARY_INTEREST_CODE_ID PRIMARY_INTEREST_CODE_ID
, BPR.PRIMARY_INTEREST_CODE PRIMARY_INTEREST_CODE
, BCP.SECONDARY_INTEREST_CODE_ID SECONDARY_INTEREST_CODE_ID
, BPR.SECONDARY_INTEREST_CODE SECONDARY_INTEREST_CODE
, BCP.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE
, BCP.INITIATED_REVENUE INITIATED_REVENUE
, BCP.ORDER_ID ORDER_ID
, BCP.COGS COGS
FROM BIM_CMPGN_PERF_SUMM BCP
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
, BIM_DIMV_PROD_LOV BPR
, BIM_DIMV_OFFERS BOFH
, BIM_DIMV_OFFERS BOFL
WHERE BCP.MEDIA_ID = BMC.MEDIA_ID
AND BCP.CHANNEL_ID = BMC.CHANNEL_ID
AND BCP.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BCP.HEADER_OFFER_ID = BOFH.OFFER_ID
AND BCP.LINE_OFFER_ID = BOFL.OFFER_ID
AND BCP.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE
AND BCP.INTEREST_TYPE_ID = BPR.INTEREST_TYPE_ID
AND BCP.PRIMARY_INTEREST_CODE_ID = BPR.PRIMARY_INTEREST_CODE_ID
AND BCP.SECONDARY_INTEREST_CODE_ID = BPR.SECONDARY_INTEREST_CODE_ID WITH READ ONLY