Product: | BIM - Marketing Intelligence |
---|---|
Description: | Joins the summary table to the dimension views. |
Implementation/DBA Data: | APPS.BIM_SUMV_EVENT_REV |
SELECT BER.EVENT_ID EVENT_ID
, BER.EVENT_OFFERING_ID EVENT_OFFERING_ID
, BEH.EVENT_NAME EVENT_NAME
, BEH.EVENT_OFFER_NAME EVENT_OFFERING_NAME
, BEH.EVENT_TYPE_CODE EVENT_TYPE
, BER.PERIOD_NAME PERIOD_NAME
, BER.PERIOD_START_DATE START_DATE
, BER.PERIOD_END_DATE END_DATE
, BER.REGISTRATION_REVENUE REGISTRATION_REVENUE
, BER.INITIATED_REVENUE INITIATED_REVENUE
, BER.FORECASTED_REVENUE FORECASTED_REVENUE
, BER.FORECASTED_COST FORECASTED_COST
, BER.NUM_OF_LEADS NUM_OF_LEADS
, BER.ACTUAL_COST ACTUAL_COST
FROM BIM_EVENT_REVCOST_SUMM BER
, BIM_DIMV_EVENT_HIER BEH
WHERE BER.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID WITH READ ONLY