VIEW: APPS.BEN_LBR_MMBR_RT_V

Source

View Text - Preformatted

SELECT LMM.ROWID ROW_ID , LMM.LBR_MMBR_RT_ID , LMM.EFFECTIVE_START_DATE , LMM.EFFECTIVE_END_DATE , LMM.VRBL_RT_PRFL_ID , LMM.EXCLD_FLAG , LMM.LBR_MMBR_FLAG , LMM.ORDR_NUM , LMM.BUSINESS_GROUP_ID , LMM.LMM_ATTRIBUTE_CATEGORY , LMM.LMM_ATTRIBUTE1 , LMM.LMM_ATTRIBUTE2 , LMM.LMM_ATTRIBUTE3 , LMM.LMM_ATTRIBUTE4 , LMM.LMM_ATTRIBUTE5 , LMM.LMM_ATTRIBUTE6 , LMM.LMM_ATTRIBUTE7 , LMM.LMM_ATTRIBUTE8 , LMM.LMM_ATTRIBUTE9 , LMM.LMM_ATTRIBUTE10 , LMM.LMM_ATTRIBUTE11 , LMM.LMM_ATTRIBUTE12 , LMM.LMM_ATTRIBUTE13 , LMM.LMM_ATTRIBUTE14 , LMM.LMM_ATTRIBUTE15 , LMM.LMM_ATTRIBUTE16 , LMM.LMM_ATTRIBUTE17 , LMM.LMM_ATTRIBUTE18 , LMM.LMM_ATTRIBUTE19 , LMM.LMM_ATTRIBUTE20 , LMM.LMM_ATTRIBUTE21 , LMM.LMM_ATTRIBUTE22 , LMM.LMM_ATTRIBUTE23 , LMM.LMM_ATTRIBUTE24 , LMM.LMM_ATTRIBUTE25 , LMM.LMM_ATTRIBUTE26 , LMM.LMM_ATTRIBUTE27 , LMM.LMM_ATTRIBUTE28 , LMM.LMM_ATTRIBUTE29 , LMM.LMM_ATTRIBUTE30 , LMM.LAST_UPDATE_DATE , LMM.LAST_UPDATED_BY , LMM.LAST_UPDATE_LOGIN , LMM.CREATED_BY , LMM.CREATION_DATE , LMM.OBJECT_VERSION_NUMBER FROM BEN_LBR_MMBR_RT_F LMM, FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('sessionid') AND SE.EFFECTIVE_DATE BETWEEN LMM.EFFECTIVE_START_DATE AND LMM.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT LMM.ROWID ROW_ID
, LMM.LBR_MMBR_RT_ID
, LMM.EFFECTIVE_START_DATE
, LMM.EFFECTIVE_END_DATE
, LMM.VRBL_RT_PRFL_ID
, LMM.EXCLD_FLAG
, LMM.LBR_MMBR_FLAG
, LMM.ORDR_NUM
, LMM.BUSINESS_GROUP_ID
, LMM.LMM_ATTRIBUTE_CATEGORY
, LMM.LMM_ATTRIBUTE1
, LMM.LMM_ATTRIBUTE2
, LMM.LMM_ATTRIBUTE3
, LMM.LMM_ATTRIBUTE4
, LMM.LMM_ATTRIBUTE5
, LMM.LMM_ATTRIBUTE6
, LMM.LMM_ATTRIBUTE7
, LMM.LMM_ATTRIBUTE8
, LMM.LMM_ATTRIBUTE9
, LMM.LMM_ATTRIBUTE10
, LMM.LMM_ATTRIBUTE11
, LMM.LMM_ATTRIBUTE12
, LMM.LMM_ATTRIBUTE13
, LMM.LMM_ATTRIBUTE14
, LMM.LMM_ATTRIBUTE15
, LMM.LMM_ATTRIBUTE16
, LMM.LMM_ATTRIBUTE17
, LMM.LMM_ATTRIBUTE18
, LMM.LMM_ATTRIBUTE19
, LMM.LMM_ATTRIBUTE20
, LMM.LMM_ATTRIBUTE21
, LMM.LMM_ATTRIBUTE22
, LMM.LMM_ATTRIBUTE23
, LMM.LMM_ATTRIBUTE24
, LMM.LMM_ATTRIBUTE25
, LMM.LMM_ATTRIBUTE26
, LMM.LMM_ATTRIBUTE27
, LMM.LMM_ATTRIBUTE28
, LMM.LMM_ATTRIBUTE29
, LMM.LMM_ATTRIBUTE30
, LMM.LAST_UPDATE_DATE
, LMM.LAST_UPDATED_BY
, LMM.LAST_UPDATE_LOGIN
, LMM.CREATED_BY
, LMM.CREATION_DATE
, LMM.OBJECT_VERSION_NUMBER
FROM BEN_LBR_MMBR_RT_F LMM
, FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN LMM.EFFECTIVE_START_DATE
AND LMM.EFFECTIVE_END_DATE