SELECT RZR.PSTL_ZIP_RNG_ID , RZR.EFFECTIVE_START_DATE , RZR.EFFECTIVE_END_DATE , RZR.FROM_VALUE , RZR.TO_VALUE , RZR.LAST_UPDATE_DATE , FUSER.USER_NAME FROM BEN_PSTL_ZIP_RNG_F RZR, FND_USER FUSER WHERE FUSER.USER_ID (+)=RZR.LAST_UPDATED_BY
SELECT RZR.PSTL_ZIP_RNG_ID
, RZR.EFFECTIVE_START_DATE
, RZR.EFFECTIVE_END_DATE
, RZR.FROM_VALUE
, RZR.TO_VALUE
, RZR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_PSTL_ZIP_RNG_F RZR
, FND_USER FUSER
WHERE FUSER.USER_ID (+)=RZR.LAST_UPDATED_BY
|
|
|