to find the SO details :select * from oe_order_headers_all where order_number = '7002955' and org_id =5283; select * from oe_order_lines_all where header_id =2647372 and ordered_item like 'L57*4LT' -2776751';