VIEW: APPS.IGF_SL_CL_SETUP_V

Source

View Text - Preformatted

SELECT CLSET.ROW_ID ,CLSET.CLSET_ID ,CLSET.CI_CAL_TYPE ,CLSET.CI_SEQUENCE_NUMBER ,CI.START_DT ,CI.END_DT ,CI.ALTERNATE_CODE ,CLSET.BORW_INTEREST_IND ,NULL ,NULL ,NULL ,NULL ,RCPTV.LENDER_ID ,NULL ,RCPTV.LEND_NON_ED_BRC_ID ,RCPTV.GUARANTOR_ID ,NULL ,RCPTV.RECIPIENT_ID ,RCPTV.RECIPIENT_TYPE ,NULL ,RCPTV.RECIP_NON_ED_BRC_ID ,CLSET.EST_ORIG_FEE_PERCT ,CLSET.EST_GUARNT_FEE_PERCT ,CLSET.EST_ALT_ORIG_FEE_PERCT ,CLSET.EST_ALT_GUARNT_FEE_PERCT ,CLSET.HOLD_REL_IND ,CLSET.REQ_SERIAL_LOAN_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE', CLSET.REQ_SERIAL_LOAN_CODE) ,NULL ,NULL ,CLSET.PRC_TYPE_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE',CLSET.PRC_TYPE_CODE) ,CLSET.PNOTE_DELIVERY_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY',CLSET.PNOTE_DELIVERY_CODE) ,NULL ,NULL ,CLSET.EFT_AUTHORIZATION EFT_AUTHORIZATION ,CLSET.AUTO_LATE_DISB_IND AUTO_LATE_DISB_IND ,CLSET.CL_VERSION ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_VERSION', CLSET.CL_VERSION) ,CLSET.CREATED_BY ,CLSET.CREATION_DATE ,CLSET.LAST_UPDATED_BY ,CLSET.LAST_UPDATE_DATE ,CLSET.LAST_UPDATE_LOGIN ,CLSET.RELATIONSHIP_CD ,RCPTV.RELATIONSHIP_CD_DESC ,CLSET.DEFAULT_FLAG ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND',CLSET.HOLD_REL_IND) ,CLSET.PLUS_PROCESSING_TYPE_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE',CLSET.PLUS_PROCESSING_TYPE_CODE) ,CLSET.FUND_RETURN_METHOD_CODE ,IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH',CLSET.FUND_RETURN_METHOD_CODE) FROM IGF_SL_CL_SETUP CLSET, IGS_CA_INST CI, IGF_SL_CL_RECIPIENT RCPTV WHERE clset.ci_cal_type = ci.cal_type AND clset.ci_sequence_number = ci.sequence_number AND CLSET.RELATIONSHIP_CD = RCPTV.RELATIONSHIP_CD

View Text - HTML Formatted

SELECT CLSET.ROW_ID
, CLSET.CLSET_ID
, CLSET.CI_CAL_TYPE
, CLSET.CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.ALTERNATE_CODE
, CLSET.BORW_INTEREST_IND
, NULL
, NULL
, NULL
, NULL
, RCPTV.LENDER_ID
, NULL
, RCPTV.LEND_NON_ED_BRC_ID
, RCPTV.GUARANTOR_ID
, NULL
, RCPTV.RECIPIENT_ID
, RCPTV.RECIPIENT_TYPE
, NULL
, RCPTV.RECIP_NON_ED_BRC_ID
, CLSET.EST_ORIG_FEE_PERCT
, CLSET.EST_GUARNT_FEE_PERCT
, CLSET.EST_ALT_ORIG_FEE_PERCT
, CLSET.EST_ALT_GUARNT_FEE_PERCT
, CLSET.HOLD_REL_IND
, CLSET.REQ_SERIAL_LOAN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE'
, CLSET.REQ_SERIAL_LOAN_CODE)
, NULL
, NULL
, CLSET.PRC_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PRC_TYPE_CODE)
, CLSET.PNOTE_DELIVERY_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY'
, CLSET.PNOTE_DELIVERY_CODE)
, NULL
, NULL
, CLSET.EFT_AUTHORIZATION EFT_AUTHORIZATION
, CLSET.AUTO_LATE_DISB_IND AUTO_LATE_DISB_IND
, CLSET.CL_VERSION
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_VERSION'
, CLSET.CL_VERSION)
, CLSET.CREATED_BY
, CLSET.CREATION_DATE
, CLSET.LAST_UPDATED_BY
, CLSET.LAST_UPDATE_DATE
, CLSET.LAST_UPDATE_LOGIN
, CLSET.RELATIONSHIP_CD
, RCPTV.RELATIONSHIP_CD_DESC
, CLSET.DEFAULT_FLAG
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND'
, CLSET.HOLD_REL_IND)
, CLSET.PLUS_PROCESSING_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PLUS_PROCESSING_TYPE_CODE)
, CLSET.FUND_RETURN_METHOD_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH'
, CLSET.FUND_RETURN_METHOD_CODE)
FROM IGF_SL_CL_SETUP CLSET
, IGS_CA_INST CI
, IGF_SL_CL_RECIPIENT RCPTV
WHERE CLSET.CI_CAL_TYPE = CI.CAL_TYPE
AND CLSET.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CLSET.RELATIONSHIP_CD = RCPTV.RELATIONSHIP_CD