VIEW: APPS.IGS_GE_REF_CD_TYPE_V

Source

View Text - Preformatted

SELECT RCT.ROWID row_id, rct.reference_cd_type reference_cd_type, rct.description description, rct.self_service_flag self_service_flag, rct.program_flag program_flag, rct.program_offering_option_flag program_offering_option_flag, rct.unit_flag unit_flag, rct.unit_section_flag unit_section_flag, rct.unit_section_occurrence_flag unit_section_occurrence_flag, rct.s_reference_cd_type s_reference_cd_type, rct.closed_ind closed_ind, rct.created_by created_by, rct.creation_date creation_date, rct.last_updated_by last_updated_by, rct.last_update_date last_update_date, rct.last_update_login last_update_login, ilv.meaning dsp_meaning, ilv.closed_ind dsp_closed_ind , rct.mandatory_flag mandatory_flag, rct.restricted_flag FROM igs_ge_ref_cd_type rct, igs_lookups_view ilv WHERE ilv.lookup_code = rct.s_reference_cd_type AND ilv.lookup_type = 'REFERENCE_CD_TYPE'

View Text - HTML Formatted

SELECT RCT.ROWID ROW_ID
, RCT.REFERENCE_CD_TYPE REFERENCE_CD_TYPE
, RCT.DESCRIPTION DESCRIPTION
, RCT.SELF_SERVICE_FLAG SELF_SERVICE_FLAG
, RCT.PROGRAM_FLAG PROGRAM_FLAG
, RCT.PROGRAM_OFFERING_OPTION_FLAG PROGRAM_OFFERING_OPTION_FLAG
, RCT.UNIT_FLAG UNIT_FLAG
, RCT.UNIT_SECTION_FLAG UNIT_SECTION_FLAG
, RCT.UNIT_SECTION_OCCURRENCE_FLAG UNIT_SECTION_OCCURRENCE_FLAG
, RCT.S_REFERENCE_CD_TYPE S_REFERENCE_CD_TYPE
, RCT.CLOSED_IND CLOSED_IND
, RCT.CREATED_BY CREATED_BY
, RCT.CREATION_DATE CREATION_DATE
, RCT.LAST_UPDATED_BY LAST_UPDATED_BY
, RCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ILV.MEANING DSP_MEANING
, ILV.CLOSED_IND DSP_CLOSED_IND
, RCT.MANDATORY_FLAG MANDATORY_FLAG
, RCT.RESTRICTED_FLAG
FROM IGS_GE_REF_CD_TYPE RCT
, IGS_LOOKUPS_VIEW ILV
WHERE ILV.LOOKUP_CODE = RCT.S_REFERENCE_CD_TYPE
AND ILV.LOOKUP_TYPE = 'REFERENCE_CD_TYPE'