[Home] [Help]
View: IGS_CA_DA_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DA.ROWID ROW_ID
, DA.DT_ALIAS DT_ALIAS
, DA.DESCRIPTION DESCRIPTION
, DA.DT_CAT DT_CAT
, DAC.DESCRIPTION DAC_DESCRIPTION
, DA.ABBREVIATION ABBREVIATION
, DA.S_CAL_CAT S_CAL_CAT
, LKUP.MEANING MEANING
, DA.CLOSED_IND CLOSED_IND
, DA.NOTES NOTES
, DA.CREATED_BY CREATED_BY
, DA.CREATION_DATE CREATION_DATE
, DA.LAST_UPDATED_BY LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_DA DA
, IGS_LOOKUP_VALUES LKUP
, IGS_CA_DA_CAT DAC
WHERE LKUP.LOOKUP_CODE = DA.S_CAL_CAT
AND LKUP.LOOKUP_TYPE = 'CAL_CAT'
AND DA.DT_CAT = DAC.DT_CAT UNION ALL SELECT DA.ROWID ROW_ID
, DA.DT_ALIAS DT_ALIAS
, DA.DESCRIPTION DESCRIPTION
, DA.DT_CAT DT_CAT
, DAC.DESCRIPTION DAC_DESCRIPTION
, DA.ABBREVIATION ABBREVIATION
, DA.S_CAL_CAT S_CAL_CAT
, NULL MEANING
, DA.CLOSED_IND CLOSED_IND
, DA.NOTES NOTES
, DA.CREATED_BY CREATED_BY
, DA.CREATION_DATE CREATION_DATE
, DA.LAST_UPDATED_BY LAST_UPDATED_BY
, DA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_DA DA
, IGS_CA_DA_CAT DAC
WHERE DA.S_CAL_CAT IS NULL
AND DA.DT_CAT = DAC.DT_CAT
Columns
| Name |
| ROW_ID |
| DT_ALIAS |
| DESCRIPTION |
| DT_CAT |
| DAC_DESCRIPTION |
| ABBREVIATION |
| S_CAL_CAT |
| MEANING |
| CLOSED_IND |
| NOTES |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |