80: rct.sold_to_customer_id cust_account_id,
81: unit_selling_price last_price,
82: rct.invoice_currency_code
83: FROM
84: ra_customer_trx_lines_all rctl,
85: ra_customer_trx_all rct,
86: ra_cust_trx_types_all rctt
87: WHERE
88: line_type = 'LINE' AND
99: rctl.customer_trx_line_id = (
100: SELECT
101: MAX(rctl1.customer_trx_line_id)
102: FROM
103: ra_customer_trx_lines_all rctl1,
104: ra_customer_trx_all rct1,
105: ra_cust_trx_types_all rctt1
106: WHERE
107: line_type = 'LINE' AND