VIEW: APPS.IGF_AP_APPL_SETUPDTL_V

Source

View Text - Preformatted

SELECT DISTINCT ias.rowid, ias.question_id, ias.question, ias.enabled, ias.org_id, ias.ci_cal_type, ias.ci_sequence_number, calrel.aw_start_dt, calrel.aw_end_dt, calrel.aw_alternate_code, ias.created_by, ias.creation_date, ias.last_updated_by, ias.last_update_date, ias.last_update_login, ias.application_code, ias.application_name, ias.active_flag, ias.answer_type_code, igf_aw_gen.lookup_desc('IGF_AP_ANSWER_TYPE', ias.answer_type_code) answer_type_desc, ias.destination_txt, ias.ld_cal_type, ias.ld_sequence_number, decode(ias.ld_cal_type, NULL, igf_aw_gen.lookup_desc('IGF_AP_ALL_TERMS', ias.all_terms_flag) , calrel.ld_alternate_code)ld_alternate_code, ias.all_terms_flag, ias.override_exist_ant_data_flag, ias.required_flag, ias.minimum_value_num, ias.maximum_value_num, ias.minimum_date, ias.maximium_date, ias.lookup_code, ias.hint_txt From igf_ap_appl_setup_all ias, IGF_AW_AWD_LD_CAL_V calrel WHERE calrel.aw_cal_type = ias.ci_cal_type AND calrel.aw_sequence_number = ias.ci_sequence_number AND ((calrel.ld_cal_type = ias.ld_cal_type AND calrel.ld_sequence_number = ias.ld_sequence_number) OR (ias.ALL_TERMS_FLAG = 'Y') OR (ias.all_terms_flag IS NULL AND ias.ld_cal_type IS NULL) )

View Text - HTML Formatted

SELECT DISTINCT IAS.ROWID
, IAS.QUESTION_ID
, IAS.QUESTION
, IAS.ENABLED
, IAS.ORG_ID
, IAS.CI_CAL_TYPE
, IAS.CI_SEQUENCE_NUMBER
, CALREL.AW_START_DT
, CALREL.AW_END_DT
, CALREL.AW_ALTERNATE_CODE
, IAS.CREATED_BY
, IAS.CREATION_DATE
, IAS.LAST_UPDATED_BY
, IAS.LAST_UPDATE_DATE
, IAS.LAST_UPDATE_LOGIN
, IAS.APPLICATION_CODE
, IAS.APPLICATION_NAME
, IAS.ACTIVE_FLAG
, IAS.ANSWER_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ANSWER_TYPE'
, IAS.ANSWER_TYPE_CODE) ANSWER_TYPE_DESC
, IAS.DESTINATION_TXT
, IAS.LD_CAL_TYPE
, IAS.LD_SEQUENCE_NUMBER
, DECODE(IAS.LD_CAL_TYPE
, NULL
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ALL_TERMS'
, IAS.ALL_TERMS_FLAG)
, CALREL.LD_ALTERNATE_CODE)LD_ALTERNATE_CODE
, IAS.ALL_TERMS_FLAG
, IAS.OVERRIDE_EXIST_ANT_DATA_FLAG
, IAS.REQUIRED_FLAG
, IAS.MINIMUM_VALUE_NUM
, IAS.MAXIMUM_VALUE_NUM
, IAS.MINIMUM_DATE
, IAS.MAXIMIUM_DATE
, IAS.LOOKUP_CODE
, IAS.HINT_TXT
FROM IGF_AP_APPL_SETUP_ALL IAS
, IGF_AW_AWD_LD_CAL_V CALREL
WHERE CALREL.AW_CAL_TYPE = IAS.CI_CAL_TYPE
AND CALREL.AW_SEQUENCE_NUMBER = IAS.CI_SEQUENCE_NUMBER
AND ((CALREL.LD_CAL_TYPE = IAS.LD_CAL_TYPE
AND CALREL.LD_SEQUENCE_NUMBER = IAS.LD_SEQUENCE_NUMBER) OR (IAS.ALL_TERMS_FLAG = 'Y') OR (IAS.ALL_TERMS_FLAG IS NULL
AND IAS.LD_CAL_TYPE IS NULL) )