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_PL_FRFS_VAL_D

Source

View Text - Preformatted


SELECT FRP.ROWID ROW_ID ,FRP.PL_FRFS_VAL_ID ,FRP.EFFECTIVE_START_DATE ,FRP.EFFECTIVE_END_DATE ,FRP.PL_ID ,FRP.start_date ,FRP.end_date ,FRP.ttl_cntr_val ,FRP.ttl_distr_val ,FRP.ttl_frfd_val ,pln.name ,FRP.LAST_UPDATE_DATE ,FRP.LAST_UPDATED_BY from ben_pl_frfs_val_f frp, FND_USER FUSER, ben_pl_f pln WHERE FUSER.USER_ID (+)= frp .LAST_UPDATED_BY AND frp.pl_id = pln.pl_id AND frp.EFFECTIVE_START_DATE BETWEEN pln.EFFECTIVE_START_DATE AND pln.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT FRP.ROWID ROW_ID
, FRP.PL_FRFS_VAL_ID
, FRP.EFFECTIVE_START_DATE
, FRP.EFFECTIVE_END_DATE
, FRP.PL_ID
, FRP.START_DATE
, FRP.END_DATE
, FRP.TTL_CNTR_VAL
, FRP.TTL_DISTR_VAL
, FRP.TTL_FRFD_VAL
, PLN.NAME
, FRP.LAST_UPDATE_DATE
, FRP.LAST_UPDATED_BY
FROM BEN_PL_FRFS_VAL_F FRP
, FND_USER FUSER
, BEN_PL_F PLN
WHERE FUSER.USER_ID (+)= FRP .LAST_UPDATED_BY
AND FRP.PL_ID = PLN.PL_ID
AND FRP.EFFECTIVE_START_DATE BETWEEN PLN.EFFECTIVE_START_DATE
AND PLN.EFFECTIVE_END_DATE