VIEW: APPS.IGS_PS_UNIT_OFR_OPT_GRD_SCHM_V

Source

View Text - Preformatted

SELECT uoo.rowid row_id, uoo.unit_cd unit_cd, uoo.version_number version_number, uoo.cal_type cal_type, uoo.ci_sequence_number ci_sequence_number, uoo.location_cd location_cd, uoo.unit_class unit_class, uoo.uoo_id uoo_id, ci.start_dt dsp_ci_start_dt, ci.end_dt dsp_ci_end_dt, uv.unit_status dsp_unit_status, uv.title dsp_title, uoo.created_by created_by, uoo.creation_date creation_date, uoo.last_updated_by last_updated_by, uoo.last_update_date last_update_date, uoo.last_update_login last_update_login FROM igs_ps_unit_ofr_opt uoo, igs_ca_inst ci, igs_ps_unit_ver uv WHERE uoo.unit_cd = uv.unit_cd AND uoo.version_number = uv.version_number AND uoo.cal_type = ci.cal_type AND uoo.ci_sequence_number = ci.sequence_number

View Text - HTML Formatted

SELECT UOO.ROWID ROW_ID
, UOO.UNIT_CD UNIT_CD
, UOO.VERSION_NUMBER VERSION_NUMBER
, UOO.CAL_TYPE CAL_TYPE
, UOO.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, UOO.LOCATION_CD LOCATION_CD
, UOO.UNIT_CLASS UNIT_CLASS
, UOO.UOO_ID UOO_ID
, CI.START_DT DSP_CI_START_DT
, CI.END_DT DSP_CI_END_DT
, UV.UNIT_STATUS DSP_UNIT_STATUS
, UV.TITLE DSP_TITLE
, UOO.CREATED_BY CREATED_BY
, UOO.CREATION_DATE CREATION_DATE
, UOO.LAST_UPDATED_BY LAST_UPDATED_BY
, UOO.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOO.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_UNIT_OFR_OPT UOO
, IGS_CA_INST CI
, IGS_PS_UNIT_VER UV
WHERE UOO.UNIT_CD = UV.UNIT_CD
AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
AND UOO.CAL_TYPE = CI.CAL_TYPE
AND UOO.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER