Monday, February 22, 2016

How to list All User Created Discoverer Worksheets Using SQL statements

Below query can display, all discoverer documents created by any user with dates.

SELECT b.user_name Doc_Owner
             , a.doc_name
             , a.doc_developer_key
             , a.DOC_CREATED_DATE
             , a.doc_updated_date
FROM <schema name>.EUL5_DOCUMENTS a
           , fnd_user b
Where a.DOC_CREATED_BY <> 'ORACLE_APPS'
AND '#'||TO_CHAR(b.user_id) = a.DOC_CREATED_BY

No comments: