VIEW: APPS.IGS_CA_INST_ALT_V

Source

View Text - Preformatted

SELECT ci.CAL_TYPE, ci.sequence_number, ci.start_dt, ci.end_dt, ci.CAL_STATUS, cs.s_cal_status, ci.alternate_code, cat.description, cat.S_CAL_CAT, cat.abbreviation, ci.created_by, ci.creation_date, ci.last_updated_by, ci.last_update_date, ci.last_update_login FROM IGS_CA_INST ci, IGS_CA_TYPE cat, IGS_CA_STAT cs WHERE cat.CAL_TYPE = ci.CAL_TYPE AND cs.CAL_STATUS = ci.CAL_STATUS

View Text - HTML Formatted

SELECT CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.CAL_STATUS
, CS.S_CAL_STATUS
, CI.ALTERNATE_CODE
, CAT.DESCRIPTION
, CAT.S_CAL_CAT
, CAT.ABBREVIATION
, CI.CREATED_BY
, CI.CREATION_DATE
, CI.LAST_UPDATED_BY
, CI.LAST_UPDATE_DATE
, CI.LAST_UPDATE_LOGIN
FROM IGS_CA_INST CI
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CAT.CAL_TYPE = CI.CAL_TYPE
AND CS.CAL_STATUS = CI.CAL_STATUS