Oracle Apps script for Receivable Invoice details

SELECT 

-----------------------------------

---Receivable Invoice details Scripts

-----------------------------------    

     ac.customer_name Customer_Name ,

     rtl.trx_number Trx_No, rtl.trx_date Trx_Dt,

     rgd.gl_date GL_Dt , rct.line_number LINE_NO,

     rct.DESCRIPTION,

     rct.quantity_invoiced LINE_QTY,

     rct.unit_selling_price UNIT_SP,

     (rct.revenue_amount) Line_Amt,

     (rct.extended_amount) Dist_Amt,

     (SELECT concatenated_segments FROM apps.gl_code_combinations_kfv

       WHERE code_combination_id = rgd.code_combination_id) Acccount

FROM apps.ra_customer_trx_all rtl,

     apps.ar_customers ac,

     apps.ra_customer_trx_lines_all rct,

     apps.ra_cust_trx_line_gl_dist_all rgd

WHERE 1 = 1

 AND ac.customer_id = rtl.bill_to_customer_id

 AND rct.customer_trx_id = rtl.customer_trx_id

 AND rct.customer_trx_line_id = rgd.customer_trx_line_id

 AND rtl.customer_trx_id = rgd.customer_trx_id

-- and  ac.customer_name like 'Ministry of Defence'

 and rtl.trx_date between '01-jan-2016'   and '31-jan-2016'