VIEW: APPS.BIM_SUMV_CAMP_PERF

Source

View Text - Preformatted

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

View Text - HTML Formatted

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