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_EVENT_REV

Source

View Text - Preformatted


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

View Text - HTML Formatted

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