eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BEN_ACTY_RT_PYMT_SCHED_D

Source

View Text - Preformatted


SELECT apf.rowid, apf.acty_rt_pymt_sched_id, apf.effective_start_date, apf.effective_end_date, abr.NAME, crl1.formula_name, hr1.meaning, apf.last_update_date, fuser.user_name FROM ben_acty_rt_pymt_sched_f apf, ben_acty_base_rt_f abr, hr_lookups hr1, ff_formulas_f crl1, fnd_user_view fuser WHERE hr1.lookup_type(+) = 'BEN_PYMT_SCHED' AND hr1.lookup_code(+) = apf.pymt_sched_cd AND hr1.enabled_flag(+) = 'Y' /*added to include the abr.name in the view End Bug: 5107301*/ AND abr.acty_base_rt_id(+) = apf.acty_base_rt_id AND apf.effective_start_date BETWEEN abr.effective_start_date(+) AND abr.effective_end_date(+) /*End Bug: 5107301*/ AND apf.effective_start_date BETWEEN NVL (hr1.start_date_active, apf.effective_start_date ) AND NVL (hr1.end_date_active, apf.effective_start_date ) AND apf.effective_end_date BETWEEN NVL (hr1.start_date_active, apf.effective_end_date ) AND NVL (hr1.end_date_active, apf.effective_end_date ) AND crl1.formula_id(+) = apf.pymt_sched_rl /*commented for bug: 5107301 AND apf.effective_start_date BETWEEN crl1.effective_start_date AND crl1.effective_end_date AND apf.effective_end_date BETWEEN crl1.effective_start_date AND crl1.effective_end_date added outer joins for bug: 5107301*/ AND apf.effective_start_date BETWEEN crl1.effective_start_date(+) AND crl1.effective_end_date(+) AND apf.effective_end_date BETWEEN crl1.effective_start_date(+) AND crl1.effective_end_date(+) AND fuser.user_id(+) = apf.last_updated_by

View Text - HTML Formatted

SELECT APF.ROWID
, APF.ACTY_RT_PYMT_SCHED_ID
, APF.EFFECTIVE_START_DATE
, APF.EFFECTIVE_END_DATE
, ABR.NAME
, CRL1.FORMULA_NAME
, HR1.MEANING
, APF.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ACTY_RT_PYMT_SCHED_F APF
, BEN_ACTY_BASE_RT_F ABR
, HR_LOOKUPS HR1
, FF_FORMULAS_F CRL1
, FND_USER_VIEW FUSER
WHERE HR1.LOOKUP_TYPE(+) = 'BEN_PYMT_SCHED'
AND HR1.LOOKUP_CODE(+) = APF.PYMT_SCHED_CD
AND HR1.ENABLED_FLAG(+) = 'Y' /*ADDED TO INCLUDE THE ABR.NAME IN THE VIEW END BUG: 5107301*/
AND ABR.ACTY_BASE_RT_ID(+) = APF.ACTY_BASE_RT_ID
AND APF.EFFECTIVE_START_DATE BETWEEN ABR.EFFECTIVE_START_DATE(+)
AND ABR.EFFECTIVE_END_DATE(+) /*END BUG: 5107301*/
AND APF.EFFECTIVE_START_DATE BETWEEN NVL (HR1.START_DATE_ACTIVE
, APF.EFFECTIVE_START_DATE )
AND NVL (HR1.END_DATE_ACTIVE
, APF.EFFECTIVE_START_DATE )
AND APF.EFFECTIVE_END_DATE BETWEEN NVL (HR1.START_DATE_ACTIVE
, APF.EFFECTIVE_END_DATE )
AND NVL (HR1.END_DATE_ACTIVE
, APF.EFFECTIVE_END_DATE )
AND CRL1.FORMULA_ID(+) = APF.PYMT_SCHED_RL /*COMMENTED FOR BUG: 5107301
AND APF.EFFECTIVE_START_DATE BETWEEN CRL1.EFFECTIVE_START_DATE
AND CRL1.EFFECTIVE_END_DATE
AND APF.EFFECTIVE_END_DATE BETWEEN CRL1.EFFECTIVE_START_DATE
AND CRL1.EFFECTIVE_END_DATE ADDED OUTER JOINS FOR BUG: 5107301*/
AND APF.EFFECTIVE_START_DATE BETWEEN CRL1.EFFECTIVE_START_DATE(+)
AND CRL1.EFFECTIVE_END_DATE(+)
AND APF.EFFECTIVE_END_DATE BETWEEN CRL1.EFFECTIVE_START_DATE(+)
AND CRL1.EFFECTIVE_END_DATE(+)
AND FUSER.USER_ID(+) = APF.LAST_UPDATED_BY