[Home] [Help]
View: IGSFV_CALENDAR_PERIOD_TYPES
Product: | IGS - Student System |
Description: | This is the full view for the entity Calendar Period Types which describes available calendar types. |
Implementation/DBA Data: |
APPS.IGSFV_CALENDAR_PERIOD_TYPES
|
View Text
SELECT CA.CAL_TYPE
, CA.DESCRIPTION
, '_LA:CA.S_CAL_CAT:IGS_LOOKUP_VALUES:CAL_CAT:MEANING'
, CA.ABBREVIATION
, CA.ARTS_TEACHING_CAL_TYPE_CD
, CA.CLOSED_IND
, CA.NOTES
, AR1.DESCRIPTION
, CA.CREATED_BY
, CA.CREATION_DATE
, CA.LAST_UPDATED_BY
, CA.LAST_UPDATE_DATE
FROM IGS_CA_TYPE CA
, IGS_CA_ARTS_TC_CA_CD AR1
WHERE AR1.ARTS_TEACHING_CAL_TYPE_CD(+) = CA.ARTS_TEACHING_CAL_TYPE_CD WITH READ ONLY
Columns
Name |
CALENDAR_TYPE |
DESCRIPTION |
"_LA:S_CALENDAR_CATEGORY" |
ABBREVIATION |
ARTS_TEACHING_CAL_TYPE_CD |
CLOSED_INDICATOR |
NOTES |
ARTS_TEACHING_CAL_TYPE_DESC |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |