DBA Data[Home] [Help]

VIEW: APPS.BEN_ORG_UNIT_RT_D

Source

View Text - Preformatted

SELECT OUR.ORG_UNIT_RT_ID , OUR.EFFECTIVE_START_DATE , OUR.EFFECTIVE_END_DATE , OUR.VRBL_RT_PRFL_ID , OUR.ORGANIZATION_ID , OUR.EXCLD_FLAG , OUR.ORDR_NUM , OUR.LAST_UPDATE_DATE , fuser.user_name FROM BEN_ORG_UNIT_RT_F OUR, fnd_user fuser WHERE fuser.user_id(+) = our.last_updated_by
View Text - HTML Formatted

SELECT OUR.ORG_UNIT_RT_ID
, OUR.EFFECTIVE_START_DATE
, OUR.EFFECTIVE_END_DATE
, OUR.VRBL_RT_PRFL_ID
, OUR.ORGANIZATION_ID
, OUR.EXCLD_FLAG
, OUR.ORDR_NUM
, OUR.LAST_UPDATE_DATE
, FUSER.USER_NAME
FROM BEN_ORG_UNIT_RT_F OUR
, FND_USER FUSER
WHERE FUSER.USER_ID(+) = OUR.LAST_UPDATED_BY