VIEW: APPS.IGS_EN_DCNT_REASONCD_V

Source

View Text - Preformatted

SELECT dr.ROWID ROW_ID, dr.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD, dr.DESCRIPTION DESCRIPTION, dr.DFLT_IND DFLT_IND, dr.CLOSED_IND CLOSED_IND, dr.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE, lkups.MEANING MEANING, lkups.closed_ind dsp_closed_ind, dr.SYS_DFLT_IND SYS_DFLT_IND, dr.COMMENTS COMMENTS, dr.DCNT_PROGRAM_IND DCNT_PROGRAM_IND, dr.DCNT_UNIT_IND DCNT_UNIT_IND, dr.CREATED_BY CREATED_BY, dr.CREATION_DATE CREATION_DATE, dr.LAST_UPDATED_BY LAST_UPDATED_BY, dr.LAST_UPDATE_DATE LAST_UPDATE_DATE, dr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_EN_DCNT_REASONCD dr, IGS_LOOKUPS_VIEW lkups WHERE dr.S_DISCONTINUATION_REASON_TYPE IS NOT NULL AND lkups.LOOKUP_CODE = DR.S_DISCONTINUATION_REASON_TYPE AND lkups.CLOSED_IND = 'N' AND lkups.lookup_type = 'DISCONTINUATION_REASON_TYPE' UNION SELECT dr.ROWID ROW_ID, dr.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD, dr.DESCRIPTION DESCRIPTION, dr.DFLT_IND DFLT_IND, dr.CLOSED_IND CLOSED_IND, dr.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE, TO_CHAR(NULL) MEANING, TO_CHAR(NULL) dsp_closed_ind, dr.SYS_DFLT_IND SYS_DFLT_IND, dr.COMMENTS COMMENTS, dr.DCNT_PROGRAM_IND DCNT_PROGRAM_IND, dr.DCNT_UNIT_IND DCNT_UNIT_IND, dr.CREATED_BY CREATED_BY, dr.CREATION_DATE CREATION_DATE, dr.LAST_UPDATED_BY LAST_UPDATED_BY, dr.LAST_UPDATE_DATE LAST_UPDATE_DATE, dr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IGS_EN_DCNT_REASONCD dr WHERE dr.S_DISCONTINUATION_REASON_TYPE IS NULL

View Text - HTML Formatted

SELECT DR.ROWID ROW_ID
, DR.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, DR.DESCRIPTION DESCRIPTION
, DR.DFLT_IND DFLT_IND
, DR.CLOSED_IND CLOSED_IND
, DR.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE
, LKUPS.MEANING MEANING
, LKUPS.CLOSED_IND DSP_CLOSED_IND
, DR.SYS_DFLT_IND SYS_DFLT_IND
, DR.COMMENTS COMMENTS
, DR.DCNT_PROGRAM_IND DCNT_PROGRAM_IND
, DR.DCNT_UNIT_IND DCNT_UNIT_IND
, DR.CREATED_BY CREATED_BY
, DR.CREATION_DATE CREATION_DATE
, DR.LAST_UPDATED_BY LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_DCNT_REASONCD DR
, IGS_LOOKUPS_VIEW LKUPS
WHERE DR.S_DISCONTINUATION_REASON_TYPE IS NOT NULL
AND LKUPS.LOOKUP_CODE = DR.S_DISCONTINUATION_REASON_TYPE
AND LKUPS.CLOSED_IND = 'N'
AND LKUPS.LOOKUP_TYPE = 'DISCONTINUATION_REASON_TYPE' UNION SELECT DR.ROWID ROW_ID
, DR.DISCONTINUATION_REASON_CD DISCONTINUATION_REASON_CD
, DR.DESCRIPTION DESCRIPTION
, DR.DFLT_IND DFLT_IND
, DR.CLOSED_IND CLOSED_IND
, DR.S_DISCONTINUATION_REASON_TYPE S_DISCONTINUATION_REASON_TYPE
, TO_CHAR(NULL) MEANING
, TO_CHAR(NULL) DSP_CLOSED_IND
, DR.SYS_DFLT_IND SYS_DFLT_IND
, DR.COMMENTS COMMENTS
, DR.DCNT_PROGRAM_IND DCNT_PROGRAM_IND
, DR.DCNT_UNIT_IND DCNT_UNIT_IND
, DR.CREATED_BY CREATED_BY
, DR.CREATION_DATE CREATION_DATE
, DR.LAST_UPDATED_BY LAST_UPDATED_BY
, DR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_EN_DCNT_REASONCD DR
WHERE DR.S_DISCONTINUATION_REASON_TYPE IS NULL