eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BEN_LGL_ENTY_RT

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_LGL_ENTY_RT

View Text

SELECT LGL.LGL_ENTY_RT_ID
, LGL.EFFECTIVE_START_DATE
, LGL.EFFECTIVE_END_DATE
, LGL.VRBL_RT_PRFL_ID
, LGL.ORGANIZATION_ID
, LGL.EXCLD_FLAG
, LGL.ORDR_NUM
, LGL.BUSINESS_GROUP_ID
, LGL.LER1_ATTRIBUTE_CATEGORY
, LGL.LER1_ATTRIBUTE1
, LGL.LER1_ATTRIBUTE2
, LGL.LER1_ATTRIBUTE3
, LGL.LER1_ATTRIBUTE4
, LGL.LER1_ATTRIBUTE5
, LGL.LER1_ATTRIBUTE6
, LGL.LER1_ATTRIBUTE7
, LGL.LER1_ATTRIBUTE8
, LGL.LER1_ATTRIBUTE9
, LGL.LER1_ATTRIBUTE10
, LGL.LER1_ATTRIBUTE11
, LGL.LER1_ATTRIBUTE12
, LGL.LER1_ATTRIBUTE13
, LGL.LER1_ATTRIBUTE14
, LGL.LER1_ATTRIBUTE15
, LGL.LER1_ATTRIBUTE16
, LGL.LER1_ATTRIBUTE17
, LGL.LER1_ATTRIBUTE18
, LGL.LER1_ATTRIBUTE19
, LGL.LER1_ATTRIBUTE20
, LGL.LER1_ATTRIBUTE21
, LGL.LER1_ATTRIBUTE22
, LGL.LER1_ATTRIBUTE23
, LGL.LER1_ATTRIBUTE24
, LGL.LER1_ATTRIBUTE25
, LGL.LER1_ATTRIBUTE26
, LGL.LER1_ATTRIBUTE27
, LGL.LER1_ATTRIBUTE28
, LGL.LER1_ATTRIBUTE29
, LGL.LER1_ATTRIBUTE30
, LGL.LAST_UPDATE_DATE
, LGL.LAST_UPDATED_BY
, LGL.LAST_UPDATE_LOGIN
, LGL.CREATED_BY
, LGL.CREATION_DATE
, LGL.OBJECT_VERSION_NUMBER
FROM BEN_LGL_ENTY_RT_F LGL
WHERE LGL.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND LGL.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
LGL_ENTY_RT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
VRBL_RT_PRFL_ID
ORGANIZATION_ID
EXCLD_FLAG
ORDR_NUM
BUSINESS_GROUP_ID
LER1_ATTRIBUTE_CATEGORY
LER1_ATTRIBUTE1
LER1_ATTRIBUTE2
LER1_ATTRIBUTE3
LER1_ATTRIBUTE4
LER1_ATTRIBUTE5
LER1_ATTRIBUTE6
LER1_ATTRIBUTE7
LER1_ATTRIBUTE8
LER1_ATTRIBUTE9
LER1_ATTRIBUTE10
LER1_ATTRIBUTE11
LER1_ATTRIBUTE12
LER1_ATTRIBUTE13
LER1_ATTRIBUTE14
LER1_ATTRIBUTE15
LER1_ATTRIBUTE16
LER1_ATTRIBUTE17
LER1_ATTRIBUTE18
LER1_ATTRIBUTE19
LER1_ATTRIBUTE20
LER1_ATTRIBUTE21
LER1_ATTRIBUTE22
LER1_ATTRIBUTE23
LER1_ATTRIBUTE24
LER1_ATTRIBUTE25
LER1_ATTRIBUTE26
LER1_ATTRIBUTE27
LER1_ATTRIBUTE28
LER1_ATTRIBUTE29
LER1_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER