VIEW: APPS.IGF_SL_ALT_BORW_V

Source

View Text - Preformatted

SELECT ALBWV.ROW_ID, ALBWV.ALBW_ID, ALBWV.LOAN_ID, ALBWV.FED_STAFFORD_LOAN_DEBT, ALBWV.FED_SLS_DEBT, ALBWV.HEAL_DEBT, ALBWV.PERKINS_DEBT, ALBWV.OTHER_DEBT, ALBWV.CRDT_UNDR_DIFFT_NAME, ALBWV.BORW_GROSS_ANNUAL_SAL, ALBWV.BORW_OTHER_INCOME, ALBWV.STUDENT_MAJOR, ALBWV.INT_RATE_OPT, ALBWV.REPAYMENT_OPT_CODE, ALBWV.STUD_MTH_HOUSING_PYMT, ALBWV.STUD_MTH_CRDTCARD_PYMT, ALBWV.STUD_MTH_AUTO_PYMT, ALBWV.STUD_MTH_ED_LOAN_PYMT, ALBWV.STUD_MTH_OTHER_PYMT, ALBWV.CREATED_BY, ALBWV.CREATION_DATE, ALBWV.LAST_UPDATED_BY, ALBWV.LAST_UPDATE_DATE, ALBWV.LAST_UPDATE_LOGIN, ALBWV.REQUEST_ID, ALBWV.PROGRAM_APPLICATION_ID, ALBWV.PROGRAM_ID, ALBWV.PROGRAM_UPDATE_DATE, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_INT_RATE_OPTION' , ALBWV.INT_RATE_OPT), IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_REPAY_OPTION', ALBWV.REPAYMENT_OPT_CODE), IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CRDT_UNDR_DIFFT_NAME), OTHER_LOAN_AMT , ALBWV.CS1_LNAME , ALBWV.CS1_FNAME , ALBWV.CS1_MI_TXT , ALBWV.CS1_SSN_TXT , ALBWV.CS1_CITIZENSHIP_STATUS , ALBWV.CS1_ADDRESS_LINE_1_TXT , ALBWV.CS1_ADDRESS_LINE_2_TXT , ALBWV.CS1_CITY_TXT , ALBWV.CS1_STATE_TXT , ALBWV.CS1_ZIP_TXT , ALBWV.CS1_ZIP_SUFFIX_TXT , ALBWV.CS1_TELEPHONE_NUMBER_TXT , ALBWV.CS1_SIGNATURE_CODE_TXT , ALBWV.CS2_LNAME , ALBWV.CS2_FNAME , ALBWV.CS2_MI_TXT , ALBWV.CS2_SSN_TXT , ALBWV.CS2_CITIZENSHIP_STATUS , ALBWV.CS2_ADDRESS_LINE_1_TXT , ALBWV.CS2_ADDRESS_LINE_2_TXT , ALBWV.CS2_CITY_TXT , ALBWV.CS2_STATE_TXT , ALBWV.CS2_ZIP_TXT , ALBWV.CS2_ZIP_SUFFIX_TXT , ALBWV.CS2_TELEPHONE_NUMBER_TXT , ALBWV.CS2_SIGNATURE_CODE_TXT , ALBWV.CS1_CREDIT_AUTH_CODE_TXT , ALBWV.CS1_BIRTH_DATE , ALBWV.CS1_DRV_LICENSE_NUM_TXT , ALBWV.CS1_DRV_LICENSE_STATE_TXT , ALBWV.CS1_ELECT_SIG_IND_CODE_TXT , ALBWV.CS1_FRGN_POSTAL_CODE_TXT , ALBWV.CS1_FRGN_TEL_NUM_PREFIX_TXT , ALBWV.CS1_GROSS_ANNUAL_SAL_NUM , ALBWV.CS1_MTHL_AUTO_PAY_TXT , ALBWV.CS1_MTHL_CC_PAY_TXT , ALBWV.CS1_MTHL_EDU_LOAN_PAY_TXT , ALBWV.CS1_MTHL_HOUSING_PAY_TXT , ALBWV.CS1_MTHL_OTHER_PAY_TXT , ALBWV.CS1_OTHER_INCOME_AMT , ALBWV.CS1_REL_TO_STUDENT_FLAG , ALBWV.CS1_SUFFIX_TXT , ALBWV.CS1_YEARS_AT_ADDRESS_TXT , ALBWV.CS2_CREDIT_AUTH_CODE_TXT , ALBWV.CS2_BIRTH_DATE , ALBWV.CS2_DRV_LICENSE_NUM_TXT , ALBWV.CS2_DRV_LICENSE_STATE_TXT , ALBWV.CS2_ELECT_SIG_IND_CODE_TXT , ALBWV.CS2_FRGN_POSTAL_CODE_TXT , ALBWV.CS2_FRGN_TEL_NUM_PREFIX_TXT , ALBWV.CS2_GROSS_ANNUAL_SAL_NUM , ALBWV.CS2_MTHL_AUTO_PAY_TXT , ALBWV.CS2_MTHL_CC_PAY_TXT , ALBWV.CS2_MTHL_EDU_LOAN_PAY_TXT , ALBWV.CS2_MTHL_HOUSING_PAY_TXT , ALBWV.CS2_MTHL_OTHER_PAY_TXT , ALBWV.CS2_OTHER_INCOME_AMT , ALBWV.CS2_REL_TO_STUDENT_FLAG , ALBWV.CS2_SUFFIX_TXT , ALBWV.CS2_YEARS_AT_ADDRESS_TXT , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS1_CREDIT_AUTH_CODE_TXT) CS1_CREDIT_AUTH_CODE_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS1_ELECT_SIG_IND_CODE_TXT) CS1_ELECT_SIG_IND_CODE_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_STUDENT_RELATION', ALBWV.CS1_REL_TO_STUDENT_FLAG) CS1_REL_TO_STUDENT_FLAG_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS1_SIGNATURE_CODE_TXT) CS1_SIGNATURE_CODE_TXT_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_US_CT_ST_CODE', ALBWV.CS1_CITIZENSHIP_STATUS) CS1_CITIZENSHIP_STATUS_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS2_CREDIT_AUTH_CODE_TXT) CS2_CREDIT_AUTH_CODE_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS2_ELECT_SIG_IND_CODE_TXT) CS2_ELECT_SIG_IND_CODE_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_STUDENT_RELATION', ALBWV.CS2_REL_TO_STUDENT_FLAG) CS2_REL_TO_STUDENT_FLAG_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO', ALBWV.CS2_SIGNATURE_CODE_TXT) CS2_SIGNATURE_CODE_TXT_DESC , IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_US_CT_ST_CODE', ALBWV.CS2_CITIZENSHIP_STATUS) CS2_CITIZENSHIP_STATUS_DESC FROM IGF_SL_ALT_BORW ALBWV

