Display user details in oracle apps

-

 SELECT * FROM FND_USER WHERE USER_NAME='126545'

Comments

Post a Comment

Popular posts from this blog

Oracle Lock table

-
 SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name   FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID select * from V$Locked_Object select    c.owner,    c.object_name,    c.object_type,    b.sid,    b.serial#,    b.status,    b.osuser,    b.machine from    v$locked_object a ,    v$session b,    dba_objects c where    b.sid = a.session_id and    a.object_id = c.object_id;
Read more

Delete formula line

-
 select * FROM FM_MATL_DTL WHERE line_no=3 and RELEASE_TYPE='1'  and trunc(LAST_UPDATE_DATE)=trunc(sysdate) SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='940589') AND RELEASE_TYPE='1' delete from FM_MATL_DTL WHERE FORMULALINE_ID='784760' and FORMULA_ID='65818' AND RELEASE_TYPE='1';
Read more