VIEW: APPS.IGF_SL_LOANS_V

Source

View Text - Preformatted

SELECT LAR.ROWID, LAR.LOAN_ID, LAR.SEQ_NUM, AWDV.BASE_ID, AWDV.AWARD_ID, BASE.PERSON_ID, P.PARTY_NUMBER, P.PARTY_NAME, pit.API_PERSON_ID, AWDV.FUND_ID, FMAST.CI_CAL_TYPE, FMAST.CI_SEQUENCE_NUMBER, CI.START_DT, CI.END_DT, CI.ALTERNATE_CODE, FMAST.FUND_CODE, FMAST.FUND_CODE||TO_CHAR(LAR.SEQ_NUM), FCAT.FUND_SOURCE, FCAT.FUND_TYPE, FCAT.SYS_FUND_TYPE, FCAT.FED_FUND_CODE, AWDV.OFFERED_AMT, AWDV.ACCEPTED_AMT, LAR.LOAN_NUMBER, LAR.LOAN_PER_BEGIN_DATE, LAR.LOAN_PER_END_DATE, LAR.LOAN_STATUS, LAR.LOAN_STATUS_DATE, LAR.LOAN_CHG_STATUS, LAR.LOAN_CHG_STATUS_DATE, LAR.ACTIVE, LAR.ACTIVE_DATE, LAR.BORW_DETRM_CODE, LAR.CREATED_BY, LAR.CREATION_DATE, LAR.LAST_UPDATED_BY, LAR.LAST_UPDATE_DATE, LAR.LAST_UPDATE_LOGIN, LAR.REQUEST_ID, LAR.PROGRAM_APPLICATION_ID, LAR.PROGRAM_ID, LAR.PROGRAM_UPDATE_DATE, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_STATUS', LAR.LOAN_STATUS), IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_CHG_STATUS', LAR.LOAN_CHG_STATUS), LAR.LEGACY_RECORD_FLAG, LAR.EXTERNAL_LOAN_ID_TXT FROM IGF_SL_LOANS LAR, IGF_AW_AWARD AWDV, IGF_AW_FUND_MAST FMAST, IGF_AW_FUND_CAT FCAT, IGS_CA_INST CI, IGF_AP_FA_BASE_REC BASE, HZ_PARTIES P, (SELECT api_person_id, pe_person_id FROM igs_pe_person_id_typ pit_2, igs_pe_alt_pers_id api_2 WHERE api_2.person_id_type = pit_2.person_id_type AND pit_2.s_person_id_type = 'SSN' AND SYSDATE BETWEEN api_2.start_dt AND NVL(api_2.end_dt, SYSDATE)) pit WHERE lar.award_id = awdv.award_id AND fmast.fund_id = awdv.fund_id AND base.base_id = awdv.base_id AND ci.cal_type = base.ci_cal_type AND ci.sequence_number = base.ci_sequence_number AND fcat.fund_code = fmast.fund_code AND base.person_id = p.party_id AND base.person_id = pit.pe_person_id (+)

View Text - HTML Formatted

SELECT LAR.ROWID
, LAR.LOAN_ID
, LAR.SEQ_NUM
, AWDV.BASE_ID
, AWDV.AWARD_ID
, BASE.PERSON_ID
, P.PARTY_NUMBER
, P.PARTY_NAME
, PIT.API_PERSON_ID
, AWDV.FUND_ID
, FMAST.CI_CAL_TYPE
, FMAST.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, FMAST.FUND_CODE
, FMAST.FUND_CODE||TO_CHAR(LAR.SEQ_NUM)
, FCAT.FUND_SOURCE
, FCAT.FUND_TYPE
, FCAT.SYS_FUND_TYPE
, FCAT.FED_FUND_CODE
, AWDV.OFFERED_AMT
, AWDV.ACCEPTED_AMT
, LAR.LOAN_NUMBER
, LAR.LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE
, LAR.LOAN_STATUS
, LAR.LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE
, LAR.ACTIVE
, LAR.ACTIVE_DATE
, LAR.BORW_DETRM_CODE
, LAR.CREATED_BY
, LAR.CREATION_DATE
, LAR.LAST_UPDATED_BY
, LAR.LAST_UPDATE_DATE
, LAR.LAST_UPDATE_LOGIN
, LAR.REQUEST_ID
, LAR.PROGRAM_APPLICATION_ID
, LAR.PROGRAM_ID
, LAR.PROGRAM_UPDATE_DATE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_STATUS'
, LAR.LOAN_STATUS)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_LOAN_CHG_STATUS'
, LAR.LOAN_CHG_STATUS)
, LAR.LEGACY_RECORD_FLAG
, LAR.EXTERNAL_LOAN_ID_TXT
FROM IGF_SL_LOANS LAR
, IGF_AW_AWARD AWDV
, IGF_AW_FUND_MAST FMAST
, IGF_AW_FUND_CAT FCAT
, IGS_CA_INST CI
, IGF_AP_FA_BASE_REC BASE
, HZ_PARTIES P
, (SELECT API_PERSON_ID
, PE_PERSON_ID
FROM IGS_PE_PERSON_ID_TYP PIT_2
, IGS_PE_ALT_PERS_ID API_2
WHERE API_2.PERSON_ID_TYPE = PIT_2.PERSON_ID_TYPE
AND PIT_2.S_PERSON_ID_TYPE = 'SSN'
AND SYSDATE BETWEEN API_2.START_DT
AND NVL(API_2.END_DT
, SYSDATE)) PIT
WHERE LAR.AWARD_ID = AWDV.AWARD_ID
AND FMAST.FUND_ID = AWDV.FUND_ID
AND BASE.BASE_ID = AWDV.BASE_ID
AND CI.CAL_TYPE = BASE.CI_CAL_TYPE
AND CI.SEQUENCE_NUMBER = BASE.CI_SEQUENCE_NUMBER
AND FCAT.FUND_CODE = FMAST.FUND_CODE
AND BASE.PERSON_ID = P.PARTY_ID
AND BASE.PERSON_ID = PIT.PE_PERSON_ID (+)