View: BIM_SUMV_CAMP_PERF

Product:	BIM - Marketing Intelligence
Description:	Joins the summary table to the dimension views.
Implementation/DBA Data:	APPS.BIM_SUMV_CAMP_PERF

View Text

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.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.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, BCP.INITIATED_REVENUE INITIATED_REVENUE
, BCP.ORDER_ID ORDER_ID
, BCP.COGS COGS
, BCP.LEAD_ID LEAD_ID
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
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.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

Columns