VIEW: APPS.BEN_POPL_RPTG_GRP

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))