Product: | IGF - Financial Aid |
---|---|
Description: | Stores all the change records for Loan record for CommonLine Release 4 Version. |
Implementation/DBA Data: | APPS.IGF_SL_CLCHSN_DTLS_V |
SELECT CLCHGSND.ROWID
, CLCHGSND.CLCHGSND_ID
, CLCHGSND.CL_VERSION_CODE
, CLCHGSND.AWARD_ID
, CLCHGSND.LOAN_NUMBER_TXT
, CLCHGSND.DISBURSEMENT_NUMBER
, CLCHGSND.DISBURSEMENT_DATE
, CLCHGSND.CHANGE_ISSUE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_ISSUE_CODES'
, CLCHGSND.CHANGE_ISSUE_CODE)
, CLCHGSND.CHANGE_CODE_TXT
, CLCHRTS.CHANGE_CODE_DESCRIPTION
, CLCHGSND.CHANGE_FIELD_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHANGE_FIELDS'
, CLCHGSND.CHANGE_FIELD_CODE)
, CLCHGSND.CHANGE_RECORD_TYPE_TXT
, CLCHRTS.RECORD_DESCRIPTION_TXT
, CLCHGSND.OLD_VALUE_TXT
, CLCHGSND.NEW_VALUE_TXT
, CLCHGSND.OLD_AMT
, CLCHGSND.NEW_AMT
, CLCHGSND.OLD_DATE
, CLCHGSND.NEW_DATE
, CLCHGSND.DISBURSEMENT_CANCEL_AMT
, CLCHGSND.DISBURSEMENT_CANCEL_DATE
, CLCHGSND.DISBURSEMENT_REINST_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REINST_CODES'
, CLCHGSND.DISBURSEMENT_REINST_CODE)
, CLCHGSND.DISBURSEMENT_REISSUE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REISSUE_CODES'
, CLCHGSND.DISBURSEMENT_REISSUE_CODE)
, CLCHGSND.DISBURSEMENT_RETURN_AMT
, CLCHGSND.DISBURSEMENT_RETURN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH'
, CLCHGSND.DISBURSEMENT_RETURN_CODE)
, CLCHGSND.DISBURSEMENT_RETURN_DATE
, CLCHGSND.DISBURSEMENT_REVISED_AMT
, CLCHGSND.DISBURSEMENT_REVISED_DATE
, CLCHGSND.GUARANTOR_USE_TXT
, CLCHGSND.LENDER_USE_TXT
, CLCHGSND.RESPONSE_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_RESP_STATUS'
, CLCHGSND.RESPONSE_STATUS_CODE)
, CLCHGSND.SCHOOL_USE_TXT
, CLCHGSND.SEND_RECORD_TXT
, CLCHGSND.STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REC_STATUS'
, CLCHGSND.STATUS_CODE)
, CLCHGSND.STATUS_DATE
, CLCHGSND.VALIDATION_EDIT_TXT
, CLCHGSND.CREATED_BY
, CLCHGSND.CREATION_DATE
, CLCHGSND.LAST_UPDATED_BY
, CLCHGSND.LAST_UPDATE_DATE
, CLCHGSND.LAST_UPDATE_LOGIN
, CLCHGSND.REQUEST_ID
, CLCHGSND.PROGRAM_APPLICATION_ID
, CLCHGSND.PROGRAM_ID
, CLCHGSND.PROGRAM_UPDATE_DATE
FROM IGF_SL_CL_CHG_REC_TYPES CLCHRTS
, IGF_SL_CLCHSN_DTLS CLCHGSND
WHERE CLCHGSND.CL_VERSION_CODE = CLCHRTS.CL_VERSION_CODE
AND CLCHRTS.RECORD_TYPE_TXT = CLCHGSND.CHANGE_RECORD_TYPE_TXT
AND CLCHRTS.CHANGE_CODE_TXT = CLCHGSND.CHANGE_CODE_TXT