VIEW: APPS.BEN_MTCHG_RT

Source

View Text - Preformatted

SELECT MTR.MTCHG_RT_ID , MTR.EFFECTIVE_START_DATE , MTR.EFFECTIVE_END_DATE , MTR.ORDR_NUM , MTR.FROM_PCT_VAL , MTR.TO_PCT_VAL , MTR.PCT_VAL , MTR.MX_AMT_OF_PY_NUM , MTR.MX_PCT_OF_PY_NUM , MTR.MX_MTCH_AMT , MTR.MN_MTCH_AMT , MTR.MTCHG_RT_CALC_RL , MTR.NO_MX_MTCH_AMT_FLAG , MTR.NO_MX_PCT_OF_PY_NUM_FLAG , MTR.CNTNU_MTCH_AFTR_MX_RL_FLAG , MTR.NO_MX_AMT_OF_PY_NUM_FLAG , MTR.ACTY_BASE_RT_ID , MTR.COMP_LVL_FCTR_ID , MTR.BUSINESS_GROUP_ID , MTR.MTR_ATTRIBUTE_CATEGORY , MTR.MTR_ATTRIBUTE1 , MTR.MTR_ATTRIBUTE2 , MTR.MTR_ATTRIBUTE3 , MTR.MTR_ATTRIBUTE4 , MTR.MTR_ATTRIBUTE5 , MTR.MTR_ATTRIBUTE6 , MTR.MTR_ATTRIBUTE7 , MTR.MTR_ATTRIBUTE8 , MTR.MTR_ATTRIBUTE9 , MTR.MTR_ATTRIBUTE10 , MTR.MTR_ATTRIBUTE11 , MTR.MTR_ATTRIBUTE12 , MTR.MTR_ATTRIBUTE13 , MTR.MTR_ATTRIBUTE14 , MTR.MTR_ATTRIBUTE15 , MTR.MTR_ATTRIBUTE16 , MTR.MTR_ATTRIBUTE17 , MTR.MTR_ATTRIBUTE18 , MTR.MTR_ATTRIBUTE19 , MTR.MTR_ATTRIBUTE20 , MTR.MTR_ATTRIBUTE21 , MTR.MTR_ATTRIBUTE22 , MTR.MTR_ATTRIBUTE23 , MTR.MTR_ATTRIBUTE24 , MTR.MTR_ATTRIBUTE25 , MTR.MTR_ATTRIBUTE26 , MTR.MTR_ATTRIBUTE27 , MTR.MTR_ATTRIBUTE28 , MTR.MTR_ATTRIBUTE29 , MTR.MTR_ATTRIBUTE30 , MTR.LAST_UPDATE_DATE , MTR.LAST_UPDATED_BY , MTR.LAST_UPDATE_LOGIN , MTR.CREATED_BY , MTR.CREATION_DATE , MTR.OBJECT_VERSION_NUMBER FROM BEN_MTCHG_RT_F MTR WHERE MTR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid')) AND MTR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('sessionid'))

View Text - HTML Formatted

SELECT MTR.MTCHG_RT_ID
, MTR.EFFECTIVE_START_DATE
, MTR.EFFECTIVE_END_DATE
, MTR.ORDR_NUM
, MTR.FROM_PCT_VAL
, MTR.TO_PCT_VAL
, MTR.PCT_VAL
, MTR.MX_AMT_OF_PY_NUM
, MTR.MX_PCT_OF_PY_NUM
, MTR.MX_MTCH_AMT
, MTR.MN_MTCH_AMT
, MTR.MTCHG_RT_CALC_RL
, MTR.NO_MX_MTCH_AMT_FLAG
, MTR.NO_MX_PCT_OF_PY_NUM_FLAG
, MTR.CNTNU_MTCH_AFTR_MX_RL_FLAG
, MTR.NO_MX_AMT_OF_PY_NUM_FLAG
, MTR.ACTY_BASE_RT_ID
, MTR.COMP_LVL_FCTR_ID
, MTR.BUSINESS_GROUP_ID
, MTR.MTR_ATTRIBUTE_CATEGORY
, MTR.MTR_ATTRIBUTE1
, MTR.MTR_ATTRIBUTE2
, MTR.MTR_ATTRIBUTE3
, MTR.MTR_ATTRIBUTE4
, MTR.MTR_ATTRIBUTE5
, MTR.MTR_ATTRIBUTE6
, MTR.MTR_ATTRIBUTE7
, MTR.MTR_ATTRIBUTE8
, MTR.MTR_ATTRIBUTE9
, MTR.MTR_ATTRIBUTE10
, MTR.MTR_ATTRIBUTE11
, MTR.MTR_ATTRIBUTE12
, MTR.MTR_ATTRIBUTE13
, MTR.MTR_ATTRIBUTE14
, MTR.MTR_ATTRIBUTE15
, MTR.MTR_ATTRIBUTE16
, MTR.MTR_ATTRIBUTE17
, MTR.MTR_ATTRIBUTE18
, MTR.MTR_ATTRIBUTE19
, MTR.MTR_ATTRIBUTE20
, MTR.MTR_ATTRIBUTE21
, MTR.MTR_ATTRIBUTE22
, MTR.MTR_ATTRIBUTE23
, MTR.MTR_ATTRIBUTE24
, MTR.MTR_ATTRIBUTE25
, MTR.MTR_ATTRIBUTE26
, MTR.MTR_ATTRIBUTE27
, MTR.MTR_ATTRIBUTE28
, MTR.MTR_ATTRIBUTE29
, MTR.MTR_ATTRIBUTE30
, MTR.LAST_UPDATE_DATE
, MTR.LAST_UPDATED_BY
, MTR.LAST_UPDATE_LOGIN
, MTR.CREATED_BY
, MTR.CREATION_DATE
, MTR.OBJECT_VERSION_NUMBER
FROM BEN_MTCHG_RT_F MTR
WHERE MTR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND MTR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))