VIEW: APPS.BEN_LER_RLTD_PER_CS_LER_D

Source

View Text - Preformatted

SELECT lrc.ROWID row_id, lrc.ler_rltd_per_cs_ler_id, lrc.effective_start_date, lrc.effective_end_date, ler_rltd_per_cs_chg.formula_name, ler.NAME, rltd_per_chg_cs_ler_f.name, lrc.last_update_date, fuser.user_name FROM ben_ler_rltd_per_cs_ler_f lrc, fnd_user fuser, ben_ler_f ler, ben_rltd_per_chg_cs_ler_f rltd_per_chg_cs_ler_f, ff_formulas_f ler_rltd_per_cs_chg WHERE fuser.user_id(+) = lrc.last_updated_by AND ler.ler_id(+) = lrc.ler_id AND rltd_per_chg_cs_ler_f.rltd_per_chg_cs_ler_id(+) = lrc.rltd_per_chg_cs_ler_id AND ler_rltd_per_cs_chg.formula_id(+) = lrc.ler_rltd_per_cs_chg_rl AND lrc.effective_start_date BETWEEN ler_rltd_per_cs_chg.effective_start_date(+) AND ler_rltd_per_cs_chg.effective_end_date(+) AND lrc.effective_start_date BETWEEN rltd_per_chg_cs_ler_f.effective_start_date(+) AND rltd_per_chg_cs_ler_f.effective_end_date(+) AND lrc.effective_start_date BETWEEN ler.effective_start_date(+) AND ler.effective_end_date(+)

View Text - HTML Formatted

SELECT LRC.ROWID ROW_ID
, LRC.LER_RLTD_PER_CS_LER_ID
, LRC.EFFECTIVE_START_DATE
, LRC.EFFECTIVE_END_DATE
, LER_RLTD_PER_CS_CHG.FORMULA_NAME
, LER.NAME
, RLTD_PER_CHG_CS_LER_F.NAME
, LRC.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_LER_RLTD_PER_CS_LER_F LRC
, FND_USER FUSER
, BEN_LER_F LER
, BEN_RLTD_PER_CHG_CS_LER_F RLTD_PER_CHG_CS_LER_F
, FF_FORMULAS_F LER_RLTD_PER_CS_CHG
WHERE FUSER.USER_ID(+) = LRC.LAST_UPDATED_BY
AND LER.LER_ID(+) = LRC.LER_ID
AND RLTD_PER_CHG_CS_LER_F.RLTD_PER_CHG_CS_LER_ID(+) = LRC.RLTD_PER_CHG_CS_LER_ID
AND LER_RLTD_PER_CS_CHG.FORMULA_ID(+) = LRC.LER_RLTD_PER_CS_CHG_RL
AND LRC.EFFECTIVE_START_DATE BETWEEN LER_RLTD_PER_CS_CHG.EFFECTIVE_START_DATE(+)
AND LER_RLTD_PER_CS_CHG.EFFECTIVE_END_DATE(+)
AND LRC.EFFECTIVE_START_DATE BETWEEN RLTD_PER_CHG_CS_LER_F.EFFECTIVE_START_DATE(+)
AND RLTD_PER_CHG_CS_LER_F.EFFECTIVE_END_DATE(+)
AND LRC.EFFECTIVE_START_DATE BETWEEN LER.EFFECTIVE_START_DATE(+)
AND LER.EFFECTIVE_END_DATE(+)