VIEW: APPS.IGSFV_USEC_TEACH_INSTRUCTORS

Source

View Text - Preformatted

SELECT US.UNIT_SECTION_TEACH_RESP_ID, US.UOO_ID UNIT_SECTION_ID, US.INSTRUCTOR_ID, US.CONFIRMED_FLAG, US.PERCENTAGE_ALLOCATION, US.INSTRUCTIONAL_LOAD, US.LEAD_INSTRUCTOR_FLAG, US.INSTRUCTIONAL_LOAD_LAB, US.INSTRUCTIONAL_LOAD_LECTURE, HZ.PARTY_NUMBER, HZ.PARTY_NAME, UN.UNIT_CD, UN.VERSION_NUMBER, UN.CAL_TYPE, UN.CI_SEQUENCE_NUMBER, UN.LOCATION_CD, UN.UNIT_CLASS, US.CREATED_BY, US.CREATION_DATE, US.LAST_UPDATED_BY, US.LAST_UPDATE_DATE FROM IGS_PS_USEC_TCH_RESP US, HZ_PARTIES HZ, IGS_PS_UNIT_OFR_OPT_ALL UN WHERE UN.UOO_ID = US.UOO_ID AND US.INSTRUCTOR_ID = HZ.PARTY_ID AND HZ.STATUS = 'A' WITH READ ONLY

View Text - HTML Formatted

SELECT US.UNIT_SECTION_TEACH_RESP_ID
, US.UOO_ID UNIT_SECTION_ID
, US.INSTRUCTOR_ID
, US.CONFIRMED_FLAG
, US.PERCENTAGE_ALLOCATION
, US.INSTRUCTIONAL_LOAD
, US.LEAD_INSTRUCTOR_FLAG
, US.INSTRUCTIONAL_LOAD_LAB
, US.INSTRUCTIONAL_LOAD_LECTURE
, HZ.PARTY_NUMBER
, HZ.PARTY_NAME
, UN.UNIT_CD
, UN.VERSION_NUMBER
, UN.CAL_TYPE
, UN.CI_SEQUENCE_NUMBER
, UN.LOCATION_CD
, UN.UNIT_CLASS
, US.CREATED_BY
, US.CREATION_DATE
, US.LAST_UPDATED_BY
, US.LAST_UPDATE_DATE
FROM IGS_PS_USEC_TCH_RESP US
, HZ_PARTIES HZ
, IGS_PS_UNIT_OFR_OPT_ALL UN
WHERE UN.UOO_ID = US.UOO_ID
AND US.INSTRUCTOR_ID = HZ.PARTY_ID
AND HZ.STATUS = 'A' WITH READ ONLY