Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_AP_TD_ITEM_INST_V |
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