VIEW: APPS.BEN_ACTY_BASE_RT_CTFN_X

Source

View Text - Preformatted

SELECT abc.acty_base_rt_ctfn_id ,abc.EFFECTIVE_START_DATE ,abc.EFFECTIVE_END_DATE ,abc.ENRT_CTFN_TYP_CD ,abc.CTFN_RQD_WHEN_RL ,abc.RQD_FLAG ,abc.acty_base_rt_id ,abc.BUSINESS_GROUP_ID ,abc.abc_ATTRIBUTE_CATEGORY ,abc.abc_ATTRIBUTE1 ,abc.abc_ATTRIBUTE2 ,abc.abc_ATTRIBUTE3 ,abc.abc_ATTRIBUTE4 ,abc.abc_ATTRIBUTE5 ,abc.abc_ATTRIBUTE6 ,abc.abc_ATTRIBUTE7 ,abc.abc_ATTRIBUTE8 ,abc.abc_ATTRIBUTE9 ,abc.abc_ATTRIBUTE10 ,abc.abc_ATTRIBUTE11 ,abc.abc_ATTRIBUTE12 ,abc.abc_ATTRIBUTE13 ,abc.abc_ATTRIBUTE14 ,abc.abc_ATTRIBUTE15 ,abc.abc_ATTRIBUTE16 ,abc.abc_ATTRIBUTE17 ,abc.abc_ATTRIBUTE18 ,abc.abc_ATTRIBUTE19 ,abc.abc_ATTRIBUTE20 ,abc.abc_ATTRIBUTE21 ,abc.abc_ATTRIBUTE22 ,abc.abc_ATTRIBUTE23 ,abc.abc_ATTRIBUTE24 ,abc.abc_ATTRIBUTE25 ,abc.abc_ATTRIBUTE26 ,abc.abc_ATTRIBUTE27 ,abc.abc_ATTRIBUTE28 ,abc.abc_ATTRIBUTE29 ,abc.abc_ATTRIBUTE30 ,abc.LAST_UPDATE_DATE ,abc.LAST_UPDATED_BY ,abc.LAST_UPDATE_LOGIN ,abc.CREATED_BY ,abc.CREATION_DATE ,abc.OBJECT_VERSION_NUMBER from BEN_ACTY_BASE_RT_CTFN_F abc WHERE trunc(sysdate) between abc.effective_start_date and abc.effective_end_date

View Text - HTML Formatted

SELECT ABC.ACTY_BASE_RT_CTFN_ID
, ABC.EFFECTIVE_START_DATE
, ABC.EFFECTIVE_END_DATE
, ABC.ENRT_CTFN_TYP_CD
, ABC.CTFN_RQD_WHEN_RL
, ABC.RQD_FLAG
, ABC.ACTY_BASE_RT_ID
, ABC.BUSINESS_GROUP_ID
, ABC.ABC_ATTRIBUTE_CATEGORY
, ABC.ABC_ATTRIBUTE1
, ABC.ABC_ATTRIBUTE2
, ABC.ABC_ATTRIBUTE3
, ABC.ABC_ATTRIBUTE4
, ABC.ABC_ATTRIBUTE5
, ABC.ABC_ATTRIBUTE6
, ABC.ABC_ATTRIBUTE7
, ABC.ABC_ATTRIBUTE8
, ABC.ABC_ATTRIBUTE9
, ABC.ABC_ATTRIBUTE10
, ABC.ABC_ATTRIBUTE11
, ABC.ABC_ATTRIBUTE12
, ABC.ABC_ATTRIBUTE13
, ABC.ABC_ATTRIBUTE14
, ABC.ABC_ATTRIBUTE15
, ABC.ABC_ATTRIBUTE16
, ABC.ABC_ATTRIBUTE17
, ABC.ABC_ATTRIBUTE18
, ABC.ABC_ATTRIBUTE19
, ABC.ABC_ATTRIBUTE20
, ABC.ABC_ATTRIBUTE21
, ABC.ABC_ATTRIBUTE22
, ABC.ABC_ATTRIBUTE23
, ABC.ABC_ATTRIBUTE24
, ABC.ABC_ATTRIBUTE25
, ABC.ABC_ATTRIBUTE26
, ABC.ABC_ATTRIBUTE27
, ABC.ABC_ATTRIBUTE28
, ABC.ABC_ATTRIBUTE29
, ABC.ABC_ATTRIBUTE30
, ABC.LAST_UPDATE_DATE
, ABC.LAST_UPDATED_BY
, ABC.LAST_UPDATE_LOGIN
, ABC.CREATED_BY
, ABC.CREATION_DATE
, ABC.OBJECT_VERSION_NUMBER
FROM BEN_ACTY_BASE_RT_CTFN_F ABC
WHERE TRUNC(SYSDATE) BETWEEN ABC.EFFECTIVE_START_DATE
AND ABC.EFFECTIVE_END_DATE