VIEW: APPS.BEN_AGE_RT_V

Source

View Text - Preformatted

SELECT ART.ROWID ROW_ID , ART.AGE_RT_ID , ART.EFFECTIVE_START_DATE , ART.EFFECTIVE_END_DATE , ART.BUSINESS_GROUP_ID , ART.VRBL_RT_PRFL_ID , ART.AGE_FCTR_ID , ART.ORDR_NUM , ART.EXCLD_FLAG , ART.ART_ATTRIBUTE_CATEGORY , ART.ART_ATTRIBUTE1 , ART.ART_ATTRIBUTE2 , ART.ART_ATTRIBUTE3 , ART.ART_ATTRIBUTE4 , ART.ART_ATTRIBUTE5 , ART.ART_ATTRIBUTE6 , ART.ART_ATTRIBUTE7 , ART.ART_ATTRIBUTE8 , ART.ART_ATTRIBUTE9 , ART.ART_ATTRIBUTE10 , ART.ART_ATTRIBUTE11 , ART.ART_ATTRIBUTE12 , ART.ART_ATTRIBUTE13 , ART.ART_ATTRIBUTE14 , ART.ART_ATTRIBUTE15 , ART.ART_ATTRIBUTE16 , ART.ART_ATTRIBUTE17 , ART.ART_ATTRIBUTE18 , ART.ART_ATTRIBUTE19 , ART.ART_ATTRIBUTE20 , ART.ART_ATTRIBUTE21 , ART.ART_ATTRIBUTE22 , ART.ART_ATTRIBUTE23 , ART.ART_ATTRIBUTE24 , ART.ART_ATTRIBUTE25 , ART.ART_ATTRIBUTE26 , ART.ART_ATTRIBUTE27 , ART.ART_ATTRIBUTE28 , ART.ART_ATTRIBUTE29 , ART.ART_ATTRIBUTE30 , ART.LAST_UPDATE_DATE , ART.LAST_UPDATED_BY , ART.LAST_UPDATE_LOGIN , ART.CREATED_BY , ART.CREATION_DATE , ART.OBJECT_VERSION_NUMBER FROM BEN_AGE_RT_F ART, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN ART.EFFECTIVE_START_DATE AND ART.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT ART.ROWID ROW_ID
, ART.AGE_RT_ID
, ART.EFFECTIVE_START_DATE
, ART.EFFECTIVE_END_DATE
, ART.BUSINESS_GROUP_ID
, ART.VRBL_RT_PRFL_ID
, ART.AGE_FCTR_ID
, ART.ORDR_NUM
, ART.EXCLD_FLAG
, ART.ART_ATTRIBUTE_CATEGORY
, ART.ART_ATTRIBUTE1
, ART.ART_ATTRIBUTE2
, ART.ART_ATTRIBUTE3
, ART.ART_ATTRIBUTE4
, ART.ART_ATTRIBUTE5
, ART.ART_ATTRIBUTE6
, ART.ART_ATTRIBUTE7
, ART.ART_ATTRIBUTE8
, ART.ART_ATTRIBUTE9
, ART.ART_ATTRIBUTE10
, ART.ART_ATTRIBUTE11
, ART.ART_ATTRIBUTE12
, ART.ART_ATTRIBUTE13
, ART.ART_ATTRIBUTE14
, ART.ART_ATTRIBUTE15
, ART.ART_ATTRIBUTE16
, ART.ART_ATTRIBUTE17
, ART.ART_ATTRIBUTE18
, ART.ART_ATTRIBUTE19
, ART.ART_ATTRIBUTE20
, ART.ART_ATTRIBUTE21
, ART.ART_ATTRIBUTE22
, ART.ART_ATTRIBUTE23
, ART.ART_ATTRIBUTE24
, ART.ART_ATTRIBUTE25
, ART.ART_ATTRIBUTE26
, ART.ART_ATTRIBUTE27
, ART.ART_ATTRIBUTE28
, ART.ART_ATTRIBUTE29
, ART.ART_ATTRIBUTE30
, ART.LAST_UPDATE_DATE
, ART.LAST_UPDATED_BY
, ART.LAST_UPDATE_LOGIN
, ART.CREATED_BY
, ART.CREATION_DATE
, ART.OBJECT_VERSION_NUMBER
FROM BEN_AGE_RT_F ART
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN ART.EFFECTIVE_START_DATE
AND ART.EFFECTIVE_END_DATE