AR INVOICE AND GL JOURNAL QUERY IN ORACLE

Hi,

How to query to extract a report which AR invoice (invoice amount per line, invoice description per line and invoice transaction number) link with GL Journal (document sequence number)?

As per below SQL, the result i get is

AR INV amout per line show the total amount according to the account code and

AR INV description per line only show one INV's description

with one journal sequence number because user using create accounting to post the invoice, therefore all the invoice will be included in one journal sequence number.

Below are the SQL:

select

 H.period_name as "Period_Name"