20150210 Halpin SOD report

This report is a calendar appointment that recurs on first Thursday every 6 months starting 2/6/14
The report is a simple query:

select count(pk1)

from bb_bb60.course_main cm

where cm.AVAILABLE_IND = ‘Y’

and cm.ROW_STATUS = 0

and cm.DATA_SRC_PK1 = 8

and (cm.COURSE_ID like ‘%DEN%’ or cm.COURSE_ID like ‘%DEP%’ or cm.COURSE_ID like ‘%CLIN%’ or cm.course_id like ‘%CDEP4100%’ or cm.course_id like ‘%NBDE4300%’ or cm.course_id like ‘%MBE-4200%’)

and cm.DTCREATED > to_date(SYSDATE-240)