Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Thursday, September 29, 2011

Returns the Query for the forms used by a user in the last number of days

SELECT DISTINCT
D.USER_NAME,
E.RESPONSIBILITY_NAME,
TO_CHAR(A.START_TIME,'DD-MON-YYYY HH24:MI:SS'),
TO_CHAR(A.END_TIME,'DD-MON-YYYY HH24:MI:SS'),
G.USER_FORM_NAME,
TO_CHAR(F.START_TIME,'DD-MON-YYYY HH24:MI:SS') FORM_START_TIME,
TO_CHAR(F.END_TIME,'DD-MON-YYYY HH24:MI:SS') FORM_END_TIME,
F.START_TIME FORM_START_TIME_ORDER
FROM
FND_LOGIN_RESPONSIBILITIES A,
FND_RESPONSIBILITY B,
FND_LOGINS C,
FND_USER D,
FND_RESPONSIBILITY_TL E,
FND_LOGIN_RESP_FORMS F,
FND_FORM_TL G
WHERE
1 =1
AND A.RESPONSIBILITY_ID = B.RESPONSIBILITY_ID
AND A.RESPONSIBILITY_ID = E.RESPONSIBILITY_ID
AND B.RESPONSIBILITY_ID = E.RESPONSIBILITY_ID
AND A.LOGIN_RESP_ID = F.LOGIN_RESP_ID
AND C.LOGIN_ID = A.LOGIN_ID
AND A.LOGIN_ID = F.LOGIN_ID
AND C.LOGIN_ID = F.LOGIN_ID
AND C.USER_ID = D.USER_ID
AND G.FORM_ID = F.FORM_ID
AND E.LANGUAGE = 'US'
AND G.LANGUAGE = 'US'
AND B.APPLICATION_ID = G.APPLICATION_ID
AND E.RESPONSIBILITY_NAME LIKE '%'
AND D.USER_NAME LIKE 'USERNAME_TO_BE_CHECKED'
AND A.START_TIME > SYSDATE - 90
ORDER BY
FORM_START_TIME_ORDER DESC /

No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect