VIEW: APPS.IGF_SL_CL_SETUP_OVRD_V

Source

View Text - Preformatted

SELECT CLSET.ROW_ID, CLSET.CLSET_ID, AWDYR.CI_CAL_TYPE, AWDYR.CI_SEQUENCE_NUMBER, CA.START_DT, CA.END_DT, CA.ALTERNATE_CODE, CLSET.PARTY_ID, ORGV.PARTY_NUMBER, ORGV.PARTY_NAME, CLSET.RELATIONSHIP_CD, RECEP.RELATIONSHIP_CD_DESC, CLSET.DEFAULT_FLAG, RECEP.LENDER_ID, RECEP.LEND_NON_ED_BRC_ID, RECEP.GUARANTOR_ID, RECEP.RECIPIENT_ID, RECEP.RECIPIENT_TYPE, RECEP.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.PRC_TYPE_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE',CLSET.PRC_TYPE_CODE), CLSET.REQ_SERIAL_LOAN_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE',CLSET.REQ_SERIAL_LOAN_CODE), CLSET.PNOTE_DELIVERY_CODE, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY',CLSET.PNOTE_DELIVERY_CODE), CLSET.BORW_INTEREST_IND, CLSET.HOLD_REL_IND, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND',CLSET.HOLD_REL_IND), CLSET.EFT_AUTHORIZATION, CLSET.AUTO_LATE_DISB_IND, CLSET.CREATED_BY, CLSET.CREATION_DATE, CLSET.LAST_UPDATED_BY, CLSET.LAST_UPDATE_DATE, CLSET.LAST_UPDATE_LOGIN, 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), CLSET.CL_VERSION, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_VERSION', CLSET.CL_VERSION) FROM IGS_CA_INST CA, IGF_AP_BATCH_AW_MAP AWDYR, IGF_SL_CL_SETUP CLSET, IGF_SL_CL_RECIPIENT RECEP, IGS_OR_INST_ORG_BASE_V ORGV WHERE CA.CAL_TYPE = CLSET.CI_CAL_TYPE AND CA.SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER AND ORGV.PARTY_ID = CLSET.PARTY_ID AND RECEP.RELATIONSHIP_CD = CLSET.RELATIONSHIP_CD

View Text - HTML Formatted

SELECT CLSET.ROW_ID
, CLSET.CLSET_ID
, AWDYR.CI_CAL_TYPE
, AWDYR.CI_SEQUENCE_NUMBER
, CA.START_DT
, CA.END_DT
, CA.ALTERNATE_CODE
, CLSET.PARTY_ID
, ORGV.PARTY_NUMBER
, ORGV.PARTY_NAME
, CLSET.RELATIONSHIP_CD
, RECEP.RELATIONSHIP_CD_DESC
, CLSET.DEFAULT_FLAG
, RECEP.LENDER_ID
, RECEP.LEND_NON_ED_BRC_ID
, RECEP.GUARANTOR_ID
, RECEP.RECIPIENT_ID
, RECEP.RECIPIENT_TYPE
, RECEP.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.PRC_TYPE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PRC_TYPE_CODE'
, CLSET.PRC_TYPE_CODE)
, CLSET.REQ_SERIAL_LOAN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_SERIAL_LOAN_CODE'
, CLSET.REQ_SERIAL_LOAN_CODE)
, CLSET.PNOTE_DELIVERY_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_PNOTE_DELIVERY'
, CLSET.PNOTE_DELIVERY_CODE)
, CLSET.BORW_INTEREST_IND
, CLSET.HOLD_REL_IND
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_HOLD_REL_IND'
, CLSET.HOLD_REL_IND)
, CLSET.EFT_AUTHORIZATION
, CLSET.AUTO_LATE_DISB_IND
, CLSET.CREATED_BY
, CLSET.CREATION_DATE
, CLSET.LAST_UPDATED_BY
, CLSET.LAST_UPDATE_DATE
, CLSET.LAST_UPDATE_LOGIN
, 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)
, CLSET.CL_VERSION
, IGF_AW_GEN.LOOKUP_DESC ('IGF_SL_CL_VERSION'
, CLSET.CL_VERSION)
FROM IGS_CA_INST CA
, IGF_AP_BATCH_AW_MAP AWDYR
, IGF_SL_CL_SETUP CLSET
, IGF_SL_CL_RECIPIENT RECEP
, IGS_OR_INST_ORG_BASE_V ORGV
WHERE CA.CAL_TYPE = CLSET.CI_CAL_TYPE
AND CA.SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND AWDYR.CI_CAL_TYPE = CLSET.CI_CAL_TYPE
AND AWDYR.CI_SEQUENCE_NUMBER = CLSET.CI_SEQUENCE_NUMBER
AND ORGV.PARTY_ID = CLSET.PARTY_ID
AND RECEP.RELATIONSHIP_CD = CLSET.RELATIONSHIP_CD