VIEW: APPS.BIM_SUMV_SLIST_PERF

Source

View Text - Preformatted

SELECT BTS.CAMPAIGN_ID CAMPAIGN_ID , BTS.PERIOD_NAME PERIOD_NAME , BTS.PERIOD_START_DATE START_DATE , BTS.PERIOD_END_DATE END_DATE , BTS.MEDIA_ID MEDIA_ID , BMC.MEDIA_NAME MEDIA_NAME , BMC.MEDIA_TYPE_CODE MEDIA_TYPE , BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME , BTS.CHANNEL_ID CHANNEL_ID , BMC.CHANNEL_NAME CHANNEL_NAME , BTS.MARKET_SEGMENT_ID MARKET_SEGMENT_ID , BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME , BTS.SALES_CHANNEL_CODE SALES_CHANNEL_CODE , BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME , BTS.TARGET_SEGMENT_ID TARGET_SEGMENT_ID , BTG.TARGET_SEGMENT_NAME TARGET_SEGMENT_NAME , BTS.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE , BTS.NUM_OF_LEADS NUM_OF_LEADS , BTS.INITIATED_REVENUE INITIATED_REVENUE , BTS.NUM_OF_NEW_ACCTS NUM_OF_NEW_ACCTS FROM BIM_TRGT_SGMT_PERF_SUMM BTS , BIM_DIMV_MEDIA_CHANNELS BMC , BIM_DIMV_MARKET_SGMTS BMS , BIM_DIMV_SALES_CHANNELS BSC , BIM_DIMV_TARGET_SGMTS BTG WHERE BTS.MEDIA_ID = BMC.MEDIA_ID AND BTS.CHANNEL_ID = BMC.CHANNEL_ID AND BTS.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID AND BTS.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE AND BTS.TARGET_SEGMENT_ID = BTG.TARGET_SEGMENT_ID WITH READ ONLY

View Text - HTML Formatted

SELECT BTS.CAMPAIGN_ID CAMPAIGN_ID
, BTS.PERIOD_NAME PERIOD_NAME
, BTS.PERIOD_START_DATE START_DATE
, BTS.PERIOD_END_DATE END_DATE
, BTS.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BTS.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BTS.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BTS.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BTS.TARGET_SEGMENT_ID TARGET_SEGMENT_ID
, BTG.TARGET_SEGMENT_NAME TARGET_SEGMENT_NAME
, BTS.BILL_TO_GEOGRAPHY_CODE GEOGRAPHY_CODE
, BTS.NUM_OF_LEADS NUM_OF_LEADS
, BTS.INITIATED_REVENUE INITIATED_REVENUE
, BTS.NUM_OF_NEW_ACCTS NUM_OF_NEW_ACCTS
FROM BIM_TRGT_SGMT_PERF_SUMM BTS
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
, BIM_DIMV_TARGET_SGMTS BTG
WHERE BTS.MEDIA_ID = BMC.MEDIA_ID
AND BTS.CHANNEL_ID = BMC.CHANNEL_ID
AND BTS.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BTS.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE
AND BTS.TARGET_SEGMENT_ID = BTG.TARGET_SEGMENT_ID WITH READ ONLY