VIEW: APPS.IGS_CA_TYPE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'