VIEW: APPS.BIM_SUMV_CAMP_COST

Source

View Text - Preformatted

SELECT BCR.CAMPAIGN_ID CAMPAIGN_ID , BCR.PERIOD_NAME PERIOD_NAME , BCR.PERIOD_START_DATE START_DATE , BCR.PERIOD_END_DATE END_DATE , BCR.MEDIA_ID MEDIA_ID , BMC.MEDIA_NAME MEDIA_NAME , BMC.MEDIA_TYPE_CODE MEDIA_TYPE , BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME , BCR.CHANNEL_ID CHANNEL_ID , BMC.CHANNEL_NAME CHANNEL_NAME , BCR.FORECASTED_REVENUE FORECASTED_REVENUE , BCR.FORECASTED_COST FORECASTED_COST , BCR.INITIATED_REVENUE INITIATED_REVENUE , BCR.ACTUAL_COST ACTUAL_COST , BCR.NUM_OF_LEADS NUM_OF_LEADS FROM BIM_CMPGN_REVCOST_SUMM BCR , BIM_DIMV_MEDIA_CHANNELS BMC WHERE BCR.MEDIA_ID = BMC.MEDIA_ID AND BCR.CHANNEL_ID = BMC.CHANNEL_ID WITH READ ONLY

View Text - HTML Formatted

SELECT BCR.CAMPAIGN_ID CAMPAIGN_ID
, BCR.PERIOD_NAME PERIOD_NAME
, BCR.PERIOD_START_DATE START_DATE
, BCR.PERIOD_END_DATE END_DATE
, BCR.MEDIA_ID MEDIA_ID
, BMC.MEDIA_NAME MEDIA_NAME
, BMC.MEDIA_TYPE_CODE MEDIA_TYPE
, BMC.MEDIA_TYPE_NAME MEDIA_TYPE_NAME
, BCR.CHANNEL_ID CHANNEL_ID
, BMC.CHANNEL_NAME CHANNEL_NAME
, BCR.FORECASTED_REVENUE FORECASTED_REVENUE
, BCR.FORECASTED_COST FORECASTED_COST
, BCR.INITIATED_REVENUE INITIATED_REVENUE
, BCR.ACTUAL_COST ACTUAL_COST
, BCR.NUM_OF_LEADS NUM_OF_LEADS
FROM BIM_CMPGN_REVCOST_SUMM BCR
, BIM_DIMV_MEDIA_CHANNELS BMC
WHERE BCR.MEDIA_ID = BMC.MEDIA_ID
AND BCR.CHANNEL_ID = BMC.CHANNEL_ID WITH READ ONLY