VIEW: APPS.IGS_SS_USEC_OCCURENCES_V

Source

View Text - Preformatted

SELECT distinct c.unit_section_occurrence_id, c.uoo_id, decode(c.monday,'Y','Mon',null)|| decode(c.tuesday,'Y','Tue',null)|| decode(c.wednesday,'Y','Wed',null)|| decode(c.thursday,'Y','Thu',null)|| decode(c.friday,'Y','Fri',null)|| decode(c.saturday,'Y','Sat',null)|| decode(c.sunday,'Y','Sun',null), to_char(c.start_time,'hh:miam')||'-'||to_char(c.end_time,'hh:miam'), d.location_cd, b.description, c.building_code, d.building_cd, d.description building_description, c.room_code, e.room_cd, e.description room_description, c.instructor_id, f.person_last_name, f.person_first_name, f. person_title, f.person_last_name||',  '||f.person_first_name||'  '||f.person_middle_name ,c.start_date ,c.end_date from igs_ps_usec_occurs c, igs_ad_building d, igs_ad_room e, hz_parties f, igs_ad_location b WHERE c.building_code = d.building_id(+) and c.room_code = e.room_id(+) and c.instructor_id = f.party_id(+) and d.location_cd = b.location_cd(+)

View Text - HTML Formatted

SELECT DISTINCT C.UNIT_SECTION_OCCURRENCE_ID
, C.UOO_ID
, DECODE(C.MONDAY
, 'Y'
, 'MON'
, NULL)|| DECODE(C.TUESDAY
, 'Y'
, 'TUE'
, NULL)|| DECODE(C.WEDNESDAY
, 'Y'
, 'WED'
, NULL)|| DECODE(C.THURSDAY
, 'Y'
, 'THU'
, NULL)|| DECODE(C.FRIDAY
, 'Y'
, 'FRI'
, NULL)|| DECODE(C.SATURDAY
, 'Y'
, 'SAT'
, NULL)|| DECODE(C.SUNDAY
, 'Y'
, 'SUN'
, NULL)
, TO_CHAR(C.START_TIME
, 'HH:MIAM')||'-'||TO_CHAR(C.END_TIME
, 'HH:MIAM')
, D.LOCATION_CD
, B.DESCRIPTION
, C.BUILDING_CODE
, D.BUILDING_CD
, D.DESCRIPTION BUILDING_DESCRIPTION
, C.ROOM_CODE
, E.ROOM_CD
, E.DESCRIPTION ROOM_DESCRIPTION
, C.INSTRUCTOR_ID
, F.PERSON_LAST_NAME
, F.PERSON_FIRST_NAME
, F. PERSON_TITLE
, F.PERSON_LAST_NAME||'
, '||F.PERSON_FIRST_NAME||' '||F.PERSON_MIDDLE_NAME
, C.START_DATE
, C.END_DATE
FROM IGS_PS_USEC_OCCURS C
, IGS_AD_BUILDING D
, IGS_AD_ROOM E
, HZ_PARTIES F
, IGS_AD_LOCATION B
WHERE C.BUILDING_CODE = D.BUILDING_ID(+)
AND C.ROOM_CODE = E.ROOM_ID(+)
AND C.INSTRUCTOR_ID = F.PARTY_ID(+)
AND D.LOCATION_CD = B.LOCATION_CD(+)