VIEW: APPS.BEN_ACTL_PREM_VRBL_RT_V

Source

View Text - Preformatted

SELECT APV.ROWID ROW_ID , APV.ACTL_PREM_VRBL_RT_ID , APV.EFFECTIVE_START_DATE , APV.EFFECTIVE_END_DATE , APV.ACTL_PREM_ID , APV.VRBL_RT_PRFL_ID ,apv.ordr_num , APV.BUSINESS_GROUP_ID , APV.APV_ATTRIBUTE_CATEGORY , APV.APV_ATTRIBUTE1 , APV.APV_ATTRIBUTE2 , APV.APV_ATTRIBUTE3 , APV.APV_ATTRIBUTE4 , APV.APV_ATTRIBUTE5 , APV.APV_ATTRIBUTE6 , APV.APV_ATTRIBUTE7 , APV.APV_ATTRIBUTE8 , APV.APV_ATTRIBUTE9 , APV.APV_ATTRIBUTE10 , APV.APV_ATTRIBUTE11 , APV.APV_ATTRIBUTE12 , APV.APV_ATTRIBUTE13 , APV.APV_ATTRIBUTE14 , APV.APV_ATTRIBUTE15 , APV.APV_ATTRIBUTE16 , APV.APV_ATTRIBUTE17 , APV.APV_ATTRIBUTE18 , APV.APV_ATTRIBUTE19 , APV.APV_ATTRIBUTE20 , APV.APV_ATTRIBUTE21 , APV.APV_ATTRIBUTE22 , APV.APV_ATTRIBUTE23 , APV.APV_ATTRIBUTE24 , APV.APV_ATTRIBUTE25 , APV.APV_ATTRIBUTE26 , APV.APV_ATTRIBUTE27 , APV.APV_ATTRIBUTE28 , APV.APV_ATTRIBUTE29 , APV.APV_ATTRIBUTE30 , APV.LAST_UPDATE_DATE , APV.LAST_UPDATED_BY , APV.LAST_UPDATE_LOGIN , APV.CREATED_BY , APV.CREATION_DATE , APV.OBJECT_VERSION_NUMBER FROM BEN_ACTL_PREM_VRBL_RT_F APV, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN APV.EFFECTIVE_START_DATE AND APV.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT APV.ROWID ROW_ID
, APV.ACTL_PREM_VRBL_RT_ID
, APV.EFFECTIVE_START_DATE
, APV.EFFECTIVE_END_DATE
, APV.ACTL_PREM_ID
, APV.VRBL_RT_PRFL_ID
, APV.ORDR_NUM
, APV.BUSINESS_GROUP_ID
, APV.APV_ATTRIBUTE_CATEGORY
, APV.APV_ATTRIBUTE1
, APV.APV_ATTRIBUTE2
, APV.APV_ATTRIBUTE3
, APV.APV_ATTRIBUTE4
, APV.APV_ATTRIBUTE5
, APV.APV_ATTRIBUTE6
, APV.APV_ATTRIBUTE7
, APV.APV_ATTRIBUTE8
, APV.APV_ATTRIBUTE9
, APV.APV_ATTRIBUTE10
, APV.APV_ATTRIBUTE11
, APV.APV_ATTRIBUTE12
, APV.APV_ATTRIBUTE13
, APV.APV_ATTRIBUTE14
, APV.APV_ATTRIBUTE15
, APV.APV_ATTRIBUTE16
, APV.APV_ATTRIBUTE17
, APV.APV_ATTRIBUTE18
, APV.APV_ATTRIBUTE19
, APV.APV_ATTRIBUTE20
, APV.APV_ATTRIBUTE21
, APV.APV_ATTRIBUTE22
, APV.APV_ATTRIBUTE23
, APV.APV_ATTRIBUTE24
, APV.APV_ATTRIBUTE25
, APV.APV_ATTRIBUTE26
, APV.APV_ATTRIBUTE27
, APV.APV_ATTRIBUTE28
, APV.APV_ATTRIBUTE29
, APV.APV_ATTRIBUTE30
, APV.LAST_UPDATE_DATE
, APV.LAST_UPDATED_BY
, APV.LAST_UPDATE_LOGIN
, APV.CREATED_BY
, APV.CREATION_DATE
, APV.OBJECT_VERSION_NUMBER
FROM BEN_ACTL_PREM_VRBL_RT_F APV
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN APV.EFFECTIVE_START_DATE
AND APV.EFFECTIVE_END_DATE