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_POPL_RPTG_GRP

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

View Text

SELECT RGR.POPL_RPTG_GRP_ID
, RGR.EFFECTIVE_START_DATE
, RGR.EFFECTIVE_END_DATE
, RGR.BUSINESS_GROUP_ID
, RGR.RPTG_GRP_ID
, RGR.PGM_ID
, RGR.PL_ID
, RGR.ORDR_NUM
, RGR.RGR_ATTRIBUTE_CATEGORY
, RGR.RGR_ATTRIBUTE1
, RGR.RGR_ATTRIBUTE2
, RGR.RGR_ATTRIBUTE3
, RGR.RGR_ATTRIBUTE4
, RGR.RGR_ATTRIBUTE5
, RGR.RGR_ATTRIBUTE6
, RGR.RGR_ATTRIBUTE7
, RGR.RGR_ATTRIBUTE8
, RGR.RGR_ATTRIBUTE9
, RGR.RGR_ATTRIBUTE10
, RGR.RGR_ATTRIBUTE11
, RGR.RGR_ATTRIBUTE12
, RGR.RGR_ATTRIBUTE13
, RGR.RGR_ATTRIBUTE14
, RGR.RGR_ATTRIBUTE15
, RGR.RGR_ATTRIBUTE16
, RGR.RGR_ATTRIBUTE17
, RGR.RGR_ATTRIBUTE18
, RGR.RGR_ATTRIBUTE19
, RGR.RGR_ATTRIBUTE20
, RGR.RGR_ATTRIBUTE21
, RGR.RGR_ATTRIBUTE22
, RGR.RGR_ATTRIBUTE23
, RGR.RGR_ATTRIBUTE24
, RGR.RGR_ATTRIBUTE25
, RGR.RGR_ATTRIBUTE26
, RGR.RGR_ATTRIBUTE27
, RGR.RGR_ATTRIBUTE28
, RGR.RGR_ATTRIBUTE29
, RGR.RGR_ATTRIBUTE30
, RGR.LAST_UPDATE_DATE
, RGR.LAST_UPDATED_BY
, RGR.LAST_UPDATE_LOGIN
, RGR.CREATED_BY
, RGR.CREATION_DATE
, RGR.OBJECT_VERSION_NUMBER
FROM BEN_POPL_RPTG_GRP_F RGR
WHERE RGR.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND RGR.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))

Columns

Name
POPL_RPTG_GRP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
RPTG_GRP_ID
PGM_ID
PL_ID
ORDR_NUM
RGR_ATTRIBUTE_CATEGORY
RGR_ATTRIBUTE1
RGR_ATTRIBUTE2
RGR_ATTRIBUTE3
RGR_ATTRIBUTE4
RGR_ATTRIBUTE5
RGR_ATTRIBUTE6
RGR_ATTRIBUTE7
RGR_ATTRIBUTE8
RGR_ATTRIBUTE9
RGR_ATTRIBUTE10
RGR_ATTRIBUTE11
RGR_ATTRIBUTE12
RGR_ATTRIBUTE13
RGR_ATTRIBUTE14
RGR_ATTRIBUTE15
RGR_ATTRIBUTE16
RGR_ATTRIBUTE17
RGR_ATTRIBUTE18
RGR_ATTRIBUTE19
RGR_ATTRIBUTE20
RGR_ATTRIBUTE21
RGR_ATTRIBUTE22
RGR_ATTRIBUTE23
RGR_ATTRIBUTE24
RGR_ATTRIBUTE25
RGR_ATTRIBUTE26
RGR_ATTRIBUTE27
RGR_ATTRIBUTE28
RGR_ATTRIBUTE29
RGR_ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER