Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_CL_RESP_R1 |
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)