VIEW: APPS.BEN_LVG_RSN_RT_V

Source

View Text - Preformatted

SELECT LRN.ROWID, LRN.LVG_RSN_RT_ID, LRN.EFFECTIVE_START_DATE , LRN.EFFECTIVE_END_DATE , LRN.EXCLD_FLAG , LRN.VRBL_RT_PRFL_ID , LRN.BUSINESS_GROUP_ID , LRN.LVG_RSN_CD , LRN.OBJECT_VERSION_NUMBER , LRN.ORDR_NUM , LRN.LRN_ATTRIBUTE_CATEGORY, LRN.LRN_ATTRIBUTE1 , LRN.LRN_ATTRIBUTE2 , LRN.LRN_ATTRIBUTE3 , LRN.LRN_ATTRIBUTE4 , LRN.LRN_ATTRIBUTE5 , LRN.LRN_ATTRIBUTE6 , LRN.LRN_ATTRIBUTE7 , LRN.LRN_ATTRIBUTE8 , LRN.LRN_ATTRIBUTE9 , LRN.LRN_ATTRIBUTE10 , LRN.LRN_ATTRIBUTE11 , LRN.LRN_ATTRIBUTE12 , LRN.LRN_ATTRIBUTE13 , LRN.LRN_ATTRIBUTE14 , LRN.LRN_ATTRIBUTE15 , LRN.LRN_ATTRIBUTE16 , LRN.LRN_ATTRIBUTE17 , LRN.LRN_ATTRIBUTE18 , LRN.LRN_ATTRIBUTE19 , LRN.LRN_ATTRIBUTE20 , LRN.LRN_ATTRIBUTE21 , LRN.LRN_ATTRIBUTE22 , LRN.LRN_ATTRIBUTE23 , LRN.LRN_ATTRIBUTE24 , LRN.LRN_ATTRIBUTE25 , LRN.LRN_ATTRIBUTE26 , LRN.LRN_ATTRIBUTE27 , LRN.LRN_ATTRIBUTE28 , LRN.LRN_ATTRIBUTE29 , LRN.LRN_ATTRIBUTE30 , LRN.LAST_UPDATE_DATE, LRN.LAST_UPDATED_BY , LRN.LAST_UPDATE_LOGIN, LRN.CREATED_BY , LRN.CREATION_DATE FROM BEN_LVG_RSN_RT_F LRN, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('SESSIONID') AND SE.EFFECTIVE_DATE BETWEEN LRN.EFFECTIVE_START_DATE AND LRN.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LRN.ROWID
, LRN.LVG_RSN_RT_ID
, LRN.EFFECTIVE_START_DATE
, LRN.EFFECTIVE_END_DATE
, LRN.EXCLD_FLAG
, LRN.VRBL_RT_PRFL_ID
, LRN.BUSINESS_GROUP_ID
, LRN.LVG_RSN_CD
, LRN.OBJECT_VERSION_NUMBER
, LRN.ORDR_NUM
, LRN.LRN_ATTRIBUTE_CATEGORY
, LRN.LRN_ATTRIBUTE1
, LRN.LRN_ATTRIBUTE2
, LRN.LRN_ATTRIBUTE3
, LRN.LRN_ATTRIBUTE4
, LRN.LRN_ATTRIBUTE5
, LRN.LRN_ATTRIBUTE6
, LRN.LRN_ATTRIBUTE7
, LRN.LRN_ATTRIBUTE8
, LRN.LRN_ATTRIBUTE9
, LRN.LRN_ATTRIBUTE10
, LRN.LRN_ATTRIBUTE11
, LRN.LRN_ATTRIBUTE12
, LRN.LRN_ATTRIBUTE13
, LRN.LRN_ATTRIBUTE14
, LRN.LRN_ATTRIBUTE15
, LRN.LRN_ATTRIBUTE16
, LRN.LRN_ATTRIBUTE17
, LRN.LRN_ATTRIBUTE18
, LRN.LRN_ATTRIBUTE19
, LRN.LRN_ATTRIBUTE20
, LRN.LRN_ATTRIBUTE21
, LRN.LRN_ATTRIBUTE22
, LRN.LRN_ATTRIBUTE23
, LRN.LRN_ATTRIBUTE24
, LRN.LRN_ATTRIBUTE25
, LRN.LRN_ATTRIBUTE26
, LRN.LRN_ATTRIBUTE27
, LRN.LRN_ATTRIBUTE28
, LRN.LRN_ATTRIBUTE29
, LRN.LRN_ATTRIBUTE30
, LRN.LAST_UPDATE_DATE
, LRN.LAST_UPDATED_BY
, LRN.LAST_UPDATE_LOGIN
, LRN.CREATED_BY
, LRN.CREATION_DATE
FROM BEN_LVG_RSN_RT_F LRN
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LRN.EFFECTIVE_START_DATE
AND LRN.EFFECTIVE_END_DATE