eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BIM_SUMV_LEAD_CONV

Source

View Text - Preformatted


SELECT BLC.CAMPAIGN_ID CAMPAIGN_ID , BLC.PERIOD_NAME PERIOD_NAME , BLC.PERIOD_START_DATE START_DATE , BLC.PERIOD_END_DATE END_DATE , BLC.MEDIA_ID MEDIA_ID , BMC.MEDIA_NAME MEDIA_NAME , BMC.MEDIA_TYPE_CODE MEDIA_TYPE , BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME , BLC.CHANNEL_ID CHANNEL_ID , BMC.CHANNEL_NAME CHANNEL_NAME , BLC.MARKET_SEGMENT_ID MARKET_SEGMENT_ID , BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME , BLC.SALES_CHANNEL_CODE SALES_CHANNEL_CODE , BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME , BLC.GEOGRAPHY_CODE , BLC.NUM_OF_ORDERS NUM_OF_ORDERS , BLC.NUM_OF_LEADS NUM_OF_LEADS , BLC.NUM_OF_OPPORTUNITIES NUM_OF_OPPORTUNITIES , BLC.NUM_OF_ORDERS_FROM_LEADS NUM_OF_ORDERS_FROM_LEADS , BLC.NUM_OF_ORDERS_FROM_OPPS NUM_OF_ORDERS_FROM_OPPS FROM BIM_LEAD_CONV_SUMM BLC , BIM_DIMV_MEDIA_CHANNELS BMC , BIM_DIMV_MARKET_SGMTS BMS , BIM_DIMV_SALES_CHANNELS BSC WHERE BLC.MEDIA_ID = BMC.MEDIA_ID AND BLC.CHANNEL_ID = BMC.CHANNEL_ID AND BLC.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID AND BLC.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE WITH READ ONLY

View Text - HTML Formatted

SELECT BLC.CAMPAIGN_ID CAMPAIGN_ID
, BLC.PERIOD_NAME PERIOD_NAME
, BLC.PERIOD_START_DATE START_DATE
, BLC.PERIOD_END_DATE END_DATE
, BLC.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BLC.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BLC.MARKET_SEGMENT_ID MARKET_SEGMENT_ID
, BMS.MARKET_SEGMENT_NAME MARKET_SEGMENT_NAME
, BLC.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, BSC.SALES_CHANNEL_NAME SALES_CHANNEL_NAME
, BLC.GEOGRAPHY_CODE
, BLC.NUM_OF_ORDERS NUM_OF_ORDERS
, BLC.NUM_OF_LEADS NUM_OF_LEADS
, BLC.NUM_OF_OPPORTUNITIES NUM_OF_OPPORTUNITIES
, BLC.NUM_OF_ORDERS_FROM_LEADS NUM_OF_ORDERS_FROM_LEADS
, BLC.NUM_OF_ORDERS_FROM_OPPS NUM_OF_ORDERS_FROM_OPPS
FROM BIM_LEAD_CONV_SUMM BLC
, BIM_DIMV_MEDIA_CHANNELS BMC
, BIM_DIMV_MARKET_SGMTS BMS
, BIM_DIMV_SALES_CHANNELS BSC
WHERE BLC.MEDIA_ID = BMC.MEDIA_ID
AND BLC.CHANNEL_ID = BMC.CHANNEL_ID
AND BLC.MARKET_SEGMENT_ID = BMS.MARKET_SEGMENT_ID
AND BLC.SALES_CHANNEL_CODE = BSC.SALES_CHANNEL_CODE WITH READ ONLY