VIEW: APPS.IGS_CO_S_LTR_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'