Sunday, March 20, 2016

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' ;

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect