Posted: Fri Jun 08, 2007 2:58 am
<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
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