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_MTCHG_RT_D

Source

View Text - Preformatted


SELECT MTR.ROWID ROW_ID , MTR.MTCHG_RT_ID , MTR.EFFECTIVE_START_DATE , MTR.EFFECTIVE_END_DATE , MTR.ORDR_NUM , MTR.FROM_PCT_VAL , MTR.TO_PCT_VAL , MTR.PCT_VAL , MTR.MX_AMT_OF_PY_NUM , MTR.MX_PCT_OF_PY_NUM , MTR.MX_MTCH_AMT , MTR.MN_MTCH_AMT , MTCHG_RT_CALC.FORMULA_NAME , NO_MX_MTCH_AMT.MEANING , NO_MX_PCT_OF_PY_NUM.MEANING , CNTNU_MTCH_AFTR_MX_RL.MEANING , NO_MX_AMT_OF_PY_NUM.MEANING , ACTY_BASE_RT.NAME , COMP_LVL_FCTR.NAME , MTR.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_MTCHG_RT_F MTR, FND_USER FUSER ,BEN_ACTY_BASE_RT_F ACTY_BASE_RT ,BEN_COMP_LVL_FCTR COMP_LVL_FCTR ,HR_LOOKUPS NO_MX_MTCH_AMT ,HR_LOOKUPS NO_MX_PCT_OF_PY_NUM ,HR_LOOKUPS NO_MX_AMT_OF_PY_NUM ,FF_FORMULAS_F MTCHG_RT_CALC ,HR_LOOKUPS CNTNU_MTCH_AFTR_MX_RL WHERE FUSER.USER_ID (+)= MTR .LAST_UPDATED_BY AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= MTR .ACTY_BASE_RT_ID and mtr.effective_start_date between acty_base_rt.effective_start_date and acty_base_rt.effective_end_date AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= MTR .COMP_LVL_FCTR_ID AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= MTR .NO_MX_MTCH_AMT_FLAG AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_PCT_OF_PY_NUM_FLAG AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO' AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_CODE (+)= MTR .CNTNU_MTCH_AFTR_MX_RL_FLAG AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_AMT_OF_PY_NUM_FLAG AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO' AND MTCHG_RT_CALC.FORMULA_ID (+)= MTR .MTCHG_RT_CALC_RL AND MTR .EFFECTIVE_START_DATE BETWEEN MTCHG_RT_CALC.EFFECTIVE_START_DATE (+) AND MTCHG_RT_CALC.EFFECTIVE_END_DATE (+)

View Text - HTML Formatted

SELECT MTR.ROWID ROW_ID
, MTR.MTCHG_RT_ID
, MTR.EFFECTIVE_START_DATE
, MTR.EFFECTIVE_END_DATE
, MTR.ORDR_NUM
, MTR.FROM_PCT_VAL
, MTR.TO_PCT_VAL
, MTR.PCT_VAL
, MTR.MX_AMT_OF_PY_NUM
, MTR.MX_PCT_OF_PY_NUM
, MTR.MX_MTCH_AMT
, MTR.MN_MTCH_AMT
, MTCHG_RT_CALC.FORMULA_NAME
, NO_MX_MTCH_AMT.MEANING
, NO_MX_PCT_OF_PY_NUM.MEANING
, CNTNU_MTCH_AFTR_MX_RL.MEANING
, NO_MX_AMT_OF_PY_NUM.MEANING
, ACTY_BASE_RT.NAME
, COMP_LVL_FCTR.NAME
, MTR.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_MTCHG_RT_F MTR
, FND_USER FUSER
, BEN_ACTY_BASE_RT_F ACTY_BASE_RT
, BEN_COMP_LVL_FCTR COMP_LVL_FCTR
, HR_LOOKUPS NO_MX_MTCH_AMT
, HR_LOOKUPS NO_MX_PCT_OF_PY_NUM
, HR_LOOKUPS NO_MX_AMT_OF_PY_NUM
, FF_FORMULAS_F MTCHG_RT_CALC
, HR_LOOKUPS CNTNU_MTCH_AFTR_MX_RL
WHERE FUSER.USER_ID (+)= MTR .LAST_UPDATED_BY
AND ACTY_BASE_RT.ACTY_BASE_RT_ID (+)= MTR .ACTY_BASE_RT_ID
AND MTR.EFFECTIVE_START_DATE BETWEEN ACTY_BASE_RT.EFFECTIVE_START_DATE
AND ACTY_BASE_RT.EFFECTIVE_END_DATE
AND COMP_LVL_FCTR.COMP_LVL_FCTR_ID (+)= MTR .COMP_LVL_FCTR_ID
AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= MTR .NO_MX_MTCH_AMT_FLAG
AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_PCT_OF_PY_NUM_FLAG
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_CODE (+)= MTR .CNTNU_MTCH_AFTR_MX_RL_FLAG
AND CNTNU_MTCH_AFTR_MX_RL.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= MTR .NO_MX_AMT_OF_PY_NUM_FLAG
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND MTCHG_RT_CALC.FORMULA_ID (+)= MTR .MTCHG_RT_CALC_RL
AND MTR .EFFECTIVE_START_DATE BETWEEN MTCHG_RT_CALC.EFFECTIVE_START_DATE (+)
AND MTCHG_RT_CALC.EFFECTIVE_END_DATE (+)