Query to get the Order and transaction details

select distinct

OOHA.ORDER_NUMBER

,rcta.trx_number

,rcta.trx_date

,oola.line_number

,oola.ordered_quantity

from

oe_order_headers_all ooha,

oe_order_lines_all oola,

ra_customer_trx_all rcta,

RA_CUSTOMER_TRX_LINES_ALL RCTLA

where 1=1

and ooha.header_id=oola.header_id

AND rcta.customer_trx_id = rctla.customer_trx_id

and RCTLA.INTERFACE_LINE_ATTRIBUTE1  = TO_CHAR(OOHA.ORDER_NUMBER)

AND RCTLA.INTERFACE_LINE_ATTRIBUTE6 = TO_CHAR(OOLA.LINE_ID)

AND OOHA.ORDER_NUMBER='343343' ;