VIEW: APPS.IGS_AS_SUA_EXAM_CLASH_V

Source

View Text - Preformatted

SELECT ACI.CAL_TYPE , ACI.SEQUENCE_NUMBER , SUA1.PERSON_ID , SUA1.UNIT_CD , SUA1.CAL_TYPE , SUA1.CI_SEQUENCE_NUMBER , SUA1.LOCATION_CD , SUA2.UNIT_CD , SUA2.CAL_TYPE , SUA2.CI_SEQUENCE_NUMBER , SUA2.LOCATION_CD , SUA1.created_by , SUA1.creation_date , SUA1.last_updated_by , SUA1.last_update_date , SUA1.last_update_login , SUA1.DEG_AUD_DETAIL_ID FROM IGS_CA_INST ACI, IGS_CA_INST TCI, IGS_CA_TYPE CT, IGS_CA_STAT CS, IGS_EN_SU_ATTEMPT SUA1, IGS_EN_SU_ATTEMPT SUA2 WHERE CT.CAL_TYPE = TCI.CAL_TYPE AND CT.S_CAL_CAT = 'TEACHING' AND CS.CAL_STATUS = TCI.CAL_STATUS AND CS.S_CAL_STATUS = 'ACTIVE' AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE,ACI.SEQUENCE_NUMBER, TCI.CAL_TYPE,TCI.SEQUENCE_NUMBER,'N') = 'Y' AND SUA1.CAL_TYPE = TCI.CAL_TYPE AND SUA1.CI_SEQUENCE_NUMBER = TCI.SEQUENCE_NUMBER AND SUA1.UNIT_ATTEMPT_STATUS = 'ENROLLED' AND SUA2.PERSON_ID = SUA1.PERSON_ID AND SUA2.UNIT_CD != SUA1.UNIT_CD AND SUA2.LOCATION_CD != SUA1.LOCATION_CD AND (( SUA2.CAL_TYPE = SUA1.CAL_TYPE AND SUA2.CI_SEQUENCE_NUMBER = SUA1.CI_SEQUENCE_NUMBER) OR IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE,ACI.SEQUENCE_NUMBER, SUA2.CAL_TYPE,SUA2.CI_SEQUENCE_NUMBER,'N') = 'Y') AND SUA2.UNIT_ATTEMPT_STATUS = 'ENROLLED'

View Text - HTML Formatted

SELECT ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, SUA1.PERSON_ID
, SUA1.UNIT_CD
, SUA1.CAL_TYPE
, SUA1.CI_SEQUENCE_NUMBER
, SUA1.LOCATION_CD
, SUA2.UNIT_CD
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, SUA2.LOCATION_CD
, SUA1.CREATED_BY
, SUA1.CREATION_DATE
, SUA1.LAST_UPDATED_BY
, SUA1.LAST_UPDATE_DATE
, SUA1.LAST_UPDATE_LOGIN
, SUA1.DEG_AUD_DETAIL_ID
FROM IGS_CA_INST ACI
, IGS_CA_INST TCI
, IGS_CA_TYPE CT
, IGS_CA_STAT CS
, IGS_EN_SU_ATTEMPT SUA1
, IGS_EN_SU_ATTEMPT SUA2
WHERE CT.CAL_TYPE = TCI.CAL_TYPE
AND CT.S_CAL_CAT = 'TEACHING'
AND CS.CAL_STATUS = TCI.CAL_STATUS
AND CS.S_CAL_STATUS = 'ACTIVE'
AND IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, TCI.CAL_TYPE
, TCI.SEQUENCE_NUMBER
, 'N') = 'Y'
AND SUA1.CAL_TYPE = TCI.CAL_TYPE
AND SUA1.CI_SEQUENCE_NUMBER = TCI.SEQUENCE_NUMBER
AND SUA1.UNIT_ATTEMPT_STATUS = 'ENROLLED'
AND SUA2.PERSON_ID = SUA1.PERSON_ID
AND SUA2.UNIT_CD != SUA1.UNIT_CD
AND SUA2.LOCATION_CD != SUA1.LOCATION_CD
AND (( SUA2.CAL_TYPE = SUA1.CAL_TYPE
AND SUA2.CI_SEQUENCE_NUMBER = SUA1.CI_SEQUENCE_NUMBER) OR IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(ACI.CAL_TYPE
, ACI.SEQUENCE_NUMBER
, SUA2.CAL_TYPE
, SUA2.CI_SEQUENCE_NUMBER
, 'N') = 'Y')
AND SUA2.UNIT_ATTEMPT_STATUS = 'ENROLLED'