VIEW: APPS.IGFFV_ALT_ORIG_RESPONSES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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