add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, September 29

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: