VIEW: APPS.IGF_DB_CL_DISB_RESP

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)