select product_code APPLICATION, a.method_code METHOD, a.category_code CATEGORY, d.name SET_OF_BOOKS, b.name 
from apps.fnd_doc_sequence_assignments a, apps.fnd_document_sequences b, 
     apps.fnd_application c, apps.gl_sets_of_books d
where a.doc_sequence_id = b.doc_sequence_id
and a.application_id = c.application_id
and a.set_of_books_id = d.set_of_books_id
and d.name like 'SOB Name'