View: IGS_PS_FAC_CAL_INST_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PS_FAC_CAL_INST_V

View Text

SELECT PEV.PERSON_ID INSTRUCTOR_ID
, PEV.PERSON_NUMBER PERSON_NUMBER
, PEV.FULL_NAME INSTRUCTOR_NAME
, PEV.BIRTH_DATE BIRTH_DT
, PEV.GENDER SEX
, CI.CAL_TYPE CAL_TYPE
, CI.SEQUENCE_NUMBER SEQUENCE_NUMBER
, CI.ALTERNATE_CODE ALTERNATE_CD
, CI.START_DT START_DT
, CI.END_DT END_DT
, PEV.CREATED_BY CREATED_BY
, PEV.CREATION_DATE CREATION_DATE
, PEV.LAST_UPDATED_BY LAST_UPDATED_BY
, PEV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PEV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI
, IGS_PE_PERSON_BASE_V PEV
, IGS_PS_USEC_TCH_RESP USR
, IGS_PS_UNIT_OFR_OPT_ALL UOO
WHERE PEV.PERSON_ID=USR.INSTRUCTOR_ID
AND USR.UOO_ID=UOO.UOO_ID
AND UOO.CAL_TYPE=CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER=CI.SEQUENCE_NUMBER
AND UOO.UOO_ID = ( SELECT MAX(UOO1.UOO_ID)
FROM IGS_PS_USEC_TCH_RESP USR1
, IGS_PS_UNIT_OFR_OPT_ALL UOO1
WHERE UOO1.UOO_ID = USR1.UOO_ID
AND USR1.INSTRUCTOR_ID = USR.INSTRUCTOR_ID
AND UOO.CAL_TYPE = UOO1.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = UOO1.CI_SEQUENCE_NUMBER )

Columns