VIEW: APPS.IGF_AP_TD_ITEM_INST_V

Source

View Text - Preformatted

SELECT tdii.rowid row_id, tdii.base_id, tdii.item_sequence_number, tdm.item_code, tdm.description item_description, tdii.status, lv.meaning status_desc, tdii.status_date, tdii.add_date, tdii.corsp_date, tdii.corsp_count, tdii.inactive_flag, tdii.required_for_application, tdii.freq_attempt, tdii.max_attempt, tdii.legacy_record_flag, tdii.created_by, tdii.creation_date, tdii.last_updated_by, tdii.last_update_date, tdii.last_update_login, tdm.system_todo_type_code ,tdii.clprl_id ,preflend.relationship_cd ,preflend.relationship_cd_desc ,tdm.application_code ,fa.person_id, tdm.career_item FROM igf_ap_td_item_inst tdii, igf_lookups_view lv, igf_ap_td_item_mst tdm, igf_sl_cl_pref_lenders_v preflend, igf_ap_fa_base_rec_all fa WHERE tdm.todo_number = tdii.item_sequence_number AND lv.lookup_type = 'IGF_TD_ITEM_STATUS' AND lv.lookup_code = tdii.status AND fa.base_id = tdii.base_id AND preflend.clprl_id(+) = tdii.clprl_id

View Text - HTML Formatted

SELECT TDII.ROWID ROW_ID
, TDII.BASE_ID
, TDII.ITEM_SEQUENCE_NUMBER
, TDM.ITEM_CODE
, TDM.DESCRIPTION ITEM_DESCRIPTION
, TDII.STATUS
, LV.MEANING STATUS_DESC
, TDII.STATUS_DATE
, TDII.ADD_DATE
, TDII.CORSP_DATE
, TDII.CORSP_COUNT
, TDII.INACTIVE_FLAG
, TDII.REQUIRED_FOR_APPLICATION
, TDII.FREQ_ATTEMPT
, TDII.MAX_ATTEMPT
, TDII.LEGACY_RECORD_FLAG
, TDII.CREATED_BY
, TDII.CREATION_DATE
, TDII.LAST_UPDATED_BY
, TDII.LAST_UPDATE_DATE
, TDII.LAST_UPDATE_LOGIN
, TDM.SYSTEM_TODO_TYPE_CODE
, TDII.CLPRL_ID
, PREFLEND.RELATIONSHIP_CD
, PREFLEND.RELATIONSHIP_CD_DESC
, TDM.APPLICATION_CODE
, FA.PERSON_ID
, TDM.CAREER_ITEM
FROM IGF_AP_TD_ITEM_INST TDII
, IGF_LOOKUPS_VIEW LV
, IGF_AP_TD_ITEM_MST TDM
, IGF_SL_CL_PREF_LENDERS_V PREFLEND
, IGF_AP_FA_BASE_REC_ALL FA
WHERE TDM.TODO_NUMBER = TDII.ITEM_SEQUENCE_NUMBER
AND LV.LOOKUP_TYPE = 'IGF_TD_ITEM_STATUS'
AND LV.LOOKUP_CODE = TDII.STATUS
AND FA.BASE_ID = TDII.BASE_ID
AND PREFLEND.CLPRL_ID(+) = TDII.CLPRL_ID