VIEW: APPS.IGS_PS_USEC_TCH_RESP_V

Source

View Text - Preformatted

SELECT ustr.rowid row_id, ustr.unit_section_teach_resp_id, ustr.uoo_id uoo_id, ustr.instructor_id instructor_id, pe.person_last_name || ',  '|| pe.person_first_name||' '||pe.person_middle_name surname, ustr.confirmed_flag confirmed_flag, ustr.percentage_allocation percentage_allocation, ustr.instructional_load instructional_load, ustr.instructional_load_lab, ustr.instructional_load_lecture, ustr.lead_instructor_flag lead_instructor_flag, ustr.created_by created_by, ustr.creation_date creation_date, ustr.last_updated_by last_updated_by, ustr.last_update_date last_update_date, ustr.last_update_login last_update_login, pe.party_number FROM igs_ps_usec_tch_resp ustr, hz_parties pe WHERE ustr.instructor_id = pe.party_id

View Text - HTML Formatted

SELECT USTR.ROWID ROW_ID
, USTR.UNIT_SECTION_TEACH_RESP_ID
, USTR.UOO_ID UOO_ID
, USTR.INSTRUCTOR_ID INSTRUCTOR_ID
, PE.PERSON_LAST_NAME || '
, '|| PE.PERSON_FIRST_NAME||' '||PE.PERSON_MIDDLE_NAME SURNAME
, USTR.CONFIRMED_FLAG CONFIRMED_FLAG
, USTR.PERCENTAGE_ALLOCATION PERCENTAGE_ALLOCATION
, USTR.INSTRUCTIONAL_LOAD INSTRUCTIONAL_LOAD
, USTR.INSTRUCTIONAL_LOAD_LAB
, USTR.INSTRUCTIONAL_LOAD_LECTURE
, USTR.LEAD_INSTRUCTOR_FLAG LEAD_INSTRUCTOR_FLAG
, USTR.CREATED_BY CREATED_BY
, USTR.CREATION_DATE CREATION_DATE
, USTR.LAST_UPDATED_BY LAST_UPDATED_BY
, USTR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USTR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PE.PARTY_NUMBER
FROM IGS_PS_USEC_TCH_RESP USTR
, HZ_PARTIES PE
WHERE USTR.INSTRUCTOR_ID = PE.PARTY_ID