eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGF_SL_LOR_LOC

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)