VIEW: APPS.IGF_AW_AWARD_LEVEL_HIST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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