eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.IGSFV_CALENDAR_PERIOD_TYPES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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