Useful queries for Oracle EBS

[ahmadbilal]

<b>How to get document sequence detail</b>
SELECT (SELECT gl_sets_of_books.NAME
FROM gl_sets_of_books
WHERE set_of_books_id =
fnd_doc_sequence_assignments.set_of_books_id)
gl_sets_of_books,
(SELECT application_name
FROM fnd_application_tl fat
WHERE fat.application_id =
fnd_doc_sequence_assignments.application_id)
application,
(SELECT NAME
FROM fnd_document_sequences
WHERE doc_sequence_id =
fnd_doc_sequence_assignments.doc_sequence_id)
doc_sequence_name,
start_date, end_date,
(SELECT fu.user_name
FROM fnd_user fu
WHERE fu.user_id =
fnd_doc_sequence_assignments.last_updated_by)
last_updated_by,
last_update_date,
(SELECT fu.user_name
FROM fnd_user fu
WHERE fu.user_id =
fnd_doc_sequence_assignments.created_by)
created_by,
creation_date, last_update_login, doc_sequence_assignment_id
FROM fnd_doc_sequence_assignments
ORDER BY 1, 2, 3

[ahmadbilal]

<b>How get Folder Details used In Application</b>
SELECT ff.folder_id, ff.OBJECT, ff.NAME, ff.window_width, ff.public_flag,
ff.autoquery_flag, ff.where_clause, ff.order_by,
(SELECT user_name
FROM fnd_user fu
WHERE fu.user_id = ff.created_by) created_by, ffc.display_mode,
ffc.item_name, ffc.SEQUENCE, ffc.item_width, ffc.item_prompt,
ffc.x_position, ffc.y_position
FROM applsys.fnd_folders ff, fnd_folder_columns ffc
WHERE ff.folder_id = ffc.folder_id
Order by ff.OBJECT, ff.NAME