VIEW: APPS.BEN_VRBL_MTCHG_RT_D

Source

View Text - Preformatted

SELECT VMR.ROWID ROW_ID , VMR.VRBL_MTCHG_RT_ID , VMR.EFFECTIVE_END_DATE , VMR.EFFECTIVE_START_DATE , NO_MX_PCT_OF_PY_NUM.MEANING , VMR.TO_PCT_VAL , NO_MX_AMT_OF_PY_NUM.MEANING , VMR.MX_PCT_OF_PY_NUM , NO_MX_MTCH_AMT.MEANING , VMR.ORDR_NUM , VMR.PCT_VAL , VMR.MX_MTCH_AMT , VMR.MX_AMT_OF_PY_NUM , VMR.MN_MTCH_AMT , MTCHG_RT_CALC.FORMULA_NAME , CNTNU_MTCH_AFTR_MAX_RL.MEANING , VMR.FROM_PCT_VAL , VRBL_RT_PRFL.NAME , VMR.LAST_UPDATE_DATE , FUSER.USER_NAME FROM BEN_VRBL_MTCHG_RT_F VMR, FND_USER FUSER ,BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL ,HR_LOOKUPS NO_MX_PCT_OF_PY_NUM ,HR_LOOKUPS NO_MX_AMT_OF_PY_NUM ,HR_LOOKUPS NO_MX_MTCH_AMT ,FF_FORMULAS_F MTCHG_RT_CALC ,HR_LOOKUPS CNTNU_MTCH_AFTR_MAX_RL WHERE FUSER.USER_ID (+)= VMR.LAST_UPDATED_BY AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= VMR.VRBL_RT_PRFL_ID AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_PCT_OF_PY_NUM_FLAG AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_AMT_OF_PY_NUM_FLAG AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO' AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= VMR.NO_MX_MTCH_AMT_FLAG AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO' AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_CODE (+)= VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_TYPE (+)= 'YES_NO' AND MTCHG_RT_CALC.FORMULA_ID (+)= VMR.MTCHG_RT_CALC_RL

View Text - HTML Formatted

SELECT VMR.ROWID ROW_ID
, VMR.VRBL_MTCHG_RT_ID
, VMR.EFFECTIVE_END_DATE
, VMR.EFFECTIVE_START_DATE
, NO_MX_PCT_OF_PY_NUM.MEANING
, VMR.TO_PCT_VAL
, NO_MX_AMT_OF_PY_NUM.MEANING
, VMR.MX_PCT_OF_PY_NUM
, NO_MX_MTCH_AMT.MEANING
, VMR.ORDR_NUM
, VMR.PCT_VAL
, VMR.MX_MTCH_AMT
, VMR.MX_AMT_OF_PY_NUM
, VMR.MN_MTCH_AMT
, MTCHG_RT_CALC.FORMULA_NAME
, CNTNU_MTCH_AFTR_MAX_RL.MEANING
, VMR.FROM_PCT_VAL
, VRBL_RT_PRFL.NAME
, VMR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_VRBL_MTCHG_RT_F VMR
, FND_USER FUSER
, BEN_VRBL_RT_PRFL_F VRBL_RT_PRFL
, HR_LOOKUPS NO_MX_PCT_OF_PY_NUM
, HR_LOOKUPS NO_MX_AMT_OF_PY_NUM
, HR_LOOKUPS NO_MX_MTCH_AMT
, FF_FORMULAS_F MTCHG_RT_CALC
, HR_LOOKUPS CNTNU_MTCH_AFTR_MAX_RL
WHERE FUSER.USER_ID (+)= VMR.LAST_UPDATED_BY
AND VRBL_RT_PRFL.VRBL_RT_PRFL_ID (+)= VMR.VRBL_RT_PRFL_ID
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_PCT_OF_PY_NUM_FLAG
AND NO_MX_PCT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_CODE (+)= VMR.NO_MX_AMT_OF_PY_NUM_FLAG
AND NO_MX_AMT_OF_PY_NUM.LOOKUP_TYPE (+)= 'YES_NO'
AND NO_MX_MTCH_AMT.LOOKUP_CODE (+)= VMR.NO_MX_MTCH_AMT_FLAG
AND NO_MX_MTCH_AMT.LOOKUP_TYPE (+)= 'YES_NO'
AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_CODE (+)= VMR.CNTNU_MTCH_AFTR_MAX_RL_FLAG
AND CNTNU_MTCH_AFTR_MAX_RL.LOOKUP_TYPE (+)= 'YES_NO'
AND MTCHG_RT_CALC.FORMULA_ID (+)= VMR.MTCHG_RT_CALC_RL