VIEW: APPS.BEN_DSBLD_RT_X

Source

View Text - Preformatted

SELECT dbr.DSBLD_RT_ID ,dbr.DSBLD_CD ,dbr.EFFECTIVE_START_DATE ,dbr.EFFECTIVE_END_DATE ,dbr.ORDR_NUM ,dbr.EXCLD_FLAG ,dbr.VRBL_RT_PRFL_ID ,dbr.BUSINESS_GROUP_ID ,dbr.DBR_ATTRIBUTE_CATEGORY ,dbr.DBR_ATTRIBUTE1 ,dbr.DBR_ATTRIBUTE2 ,dbr.DBR_ATTRIBUTE3 ,dbr.DBR_ATTRIBUTE4 ,dbr.DBR_ATTRIBUTE5 ,dbr.DBR_ATTRIBUTE6 ,dbr.DBR_ATTRIBUTE7 ,dbr.DBR_ATTRIBUTE8 ,dbr.DBR_ATTRIBUTE9 ,dbr.DBR_ATTRIBUTE10 ,dbr.DBR_ATTRIBUTE11 ,dbr.DBR_ATTRIBUTE12 ,dbr.DBR_ATTRIBUTE13 ,dbr.DBR_ATTRIBUTE14 ,dbr.DBR_ATTRIBUTE15 ,dbr.DBR_ATTRIBUTE16 ,dbr.DBR_ATTRIBUTE17 ,dbr.DBR_ATTRIBUTE18 ,dbr.DBR_ATTRIBUTE19 ,dbr.DBR_ATTRIBUTE20 ,dbr.DBR_ATTRIBUTE21 ,dbr.DBR_ATTRIBUTE22 ,dbr.DBR_ATTRIBUTE23 ,dbr.DBR_ATTRIBUTE24 ,dbr.DBR_ATTRIBUTE25 ,dbr.DBR_ATTRIBUTE26 ,dbr.DBR_ATTRIBUTE27 ,dbr.DBR_ATTRIBUTE28 ,dbr.DBR_ATTRIBUTE29 ,dbr.DBR_ATTRIBUTE30 ,dbr.LAST_UPDATE_DATE ,dbr.LAST_UPDATED_BY ,dbr.LAST_UPDATE_LOGIN ,dbr.CREATED_BY ,dbr.CREATION_DATE ,dbr.OBJECT_VERSION_NUMBER from BEN_DSBLD_RT_F dbr WHERE trunc(sysdate) between dbr.effective_start_date and dbr.effective_end_date

View Text - HTML Formatted

SELECT DBR.DSBLD_RT_ID
, DBR.DSBLD_CD
, DBR.EFFECTIVE_START_DATE
, DBR.EFFECTIVE_END_DATE
, DBR.ORDR_NUM
, DBR.EXCLD_FLAG
, DBR.VRBL_RT_PRFL_ID
, DBR.BUSINESS_GROUP_ID
, DBR.DBR_ATTRIBUTE_CATEGORY
, DBR.DBR_ATTRIBUTE1
, DBR.DBR_ATTRIBUTE2
, DBR.DBR_ATTRIBUTE3
, DBR.DBR_ATTRIBUTE4
, DBR.DBR_ATTRIBUTE5
, DBR.DBR_ATTRIBUTE6
, DBR.DBR_ATTRIBUTE7
, DBR.DBR_ATTRIBUTE8
, DBR.DBR_ATTRIBUTE9
, DBR.DBR_ATTRIBUTE10
, DBR.DBR_ATTRIBUTE11
, DBR.DBR_ATTRIBUTE12
, DBR.DBR_ATTRIBUTE13
, DBR.DBR_ATTRIBUTE14
, DBR.DBR_ATTRIBUTE15
, DBR.DBR_ATTRIBUTE16
, DBR.DBR_ATTRIBUTE17
, DBR.DBR_ATTRIBUTE18
, DBR.DBR_ATTRIBUTE19
, DBR.DBR_ATTRIBUTE20
, DBR.DBR_ATTRIBUTE21
, DBR.DBR_ATTRIBUTE22
, DBR.DBR_ATTRIBUTE23
, DBR.DBR_ATTRIBUTE24
, DBR.DBR_ATTRIBUTE25
, DBR.DBR_ATTRIBUTE26
, DBR.DBR_ATTRIBUTE27
, DBR.DBR_ATTRIBUTE28
, DBR.DBR_ATTRIBUTE29
, DBR.DBR_ATTRIBUTE30
, DBR.LAST_UPDATE_DATE
, DBR.LAST_UPDATED_BY
, DBR.LAST_UPDATE_LOGIN
, DBR.CREATED_BY
, DBR.CREATION_DATE
, DBR.OBJECT_VERSION_NUMBER
FROM BEN_DSBLD_RT_F DBR
WHERE TRUNC(SYSDATE) BETWEEN DBR.EFFECTIVE_START_DATE
AND DBR.EFFECTIVE_END_DATE