VIEW: APPS.IGFFV_DIRECT_LOAN_ORIGINATIONS

Source

View Text - Preformatted

SELECT LOR.SCH_CERT_DATE, LOR.ORIG_FEE_PERCT, '_LA:LOR.ORIG_STATUS_FLAG:IGF_LOOKUPS_VIEW:IGF_SL_ORIG_STATUS_FLAG:MEANING', LOR.ORIG_BATCH_ID, LOR.ORIG_BATCH_DATE, LOR.PNOTE_ID, LOR.PNOTE_BATCH_ID, LOR.PNOTE_ACK_DATE, LOR.PNOTE_STATUS_DATE, '_LA:LOR.GRADE_LEVEL_CODE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING', '_LA:LOR.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING', '_LA:LOR.PNOTE_PRINT_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_PRINT_IND:MEANING', '_LA:LOR.UNSUB_ELIG_FOR_HEAL:IGF_LOOKUPS_VIEW:IGF_SL_DL_HP_UNSUB_ELIG:MEANING', '_LA:LOR.UNSUB_ELIG_FOR_DEPNT:IGF_LOOKUPS_VIEW:IGF_SL_DL_DEP_UNSUB_ELIG:MEANING', '_LA:LOR.S_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_S_DEFAULT_STATUS:MEANING', '_LA:LOR.P_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_P_DEFAULT_STATUS:MEANING', '_LA:LOR.ELEC_MPN_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_TYPE:MEANING', '_LA:LOR.PNOTE_MPN_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_LINK:MEANING', '_LA:LOR.CREDIT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_SL_CREDIT_OVERRIDE:MEANING', LOR.CREDIT_DECISION_DATE, LOR.PNOTE_ACCEPT_AMT, HZ_STUD.PARTY_NUMBER, HZ_STUD.PERSON_FIRST_NAME, HZ_STUD.PERSON_LAST_NAME, HZ_STUD.PERSON_MIDDLE_NAME, HZ_STUD.ADDRESS1, HZ_STUD.ADDRESS2, HZ_STUD.ADDRESS3, HZ_STUD.ADDRESS4, HZ_STUD.CITY, HZ_STUD.STATE, HZ_STUD.POSTAL_CODE, HZ_STUD.EMAIL_ADDRESS, HZ_BORR.PARTY_NUMBER, HZ_BORR.PERSON_FIRST_NAME, HZ_BORR.PERSON_LAST_NAME, HZ_BORR.PERSON_MIDDLE_NAME, HZ_BORR.ADDRESS1, HZ_BORR.ADDRESS2, HZ_BORR.ADDRESS3, HZ_BORR.ADDRESS4, HZ_BORR.CITY, HZ_BORR.STATE, HZ_BORR.POSTAL_CODE, HZ_BORR.EMAIL_ADDRESS, FABASE.CI_CAL_TYPE, FABASE.CI_SEQUENCE_NUMBER, CA.ALTERNATE_CODE, LOANS.LOAN_NUMBER, LOANS.LOAN_PER_BEGIN_DATE, LOANS.LOAN_PER_END_DATE, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING', LOANS.LOAN_STATUS_DATE, LOANS.ACTIVE, LOANS.ACTIVE_DATE, AWD.ACCEPTED_AMT, FMAST.DESCRIPTION, LOR.P_PERSON_ID, FABASE.BASE_ID, FABASE.PERSON_ID, LOR.ORIGINATION_ID, LOR.CREATED_BY, LOR.CREATION_DATE, LOR.LAST_UPDATED_BY, LOR.LAST_UPDATE_DATE FROM IGF_SL_LOR_ALL LOR, IGF_SL_LOANS_ALL LOANS, IGF_AP_FA_BASE_REC_ALL FABASE, IGF_AW_AWARD_ALL AWD, IGF_AW_FUND_MAST_ALL FMAST, IGF_AW_FUND_CAT_ALL FCAT, HZ_PARTIES HZ_STUD, HZ_PARTIES HZ_BORR, IGS_CA_INST_ALL CA WHERE AWD.AWARD_ID = LOANS.AWARD_ID AND LOR.LOAN_ID = LOANS.LOAN_ID AND FABASE.BASE_ID = AWD.BASE_ID AND FMAST.FUND_ID = AWD.FUND_ID AND FCAT.FUND_CODE = FMAST.FUND_CODE AND FABASE.CI_CAL_TYPE = CA.CAL_TYPE AND FABASE.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER AND FCAT.FED_FUND_CODE IN ( 'DLP','DLS','DLU') AND HZ_STUD.PARTY_ID = FABASE.PERSON_ID AND LOR.P_PERSON_ID = HZ_BORR.PARTY_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT LOR.SCH_CERT_DATE
, LOR.ORIG_FEE_PERCT
, '_LA:LOR.ORIG_STATUS_FLAG:IGF_LOOKUPS_VIEW:IGF_SL_ORIG_STATUS_FLAG:MEANING'
, LOR.ORIG_BATCH_ID
, LOR.ORIG_BATCH_DATE
, LOR.PNOTE_ID
, LOR.PNOTE_BATCH_ID
, LOR.PNOTE_ACK_DATE
, LOR.PNOTE_STATUS_DATE
, '_LA:LOR.GRADE_LEVEL_CODE:IGF_LOOKUPS_VIEW:IGF_AP_GRADE_LEVEL:MEANING'
, '_LA:LOR.PNOTE_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_STATUS:MEANING'
, '_LA:LOR.PNOTE_PRINT_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_PRINT_IND:MEANING'
, '_LA:LOR.UNSUB_ELIG_FOR_HEAL:IGF_LOOKUPS_VIEW:IGF_SL_DL_HP_UNSUB_ELIG:MEANING'
, '_LA:LOR.UNSUB_ELIG_FOR_DEPNT:IGF_LOOKUPS_VIEW:IGF_SL_DL_DEP_UNSUB_ELIG:MEANING'
, '_LA:LOR.S_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_S_DEFAULT_STATUS:MEANING'
, '_LA:LOR.P_DEFAULT_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_P_DEFAULT_STATUS:MEANING'
, '_LA:LOR.ELEC_MPN_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_TYPE:MEANING'
, '_LA:LOR.PNOTE_MPN_IND:IGF_LOOKUPS_VIEW:IGF_SL_PNOTE_LINK:MEANING'
, '_LA:LOR.CREDIT_OVERRIDE:IGF_LOOKUPS_VIEW:IGF_SL_CREDIT_OVERRIDE:MEANING'
, LOR.CREDIT_DECISION_DATE
, LOR.PNOTE_ACCEPT_AMT
, HZ_STUD.PARTY_NUMBER
, HZ_STUD.PERSON_FIRST_NAME
, HZ_STUD.PERSON_LAST_NAME
, HZ_STUD.PERSON_MIDDLE_NAME
, HZ_STUD.ADDRESS1
, HZ_STUD.ADDRESS2
, HZ_STUD.ADDRESS3
, HZ_STUD.ADDRESS4
, HZ_STUD.CITY
, HZ_STUD.STATE
, HZ_STUD.POSTAL_CODE
, HZ_STUD.EMAIL_ADDRESS
, HZ_BORR.PARTY_NUMBER
, HZ_BORR.PERSON_FIRST_NAME
, HZ_BORR.PERSON_LAST_NAME
, HZ_BORR.PERSON_MIDDLE_NAME
, HZ_BORR.ADDRESS1
, HZ_BORR.ADDRESS2
, HZ_BORR.ADDRESS3
, HZ_BORR.ADDRESS4
, HZ_BORR.CITY
, HZ_BORR.STATE
, HZ_BORR.POSTAL_CODE
, HZ_BORR.EMAIL_ADDRESS
, FABASE.CI_CAL_TYPE
, FABASE.CI_SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, LOANS.LOAN_NUMBER
, LOANS.LOAN_PER_BEGIN_DATE
, LOANS.LOAN_PER_END_DATE
, '_LA:LOANS.LOAN_STATUS:IGF_LOOKUPS_VIEW:IGF_SL_LOAN_STATUS:MEANING'
, LOANS.LOAN_STATUS_DATE
, LOANS.ACTIVE
, LOANS.ACTIVE_DATE
, AWD.ACCEPTED_AMT
, FMAST.DESCRIPTION
, LOR.P_PERSON_ID
, FABASE.BASE_ID
, FABASE.PERSON_ID
, LOR.ORIGINATION_ID
, LOR.CREATED_BY
, LOR.CREATION_DATE
, LOR.LAST_UPDATED_BY
, LOR.LAST_UPDATE_DATE
FROM IGF_SL_LOR_ALL LOR
, IGF_SL_LOANS_ALL LOANS
, IGF_AP_FA_BASE_REC_ALL FABASE
, IGF_AW_AWARD_ALL AWD
, IGF_AW_FUND_MAST_ALL FMAST
, IGF_AW_FUND_CAT_ALL FCAT
, HZ_PARTIES HZ_STUD
, HZ_PARTIES HZ_BORR
, IGS_CA_INST_ALL CA
WHERE AWD.AWARD_ID = LOANS.AWARD_ID
AND LOR.LOAN_ID = LOANS.LOAN_ID
AND FABASE.BASE_ID = AWD.BASE_ID
AND FMAST.FUND_ID = AWD.FUND_ID
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND FABASE.CI_CAL_TYPE = CA.CAL_TYPE
AND FABASE.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND FCAT.FED_FUND_CODE IN ( 'DLP'
, 'DLS'
, 'DLU')
AND HZ_STUD.PARTY_ID = FABASE.PERSON_ID
AND LOR.P_PERSON_ID = HZ_BORR.PARTY_ID(+) WITH READ ONLY