OeBS : Заводим/правим пользоателей в OeBS

select f.USER_ID ,
f.USER_NAME "Логин",
f.description "ФИО",
x.POSITION "Должность",
x.PHONE "Телефон",
x.DEPARTMENT "Отдел",
x.LAST_UPDATE_LOGIN "Последний вход(-1)",
x.LAST_UPDATED_BY "Обновил (-1)",
x.Last_Update_Date "Обновлено (sysdate)",
f.Created_By "Создал (-1)",
f.Creation_Date "Создано (sysdate)"
from XXT_BS_USER_ATTRS x, FND_USER f
where f.user_id = x.user_id
select * from FND_USER f where user_id=1394 for update
select * from XXT_BS_USER_ATTRS where user_id=1394 for update
insert into XXT_BS_USER_ATTRS (user_id, LAST_UPDATE_DATE,LAST_UPDATED_BY,created_by,creation_date) values (1394,sysdate,1394,1394,sysdate)