APPS.IGF_SL_LOR_DTLS_V
[Home] [Help]
| Product: | IGF - Financial Aid |
|---|---|
| Description: | Obsolete |
| Implementation/DBA Data: |
APPS.IGF_SL_LOR_DTLS_V
|
SELECT LAR.ROW_ID LAR_ROWID
, LAR.LOAN_ID LOAN_ID
, AWDV.BASE_ID BASE_ID
, AWDV.AWARD_ID AWARD_ID
, AWDV.STUDENT_ID STUDENT_ID
, AWDV.FUND_ID FUND_ID
, LAR.SEQ_NUM SEQ_NUM
, LOR.ROW_ID LOR_ROWID
, LOR.ORIGINATION_ID ORIGINATION_ID
, LAR.LOAN_NUMBER LOAN_NUMBER
, AWDV.CI_CAL_TYPE CI_CAL_TYPE
, AWDV.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, AWDV.CI_START_DT CI_START_DT
, AWDV.CI_END_DT CI_END_DT
, AWDV.CI_ALTERNATE_CODE CI_ALTERNATE_CODE
, AWDV.FUND_CODE LOAN_TYPE
, AWDV.FUND_CODE||TO_CHAR(LAR.SEQ_NUM) LOAN_TYPE_NUM
, AWDV.FUND_SOURCE FUND_SOURCE
, AWDV.FUND_TYPE FUND_TYPE
, AWDV.SYS_FUND_TYPE SYS_FUND_TYPE
, AWDV.FED_FUND_CODE FED_FUND_CODE
, AWDV.OFFERED_AMT LOAN_AMT_OFFERED
, AWDV.ACCEPTED_AMT LOAN_AMT_ACCEPTED
, LAR.LOAN_PER_BEGIN_DATE LOAN_PER_BEGIN_DATE
, LAR.LOAN_PER_END_DATE LOAN_PER_END_DATE
, LAR.LOAN_STATUS LOAN_STATUS
, LAR.LOAN_STATUS_DATE LOAN_STATUS_DATE
, LAR.LOAN_CHG_STATUS LOAN_CHG_STATUS
, LAR.LOAN_CHG_STATUS_DATE LOAN_CHG_STATUS_DATE
, LAR.ACTIVE ACTIVE
, LAR.ACTIVE_DATE ACTIVE_DATE
, LAR.BORW_DETRM_CODE BORW_DETRM_CODE
, LKV.MEANING BORW_DETRM
, LOR.SCH_CERT_DATE SCH_CERT_DATE
, LOR.ORIG_STATUS_FLAG ORIG_STATUS_FLAG
, LOR.ORIG_BATCH_ID ORIG_BATCH_ID
, LOR.ORIG_BATCH_DATE ORIG_BATCH_DATE
, LOR.CHG_BATCH_ID CHG_BATCH_ID
, LOR.ORIG_ACK_DATE ORIG_ACK_DATE
, LOR.CREDIT_OVERRIDE CREDIT_OVERRIDE
, LOR.CREDIT_DECISION_DATE CREDIT_DECISION_DATE
, LOR.REQ_SERIAL_LOAN_CODE REQ_SERIAL_LOAN_CODE
, LOR.ACT_SERIAL_LOAN_CODE ACT_SERIAL_LOAN_CODE
, LOR.PNOTE_DELIVERY_CODE PNOTE_DELIVERY_CODE
, LOR.PNOTE_STATUS PNOTE_STATUS
, LOR.PNOTE_STATUS_DATE PNOTE_STATUS_DATE
, LOR.PNOTE_ID PNOTE_ID
, LOR.PNOTE_PRINT_IND PNOTE_PRINT_IND
, LOR.PNOTE_ACCEPT_AMT PNOTE_ACCEPT_AMT
, LOR.PNOTE_ACCEPT_DATE PNOTE_ACCEPT_DATE
, LOR.PNOTE_BATCH_ID PNOTE_BATCH_ID
, LOR.PNOTE_ACK_DATE PNOTE_ACK_DATE
, LOR.PNOTE_MPN_IND PNOTE_MPN_IND
, LOR.UNSUB_ELIG_FOR_HEAL UNSUB_ELIG_FOR_HEAL
, LOR.DISCLOSURE_PRINT_IND DISCLOSURE_PRINT_IND
, LOR.ORIG_FEE_PERCT ORIG_FEE_PERCT
, LOR.BORW_CONFIRM_IND BORW_CONFIRM_IND
, LOR.BORW_INTEREST_IND BORW_INTEREST_IND
, LOR.BORW_OUTSTD_LOAN_CODE BORW_OUTSTD_LOAN_CODE
, LOR.UNSUB_ELIG_FOR_DEPNT UNSUB_ELIG_FOR_DEPNT
, LOR.GUARANTEE_AMT GUARANTEE_AMT
, LOR.GUARANTEE_DATE GUARANTEE_DATE
, LOR.GUARNT_AMT_REDN_CODE GUARNT_AMT_REDN_CODE
, LOR.GUARNT_STATUS_CODE GUARNT_STATUS_CODE
, LOR.GUARNT_STATUS_DATE GUARNT_STATUS_DATE
, LOR.LEND_APPRV_DENIED_CODE LEND_APPRV_DENIED_CODE
, LOR.LEND_APPRV_DENIED_DATE LEND_APPRV_DENIED_DATE
, LOR.LEND_STATUS_CODE LEND_STATUS_CODE
, LOR.LEND_STATUS_DATE LEND_STATUS_DATE
, LOR.GUARNT_ADJ_IND GUARNT_ADJ_IND
, LOR.GRADE_LEVEL_CODE GRADE_LEVEL_CODE
, LOR.ENROLLMENT_CODE ENROLLMENT_CODE
, LOR.ANTICIP_COMPL_DATE ANTICIP_COMPL_DATE
, LOR.BORW_LENDER_ID BORW_LENDER_ID
, LOR.DUNS_BORW_LENDER_ID DUNS_BORW_LENDER_ID
, LOR.GUARANTOR_ID GUARANTOR_ID
, LOR.DUNS_GUARNT_ID DUNS_GUARNT_ID
, LOR.PRC_TYPE_CODE PRC_TYPE_CODE
, LOR.CL_SEQ_NUMBER CL_SEQ_NUMBER
, LOR.LAST_RESORT_LENDER LAST_RESORT_LENDER
, LOR.LENDER_ID LENDER_ID
, LOR.DUNS_LENDER_ID DUNS_LENDER_ID
, LOR.LEND_NON_ED_BRC_ID LEND_NON_ED_BRC_ID
, LOR.RECIPIENT_ID RECIPIENT_ID
, LOR.RECIPIENT_TYPE RECIPIENT_TYPE
, LOR.DUNS_RECIP_ID DUNS_RECIP_ID
, LOR.RECIP_NON_ED_BRC_ID RECIP_NON_ED_BRC_ID
, LOR.REC_TYPE_IND REC_TYPE_IND
, LOR.CL_LOAN_TYPE CL_LOAN_TYPE
, LOR.CL_REC_STATUS CL_REC_STATUS
, LOR.CL_REC_STATUS_LAST_UPDATE CL_REC_STATUS_LAST_UPDATE
, LOR.ALT_PROG_TYPE_CODE ALT_PROG_TYPE_CODE
, LOR.ALT_APPL_VER_CODE ALT_APPL_VER_CODE
, LOR.MPN_CONFIRM_CODE MPN_CONFIRM_CODE
, LOR.RESP_TO_ORIG_CODE RESP_TO_ORIG_CODE
, LOR.APPL_LOAN_PHASE_CODE APPL_LOAN_PHASE_CODE
, LOR.APPL_LOAN_PHASE_CODE_CHG APPL_LOAN_PHASE_CODE_CHG
, LOR.APPL_SEND_ERROR_CODES APPL_SEND_ERROR_CODES
, LOR.TOT_OUTSTD_STAFFORD TOT_OUTSTD_STAFFORD
, LOR.TOT_OUTSTD_PLUS TOT_OUTSTD_PLUS
, LOR.ALT_BORW_TOT_DEBT ALT_BORW_TOT_DEBT
, LOR.ACT_INTEREST_RATE ACT_INTEREST_RATE
, LOR.SERVICE_TYPE_CODE SERVICE_TYPE_CODE
, LOR.REV_NOTICE_OF_GUARNT REV_NOTICE_OF_GUARNT
, LOR.SCH_REFUND_AMT SCH_REFUND_AMT
, LOR.SCH_REFUND_DATE SCH_REFUND_DATE
, LOR.UNIQ_LAYOUT_VEND_CODE UNIQ_LAYOUT_VEND_CODE
, LOR.UNIQ_LAYOUT_IDENT_CODE UNIQ_LAYOUT_IDENT_CODE
, LOR.P_PERSON_ID P_PERSON_ID
, P_PARENT.API_PERSON_ID P_SSN
, LOR.P_SSN_CHG_DATE P_SSN_CHG_DATE
, P_PARENT.SURNAME P_LAST_NAME
, P_PARENT.GIVEN_NAMES P_FIRST_NAME
, P_PARENT.MIDDLE_NAME P_MIDDLE_NAME
, P_PARENT.FULL_NAME P_FULL_NAME
, P_PERMT.ADDR_LINE_1 P_PERMT_ADDR1
, P_PERMT.ADDR_LINE_2 P_PERMT_ADDR2
, P_PERMT.CITY P_PERMT_CITY
, P_PERMT.STATE P_PERMT_STATE
, P_PERMT.POSTAL_CODE P_PERMT_ZIP
, LOR.P_PERMT_ADDR_CHG_DATE P_PERMT_ADDR_CHG_DATE
, P_PARENT.EMAIL_ADDR P_EMAIL_ADDR
, P_PARENT.BIRTH_DT P_DATE_OF_BIRTH
, LOR.P_DOB_CHG_DATE P_DOB_CHG_DATE
, LOR.P_DEFAULT_STATUS P_DEFAULT_STATUS
, PLBW.LICENSE_NUM P_LICENSE_NUM
, PLBW.LICENSE_STATE P_LICENSE_STATE
, PLBW.CITIZENSHIP_STATUS P_CITIZENSHIP_STATUS
, PLBW.ALIEN_REG_NUM P_ALIEN_REG_NUM
, PLBW.STATE_OF_LEGAL_RES P_STATE_OF_LEGAL_RES
, PLBW.LEGAL_RES_DATE P_LEGAL_RES_DATE
, LOR.P_SIGNATURE_CODE P_SIGNATURE_CODE
, LOR.P_SIGNATURE_DATE P_SIGNATURE_DATE
, P_STUD.API_PERSON_ID S_SSN
, LOR.S_SSN_CHG_DATE S_SSN_CHG_DATE
, P_STUD.SURNAME S_LAST_NAME
, P_STUD.GIVEN_NAMES S_FIRST_NAME
, P_STUD.MIDDLE_NAME S_MIDDLE_NAME
, P_STUD.FULL_NAME S_FULL_NAME
, S_PERMT.ADDR_LINE_1 S_PERMT_ADDR1
, S_PERMT.ADDR_LINE_2 S_PERMT_ADDR2
, S_PERMT.CITY S_PERMT_CITY
, S_PERMT.STATE S_PERMT_STATE
, S_PERMT.POSTAL_CODE S_PERMT_ZIP
, LOR.S_PERMT_ADDR_CHG_DATE S_PERMT_ADDR_CHG_DATE
, S_LOCAL.ADDR_LINE_1 S_LOCAL_ADDR1
, S_LOCAL.ADDR_LINE_2 S_LOCAL_ADDR2
, S_LOCAL.CITY S_LOCAL_CITY
, S_LOCAL.STATE S_LOCAL_STATE
, S_LOCAL.POSTAL_CODE S_LOCAL_ZIP
, LOR.S_LOCAL_ADDR_CHG_DATE S_LOCAL_ADDR_CHG_DATE
, P_STUD.EMAIL_ADDR S_EMAIL_ADDR
, P_STUD.BIRTH_DT S_DATE_OF_BIRTH
, LOR.S_DOB_CHG_DATE S_DOB_CHG_DATE
, LOR.S_DEFAULT_STATUS S_DEFAULT_STATUS
, LOR.S_SIGNATURE_CODE S_SIGNATURE_CODE
, LOR.CREATED_BY CREATED_BY
, LOR.CREATION_DATE CREATION_DATE
, LOR.LAST_UPDATED_BY LAST_UPDATED_BY
, LOR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOR.REQUEST_ID REQUEST_ID
, LOR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, LOR.PROGRAM_ID PROGRAM_ID
, LOR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, AWDV.PAID_AMT
, LOR.ELEC_MPN_IND
, LOR.BORR_SIGN_IND
, LOR.STUD_SIGN_IND
, LOR.BORR_CREDIT_AUTH_CODE
FROM IGF_SL_LOANS LAR
, IGF_SL_LOR LOR
, IGF_AP_PERSON_V P_STUD
, IGF_AP_PERSON_V P_PARENT
, IGF_SL_PLUS_BORW PLBW
, IGF_SL_ADDR_V P_PERMT
, IGF_SL_ADDR_V S_PERMT
, IGF_SL_ADDR_V S_LOCAL
, IGF_AW_AWARD_V AWDV
, IGS_LOOKUPS_VIEW LKV
WHERE LAR.LOAN_ID = LOR.LOAN_ID
AND LAR.AWARD_ID = AWDV.AWARD_ID
AND AWDV.STUDENT_ID = P_STUD.PERSON_ID
AND NVL(LOR.P_PERSON_ID
, 0) = P_PARENT.PERSON_ID(+)
AND NVL(LOR.P_PERSON_ID
, 0) = PLBW.PERSON_ID(+)
AND NVL(LOR.P_PERSON_ID
, 0) = P_PERMT.PERSON_ID(+)
AND P_PERMT.SITE_USE_TYPE(+) = 'HOME'
AND AWDV.STUDENT_ID = S_PERMT.PERSON_ID(+)
AND S_PERMT.SITE_USE_TYPE(+) = 'HOME'
AND AWDV.STUDENT_ID = S_LOCAL.PERSON_ID(+)
AND S_LOCAL.SITE_USE_TYPE(+) = 'RESIDES_AT'
AND LAR.BORW_DETRM_CODE=LKV.LOOKUP_CODE(+)
AND LKV.LOOKUP_TYPE(+)= 'IGS_FI_BORW_DETRM'