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.

[Home] [Help]

View: IGS_CO_S_LTR_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DRVTAB.ROWID ROW_ID
, DRVTAB.CORRESPONDENCE_TYPE CORRESPONDENCE_TYPE
, CORT.DESCRIPTION COR_TYP_DESC
, CORT.SYS_GENERATED_IND SYS_GENERATED_IND
, CORT.CLOSED_IND CLOSED_IND2
, DRVTAB.LETTER_REFERENCE_NUMBER LETTER_REFERENCE_NUMBER
, DRVTAB.DESCRIPTION DESCRIPTION
, DRVTAB.S_LETTER_REFERENCE_TYPE S_LETTER_REFERENCE_TYPE
, LKUP1.MEANING MEANING2
, DRVTAB.S_LETTER_OBJECT S_LETTER_OBJECT
, LKUP2.MEANING MEANING1
, DRVTAB.TEMPLATE_FILENAME TEMPLATE_FILENAME
, DRVTAB.LETTER_TITLE LETTER_TITLE
, DRVTAB.CLOSED_IND CLOSED_IND
, DRVTAB.CREATED_BY CREATED_BY
, DRVTAB.CREATION_DATE CREATION_DATE
, DRVTAB.LAST_UPDATED_BY LAST_UPDATED_BY
, DRVTAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DRVTAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_CO_S_LTR DRVTAB
, IGS_LOOKUPS_VIEW LKUP1
, IGS_LOOKUPS_VIEW LKUP2
, IGS_CO_TYPE CORT
WHERE DRVTAB.S_LETTER_REFERENCE_TYPE = LKUP1.LOOKUP_CODE
AND LKUP1.LOOKUP_TYPE='LETTER_REFERENCE_TYPE'
AND DRVTAB.S_LETTER_OBJECT=LKUP2.LOOKUP_CODE
AND LKUP2.LOOKUP_TYPE='LETTER_OBJECT'
AND DRVTAB.CORRESPONDENCE_TYPE=CORT.CORRESPONDENCE_TYPE
AND (CORT.CLOSED_IND='N' OR DRVTAB.CORRESPONDENCE_TYPE=CORT.CORRESPONDENCE_TYPE)
AND CORT.SYS_GENERATED_IND='Y'

Columns

Name
ROW_ID
CORRESPONDENCE_TYPE
COR_TYP_DESC
SYS_GENERATED_IND
CLOSED_IND2
LETTER_REFERENCE_NUMBER
DESCRIPTION
S_LETTER_REFERENCE_TYPE
MEANING2
S_LETTER_OBJECT
MEANING1
TEMPLATE_FILENAME
LETTER_TITLE
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE