Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds Alternate Loan Origination Response Details |
Implementation/DBA Data: | APPS.IGFFV_ALT_ORIG_RESPONSES |
SELECT RESP4.LOAN_NUMBER
, RESP4.FED_STAFFORD_LOAN_DEBT
, RESP4.FED_SLS_DEBT
, RESP4.HEAL_DEBT
, RESP4.PERKINS_DEBT
, RESP4.OTHER_DEBT
, RESP4.BORW_GROSS_ANNUAL_SAL
, RESP4.BORW_OTHER_INCOME
, RESP4.STUDENT_MAJOR
, '_LA:RESP4.CRDT_UNDR_DIFFT_NAME:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, '_LA:RESP4.INT_RATE_OPT:IGF_LOOKUPS_VIEW:IGF_SL_ALT_INT_RATE_OPTION:MEANING'
, '_LA:RESP4.REPAYMENT_OPT_CODE:IGF_LOOKUPS_VIEW:IGF_SL_ALT_REPAY_OPTION:MEANING'
, RESP4.STUD_MTH_HOUSING_PYMT
, RESP4.STUD_MTH_CRDTCARD_PYMT
, RESP4.STUD_MTH_AUTO_PYMT
, RESP4.STUD_MTH_ED_LOAN_PYMT
, RESP4.STUD_MTH_OTHER_PYMT
, RESP4.COSNR_1_FIRST_NAME
, RESP4.COSNR_1_LAST_NAME
, RESP4.COSNR_1_MIDDLE_NAME
, RESP4.COSNR_1_SSN
, RESP4.COSNR_1_CITIZENSHIP
, RESP4.COSNR_1_ADDR_LINE1
, RESP4.COSNR_1_ADDR_LINE2
, RESP4.COSNR_1_CITY
, RESP4.COSNR_1_STATE
, RESP4.COSNR_1_ZIP
, RESP4.COSNR_1_ZIP_SUFFIX
, RESP4.COSNR_1_PHONE
, RESP4.COSNR_1_SIG_CODE
, RESP4.COSNR_1_GROSS_ANL_SAL
, RESP4.COSNR_1_OTHER_INCOME
, RESP4.COSNR_1_FORN_POSTAL_CODE
, RESP4.COSNR_1_FORN_PHONE_PREFIX
, RESP4.COSNR_1_DOB
, RESP4.COSNR_1_LICENSE_STATE
, RESP4.COSNR_1_LICENSE_NUM
, RESP4.COSNR_1_RELATIONSHIP_TO
, RESP4.COSNR_1_YEARS_AT_ADDR
, RESP4.COSNR_1_MTH_HOUSING_PYMT
, RESP4.COSNR_1_MTH_CRDTCARD_PYMT
, RESP4.COSNR_1_MTH_AUTO_PYMT
, RESP4.COSNR_1_MTH_ED_LOAN_PYMT
, RESP4.COSNR_1_MTH_OTHER_PYMT
, RESP4.COSNR_1_CRDT_AUTH_CODE
, RESP4.COSNR_2_LAST_NAME
, RESP4.COSNR_2_FIRST_NAME
, RESP4.COSNR_2_MIDDLE_NAME
, RESP4.COSNR_2_SSN
, RESP4.COSNR_2_CITIZENSHIP
, RESP4.COSNR_2_ADDR_LINE1
, RESP4.COSNR_2_ADDR_LINE2
, RESP4.COSNR_2_CITY
, RESP4.COSNR_2_STATE
, RESP4.COSNR_2_ZIP
, RESP4.COSNR_2_ZIP_SUFFIX
, RESP4.COSNR_2_PHONE
, RESP4.COSNR_2_SIG_CODE
, RESP4.COSNR_2_GROSS_ANL_SAL
, RESP4.COSNR_2_OTHER_INCOME
, RESP4.COSNR_2_FORN_POSTAL_CODE
, RESP4.COSNR_2_FORN_PHONE_PREFIX
, RESP4.COSNR_2_DOB
, RESP4.COSNR_2_LICENSE_STATE
, RESP4.COSNR_2_LICENSE_NUM
, RESP4.COSNR_2_RELATIONSHIP_TO
, RESP4.COSNR_2_YEARS_AT_ADDR
, RESP4.COSNR_2_MTH_HOUSING_PYMT
, RESP4.COSNR_2_MTH_CRDTCARD_PYMT
, RESP4.COSNR_2_MTH_AUTO_PYMT
, RESP4.COSNR_2_MTH_ED_LOAN_PYMT
, RESP4.COSNR_2_MTH_OTHER_PYMT
, RESP4.COSNR_2_CRDT_AUTH_CODE
, RESP1.REC_TYPE_IND
, RESP1.B_LAST_NAME
, RESP1.B_FIRST_NAME
, RESP1.B_MIDDLE_NAME
, RESP1.B_SSN
, RESP4.CLRP1_ID
, RESP4.CREATED_BY
, RESP4.CREATION_DATE
, RESP4.LAST_UPDATED_BY
, RESP4.LAST_UPDATE_DATE
FROM IGF_SL_CL_RESP_R4_ALL RESP4
, IGF_SL_CL_RESP_R1_ALL RESP1
WHERE RESP1.CLRP1_ID = RESP4.CLRP1_ID WITH READ ONLY