VIEW: APPS.BEN_WK_LOC_RT_D

Source

View Text - Preformatted

SELECT WLR.WK_LOC_RT_ID , WLR.EFFECTIVE_START_DATE , WLR.EFFECTIVE_END_DATE , WLR.VRBL_RT_PRFL_ID , WLR.LOCATION_ID , WLR.EXCLD_FLAG , WLR.ORDR_NUM , WLR.LAST_UPDATE_DATE , fuser.user_name FROM BEN_WK_LOC_RT_F WLR, fnd_user fuser WHERE fuser.user_id(+) = wlr.last_updated_by

View Text - HTML Formatted

SELECT WLR.WK_LOC_RT_ID
, WLR.EFFECTIVE_START_DATE
, WLR.EFFECTIVE_END_DATE
, WLR.VRBL_RT_PRFL_ID
, WLR.LOCATION_ID
, WLR.EXCLD_FLAG
, WLR.ORDR_NUM
, WLR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_WK_LOC_RT_F WLR
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = WLR.LAST_UPDATED_BY