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

Source

View Text - Preformatted


SELECT LOR.ROWID, LOR.ORIGINATION_ID, LOR.LOAN_ID, LOR.SCH_CERT_DATE, LOR.ORIG_STATUS_FLAG, LOR.ORIG_BATCH_ID, LOR.ORIG_BATCH_DATE, null, LOR.ORIG_ACK_DATE, LOR.CREDIT_OVERRIDE, LOR.CREDIT_DECISION_DATE, LOR.REQ_SERIAL_LOAN_CODE, LOR.ACT_SERIAL_LOAN_CODE, LOR.PNOTE_DELIVERY_CODE, LOR.PNOTE_STATUS, LOR.PNOTE_STATUS_DATE, LOR.PNOTE_ID, LOR.PNOTE_PRINT_IND, LOR.PNOTE_ACCEPT_AMT, LOR.PNOTE_ACCEPT_DATE, LOR.PNOTE_BATCH_ID, LOR.PNOTE_ACK_DATE, LOR.PNOTE_MPN_IND, LOR.UNSUB_ELIG_FOR_HEAL, LOR.DISCLOSURE_PRINT_IND, LOR.ORIG_FEE_PERCT, LOR.BORW_CONFIRM_IND, LOR.BORW_INTEREST_IND, LOR.BORW_OUTSTD_LOAN_CODE, LOR.UNSUB_ELIG_FOR_DEPNT, LOR.GUARANTEE_AMT, LOR.GUARANTEE_DATE, LOR.GUARNT_AMT_REDN_CODE, LOR.GUARNT_STATUS_CODE, LOR.GUARNT_STATUS_DATE, LOR.LEND_APPRV_DENIED_CODE, LOR.LEND_APPRV_DENIED_DATE, LOR.LEND_STATUS_CODE, LOR.LEND_STATUS_DATE, LOR.GUARNT_ADJ_IND, LOR.GRADE_LEVEL_CODE, LOR.ENROLLMENT_CODE, LOR.ANTICIP_COMPL_DATE, null, null, null, null, LOR.PRC_TYPE_CODE, LOR.CL_SEQ_NUMBER, LOR.LAST_RESORT_LENDER, null, null, null, null, null, null, null, LOR.REC_TYPE_IND, LOR.CL_LOAN_TYPE, LOR.CL_REC_STATUS, LOR.CL_REC_STATUS_LAST_UPDATE, LOR.ALT_PROG_TYPE_CODE, LOR.ALT_APPL_VER_CODE, LOR.MPN_CONFIRM_CODE, LOR.RESP_TO_ORIG_CODE, LOR.APPL_LOAN_PHASE_CODE, LOR.APPL_LOAN_PHASE_CODE_CHG, null, LOR.TOT_OUTSTD_STAFFORD, LOR.TOT_OUTSTD_PLUS, LOR.ALT_BORW_TOT_DEBT, LOR.ACT_INTEREST_RATE, LOR.SERVICE_TYPE_CODE, LOR.REV_NOTICE_OF_GUARNT, LOR.SCH_REFUND_AMT, LOR.SCH_REFUND_DATE, LOR.UNIQ_LAYOUT_VEND_CODE, LOR.UNIQ_LAYOUT_IDENT_CODE, LOR.P_PERSON_ID, null, null, LOR.P_PERMT_ADDR_CHG_DATE, LOR.P_DEFAULT_STATUS, LOR.P_SIGNATURE_CODE, LOR.P_SIGNATURE_DATE, null, null, LOR.S_PERMT_ADDR_CHG_DATE, null, LOR.S_DEFAULT_STATUS, LOR.S_SIGNATURE_CODE, LOR.CREATED_BY, LOR.CREATION_DATE, LOR.LAST_UPDATED_BY, LOR.LAST_UPDATE_DATE, LOR.LAST_UPDATE_LOGIN, LOR.REQUEST_ID, LOR.PROGRAM_APPLICATION_ID, LOR.PROGRAM_ID, LOR.PROGRAM_UPDATE_DATE, LOR.ORG_ID, lor.elec_mpn_ind, lor.borr_sign_ind, lor.stud_sign_ind, lor.borr_credit_auth_code, lor.relationship_cd, lor.INTEREST_REBATE_PERCENT_NUM, lor.cps_trans_num, lor. ATD_ENTITY_ID_TXT, lor. REP_ENTITY_ID_TXT, lor.crdt_decision_status, lor.note_message, lor.book_loan_amt, lor.book_loan_amt_date, lor.pymt_servicer_amt, lor.pymt_servicer_date, LOR.EXTERNAL_LOAN_ID_TXT, LOR.DEFERMENT_REQUEST_CODE, LOR.EFT_AUTHORIZATION_CODE, LOR.REQUESTED_LOAN_AMT, LOR.ACTUAL_RECORD_TYPE_CODE, LOR.REINSTATEMENT_AMT, LOR.SCHOOL_USE_TXT, LOR.LENDER_USE_TXT, LOR.GUARANTOR_USE_TXT, LOR.FLS_APPROVED_AMT, LOR.FLU_APPROVED_AMT, LOR.FLP_APPROVED_AMT, LOR.ALT_APPROVED_AMT, LOR.LOAN_APP_FORM_CODE, LOR.OVERRIDE_GRADE_LEVEL_CODE, LOR.B_ALIEN_REG_NUM_TXT, LOR.ESIGN_SRC_TYP_CD, LOR.ACAD_BEGIN_DATE, LOR.ACAD_END_DATE FROM IGF_SL_LOR_ALL LOR WHERE NVL (LOR.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 LOR.ROWID
, LOR.ORIGINATION_ID
, LOR.LOAN_ID
, LOR.SCH_CERT_DATE
, LOR.ORIG_STATUS_FLAG
, LOR.ORIG_BATCH_ID
, LOR.ORIG_BATCH_DATE
, NULL
, LOR.ORIG_ACK_DATE
, LOR.CREDIT_OVERRIDE
, LOR.CREDIT_DECISION_DATE
, LOR.REQ_SERIAL_LOAN_CODE
, LOR.ACT_SERIAL_LOAN_CODE
, LOR.PNOTE_DELIVERY_CODE
, LOR.PNOTE_STATUS
, LOR.PNOTE_STATUS_DATE
, LOR.PNOTE_ID
, LOR.PNOTE_PRINT_IND
, LOR.PNOTE_ACCEPT_AMT
, LOR.PNOTE_ACCEPT_DATE
, LOR.PNOTE_BATCH_ID
, LOR.PNOTE_ACK_DATE
, LOR.PNOTE_MPN_IND
, LOR.UNSUB_ELIG_FOR_HEAL
, LOR.DISCLOSURE_PRINT_IND
, LOR.ORIG_FEE_PERCT
, LOR.BORW_CONFIRM_IND
, LOR.BORW_INTEREST_IND
, LOR.BORW_OUTSTD_LOAN_CODE
, LOR.UNSUB_ELIG_FOR_DEPNT
, LOR.GUARANTEE_AMT
, LOR.GUARANTEE_DATE
, LOR.GUARNT_AMT_REDN_CODE
, LOR.GUARNT_STATUS_CODE
, LOR.GUARNT_STATUS_DATE
, LOR.LEND_APPRV_DENIED_CODE
, LOR.LEND_APPRV_DENIED_DATE
, LOR.LEND_STATUS_CODE
, LOR.LEND_STATUS_DATE
, LOR.GUARNT_ADJ_IND
, LOR.GRADE_LEVEL_CODE
, LOR.ENROLLMENT_CODE
, LOR.ANTICIP_COMPL_DATE
, NULL
, NULL
, NULL
, NULL
, LOR.PRC_TYPE_CODE
, LOR.CL_SEQ_NUMBER
, LOR.LAST_RESORT_LENDER
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, LOR.REC_TYPE_IND
, LOR.CL_LOAN_TYPE
, LOR.CL_REC_STATUS
, LOR.CL_REC_STATUS_LAST_UPDATE
, LOR.ALT_PROG_TYPE_CODE
, LOR.ALT_APPL_VER_CODE
, LOR.MPN_CONFIRM_CODE
, LOR.RESP_TO_ORIG_CODE
, LOR.APPL_LOAN_PHASE_CODE
, LOR.APPL_LOAN_PHASE_CODE_CHG
, NULL
, LOR.TOT_OUTSTD_STAFFORD
, LOR.TOT_OUTSTD_PLUS
, LOR.ALT_BORW_TOT_DEBT
, LOR.ACT_INTEREST_RATE
, LOR.SERVICE_TYPE_CODE
, LOR.REV_NOTICE_OF_GUARNT
, LOR.SCH_REFUND_AMT
, LOR.SCH_REFUND_DATE
, LOR.UNIQ_LAYOUT_VEND_CODE
, LOR.UNIQ_LAYOUT_IDENT_CODE
, LOR.P_PERSON_ID
, NULL
, NULL
, LOR.P_PERMT_ADDR_CHG_DATE
, LOR.P_DEFAULT_STATUS
, LOR.P_SIGNATURE_CODE
, LOR.P_SIGNATURE_DATE
, NULL
, NULL
, LOR.S_PERMT_ADDR_CHG_DATE
, NULL
, LOR.S_DEFAULT_STATUS
, LOR.S_SIGNATURE_CODE
, LOR.CREATED_BY
, LOR.CREATION_DATE
, LOR.LAST_UPDATED_BY
, LOR.LAST_UPDATE_DATE
, LOR.LAST_UPDATE_LOGIN
, LOR.REQUEST_ID
, LOR.PROGRAM_APPLICATION_ID
, LOR.PROGRAM_ID
, LOR.PROGRAM_UPDATE_DATE
, LOR.ORG_ID
, LOR.ELEC_MPN_IND
, LOR.BORR_SIGN_IND
, LOR.STUD_SIGN_IND
, LOR.BORR_CREDIT_AUTH_CODE
, LOR.RELATIONSHIP_CD
, LOR.INTEREST_REBATE_PERCENT_NUM
, LOR.CPS_TRANS_NUM
, LOR. ATD_ENTITY_ID_TXT
, LOR. REP_ENTITY_ID_TXT
, LOR.CRDT_DECISION_STATUS
, LOR.NOTE_MESSAGE
, LOR.BOOK_LOAN_AMT
, LOR.BOOK_LOAN_AMT_DATE
, LOR.PYMT_SERVICER_AMT
, LOR.PYMT_SERVICER_DATE
, LOR.EXTERNAL_LOAN_ID_TXT
, LOR.DEFERMENT_REQUEST_CODE
, LOR.EFT_AUTHORIZATION_CODE
, LOR.REQUESTED_LOAN_AMT
, LOR.ACTUAL_RECORD_TYPE_CODE
, LOR.REINSTATEMENT_AMT
, LOR.SCHOOL_USE_TXT
, LOR.LENDER_USE_TXT
, LOR.GUARANTOR_USE_TXT
, LOR.FLS_APPROVED_AMT
, LOR.FLU_APPROVED_AMT
, LOR.FLP_APPROVED_AMT
, LOR.ALT_APPROVED_AMT
, LOR.LOAN_APP_FORM_CODE
, LOR.OVERRIDE_GRADE_LEVEL_CODE
, LOR.B_ALIEN_REG_NUM_TXT
, LOR.ESIGN_SRC_TYP_CD
, LOR.ACAD_BEGIN_DATE
, LOR.ACAD_END_DATE
FROM IGF_SL_LOR_ALL LOR
WHERE NVL (LOR.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)