select
                        cm.src_id,
                        cm.ce_course_id,
                        cm.vendor_course_id,
                        case
                                when cm.course_proper = 'Y' then 'Course'
                                else 'Series'
                        end as type ,
                        case
                                when cm.course_proper = 'N' then cm2.ce_course_id
                                else null
                        end as series_member_id
                from
                        lmsapi_courseid_map cm,
                        lmsapi_courseid_map cm2
                where
                        cm.vendor_course_id = cm2.vendor_course_id and
                        cm2.course_proper = 'Y' and
                        cm.src_id = cm2.src_id
                order by
                        1, 2