VIEW: APPS.IGF_AP_TD_ITEM_MST_V

Source

View Text - Preformatted

SELECT tdv.row_id row_id, tdv.todo_number, tdv.item_code, tdv.ci_cal_type, tdv.ci_sequence_number, ca.alternate_code award_year, ca.start_dt, ca.end_dt, tdv.description, tdv.corsp_mesg, tdv.career_item, tdv.required_for_application, tdv.freq_attempt, tdv.max_attempt, tdv.created_by, tdv.creation_date, tdv.last_updated_by, tdv.last_update_date, tdv.last_update_login, tdv.system_todo_type_code, lk.meaning, tdv.application_code, tdv.display_in_ss_flag, tdv.ss_instruction_txt, tdv.allow_attachment_flag, tdv.document_url_txt, instapp.application_name FROM igf_ap_td_item_mst tdv, igs_ca_inst ca, igf_lookups_view lk, (SELECT ci_cal_type, ci_sequence_number, application_code, application_name FROM igf_ap_appl_setup GROUP BY ci_cal_type, ci_sequence_number, application_code, application_name) instapp WHERE tdv.ci_cal_type = ca.cal_type(+) AND tdv.ci_sequence_number = ca.sequence_number(+) AND tdv.system_todo_type_code = lk.lookup_code AND lk.lookup_type = 'IGF_AP_SYSTEM_TODO_TYPE' AND lk.enabled_flag = 'Y' AND tdv.application_code = instapp.application_code AND tdv.ci_cal_type = instapp.ci_cal_type AND tdv.ci_sequence_number = instapp.ci_sequence_number AND tdv.application_code IS NOT NULL UNION ALL SELECT tdv.row_id row_id, tdv.todo_number, tdv.item_code, tdv.ci_cal_type, tdv.ci_sequence_number, ca.alternate_code award_year, ca.start_dt, ca.end_dt, tdv.description, tdv.corsp_mesg, tdv.career_item, tdv.required_for_application, tdv.freq_attempt, tdv.max_attempt, tdv.created_by, tdv.creation_date, tdv.last_updated_by, tdv.last_update_date, tdv.last_update_login, tdv.system_todo_type_code, lk.meaning, tdv.application_code, tdv.display_in_ss_flag, tdv.ss_instruction_txt, tdv.allow_attachment_flag, tdv.document_url_txt, NULL application_name FROM igf_ap_td_item_mst tdv, igs_ca_inst ca, igf_lookups_view lk WHERE tdv.ci_cal_type = ca.cal_type(+) AND tdv.ci_sequence_number = ca.sequence_number(+) AND tdv.system_todo_type_code = lk.lookup_code AND lk.lookup_type = 'IGF_AP_SYSTEM_TODO_TYPE' AND lk.enabled_flag = 'Y' AND tdv.application_code IS NULL

View Text - HTML Formatted

SELECT TDV.ROW_ID ROW_ID
, TDV.TODO_NUMBER
, TDV.ITEM_CODE
, TDV.CI_CAL_TYPE
, TDV.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE AWARD_YEAR
, CA.START_DT
, CA.END_DT
, TDV.DESCRIPTION
, TDV.CORSP_MESG
, TDV.CAREER_ITEM
, TDV.REQUIRED_FOR_APPLICATION
, TDV.FREQ_ATTEMPT
, TDV.MAX_ATTEMPT
, TDV.CREATED_BY
, TDV.CREATION_DATE
, TDV.LAST_UPDATED_BY
, TDV.LAST_UPDATE_DATE
, TDV.LAST_UPDATE_LOGIN
, TDV.SYSTEM_TODO_TYPE_CODE
, LK.MEANING
, TDV.APPLICATION_CODE
, TDV.DISPLAY_IN_SS_FLAG
, TDV.SS_INSTRUCTION_TXT
, TDV.ALLOW_ATTACHMENT_FLAG
, TDV.DOCUMENT_URL_TXT
, INSTAPP.APPLICATION_NAME
FROM IGF_AP_TD_ITEM_MST TDV
, IGS_CA_INST CA
, IGF_LOOKUPS_VIEW LK
, (SELECT CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, APPLICATION_CODE
, APPLICATION_NAME
FROM IGF_AP_APPL_SETUP GROUP BY CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, APPLICATION_CODE
, APPLICATION_NAME) INSTAPP
WHERE TDV.CI_CAL_TYPE = CA.CAL_TYPE(+)
AND TDV.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)
AND TDV.SYSTEM_TODO_TYPE_CODE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'IGF_AP_SYSTEM_TODO_TYPE'
AND LK.ENABLED_FLAG = 'Y'
AND TDV.APPLICATION_CODE = INSTAPP.APPLICATION_CODE
AND TDV.CI_CAL_TYPE = INSTAPP.CI_CAL_TYPE
AND TDV.CI_SEQUENCE_NUMBER = INSTAPP.CI_SEQUENCE_NUMBER
AND TDV.APPLICATION_CODE IS NOT NULL UNION ALL SELECT TDV.ROW_ID ROW_ID
, TDV.TODO_NUMBER
, TDV.ITEM_CODE
, TDV.CI_CAL_TYPE
, TDV.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE AWARD_YEAR
, CA.START_DT
, CA.END_DT
, TDV.DESCRIPTION
, TDV.CORSP_MESG
, TDV.CAREER_ITEM
, TDV.REQUIRED_FOR_APPLICATION
, TDV.FREQ_ATTEMPT
, TDV.MAX_ATTEMPT
, TDV.CREATED_BY
, TDV.CREATION_DATE
, TDV.LAST_UPDATED_BY
, TDV.LAST_UPDATE_DATE
, TDV.LAST_UPDATE_LOGIN
, TDV.SYSTEM_TODO_TYPE_CODE
, LK.MEANING
, TDV.APPLICATION_CODE
, TDV.DISPLAY_IN_SS_FLAG
, TDV.SS_INSTRUCTION_TXT
, TDV.ALLOW_ATTACHMENT_FLAG
, TDV.DOCUMENT_URL_TXT
, NULL APPLICATION_NAME
FROM IGF_AP_TD_ITEM_MST TDV
, IGS_CA_INST CA
, IGF_LOOKUPS_VIEW LK
WHERE TDV.CI_CAL_TYPE = CA.CAL_TYPE(+)
AND TDV.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER(+)
AND TDV.SYSTEM_TODO_TYPE_CODE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'IGF_AP_SYSTEM_TODO_TYPE'
AND LK.ENABLED_FLAG = 'Y'
AND TDV.APPLICATION_CODE IS NULL