Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_DB_CL_DISB_RESP |
SELECT DBRESP.ROWID ROW_ID
, DBRESP.CDBR_ID
, DBRESP.CBTH_ID
, DBRESP.RECORD_TYPE
, DBRESP.LOAN_NUMBER
, DBRESP.CL_SEQ_NUMBER
, DBRESP.B_LAST_NAME
, DBRESP.B_FIRST_NAME
, DBRESP.B_MIDDLE_NAME
, DBRESP.B_SSN
, DBRESP.B_ADDR_LINE_1
, DBRESP.B_ADDR_LINE_2
, DBRESP.B_CITY
, DBRESP.B_STATE
, DBRESP.B_ZIP
, DBRESP.B_ZIP_SUFFIX
, DBRESP.B_ADDR_CHG_DATE
, DBRESP.EFT_AUTH_CODE
, DBRESP.S_LAST_NAME
, DBRESP.S_FIRST_NAME
, DBRESP.S_MIDDLE_INITIAL
, DBRESP.S_SSN
, DBRESP.SCHOOL_ID
, DBRESP.SCHOOL_USE
, DBRESP.LOAN_PER_START_DATE
, DBRESP.LOAN_PER_END_DATE
, DBRESP.CL_LOAN_TYPE
, DBRESP.ALT_PROG_TYPE_CODE
, DBRESP.LENDER_ID
, DBRESP.LEND_NON_ED_BRC_ID
, DBRESP.LENDER_USE
, DBRESP.BORW_CONFIRM_IND
, DBRESP.TOT_SCHED_DISB
, DBRESP.FUND_RELEASE_DATE
, DBRESP.DISB_NUM
, DBRESP.GUARANTOR_ID
, DBRESP.GUARANTOR_USE
, DBRESP.GUARANTEE_DATE
, DBRESP.GUARANTEE_AMT
, DBRESP.GROSS_DISB_AMT
, DBRESP.FEE_1
, DBRESP.FEE_2
, DBRESP.NET_DISB_AMT
, DBRESP.FUND_DIST_MTHD
, DBRESP.CHECK_NUMBER
, DBRESP.LATE_DISB_IND
, DBRESP.PREV_REPORTED_IND
, DBRESP.ERR_CODE1
, DBRESP.ERR_CODE2
, DBRESP.ERR_CODE3
, DBRESP.ERR_CODE4
, DBRESP.ERR_CODE5
, DBRESP.FEE_PAID_2
, DBRESP.LENDER_NAME
, DBRESP.NET_CANCEL_AMT
, DBRESP.DUNS_SCHOOL_ID
, DBRESP.DUNS_LENDER_ID
, DBRESP.DUNS_GUARNT_ID
, DBRESP.HOLD_REL_IND
, DBRESP.PNOTE_CODE
, DBRESP.PNOTE_STATUS_DATE
, DBRESP.FEE_PAID_1
, DBRESP.NETTED_CANCEL_AMT
, DBRESP.OUTSTD_CANCEL_AMT
, DBRESP.SCH_NON_ED_BRC_ID
, DBRESP.STATUS
, DBRESP.CREATED_BY
, DBRESP.CREATION_DATE
, DBRESP.LAST_UPDATED_BY
, DBRESP.LAST_UPDATE_DATE
, DBRESP.LAST_UPDATE_LOGIN
, DBRESP.REQUEST_ID
, DBRESP.PROGRAM_APPLICATION_ID
, DBRESP.PROGRAM_ID
, DBRESP.PROGRAM_UPDATE_DATE
, DBRESP.ORG_ID
, DBRESP.ESIGN_SRC_TYP_CD
, DBRESP.DIRECT_TO_BORR_FLAG
FROM IGF_DB_CL_DISB_RESP_ALL DBRESP
WHERE NVL ( DBRESP.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)