VIEW: APPS.IGF_SL_CLCHSN_DTLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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