Product: | IGF - Financial Aid |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGF_SL_LOR_LOC |
SELECT LORL.ROWID
, LORL.LOAN_ID
, LORL.ORIGINATION_ID
, LORL.LOAN_NUMBER
, LORL.LOAN_TYPE
, LORL.LOAN_AMT_OFFERED
, LORL.LOAN_AMT_ACCEPTED
, LORL.LOAN_PER_BEGIN_DATE
, LORL.LOAN_PER_END_DATE
, LORL.ACAD_YR_BEGIN_DATE
, LORL.ACAD_YR_END_DATE
, LORL.LOAN_STATUS
, LORL.LOAN_STATUS_DATE
, LORL.LOAN_CHG_STATUS
, LORL.LOAN_CHG_STATUS_DATE
, LORL.REQ_SERIAL_LOAN_CODE
, LORL.ACT_SERIAL_LOAN_CODE
, LORL.ACTIVE
, LORL.ACTIVE_DATE
, LORL.SCH_CERT_DATE
, LORL.ORIG_STATUS_FLAG
, LORL.ORIG_BATCH_ID
, LORL.ORIG_BATCH_DATE
, NULL
, LORL.ORIG_ACK_DATE
, LORL.CREDIT_OVERRIDE
, LORL.CREDIT_DECISION_DATE
, LORL.PNOTE_DELIVERY_CODE
, LORL.PNOTE_STATUS
, LORL.PNOTE_STATUS_DATE
, LORL.PNOTE_ID
, LORL.PNOTE_PRINT_IND
, LORL.PNOTE_ACCEPT_AMT
, LORL.PNOTE_ACCEPT_DATE
, LORL.PNOTE_BATCH_ID
, LORL.PNOTE_ACK_DATE
, LORL.PNOTE_MPN_IND
, LORL.P_SIGNATURE_CODE
, LORL.P_SIGNATURE_DATE
, LORL.S_SIGNATURE_CODE
, LORL.UNSUB_ELIG_FOR_HEAL
, LORL.DISCLOSURE_PRINT_IND
, LORL.ORIG_FEE_PERCT
, LORL.BORW_CONFIRM_IND
, LORL.BORW_INTEREST_IND
, LORL.UNSUB_ELIG_FOR_DEPNT
, LORL.GUARANTEE_AMT
, LORL.GUARANTEE_DATE
, LORL.GUARNT_ADJ_IND
, LORL.GUARNT_AMT_REDN_CODE
, LORL.GUARNT_STATUS_CODE
, LORL.GUARNT_STATUS_DATE
, LORL.LEND_APPRV_DENIED_CODE
, LORL.LEND_APPRV_DENIED_DATE
, LORL.LEND_STATUS_CODE
, LORL.LEND_STATUS_DATE
, LORL.GRADE_LEVEL_CODE
, LORL.ENROLLMENT_CODE
, LORL.ANTICIP_COMPL_DATE
, LORL.BORW_LENDER_ID
, NULL
, LORL.GUARANTOR_ID
, NULL
, LORL.PRC_TYPE_CODE
, LORL.REC_TYPE_IND
, LORL.CL_LOAN_TYPE
, LORL.CL_SEQ_NUMBER
, LORL.LAST_RESORT_LENDER
, LORL.LENDER_ID
, NULL
, LORL.LEND_NON_ED_BRC_ID
, LORL.RECIPIENT_ID
, LORL.RECIPIENT_TYPE
, NULL
, LORL.RECIP_NON_ED_BRC_ID
, LORL.CL_REC_STATUS
, LORL.CL_REC_STATUS_LAST_UPDATE
, LORL.ALT_PROG_TYPE_CODE
, LORL.ALT_APPL_VER_CODE
, LORL.BORW_OUTSTD_LOAN_CODE
, LORL.MPN_CONFIRM_CODE
, LORL.RESP_TO_ORIG_CODE
, LORL.APPL_LOAN_PHASE_CODE
, LORL.APPL_LOAN_PHASE_CODE_CHG
, LORL.TOT_OUTSTD_STAFFORD
, LORL.TOT_OUTSTD_PLUS
, LORL.ALT_BORW_TOT_DEBT
, LORL.ACT_INTEREST_RATE
, LORL.SERVICE_TYPE_CODE
, LORL.REV_NOTICE_OF_GUARNT
, LORL.SCH_REFUND_AMT
, LORL.SCH_REFUND_DATE
, LORL.UNIQ_LAYOUT_VEND_CODE
, LORL.UNIQ_LAYOUT_IDENT_CODE
, LORL.P_PERSON_ID
, LORL.P_SSN
, NULL
, LORL.P_LAST_NAME
, LORL.P_FIRST_NAME
, LORL.P_MIDDLE_NAME
, LORL.P_PERMT_ADDR1
, LORL.P_PERMT_ADDR2
, LORL.P_PERMT_CITY
, LORL.P_PERMT_STATE
, LORL.P_PERMT_ZIP
, LORL.P_PERMT_ADDR_CHG_DATE
, LORL.P_PERMT_PHONE
, LORL.P_EMAIL_ADDR
, LORL.P_DATE_OF_BIRTH
, NULL
, LORL.P_LICENSE_NUM
, LORL.P_LICENSE_STATE
, LORL.P_CITIZENSHIP_STATUS
, LORL.P_ALIEN_REG_NUM
, LORL.P_DEFAULT_STATUS
, LORL.P_FOREIGN_POSTAL_CODE
, LORL.P_STATE_OF_LEGAL_RES
, LORL.P_LEGAL_RES_DATE
, LORL.S_SSN
, NULL
, LORL.S_LAST_NAME
, LORL.S_FIRST_NAME
, LORL.S_MIDDLE_NAME
, LORL.S_PERMT_ADDR1
, LORL.S_PERMT_ADDR2
, LORL.S_PERMT_CITY
, LORL.S_PERMT_STATE
, LORL.S_PERMT_ZIP
, LORL.S_PERMT_ADDR_CHG_DATE
, LORL.S_PERMT_PHONE
, LORL.S_LOCAL_ADDR1
, LORL.S_LOCAL_ADDR2
, LORL.S_LOCAL_CITY
, LORL.S_LOCAL_STATE
, LORL.S_LOCAL_ZIP
, NULL
, LORL.S_EMAIL_ADDR
, LORL.S_DATE_OF_BIRTH
, NULL
, LORL.S_LICENSE_NUM
, LORL.S_LICENSE_STATE
, LORL.S_DEPNCY_STATUS
, LORL.S_DEFAULT_STATUS
, LORL.S_CITIZENSHIP_STATUS
, LORL.S_ALIEN_REG_NUM
, LORL.S_FOREIGN_POSTAL_CODE
, LORL.CREATED_BY
, LORL.CREATION_DATE
, LORL.LAST_UPDATED_BY
, LORL.LAST_UPDATE_DATE
, LORL.LAST_UPDATE_LOGIN
, LORL.REQUEST_ID
, LORL.PROGRAM_APPLICATION_ID
, LORL.PROGRAM_ID
, LORL.PROGRAM_UPDATE_DATE
, LORL.ORG_ID
, LORL.AWARD_ID
, LORL.BASE_ID
, LORL.DOCUMENT_ID_TXT
, LORL.LOAN_KEY_NUM
, LORL.INTEREST_REBATE_PERCENT_NUM
, LORL.FIN_AWARD_YEAR
, LORL.CPS_TRANS_NUM
, LORL. ATD_ENTITY_ID_TXT
, LORL. REP_ENTITY_ID_TXT
, LORL.SOURCE_ENTITY_ID_TXT
, LORL.PYMT_SERVICER_AMT
, LORL.PYMT_SERVICER_DATE
, LORL.BOOK_LOAN_AMT
, LORL.BOOK_LOAN_AMT_DATE
, LORL.S_CHG_BIRTH_DATE
, LORL.S_CHG_SSN
, LORL.S_CHG_LAST_NAME
, LORL.B_CHG_BIRTH_DATE
, LORL.B_CHG_SSN
, LORL.B_CHG_LAST_NAME
, LORL.NOTE_MESSAGE
, LORL.FULL_RESP_CODE
, LORL.S_PERMT_COUNTY
, LORL.B_PERMT_COUNTY
, LORL.S_PERMT_COUNTRY
, LORL.B_PERMT_COUNTRY
, LORL.CRDT_DECISION_STATUS
, LORL.EXTERNAL_LOAN_ID_TXT
, LORL.DEFERMENT_REQUEST_CODE
, LORL.EFT_AUTHORIZATION_CODE
, LORL.REQUESTED_LOAN_AMT
, LORL.ACTUAL_RECORD_TYPE_CODE
, LORL.REINSTATEMENT_AMT
, LORL.SCHOOL_USE_TXT
, LORL.LENDER_USE_TXT
, LORL.GUARANTOR_USE_TXT
, LORL.FLS_APPROVED_AMT
, LORL.FLU_APPROVED_AMT
, LORL.FLP_APPROVED_AMT
, LORL.ALT_APPROVED_AMT
, LORL.LOAN_APP_FORM_CODE
, LORL.ALT_BORROWER_IND_FLAG
, LORL.SCHOOL_ID_TXT
, LORL.COST_OF_ATTENDANCE_AMT
, LORL.EXPECT_FAMILY_CONTRIBUTE_AMT
, LORL.ESTABLISHED_FIN_AID_AMOUNT
, LORL.BOROWER_ELECTRONIC_SIGN_FLAG
, LORL.STUDENT_ELECTRONIC_SIGN_FLAG
, LORL.BOROWER_CREDIT_AUTHORIZ_FLAG
, LORL.MPN_TYPE_FLAG
, LORL.ESIGN_SRC_TYP_CD
FROM IGF_SL_LOR_LOC_ALL LORL
WHERE NVL (LORL.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)