VIEW: APPS.BEN_VRBL_MTCHG_RT_V

Source

View Text - Preformatted

SELECT VMR.ROWID ROW_ID , VMR.VRBL_MTCHG_RT_ID , VMR.EFFECTIVE_END_DATE , VMR.EFFECTIVE_START_DATE , VMR.NO_MX_PCT_OF_PY_NUM_FLAG , VMR.TO_PCT_VAL , VMR.NO_MX_AMT_OF_PY_NUM_FLAG , VMR.MX_PCT_OF_PY_NUM , VMR.NO_MX_MTCH_AMT_FLAG , VMR.ORDR_NUM , VMR.PCT_VAL , VMR.MX_MTCH_AMT , VMR.MX_AMT_OF_PY_NUM , VMR.MN_MTCH_AMT , VMR.MTCHG_RT_CALC_RL , VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG , VMR.FROM_PCT_VAL , VMR.VRBL_RT_PRFL_ID , VMR.BUSINESS_GROUP_ID , VMR.VMR_ATTRIBUTE_CATEGORY , VMR.VMR_ATTRIBUTE1 , VMR.VMR_ATTRIBUTE2 , VMR.VMR_ATTRIBUTE3 , VMR.VMR_ATTRIBUTE4 , VMR.VMR_ATTRIBUTE5 , VMR.VMR_ATTRIBUTE6 , VMR.VMR_ATTRIBUTE7 , VMR.VMR_ATTRIBUTE8 , VMR.VMR_ATTRIBUTE9 , VMR.VMR_ATTRIBUTE10 , VMR.VMR_ATTRIBUTE11 , VMR.VMR_ATTRIBUTE12 , VMR.VMR_ATTRIBUTE13 , VMR.VMR_ATTRIBUTE14 , VMR.VMR_ATTRIBUTE15 , VMR.VMR_ATTRIBUTE16 , VMR.VMR_ATTRIBUTE17 , VMR.VMR_ATTRIBUTE18 , VMR.VMR_ATTRIBUTE19 , VMR.VMR_ATTRIBUTE20 , VMR.VMR_ATTRIBUTE21 , VMR.VMR_ATTRIBUTE22 , VMR.VMR_ATTRIBUTE23 , VMR.VMR_ATTRIBUTE24 , VMR.VMR_ATTRIBUTE25 , VMR.VMR_ATTRIBUTE26 , VMR.VMR_ATTRIBUTE27 , VMR.VMR_ATTRIBUTE28 , VMR.VMR_ATTRIBUTE29 , VMR.VMR_ATTRIBUTE30 , VMR.LAST_UPDATE_DATE , VMR.LAST_UPDATED_BY , VMR.LAST_UPDATE_LOGIN , VMR.CREATED_BY , VMR.CREATION_DATE , VMR.OBJECT_VERSION_NUMBER FROM BEN_VRBL_MTCHG_RT_F VMR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN VMR.EFFECTIVE_START_DATE AND VMR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT VMR.ROWID ROW_ID
, VMR.VRBL_MTCHG_RT_ID
, VMR.EFFECTIVE_END_DATE
, VMR.EFFECTIVE_START_DATE
, VMR.NO_MX_PCT_OF_PY_NUM_FLAG
, VMR.TO_PCT_VAL
, VMR.NO_MX_AMT_OF_PY_NUM_FLAG
, VMR.MX_PCT_OF_PY_NUM
, VMR.NO_MX_MTCH_AMT_FLAG
, VMR.ORDR_NUM
, VMR.PCT_VAL
, VMR.MX_MTCH_AMT
, VMR.MX_AMT_OF_PY_NUM
, VMR.MN_MTCH_AMT
, VMR.MTCHG_RT_CALC_RL
, VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG
, VMR.FROM_PCT_VAL
, VMR.VRBL_RT_PRFL_ID
, VMR.BUSINESS_GROUP_ID
, VMR.VMR_ATTRIBUTE_CATEGORY
, VMR.VMR_ATTRIBUTE1
, VMR.VMR_ATTRIBUTE2
, VMR.VMR_ATTRIBUTE3
, VMR.VMR_ATTRIBUTE4
, VMR.VMR_ATTRIBUTE5
, VMR.VMR_ATTRIBUTE6
, VMR.VMR_ATTRIBUTE7
, VMR.VMR_ATTRIBUTE8
, VMR.VMR_ATTRIBUTE9
, VMR.VMR_ATTRIBUTE10
, VMR.VMR_ATTRIBUTE11
, VMR.VMR_ATTRIBUTE12
, VMR.VMR_ATTRIBUTE13
, VMR.VMR_ATTRIBUTE14
, VMR.VMR_ATTRIBUTE15
, VMR.VMR_ATTRIBUTE16
, VMR.VMR_ATTRIBUTE17
, VMR.VMR_ATTRIBUTE18
, VMR.VMR_ATTRIBUTE19
, VMR.VMR_ATTRIBUTE20
, VMR.VMR_ATTRIBUTE21
, VMR.VMR_ATTRIBUTE22
, VMR.VMR_ATTRIBUTE23
, VMR.VMR_ATTRIBUTE24
, VMR.VMR_ATTRIBUTE25
, VMR.VMR_ATTRIBUTE26
, VMR.VMR_ATTRIBUTE27
, VMR.VMR_ATTRIBUTE28
, VMR.VMR_ATTRIBUTE29
, VMR.VMR_ATTRIBUTE30
, VMR.LAST_UPDATE_DATE
, VMR.LAST_UPDATED_BY
, VMR.LAST_UPDATE_LOGIN
, VMR.CREATED_BY
, VMR.CREATION_DATE
, VMR.OBJECT_VERSION_NUMBER
FROM BEN_VRBL_MTCHG_RT_F VMR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN VMR.EFFECTIVE_START_DATE
AND VMR.EFFECTIVE_END_DATE