Hi Members, I need your help in extracting following information from EBS.

1. Query to extract Open AR Invoices In interface line level and distribution level
   
   Information required in line level :
   1) Payment terms, 2) transaction_date 3) trx_number 4) customer account number 5) customer site number 6)transaction line description 7)currency code 8)conversion rate,
   9)transaction line amount, 10)transaction line quantity 11)unit selling price 12)Line number
   
   Distribution level :
   1) Account class (Rec or Rev), 2)transaction line amount, 3)transaction number 4)line number
   
   all these information required as of july fiscal period (tranasctions done upto 28 july 2024)
   
   Please help me in extracting this information, Thanks