VIEW: APPS.BEN_CMBN_AGE_LOS_RT_V

Source

View Text - Preformatted

SELECT CMR.ROWID ROW_ID , CMR.CMBN_AGE_LOS_RT_ID , CMR.EFFECTIVE_START_DATE , CMR.EFFECTIVE_END_DATE , CMR.VRBL_RT_PRFL_ID , CMR.CMBN_AGE_LOS_FCTR_ID , CMR.EXCLD_FLAG , CMR.ORDR_NUM , CMR.BUSINESS_GROUP_ID , CMR.CMR_ATTRIBUTE_CATEGORY , CMR.CMR_ATTRIBUTE1 , CMR.CMR_ATTRIBUTE2 , CMR.CMR_ATTRIBUTE3 , CMR.CMR_ATTRIBUTE4 , CMR.CMR_ATTRIBUTE5 , CMR.CMR_ATTRIBUTE6 , CMR.CMR_ATTRIBUTE7 , CMR.CMR_ATTRIBUTE8 , CMR.CMR_ATTRIBUTE9 , CMR.CMR_ATTRIBUTE10 , CMR.CMR_ATTRIBUTE11 , CMR.CMR_ATTRIBUTE12 , CMR.CMR_ATTRIBUTE13 , CMR.CMR_ATTRIBUTE14 , CMR.CMR_ATTRIBUTE15 , CMR.CMR_ATTRIBUTE16 , CMR.CMR_ATTRIBUTE17 , CMR.CMR_ATTRIBUTE18 , CMR.CMR_ATTRIBUTE19 , CMR.CMR_ATTRIBUTE20 , CMR.CMR_ATTRIBUTE21 , CMR.CMR_ATTRIBUTE22 , CMR.CMR_ATTRIBUTE23 , CMR.CMR_ATTRIBUTE24 , CMR.CMR_ATTRIBUTE25 , CMR.CMR_ATTRIBUTE26 , CMR.CMR_ATTRIBUTE27 , CMR.CMR_ATTRIBUTE28 , CMR.CMR_ATTRIBUTE29 , CMR.CMR_ATTRIBUTE30 , CMR.LAST_UPDATE_DATE , CMR.LAST_UPDATED_BY , CMR.LAST_UPDATE_LOGIN , CMR.CREATED_BY , CMR.CREATION_DATE , CMR.OBJECT_VERSION_NUMBER FROM BEN_CMBN_AGE_LOS_RT_F CMR, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN CMR.EFFECTIVE_START_DATE AND CMR.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT CMR.ROWID ROW_ID
, CMR.CMBN_AGE_LOS_RT_ID
, CMR.EFFECTIVE_START_DATE
, CMR.EFFECTIVE_END_DATE
, CMR.VRBL_RT_PRFL_ID
, CMR.CMBN_AGE_LOS_FCTR_ID
, CMR.EXCLD_FLAG
, CMR.ORDR_NUM
, CMR.BUSINESS_GROUP_ID
, CMR.CMR_ATTRIBUTE_CATEGORY
, CMR.CMR_ATTRIBUTE1
, CMR.CMR_ATTRIBUTE2
, CMR.CMR_ATTRIBUTE3
, CMR.CMR_ATTRIBUTE4
, CMR.CMR_ATTRIBUTE5
, CMR.CMR_ATTRIBUTE6
, CMR.CMR_ATTRIBUTE7
, CMR.CMR_ATTRIBUTE8
, CMR.CMR_ATTRIBUTE9
, CMR.CMR_ATTRIBUTE10
, CMR.CMR_ATTRIBUTE11
, CMR.CMR_ATTRIBUTE12
, CMR.CMR_ATTRIBUTE13
, CMR.CMR_ATTRIBUTE14
, CMR.CMR_ATTRIBUTE15
, CMR.CMR_ATTRIBUTE16
, CMR.CMR_ATTRIBUTE17
, CMR.CMR_ATTRIBUTE18
, CMR.CMR_ATTRIBUTE19
, CMR.CMR_ATTRIBUTE20
, CMR.CMR_ATTRIBUTE21
, CMR.CMR_ATTRIBUTE22
, CMR.CMR_ATTRIBUTE23
, CMR.CMR_ATTRIBUTE24
, CMR.CMR_ATTRIBUTE25
, CMR.CMR_ATTRIBUTE26
, CMR.CMR_ATTRIBUTE27
, CMR.CMR_ATTRIBUTE28
, CMR.CMR_ATTRIBUTE29
, CMR.CMR_ATTRIBUTE30
, CMR.LAST_UPDATE_DATE
, CMR.LAST_UPDATED_BY
, CMR.LAST_UPDATE_LOGIN
, CMR.CREATED_BY
, CMR.CREATION_DATE
, CMR.OBJECT_VERSION_NUMBER
FROM BEN_CMBN_AGE_LOS_RT_F CMR
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN CMR.EFFECTIVE_START_DATE
AND CMR.EFFECTIVE_END_DATE