View: IGS_CA_TYPE_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_CA_TYPE_V

View Text

SELECT CAT.ROWID ROW_ID
, CAT.CAL_TYPE CAL_TYPE
, CAT.DESCRIPTION DESCRIPTION
, CAT.S_CAL_CAT S_CAL_CAT
, LKUP.MEANING MEANING
, CAT.ABBREVIATION ABBREVIATION
, CAT.ARTS_TEACHING_CAL_TYPE_CD ARTS_TEACHING_CAL_TYPE_CD
, CAT.CLOSED_IND CLOSED_IND
, ATCTC.DESCRIPTION ATCTC_DESCRIPTION
, ATCTC.CLOSED_IND ATCTC_CLOSED_IND
, CAT.NOTES NOTES
, CAT.CREATED_BY CREATED_BY
, CAT.CREATION_DATE CREATION_DATE
, CAT.LAST_UPDATED_BY LAST_UPDATED_BY
, CAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_CA_TYPE CAT
, IGS_LOOKUPS_VIEW LKUP
, IGS_CA_ARTS_TC_CA_CD ATCTC
WHERE ATCTC.ARTS_TEACHING_CAL_TYPE_CD (+)= CAT.ARTS_TEACHING_CAL_TYPE_CD
AND LKUP.LOOKUP_CODE = CAT.S_CAL_CAT
AND LKUP.LOOKUP_TYPE = 'CAL_CAT'

Columns