VIEW: APPS.IGF_SL_CL_RESP_R1

Source

View Text - Preformatted

SELECT CLRESPR1.ROWID ROW_ID ,CLRESPR1.CLRP1_ID ,CLRESPR1.CBTH_ID ,CLRESPR1.REC_CODE ,CLRESPR1.REC_TYPE_IND ,CLRESPR1.B_LAST_NAME ,CLRESPR1.B_FIRST_NAME ,CLRESPR1.B_MIDDLE_NAME ,CLRESPR1.B_SSN ,CLRESPR1.B_PERMT_ADDR1 ,CLRESPR1.B_PERMT_ADDR2 ,CLRESPR1.B_PERMT_CITY ,CLRESPR1.B_PERMT_STATE ,CLRESPR1.B_PERMT_ZIP ,CLRESPR1.B_PERMT_ZIP_SUFFIX ,CLRESPR1.B_PERMT_PHONE ,CLRESPR1.B_DATE_OF_BIRTH ,CLRESPR1.CL_LOAN_TYPE ,CLRESPR1.REQ_LOAN_AMT ,CLRESPR1.DEFER_REQ_CODE ,CLRESPR1.BORW_INTEREST_IND ,CLRESPR1.EFT_AUTH_CODE ,CLRESPR1.B_SIGNATURE_CODE ,CLRESPR1.B_SIGNATURE_DATE ,CLRESPR1.LOAN_NUMBER ,CLRESPR1.CL_SEQ_NUMBER ,CLRESPR1.B_CITIZENSHIP_STATUS ,CLRESPR1.B_STATE_OF_LEGAL_RES ,CLRESPR1.B_LEGAL_RES_DATE ,CLRESPR1.B_DEFAULT_STATUS ,CLRESPR1.B_OUTSTD_LOAN_CODE ,CLRESPR1.B_INDICATOR_CODE ,CLRESPR1.S_LAST_NAME ,CLRESPR1.S_FIRST_NAME ,CLRESPR1.S_MIDDLE_NAME ,CLRESPR1.S_SSN ,CLRESPR1.S_DATE_OF_BIRTH ,CLRESPR1.S_CITIZENSHIP_STATUS ,CLRESPR1.S_DEFAULT_CODE ,CLRESPR1.S_SIGNATURE_CODE ,CLRESPR1.SCHOOL_ID ,CLRESPR1.LOAN_PER_BEGIN_DATE ,CLRESPR1.LOAN_PER_END_DATE ,CLRESPR1.GRADE_LEVEL_CODE ,CLRESPR1.ENROLLMENT_CODE ,CLRESPR1.ANTICIP_COMPL_DATE ,CLRESPR1.COA_AMT ,CLRESPR1.EFC_AMT ,CLRESPR1.EST_FA_AMT ,CLRESPR1.FLS_CERT_AMT ,CLRESPR1.FLU_CERT_AMT ,CLRESPR1.FLP_CERT_AMT ,CLRESPR1.SCH_CERT_DATE ,CLRESPR1.ALT_CERT_AMT ,CLRESPR1.ALT_APPL_VER_CODE ,CLRESPR1.DUNS_SCHOOL_ID ,CLRESPR1.LENDER_ID ,CLRESPR1.FLS_APPROVED_AMT ,CLRESPR1.FLU_APPROVED_AMT ,CLRESPR1.FLP_APPROVED_AMT ,CLRESPR1.ALT_APPROVED_AMT ,CLRESPR1.DUNS_LENDER_ID ,CLRESPR1.GUARANTOR_ID ,CLRESPR1.FED_APPL_FORM_CODE ,CLRESPR1.DUNS_GUARNT_ID ,CLRESPR1.LEND_BLKT_GUARNT_IND ,CLRESPR1.LEND_BLKT_GUARNT_APPR_DATE ,CLRESPR1.GUARNT_ADJ_IND ,CLRESPR1.GUARANTEE_DATE ,CLRESPR1.GUARANTEE_AMT ,CLRESPR1.REQ_SERIAL_LOAN_CODE ,CLRESPR1.BORW_CONFIRM_IND ,CLRESPR1.B_LICENSE_STATE ,CLRESPR1.B_LICENSE_NUMBER ,CLRESPR1.B_REF_CODE ,CLRESPR1.PNOTE_DELIVERY_CODE ,CLRESPR1.B_FOREIGN_POSTAL_CODE ,CLRESPR1.LEND_NON_ED_BRC_ID ,CLRESPR1.LAST_RESORT_LENDER ,CLRESPR1.RESP_TO_ORIG_CODE ,CLRESPR1.ERR_MESG_1 ,CLRESPR1.ERR_MESG_2 ,CLRESPR1.ERR_MESG_3 ,CLRESPR1.ERR_MESG_4 ,CLRESPR1.ERR_MESG_5 ,CLRESPR1.GUARNT_AMT_REDN_CODE ,CLRESPR1.TOT_OUTSTD_STAFFORD ,CLRESPR1.TOT_OUTSTD_PLUS ,CLRESPR1.B_PERMT_ADDR_CHG_DATE ,CLRESPR1.ALT_PROG_TYPE_CODE ,CLRESPR1.ALT_BORW_TOT_DEBT ,CLRESPR1.ACT_INTEREST_RATE ,CLRESPR1.PRC_TYPE_CODE ,CLRESPR1.SERVICE_TYPE_CODE ,CLRESPR1.REV_NOTICE_OF_GUARNT ,CLRESPR1.SCH_REFUND_AMT ,CLRESPR1.SCH_REFUND_DATE ,CLRESPR1.GUARNT_STATUS_CODE ,CLRESPR1.LENDER_STATUS_CODE ,CLRESPR1.PNOTE_STATUS_CODE ,CLRESPR1.CREDIT_STATUS_CODE ,CLRESPR1.GUARNT_STATUS_DATE ,CLRESPR1.LENDER_STATUS_DATE ,CLRESPR1.PNOTE_STATUS_DATE ,CLRESPR1.CREDIT_STATUS_DATE ,CLRESPR1.ACT_SERIAL_LOAN_CODE ,CLRESPR1.AMT_AVAIL_FOR_REINST ,CLRESPR1.SCH_NON_ED_BRC_ID ,CLRESPR1.UNIQ_LAYOUT_VEND_CODE ,CLRESPR1.UNIQ_LAYOUT_IDENT_CODE ,CLRESPR1.RESP_RECORD_STATUS ,CLRESPR1.CREATED_BY ,CLRESPR1.CREATION_DATE ,CLRESPR1.LAST_UPDATED_BY ,CLRESPR1.LAST_UPDATE_DATE ,CLRESPR1.LAST_UPDATE_LOGIN ,CLRESPR1.REQUEST_ID ,CLRESPR1.PROGRAM_APPLICATION_ID ,CLRESPR1.PROGRAM_ID ,CLRESPR1.PROGRAM_UPDATE_DATE ,CLRESPR1.ORG_ID ,CLRESPR1.borr_sign_ind ,CLRESPR1.stud_sign_ind ,CLRESPR1.borr_credit_auth_code ,CLRESPR1.MPN_CONFIRM_IND ,CLRESPR1.LENDER_USE_TXT ,CLRESPR1.GUARANTOR_USE_TXT ,CLRESPR1.APPL_LOAN_PHASE_CODE ,CLRESPR1.APPL_LOAN_PHASE_CODE_CHG ,CLRESPR1.CL_REC_STATUS ,CLRESPR1.CL_REC_STATUS_LAST_UPDATE ,CLRESPR1.LEND_APPRV_DENIED_CODE ,CLRESPR1.LEND_APPRV_DENIED_DATE ,CLRESPR1.CL_VERSION_CODE ,CLRESPR1.SCHOOL_USE_TXT , CLRESPR1.B_ALIEN_REG_NUM_TXT , CLRESPR1.ESIGN_SRC_TYP_CD FROM IGF_SL_CL_RESP_R1_ALL CLRESPR1 WHERE NVL (CLRESPR1.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 CLRESPR1.ROWID ROW_ID
, CLRESPR1.CLRP1_ID
, CLRESPR1.CBTH_ID
, CLRESPR1.REC_CODE
, CLRESPR1.REC_TYPE_IND
, CLRESPR1.B_LAST_NAME
, CLRESPR1.B_FIRST_NAME
, CLRESPR1.B_MIDDLE_NAME
, CLRESPR1.B_SSN
, CLRESPR1.B_PERMT_ADDR1
, CLRESPR1.B_PERMT_ADDR2
, CLRESPR1.B_PERMT_CITY
, CLRESPR1.B_PERMT_STATE
, CLRESPR1.B_PERMT_ZIP
, CLRESPR1.B_PERMT_ZIP_SUFFIX
, CLRESPR1.B_PERMT_PHONE
, CLRESPR1.B_DATE_OF_BIRTH
, CLRESPR1.CL_LOAN_TYPE
, CLRESPR1.REQ_LOAN_AMT
, CLRESPR1.DEFER_REQ_CODE
, CLRESPR1.BORW_INTEREST_IND
, CLRESPR1.EFT_AUTH_CODE
, CLRESPR1.B_SIGNATURE_CODE
, CLRESPR1.B_SIGNATURE_DATE
, CLRESPR1.LOAN_NUMBER
, CLRESPR1.CL_SEQ_NUMBER
, CLRESPR1.B_CITIZENSHIP_STATUS
, CLRESPR1.B_STATE_OF_LEGAL_RES
, CLRESPR1.B_LEGAL_RES_DATE
, CLRESPR1.B_DEFAULT_STATUS
, CLRESPR1.B_OUTSTD_LOAN_CODE
, CLRESPR1.B_INDICATOR_CODE
, CLRESPR1.S_LAST_NAME
, CLRESPR1.S_FIRST_NAME
, CLRESPR1.S_MIDDLE_NAME
, CLRESPR1.S_SSN
, CLRESPR1.S_DATE_OF_BIRTH
, CLRESPR1.S_CITIZENSHIP_STATUS
, CLRESPR1.S_DEFAULT_CODE
, CLRESPR1.S_SIGNATURE_CODE
, CLRESPR1.SCHOOL_ID
, CLRESPR1.LOAN_PER_BEGIN_DATE
, CLRESPR1.LOAN_PER_END_DATE
, CLRESPR1.GRADE_LEVEL_CODE
, CLRESPR1.ENROLLMENT_CODE
, CLRESPR1.ANTICIP_COMPL_DATE
, CLRESPR1.COA_AMT
, CLRESPR1.EFC_AMT
, CLRESPR1.EST_FA_AMT
, CLRESPR1.FLS_CERT_AMT
, CLRESPR1.FLU_CERT_AMT
, CLRESPR1.FLP_CERT_AMT
, CLRESPR1.SCH_CERT_DATE
, CLRESPR1.ALT_CERT_AMT
, CLRESPR1.ALT_APPL_VER_CODE
, CLRESPR1.DUNS_SCHOOL_ID
, CLRESPR1.LENDER_ID
, CLRESPR1.FLS_APPROVED_AMT
, CLRESPR1.FLU_APPROVED_AMT
, CLRESPR1.FLP_APPROVED_AMT
, CLRESPR1.ALT_APPROVED_AMT
, CLRESPR1.DUNS_LENDER_ID
, CLRESPR1.GUARANTOR_ID
, CLRESPR1.FED_APPL_FORM_CODE
, CLRESPR1.DUNS_GUARNT_ID
, CLRESPR1.LEND_BLKT_GUARNT_IND
, CLRESPR1.LEND_BLKT_GUARNT_APPR_DATE
, CLRESPR1.GUARNT_ADJ_IND
, CLRESPR1.GUARANTEE_DATE
, CLRESPR1.GUARANTEE_AMT
, CLRESPR1.REQ_SERIAL_LOAN_CODE
, CLRESPR1.BORW_CONFIRM_IND
, CLRESPR1.B_LICENSE_STATE
, CLRESPR1.B_LICENSE_NUMBER
, CLRESPR1.B_REF_CODE
, CLRESPR1.PNOTE_DELIVERY_CODE
, CLRESPR1.B_FOREIGN_POSTAL_CODE
, CLRESPR1.LEND_NON_ED_BRC_ID
, CLRESPR1.LAST_RESORT_LENDER
, CLRESPR1.RESP_TO_ORIG_CODE
, CLRESPR1.ERR_MESG_1
, CLRESPR1.ERR_MESG_2
, CLRESPR1.ERR_MESG_3
, CLRESPR1.ERR_MESG_4
, CLRESPR1.ERR_MESG_5
, CLRESPR1.GUARNT_AMT_REDN_CODE
, CLRESPR1.TOT_OUTSTD_STAFFORD
, CLRESPR1.TOT_OUTSTD_PLUS
, CLRESPR1.B_PERMT_ADDR_CHG_DATE
, CLRESPR1.ALT_PROG_TYPE_CODE
, CLRESPR1.ALT_BORW_TOT_DEBT
, CLRESPR1.ACT_INTEREST_RATE
, CLRESPR1.PRC_TYPE_CODE
, CLRESPR1.SERVICE_TYPE_CODE
, CLRESPR1.REV_NOTICE_OF_GUARNT
, CLRESPR1.SCH_REFUND_AMT
, CLRESPR1.SCH_REFUND_DATE
, CLRESPR1.GUARNT_STATUS_CODE
, CLRESPR1.LENDER_STATUS_CODE
, CLRESPR1.PNOTE_STATUS_CODE
, CLRESPR1.CREDIT_STATUS_CODE
, CLRESPR1.GUARNT_STATUS_DATE
, CLRESPR1.LENDER_STATUS_DATE
, CLRESPR1.PNOTE_STATUS_DATE
, CLRESPR1.CREDIT_STATUS_DATE
, CLRESPR1.ACT_SERIAL_LOAN_CODE
, CLRESPR1.AMT_AVAIL_FOR_REINST
, CLRESPR1.SCH_NON_ED_BRC_ID
, CLRESPR1.UNIQ_LAYOUT_VEND_CODE
, CLRESPR1.UNIQ_LAYOUT_IDENT_CODE
, CLRESPR1.RESP_RECORD_STATUS
, CLRESPR1.CREATED_BY
, CLRESPR1.CREATION_DATE
, CLRESPR1.LAST_UPDATED_BY
, CLRESPR1.LAST_UPDATE_DATE
, CLRESPR1.LAST_UPDATE_LOGIN
, CLRESPR1.REQUEST_ID
, CLRESPR1.PROGRAM_APPLICATION_ID
, CLRESPR1.PROGRAM_ID
, CLRESPR1.PROGRAM_UPDATE_DATE
, CLRESPR1.ORG_ID
, CLRESPR1.BORR_SIGN_IND
, CLRESPR1.STUD_SIGN_IND
, CLRESPR1.BORR_CREDIT_AUTH_CODE
, CLRESPR1.MPN_CONFIRM_IND
, CLRESPR1.LENDER_USE_TXT
, CLRESPR1.GUARANTOR_USE_TXT
, CLRESPR1.APPL_LOAN_PHASE_CODE
, CLRESPR1.APPL_LOAN_PHASE_CODE_CHG
, CLRESPR1.CL_REC_STATUS
, CLRESPR1.CL_REC_STATUS_LAST_UPDATE
, CLRESPR1.LEND_APPRV_DENIED_CODE
, CLRESPR1.LEND_APPRV_DENIED_DATE
, CLRESPR1.CL_VERSION_CODE
, CLRESPR1.SCHOOL_USE_TXT
, CLRESPR1.B_ALIEN_REG_NUM_TXT
, CLRESPR1.ESIGN_SRC_TYP_CD
FROM IGF_SL_CL_RESP_R1_ALL CLRESPR1
WHERE NVL (CLRESPR1.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)