VIEW: APPS.IGF_SL_ALT_BORW

Source

View Text - Preformatted

SELECT ROWID, ALBW_ID, LOAN_ID, FED_STAFFORD_LOAN_DEBT, FED_SLS_DEBT, HEAL_DEBT, PERKINS_DEBT, OTHER_DEBT, CRDT_UNDR_DIFFT_NAME, BORW_GROSS_ANNUAL_SAL, BORW_OTHER_INCOME, STUDENT_MAJOR, INT_RATE_OPT, REPAYMENT_OPT_CODE, STUD_MTH_HOUSING_PYMT , STUD_MTH_CRDTCARD_PYMT , STUD_MTH_AUTO_PYMT , STUD_MTH_ED_LOAN_PYMT , STUD_MTH_OTHER_PYMT , ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, OTHER_LOAN_AMT , CS1_LNAME , CS1_FNAME , CS1_MI_TXT , CS1_SSN_TXT , CS1_CITIZENSHIP_STATUS , CS1_ADDRESS_LINE_1_TXT , CS1_ADDRESS_LINE_2_TXT , CS1_CITY_TXT , CS1_STATE_TXT , CS1_ZIP_TXT , CS1_ZIP_SUFFIX_TXT , CS1_TELEPHONE_NUMBER_TXT , CS1_SIGNATURE_CODE_TXT , CS2_LNAME , CS2_FNAME , CS2_MI_TXT , CS2_SSN_TXT , CS2_CITIZENSHIP_STATUS , CS2_ADDRESS_LINE_1_TXT , CS2_ADDRESS_LINE_2_TXT , CS2_CITY_TXT , CS2_STATE_TXT , CS2_ZIP_TXT , CS2_ZIP_SUFFIX_TXT , CS2_TELEPHONE_NUMBER_TXT , CS2_SIGNATURE_CODE_TXT , CS1_CREDIT_AUTH_CODE_TXT , CS1_BIRTH_DATE , CS1_DRV_LICENSE_NUM_TXT , CS1_DRV_LICENSE_STATE_TXT , CS1_ELECT_SIG_IND_CODE_TXT , CS1_FRGN_POSTAL_CODE_TXT , CS1_FRGN_TEL_NUM_PREFIX_TXT , CS1_GROSS_ANNUAL_SAL_NUM , CS1_MTHL_AUTO_PAY_TXT , CS1_MTHL_CC_PAY_TXT , CS1_MTHL_EDU_LOAN_PAY_TXT , CS1_MTHL_HOUSING_PAY_TXT , CS1_MTHL_OTHER_PAY_TXT , CS1_OTHER_INCOME_AMT , CS1_REL_TO_STUDENT_FLAG , CS1_SUFFIX_TXT , CS1_YEARS_AT_ADDRESS_TXT , CS2_CREDIT_AUTH_CODE_TXT , CS2_BIRTH_DATE , CS2_DRV_LICENSE_NUM_TXT , CS2_DRV_LICENSE_STATE_TXT , CS2_ELECT_SIG_IND_CODE_TXT , CS2_FRGN_POSTAL_CODE_TXT , CS2_FRGN_TEL_NUM_PREFIX_TXT , CS2_GROSS_ANNUAL_SAL_NUM , CS2_MTHL_AUTO_PAY_TXT , CS2_MTHL_CC_PAY_TXT , CS2_MTHL_EDU_LOAN_PAY_TXT , CS2_MTHL_HOUSING_PAY_TXT , CS2_MTHL_OTHER_PAY_TXT , CS2_OTHER_INCOME_AMT , CS2_REL_TO_STUDENT_FLAG , CS2_SUFFIX_TXT , CS2_YEARS_AT_ADDRESS_TXT FROM IGF_SL_ALT_BORW_ALL ALBW WHERE NVL(ALBW.org_id, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ', NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT ROWID
, ALBW_ID
, LOAN_ID
, FED_STAFFORD_LOAN_DEBT
, FED_SLS_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, CRDT_UNDR_DIFFT_NAME
, BORW_GROSS_ANNUAL_SAL
, BORW_OTHER_INCOME
, STUDENT_MAJOR
, INT_RATE_OPT
, REPAYMENT_OPT_CODE
, STUD_MTH_HOUSING_PYMT
, STUD_MTH_CRDTCARD_PYMT
, STUD_MTH_AUTO_PYMT
, STUD_MTH_ED_LOAN_PYMT
, STUD_MTH_OTHER_PYMT
, ORG_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OTHER_LOAN_AMT
, CS1_LNAME
, CS1_FNAME
, CS1_MI_TXT
, CS1_SSN_TXT
, CS1_CITIZENSHIP_STATUS
, CS1_ADDRESS_LINE_1_TXT
, CS1_ADDRESS_LINE_2_TXT
, CS1_CITY_TXT
, CS1_STATE_TXT
, CS1_ZIP_TXT
, CS1_ZIP_SUFFIX_TXT
, CS1_TELEPHONE_NUMBER_TXT
, CS1_SIGNATURE_CODE_TXT
, CS2_LNAME
, CS2_FNAME
, CS2_MI_TXT
, CS2_SSN_TXT
, CS2_CITIZENSHIP_STATUS
, CS2_ADDRESS_LINE_1_TXT
, CS2_ADDRESS_LINE_2_TXT
, CS2_CITY_TXT
, CS2_STATE_TXT
, CS2_ZIP_TXT
, CS2_ZIP_SUFFIX_TXT
, CS2_TELEPHONE_NUMBER_TXT
, CS2_SIGNATURE_CODE_TXT
, CS1_CREDIT_AUTH_CODE_TXT
, CS1_BIRTH_DATE
, CS1_DRV_LICENSE_NUM_TXT
, CS1_DRV_LICENSE_STATE_TXT
, CS1_ELECT_SIG_IND_CODE_TXT
, CS1_FRGN_POSTAL_CODE_TXT
, CS1_FRGN_TEL_NUM_PREFIX_TXT
, CS1_GROSS_ANNUAL_SAL_NUM
, CS1_MTHL_AUTO_PAY_TXT
, CS1_MTHL_CC_PAY_TXT
, CS1_MTHL_EDU_LOAN_PAY_TXT
, CS1_MTHL_HOUSING_PAY_TXT
, CS1_MTHL_OTHER_PAY_TXT
, CS1_OTHER_INCOME_AMT
, CS1_REL_TO_STUDENT_FLAG
, CS1_SUFFIX_TXT
, CS1_YEARS_AT_ADDRESS_TXT
, CS2_CREDIT_AUTH_CODE_TXT
, CS2_BIRTH_DATE
, CS2_DRV_LICENSE_NUM_TXT
, CS2_DRV_LICENSE_STATE_TXT
, CS2_ELECT_SIG_IND_CODE_TXT
, CS2_FRGN_POSTAL_CODE_TXT
, CS2_FRGN_TEL_NUM_PREFIX_TXT
, CS2_GROSS_ANNUAL_SAL_NUM
, CS2_MTHL_AUTO_PAY_TXT
, CS2_MTHL_CC_PAY_TXT
, CS2_MTHL_EDU_LOAN_PAY_TXT
, CS2_MTHL_HOUSING_PAY_TXT
, CS2_MTHL_OTHER_PAY_TXT
, CS2_OTHER_INCOME_AMT
, CS2_REL_TO_STUDENT_FLAG
, CS2_SUFFIX_TXT
, CS2_YEARS_AT_ADDRESS_TXT
FROM IGF_SL_ALT_BORW_ALL ALBW
WHERE NVL(ALBW.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)