Oracle11i - Query required for creating a report containing GL JE entries information

Hi Team,

We would like to get the detailed GL journal entry transactions for few accounts. We are maintaining the accounts separately in an excel sheet.

If possible, we would like to be able to distinguish between automated JEs and
manual JEs. The following are the fields we are looking for:

1. Organizational Unit
2. Location
3. Department/Cost Center (or Branch)
4. Account Number
5. Sub-Account Number
6. Intercompany Entity
7. Line of Business
8. Amount
9. JE source (manual or automated)
10. Person who created the transaction or subsystem it came from
11. JE entry date

For fields 1-7, we are able to get the information from the gl_code_combinations segment values. Can you please help me with the query for the remaining fields.