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
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:
Post a Comment