View: IGF_SL_LOR

Product:	IGF - Financial Aid
Description:
Implementation/DBA Data:	APPS.IGF_SL_LOR

View Text

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)

Columns