[Home] [Help]
View: PAY_JP_DEF_USER_V
Product: | PAY - Payroll |
Description: | This view is used for Japanese localization only. |
Implementation/DBA Data: |
APPS.PAY_JP_DEF_USER_V
|
View Text
SELECT USR.USER_ID
, NVL(PER.FULL_NAME
, USR.USER_NAME)
, USR.EMAIL_ADDRESS
, USR.LAST_UPDATE_DATE
, USR.LAST_UPDATED_BY
, USR.CREATION_DATE
, USR.CREATED_BY
, USR.LAST_UPDATE_LOGIN FROM PER_ALL_PEOPLE_F PER
, FND_USER USR WHERE PER.PERSON_ID(+) = USR.EMPLOYEE_ID AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE(+)
AND PER.EFFECTIVE_END_DATE(+)
Columns
Name |
USER_ID |
USER_NAME |
EMAIL_ADDRESS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |