VIEW: APPS.BEN_OIPLIP_D

Source

View Text - Preformatted

SELECT opp.ROWID ROW_ID, opp.OIPLIP_ID ,opp.EFFECTIVE_START_DATE ,opp.EFFECTIVE_END_DATE ,opp.LAST_UPDATE_DATE ,fuser.user_name ,opp.LEGISLATION_CODE ,opp.LEGISLATION_SUBGROUP from BEN_OIPLIP_F opp, fnd_user_view fuser WHERE fuser.user_id (+)= opp.last_updated_by

View Text - HTML Formatted

SELECT OPP.ROWID ROW_ID
, OPP.OIPLIP_ID
, OPP.EFFECTIVE_START_DATE
, OPP.EFFECTIVE_END_DATE
, OPP.LAST_UPDATE_DATE
, FUSER.USER_NAME
, OPP.LEGISLATION_CODE
, OPP.LEGISLATION_SUBGROUP
FROM BEN_OIPLIP_F OPP
, FND_USER_VIEW FUSER
WHERE FUSER.USER_ID (+)= OPP.LAST_UPDATED_BY