View Text - HTML Formatted

SELECT ALBWV.ROW_ID
, ALBWV.ALBW_ID
, ALBWV.LOAN_ID
, ALBWV.FED_STAFFORD_LOAN_DEBT
, ALBWV.FED_SLS_DEBT
, ALBWV.HEAL_DEBT
, ALBWV.PERKINS_DEBT
, ALBWV.OTHER_DEBT
, ALBWV.CRDT_UNDR_DIFFT_NAME
, ALBWV.BORW_GROSS_ANNUAL_SAL
, ALBWV.BORW_OTHER_INCOME
, ALBWV.STUDENT_MAJOR
, ALBWV.INT_RATE_OPT
, ALBWV.REPAYMENT_OPT_CODE
, ALBWV.STUD_MTH_HOUSING_PYMT
, ALBWV.STUD_MTH_CRDTCARD_PYMT
, ALBWV.STUD_MTH_AUTO_PYMT
, ALBWV.STUD_MTH_ED_LOAN_PYMT
, ALBWV.STUD_MTH_OTHER_PYMT
, ALBWV.CREATED_BY
, ALBWV.CREATION_DATE
, ALBWV.LAST_UPDATED_BY
, ALBWV.LAST_UPDATE_DATE
, ALBWV.LAST_UPDATE_LOGIN
, ALBWV.REQUEST_ID
, ALBWV.PROGRAM_APPLICATION_ID
, ALBWV.PROGRAM_ID
, ALBWV.PROGRAM_UPDATE_DATE
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_INT_RATE_OPTION'
, ALBWV.INT_RATE_OPT)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_REPAY_OPTION'
, ALBWV.REPAYMENT_OPT_CODE)
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CRDT_UNDR_DIFFT_NAME)
, OTHER_LOAN_AMT
, ALBWV.CS1_LNAME
, ALBWV.CS1_FNAME
, ALBWV.CS1_MI_TXT
, ALBWV.CS1_SSN_TXT
, ALBWV.CS1_CITIZENSHIP_STATUS
, ALBWV.CS1_ADDRESS_LINE_1_TXT
, ALBWV.CS1_ADDRESS_LINE_2_TXT
, ALBWV.CS1_CITY_TXT
, ALBWV.CS1_STATE_TXT
, ALBWV.CS1_ZIP_TXT
, ALBWV.CS1_ZIP_SUFFIX_TXT
, ALBWV.CS1_TELEPHONE_NUMBER_TXT
, ALBWV.CS1_SIGNATURE_CODE_TXT
, ALBWV.CS2_LNAME
, ALBWV.CS2_FNAME
, ALBWV.CS2_MI_TXT
, ALBWV.CS2_SSN_TXT
, ALBWV.CS2_CITIZENSHIP_STATUS
, ALBWV.CS2_ADDRESS_LINE_1_TXT
, ALBWV.CS2_ADDRESS_LINE_2_TXT
, ALBWV.CS2_CITY_TXT
, ALBWV.CS2_STATE_TXT
, ALBWV.CS2_ZIP_TXT
, ALBWV.CS2_ZIP_SUFFIX_TXT
, ALBWV.CS2_TELEPHONE_NUMBER_TXT
, ALBWV.CS2_SIGNATURE_CODE_TXT
, ALBWV.CS1_CREDIT_AUTH_CODE_TXT
, ALBWV.CS1_BIRTH_DATE
, ALBWV.CS1_DRV_LICENSE_NUM_TXT
, ALBWV.CS1_DRV_LICENSE_STATE_TXT
, ALBWV.CS1_ELECT_SIG_IND_CODE_TXT
, ALBWV.CS1_FRGN_POSTAL_CODE_TXT
, ALBWV.CS1_FRGN_TEL_NUM_PREFIX_TXT
, ALBWV.CS1_GROSS_ANNUAL_SAL_NUM
, ALBWV.CS1_MTHL_AUTO_PAY_TXT
, ALBWV.CS1_MTHL_CC_PAY_TXT
, ALBWV.CS1_MTHL_EDU_LOAN_PAY_TXT
, ALBWV.CS1_MTHL_HOUSING_PAY_TXT
, ALBWV.CS1_MTHL_OTHER_PAY_TXT
, ALBWV.CS1_OTHER_INCOME_AMT
, ALBWV.CS1_REL_TO_STUDENT_FLAG
, ALBWV.CS1_SUFFIX_TXT
, ALBWV.CS1_YEARS_AT_ADDRESS_TXT
, ALBWV.CS2_CREDIT_AUTH_CODE_TXT
, ALBWV.CS2_BIRTH_DATE
, ALBWV.CS2_DRV_LICENSE_NUM_TXT
, ALBWV.CS2_DRV_LICENSE_STATE_TXT
, ALBWV.CS2_ELECT_SIG_IND_CODE_TXT
, ALBWV.CS2_FRGN_POSTAL_CODE_TXT
, ALBWV.CS2_FRGN_TEL_NUM_PREFIX_TXT
, ALBWV.CS2_GROSS_ANNUAL_SAL_NUM
, ALBWV.CS2_MTHL_AUTO_PAY_TXT
, ALBWV.CS2_MTHL_CC_PAY_TXT
, ALBWV.CS2_MTHL_EDU_LOAN_PAY_TXT
, ALBWV.CS2_MTHL_HOUSING_PAY_TXT
, ALBWV.CS2_MTHL_OTHER_PAY_TXT
, ALBWV.CS2_OTHER_INCOME_AMT
, ALBWV.CS2_REL_TO_STUDENT_FLAG
, ALBWV.CS2_SUFFIX_TXT
, ALBWV.CS2_YEARS_AT_ADDRESS_TXT
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS1_CREDIT_AUTH_CODE_TXT) CS1_CREDIT_AUTH_CODE_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS1_ELECT_SIG_IND_CODE_TXT) CS1_ELECT_SIG_IND_CODE_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_STUDENT_RELATION'
, ALBWV.CS1_REL_TO_STUDENT_FLAG) CS1_REL_TO_STUDENT_FLAG_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS1_SIGNATURE_CODE_TXT) CS1_SIGNATURE_CODE_TXT_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_US_CT_ST_CODE'
, ALBWV.CS1_CITIZENSHIP_STATUS) CS1_CITIZENSHIP_STATUS_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS2_CREDIT_AUTH_CODE_TXT) CS2_CREDIT_AUTH_CODE_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS2_ELECT_SIG_IND_CODE_TXT) CS2_ELECT_SIG_IND_CODE_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_STUDENT_RELATION'
, ALBWV.CS2_REL_TO_STUDENT_FLAG) CS2_REL_TO_STUDENT_FLAG_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AP_YES_NO'
, ALBWV.CS2_SIGNATURE_CODE_TXT) CS2_SIGNATURE_CODE_TXT_DESC
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_ALT_CS_US_CT_ST_CODE'
, ALBWV.CS2_CITIZENSHIP_STATUS) CS2_CITIZENSHIP_STATUS_DESC
FROM IGF_SL_ALT_BORW ALBWV