VIEW: APPS.BEN_TTL_CVG_VOL_RT_D

Source

View Text - Preformatted

SELECT tcv.ROWID ROW_ID, tcv.TTL_CVG_VOL_RT_ID ,tcv.EFFECTIVE_START_DATE ,tcv.EFFECTIVE_END_DATE ,HL1.MEANING ,HL2.MEANING ,HL3.MEANING ,tcv.ORDR_NUM ,tcv.MN_CVG_VOL_AMT ,tcv.MX_CVG_VOL_AMT ,HL4.MEANING ,FF1.FORMULA_NAME ,VRBL_RT_PRFL.NAME ,tcv.LAST_UPDATE_DATE ,fuser.user_name from BEN_TTL_CVG_VOL_RT_F tcv, fnd_user_view fuser ,BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL ,hr_lookups HL1 ,hr_lookups HL2 ,hr_lookups HL3 ,hr_lookups HL4 ,ff_formulas_f FF1 WHERE fuser.user_id (+)= tcv.last_updated_by and VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= tcv.VRBL_RT_PRFL_ID and HL4.lookup_code (+)= tcv.CVG_VOL_DET_CD and HL4.lookup_type (+)= 'BEN_CVG_DET_DT' and HL1.lookup_code (+)= tcv.EXCLD_FLAG and HL1.lookup_type (+)= 'YES_NO' and HL2.lookup_code (+)= tcv.NO_MN_CVG_VOL_AMT_APLS_FLAG and HL2.lookup_type (+)= 'YES_NO' and HL3.lookup_code (+)= tcv.NO_MX_CVG_VOL_AMT_APLS_FLAG and HL3.lookup_type (+)= 'YES_NO' and FF1.formula_id (+)= tcv.CVG_VOL_DET_RL and tcv.EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE(+) and FF1.EFFECTIVE_END_DATE(+)

View Text - HTML Formatted

SELECT TCV.ROWID ROW_ID
, TCV.TTL_CVG_VOL_RT_ID
, TCV.EFFECTIVE_START_DATE
, TCV.EFFECTIVE_END_DATE
, HL1.MEANING
, HL2.MEANING
, HL3.MEANING
, TCV.ORDR_NUM
, TCV.MN_CVG_VOL_AMT
, TCV.MX_CVG_VOL_AMT
, HL4.MEANING
, FF1.FORMULA_NAME
, VRBL_RT_PRFL.NAME
, TCV.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_TTL_CVG_VOL_RT_F TCV
, FND_USER_VIEW FUSER
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
, HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, HR_LOOKUPS HL3
, HR_LOOKUPS HL4
, FF_FORMULAS_F FF1
WHERE FUSER.USER_ID (+)= TCV.LAST_UPDATED_BY
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= TCV.VRBL_RT_PRFL_ID
AND HL4.LOOKUP_CODE (+)= TCV.CVG_VOL_DET_CD
AND HL4.LOOKUP_TYPE (+)= 'BEN_CVG_DET_DT'
AND HL1.LOOKUP_CODE (+)= TCV.EXCLD_FLAG
AND HL1.LOOKUP_TYPE (+)= 'YES_NO'
AND HL2.LOOKUP_CODE (+)= TCV.NO_MN_CVG_VOL_AMT_APLS_FLAG
AND HL2.LOOKUP_TYPE (+)= 'YES_NO'
AND HL3.LOOKUP_CODE (+)= TCV.NO_MX_CVG_VOL_AMT_APLS_FLAG
AND HL3.LOOKUP_TYPE (+)= 'YES_NO'
AND FF1.FORMULA_ID (+)= TCV.CVG_VOL_DET_RL
AND TCV.EFFECTIVE_START_DATE BETWEEN FF1.EFFECTIVE_START_DATE(+)
AND FF1.EFFECTIVE_END_DATE(+)