VIEW: APPS.IGFFV_TRACK_STUDENT_TODO_ITEMS

Source

View Text - Preformatted

SELECT '_LA:TDII.STATUS:IGF_LOOKUPS_VIEW:IGF_TD_ITEM_STATUS:MEANING', TDII.STATUS_DATE, TDII.ADD_DATE, TDII.CORSP_DATE, TDII.CORSP_COUNT, '_LA:TDII.INACTIVE_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', '_LA:TDII.REQUIRED_FOR_APPLICATION:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', TDII.FREQ_ATTEMPT, TDII.MAX_ATTEMPT, '_LA:TDII.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', CI.ALTERNATE_CODE, CI.DESCRIPTION, PE.PARTY_NUMBER, PE.PARTY_NAME, TDM.ITEM_CODE, TDM.DESCRIPTION, TDII.BASE_ID, TDII.ITEM_SEQUENCE_NUMBER, TDII.CLPRL_ID, PREF.RELATIONSHIP_CD, LEND.RELATIONSHIP_CD_DESC, TDM.APPLICATION_CODE, TDII.CREATED_BY, TDII.CREATION_DATE, TDII.LAST_UPDATED_BY, TDII.LAST_UPDATE_DATE , BASE.PERSON_ID FROM IGF_AP_TD_ITEM_INST_ALL TDII, IGF_AP_TD_ITEM_MST_ALL TDM, IGF_AP_FA_BASE_REC_ALL BASE, IGS_CA_INST_ALL CI, IGF_SL_CL_PREF_LENDERS PREF, IGF_SL_CL_RECIPIENT LEND, HZ_PARTIES PE WHERE TDM.TODO_NUMBER = TDII.ITEM_SEQUENCE_NUMBER AND TDII.BASE_ID = BASE.BASE_ID AND BASE.CI_CAL_TYPE = CI.CAL_TYPE AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND BASE.PERSON_ID = PE.PARTY_ID AND LEND.RELATIONSHIP_CD = PREF.RELATIONSHIP_CD AND PREF.CLPRL_ID(+) = TDII.CLPRL_ID WITH READ ONLY

View Text - HTML Formatted

SELECT '_LA:TDII.STATUS:IGF_LOOKUPS_VIEW:IGF_TD_ITEM_STATUS:MEANING'
, TDII.STATUS_DATE
, TDII.ADD_DATE
, TDII.CORSP_DATE
, TDII.CORSP_COUNT
, '_LA:TDII.INACTIVE_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:TDII.REQUIRED_FOR_APPLICATION:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, TDII.FREQ_ATTEMPT
, TDII.MAX_ATTEMPT
, '_LA:TDII.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, TDM.ITEM_CODE
, TDM.DESCRIPTION
, TDII.BASE_ID
, TDII.ITEM_SEQUENCE_NUMBER
, TDII.CLPRL_ID
, PREF.RELATIONSHIP_CD
, LEND.RELATIONSHIP_CD_DESC
, TDM.APPLICATION_CODE
, TDII.CREATED_BY
, TDII.CREATION_DATE
, TDII.LAST_UPDATED_BY
, TDII.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_AP_TD_ITEM_INST_ALL TDII
, IGF_AP_TD_ITEM_MST_ALL TDM
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, IGF_SL_CL_PREF_LENDERS PREF
, IGF_SL_CL_RECIPIENT LEND
, HZ_PARTIES PE
WHERE TDM.TODO_NUMBER = TDII.ITEM_SEQUENCE_NUMBER
AND TDII.BASE_ID = BASE.BASE_ID
AND BASE.CI_CAL_TYPE = CI.CAL_TYPE
AND BASE.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND BASE.PERSON_ID = PE.PARTY_ID
AND LEND.RELATIONSHIP_CD = PREF.RELATIONSHIP_CD
AND PREF.CLPRL_ID(+) = TDII.CLPRL_ID WITH READ ONLY