FND Document Categories

select
fav.application_name application,
fdsc.code,
fdsc.name,
fdsc.description,
fdsc.table_name,
xxen_util.user_name(fdsc.created_by) created_by,
xxen_util.client_time(fdsc.creation_date) creation_date,
xxen_util.user_name(fdsc.last_updated_by) last_updated_by,
xxen_util.client_time(fdsc.last_update_date) last_update_date
from
fnd_application_vl fav,
fnd_doc_sequence_categories fdsc
where
1=1 and
fav.application_id=fdsc.application_id
order by
fdsc.application_id,
fdsc.code

select fav.application_name application, fdsc.code, fdsc.name, fdsc.description, fdsc.table_name, xxen_util.user_name(fdsc.created_by) created_by, xxen_util.client_time(fdsc.creation_date) creation_date, xxen_util.user_name(fdsc.last_updated_by) last_updated_by, xxen_util.client_time(fdsc.last_update_date) last_update_date from fnd_application_vl fav, fnd_doc_sequence_categories fdsc where 1=1 and fav.application_id=fdsc.application_id order by fdsc.application_id, fdsc.code