FND Design Data [Home] [Help]

View: BEN_OIPLIP_D

Product: BEN - Advanced Benefits
Description:
Implementation/DBA Data: ViewAPPS.BEN_OIPLIP_D
View Text

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

Columns

Name
ROW_ID
OIPLIP_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LEGISLATION_CODE
LEGISLATION_SUBGROUP