[Home] [Help]
SELECT REG.ROWID ROW_ID , REG.REGN_ID , REG.EFFECTIVE_START_DATE , REG.EFFECTIVE_END_DATE , REG.NAME , REG.STTRY_CITN_NAME , REG.LAST_UPDATE_DATE , FUSER.LAST_UPDATED_BY FROM BEN_REGN_F REG, FND_USER FUSER WHERE FUSER.USER_ID (+)= REG .LAST_UPDATED_BY
SELECT REG.ROWID ROW_ID
, REG.REGN_ID
, REG.EFFECTIVE_START_DATE
, REG.EFFECTIVE_END_DATE
, REG.NAME
, REG.STTRY_CITN_NAME
, REG.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_REGN_F REG
, FND_USER FUSER
WHERE FUSER.USER_ID (+)= REG .LAST_UPDATED_BY
|
|
|
|