VIEW: APPS.IGS_EN_ST_SNAPSHOT_WARNING_V

Source

View Text - Preformatted

SELECT ess.ess_id, ess.snapshot_dt_time, ess.ci_cal_type, ess.ci_sequence_number, ci.start_dt, ci.end_dt, ess.person_id, pdv.person_number, pdv.initial_last_name, ess.course_cd || '  ' || TO_CHAR(ess.crv_version_number), crv.abbreviation, ess.unit_cd || '  ' || TO_CHAR(ess.uv_version_number), uv.abbreviation, ess.sua_cal_type, ess.sua_ci_sequence_number, ci2.start_dt, ci2.end_dt, ci2.alternate_code, ess.tr_org_unit_cd, ess.tr_ou_start_dt, ess.eftsu, ess.weftsu, ess.discipline_group_cd, ess.govt_discipline_group_cd, ess.govt_reportable_ind, ess.created_by, ess.creation_date, ess.last_updated_by, ess.last_update_date, ess.last_update_login FROM IGS_EN_ST_SNAPSHOT ess, IGS_CA_INST ci, IGS_PE_PERSON_V pdv, IGS_PS_VER crv, IGS_PS_UNIT_VER uv, IGS_CA_INST ci2 WHERE ess.ci_cal_type = ci.cal_type AND ess.ci_sequence_number = ci.sequence_number AND ess.person_id = pdv.person_id AND ess.course_cd = crv.course_cd AND ess.crv_version_number = crv.version_number AND ess.unit_cd = uv.unit_cd AND ess.uv_version_number = uv.version_number AND ess.sua_cal_type = ci2.cal_type AND ess.sua_ci_sequence_number = ci2.sequence_number AND (ess.govt_reportable_ind = 'W' OR ess.govt_reportable_ind = 'X')

View Text - HTML Formatted

SELECT ESS.ESS_ID
, ESS.SNAPSHOT_DT_TIME
, ESS.CI_CAL_TYPE
, ESS.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, ESS.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.INITIAL_LAST_NAME
, ESS.COURSE_CD || ' ' || TO_CHAR(ESS.CRV_VERSION_NUMBER)
, CRV.ABBREVIATION
, ESS.UNIT_CD || ' ' || TO_CHAR(ESS.UV_VERSION_NUMBER)
, UV.ABBREVIATION
, ESS.SUA_CAL_TYPE
, ESS.SUA_CI_SEQUENCE_NUMBER
, CI2.START_DT
, CI2.END_DT
, CI2.ALTERNATE_CODE
, ESS.TR_ORG_UNIT_CD
, ESS.TR_OU_START_DT
, ESS.EFTSU
, ESS.WEFTSU
, ESS.DISCIPLINE_GROUP_CD
, ESS.GOVT_DISCIPLINE_GROUP_CD
, ESS.GOVT_REPORTABLE_IND
, ESS.CREATED_BY
, ESS.CREATION_DATE
, ESS.LAST_UPDATED_BY
, ESS.LAST_UPDATE_DATE
, ESS.LAST_UPDATE_LOGIN
FROM IGS_EN_ST_SNAPSHOT ESS
, IGS_CA_INST CI
, IGS_PE_PERSON_V PDV
, IGS_PS_VER CRV
, IGS_PS_UNIT_VER UV
, IGS_CA_INST CI2
WHERE ESS.CI_CAL_TYPE = CI.CAL_TYPE
AND ESS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ESS.PERSON_ID = PDV.PERSON_ID
AND ESS.COURSE_CD = CRV.COURSE_CD
AND ESS.CRV_VERSION_NUMBER = CRV.VERSION_NUMBER
AND ESS.UNIT_CD = UV.UNIT_CD
AND ESS.UV_VERSION_NUMBER = UV.VERSION_NUMBER
AND ESS.SUA_CAL_TYPE = CI2.CAL_TYPE
AND ESS.SUA_CI_SEQUENCE_NUMBER = CI2.SEQUENCE_NUMBER
AND (ESS.GOVT_REPORTABLE_IND = 'W' OR ESS.GOVT_REPORTABLE_IND = 'X')