Product: | IGF - Financial Aid |
---|---|
Description: | Award Level History Details View |
Implementation/DBA Data: | APPS.IGF_AW_AWARD_LEVEL_HIST_V |
SELECT AWD_HIST.ROWID ROW_ID
, AWD_HIST.AWARD_ID
, AWD_HIST.AWARD_HIST_TRAN_ID
, AWD_HIST.AWARD_ATTRIB_CODE
, AWD_HIST.AWARD_CHANGE_SOURCE_CODE
, AWD_HIST.OLD_OFFERED_AMT
, AWD_HIST.NEW_OFFERED_AMT
, AWD_HIST.OLD_ACCEPTED_AMT
, AWD_HIST.NEW_ACCEPTED_AMT
, AWD_HIST.OLD_PAID_AMT
, AWD_HIST.NEW_PAID_AMT
, AWD_HIST.OLD_LOCK_AWARD_FLAG
, AWD_HIST.NEW_LOCK_AWARD_FLAG
, AWD_HIST.OLD_AWARD_STATUS_CODE
, AWD_HIST.NEW_AWARD_STATUS_CODE
, AWD_HIST.OLD_ADPLANS_ID
, AWD_HIST.NEW_ADPLANS_ID
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_AWARD_ATTRIBUTES'
, AWD_HIST.AWARD_ATTRIB_CODE) AWARD_ATTRIBUTE_DESC
, DECODE (AWD_HIST.PROGRAM_ID
, NULL
, IGF_AW_GEN.LOOKUP_DESC('IGF_AW_AWARD_CHANGE_SOURCE'
, AWD_HIST.AWARD_CHANGE_SOURCE_CODE)
, IGF_AW_GEN.GET_CONCURRENT_PROG_NAME (AWD_HIST.PROGRAM_ID) || ' (' || REQUEST_ID || ')') AWARD_CHANGE_SOURCE_DESC
, DECODE (AWD_HIST.PROGRAM_ID
, NULL
, AWD_HIST.LAST_UPDATE_DATE
, PROGRAM_UPDATE_DATE) DERIVED_AWARD_UPDATE_DATE
, DECODE (AWARD_ATTRIB_CODE
, 'IGF_AW_AMOUNT_ACCEPTED'
, '' || AWD_HIST.OLD_ACCEPTED_AMT
, 'IGF_AW_AMOUNT_OFFERED'
, '' || AWD_HIST.OLD_OFFERED_AMT
, 'IGF_AW_AMOUNT_PAID'
, '' || AWD_HIST.OLD_PAID_AMT
, 'IGF_AW_AWARD_STATUS'
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, AWD_HIST.OLD_AWARD_STATUS_CODE)
, 'IGF_AW_DIST_PLAN'
, OLD_DIST_PLAN.AWD_DIST_PLAN_CD_DESC
, 'IGF_AW_LOCK_STATUS'
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_LOCK_STATUS'
, AWD_HIST.OLD_LOCK_AWARD_FLAG) ) OLD_VALUE
, DECODE (AWARD_ATTRIB_CODE
, 'IGF_AW_AMOUNT_ACCEPTED'
, '' || AWD_HIST.NEW_ACCEPTED_AMT
, 'IGF_AW_AMOUNT_OFFERED'
, '' || AWD_HIST.NEW_OFFERED_AMT
, 'IGF_AW_AMOUNT_PAID'
, '' || AWD_HIST.NEW_PAID_AMT
, 'IGF_AW_AWARD_STATUS'
, IGF_AW_GEN.LOOKUP_DESC('IGF_AWARD_STATUS'
, AWD_HIST.NEW_AWARD_STATUS_CODE)
, 'IGF_AW_DIST_PLAN'
, NEW_DIST_PLAN.AWD_DIST_PLAN_CD_DESC
, 'IGF_AW_LOCK_STATUS'
, IGF_AW_GEN.LOOKUP_DESC ('IGF_AW_LOCK_STATUS'
, AWD_HIST.NEW_LOCK_AWARD_FLAG) ) NEW_VALUE
, FUSR.USER_NAME
, AWD_HIST.CREATED_BY
, AWD_HIST.CREATION_DATE
, AWD_HIST.LAST_UPDATED_BY
, AWD_HIST.LAST_UPDATE_DATE
, AWD_HIST.LAST_UPDATE_LOGIN
, AWD_HIST.REQUEST_ID
, AWD_HIST.PROGRAM_APPLICATION_ID
, AWD_HIST.PROGRAM_ID
, AWD_HIST.PROGRAM_UPDATE_DATE
FROM IGF_AW_AWARD_LEVEL_HIST AWD_HIST
, IGF_AW_AWD_DIST_PLANS OLD_DIST_PLAN
, IGF_AW_AWD_DIST_PLANS NEW_DIST_PLAN
, FND_USER FUSR
WHERE FUSR.USER_ID = AWD_HIST.CREATED_BY
AND OLD_DIST_PLAN.ADPLANS_ID(+) = AWD_HIST.OLD_ADPLANS_ID
AND NEW_DIST_PLAN.ADPLANS_ID(+) = AWD_HIST.NEW_ADPLANS_ID
AND ( NVL(AWD_HIST.OLD_OFFERED_AMT
, -99999) <> NVL(AWD_HIST.OLD_OFFERED_AMT
, -99999) OR NVL(AWD_HIST.OLD_ACCEPTED_AMT
, -99999) <> NVL(AWD_HIST.NEW_ACCEPTED_AMT
, -99999) OR NVL(AWD_HIST.OLD_PAID_AMT
, -99999) <> NVL(AWD_HIST.NEW_PAID_AMT
, -99999) OR NVL(AWD_HIST.OLD_LOCK_AWARD_FLAG
, '*') <> NVL(AWD_HIST.NEW_LOCK_AWARD_FLAG
, '*') OR NVL(AWD_HIST.OLD_AWARD_STATUS_CODE
, '*') <> NVL(AWD_HIST.NEW_AWARD_STATUS_CODE
, '*') OR NVL(AWD_HIST.OLD_ADPLANS_ID
, -99999) <> NVL(AWD_HIST.NEW_ADPLANS_ID
, -99999) ) ORDER BY AWD_HIST.AWARD_ID ASC
, AWD_HIST.AWARD_HIST_TRAN_ID DESC
, AWD_HIST.AWARD_ATTRIB_CODE DESC