List user access log on discoverer documents and sheets
SELECT b.user_name Doc_Owner
,a.doc_name
,a.doc_developer_key
,c.QS_DOC_NAME
,c.QS_DOC_DETAILS
,d.user_name accessed_by
,QS_CREATED_DATE
FROM <schema name>.EUL5_DOCUMENTS a
,fnd_user b ,
,<schema name>.EUL5_QPP_STATS c ,
,fnd_user d
WHERE a.DOC_CREATED_BY <> 'ORACLE_APPS'
AND '#'||TO_CHAR(b.user_id) = a.DOC_CREATED_BY
AND a.doc_name = c.QS_DOC_NAME
AND '#'||TO_CHAR(d.user_id) = c.QS_CREATED_BY
ORDER BY QS_CREATED_DATE DESC
No comments:
Post a Comment