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_RSLTS

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.NUM_AVAILABLE NUM_AVAILABLE , BER.NUM_TARGETED NUM_TARGETED , BER.NUM_RESPONDED NUM_RESPONDED , BER.NUM_ENROLLED NUM_ENROLLED , BER.NUM_ATTENDED NUM_ATTENDED , BER.NUM_CANCELLED NUM_CANCELLED FROM BIM_EVENT_RESP_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.NUM_AVAILABLE NUM_AVAILABLE
, BER.NUM_TARGETED NUM_TARGETED
, BER.NUM_RESPONDED NUM_RESPONDED
, BER.NUM_ENROLLED NUM_ENROLLED
, BER.NUM_ATTENDED NUM_ATTENDED
, BER.NUM_CANCELLED NUM_CANCELLED
FROM BIM_EVENT_RESP_SUMM BER
, BIM_DIMV_EVENT_HIER BEH
WHERE BER.EVENT_OFFERING_ID = BEH.EVENT_OFFER_ID WITH READ ONLY