VIEW: APPS.BEN_RLTD_PER_CHG_CS_LER_X

Source

View Text - Preformatted

SELECT rcl.RLTD_PER_CHG_CS_LER_ID ,rcl.EFFECTIVE_START_DATE ,rcl.EFFECTIVE_END_DATE ,rcl.NAME ,rcl.WHATIF_LBL_TXT ,rcl.OLD_VAL ,rcl.NEW_VAL ,rcl.SOURCE_COLUMN ,rcl.SOURCE_TABLE ,rcl.RLTD_PER_CHG_CS_LER_RL ,rcl.BUSINESS_GROUP_ID ,rcl.RCL_ATTRIBUTE_CATEGORY ,rcl.RCL_ATTRIBUTE1 ,rcl.RCL_ATTRIBUTE2 ,rcl.RCL_ATTRIBUTE3 ,rcl.RCL_ATTRIBUTE4 ,rcl.RCL_ATTRIBUTE5 ,rcl.RCL_ATTRIBUTE6 ,rcl.RCL_ATTRIBUTE7 ,rcl.RCL_ATTRIBUTE8 ,rcl.RCL_ATTRIBUTE9 ,rcl.RCL_ATTRIBUTE10 ,rcl.RCL_ATTRIBUTE11 ,rcl.RCL_ATTRIBUTE12 ,rcl.RCL_ATTRIBUTE13 ,rcl.RCL_ATTRIBUTE14 ,rcl.RCL_ATTRIBUTE15 ,rcl.RCL_ATTRIBUTE16 ,rcl.RCL_ATTRIBUTE17 ,rcl.RCL_ATTRIBUTE18 ,rcl.RCL_ATTRIBUTE19 ,rcl.RCL_ATTRIBUTE20 ,rcl.RCL_ATTRIBUTE21 ,rcl.RCL_ATTRIBUTE22 ,rcl.RCL_ATTRIBUTE23 ,rcl.RCL_ATTRIBUTE24 ,rcl.RCL_ATTRIBUTE25 ,rcl.RCL_ATTRIBUTE26 ,rcl.RCL_ATTRIBUTE27 ,rcl.RCL_ATTRIBUTE28 ,rcl.RCL_ATTRIBUTE29 ,rcl.RCL_ATTRIBUTE30 ,rcl.LAST_UPDATE_DATE ,rcl.LAST_UPDATED_BY ,rcl.LAST_UPDATE_LOGIN ,rcl.CREATED_BY ,rcl.CREATION_DATE ,rcl.OBJECT_VERSION_NUMBER ,rcl.RULE_OVERRIDES_FLAG from BEN_RLTD_PER_CHG_CS_LER_F rcl WHERE trunc(sysdate) between rcl.effective_start_date and rcl.effective_end_date

View Text - HTML Formatted

SELECT RCL.RLTD_PER_CHG_CS_LER_ID
, RCL.EFFECTIVE_START_DATE
, RCL.EFFECTIVE_END_DATE
, RCL.NAME
, RCL.WHATIF_LBL_TXT
, RCL.OLD_VAL
, RCL.NEW_VAL
, RCL.SOURCE_COLUMN
, RCL.SOURCE_TABLE
, RCL.RLTD_PER_CHG_CS_LER_RL
, RCL.BUSINESS_GROUP_ID
, RCL.RCL_ATTRIBUTE_CATEGORY
, RCL.RCL_ATTRIBUTE1
, RCL.RCL_ATTRIBUTE2
, RCL.RCL_ATTRIBUTE3
, RCL.RCL_ATTRIBUTE4
, RCL.RCL_ATTRIBUTE5
, RCL.RCL_ATTRIBUTE6
, RCL.RCL_ATTRIBUTE7
, RCL.RCL_ATTRIBUTE8
, RCL.RCL_ATTRIBUTE9
, RCL.RCL_ATTRIBUTE10
, RCL.RCL_ATTRIBUTE11
, RCL.RCL_ATTRIBUTE12
, RCL.RCL_ATTRIBUTE13
, RCL.RCL_ATTRIBUTE14
, RCL.RCL_ATTRIBUTE15
, RCL.RCL_ATTRIBUTE16
, RCL.RCL_ATTRIBUTE17
, RCL.RCL_ATTRIBUTE18
, RCL.RCL_ATTRIBUTE19
, RCL.RCL_ATTRIBUTE20
, RCL.RCL_ATTRIBUTE21
, RCL.RCL_ATTRIBUTE22
, RCL.RCL_ATTRIBUTE23
, RCL.RCL_ATTRIBUTE24
, RCL.RCL_ATTRIBUTE25
, RCL.RCL_ATTRIBUTE26
, RCL.RCL_ATTRIBUTE27
, RCL.RCL_ATTRIBUTE28
, RCL.RCL_ATTRIBUTE29
, RCL.RCL_ATTRIBUTE30
, RCL.LAST_UPDATE_DATE
, RCL.LAST_UPDATED_BY
, RCL.LAST_UPDATE_LOGIN
, RCL.CREATED_BY
, RCL.CREATION_DATE
, RCL.OBJECT_VERSION_NUMBER
, RCL.RULE_OVERRIDES_FLAG
FROM BEN_RLTD_PER_CHG_CS_LER_F RCL
WHERE TRUNC(SYSDATE) BETWEEN RCL.EFFECTIVE_START_DATE
AND RCL.EFFECTIVE_END_DATE