fetch error with line details query for any error occured during the Import Sales Order using FBDI

Hi all,

Currently, we are using the query below to fetch sales order FBDI import errors. However, we also need to retrieve the specific line data that is causing the error.

SELECT
doo.source_transaction_id,
doo.source_transaction_system,
decode(mb.message_type, 'ERROR', 'E', 'S') status,
mt.message_text error_message
FROM
doo_message_requests req,
doo_messages_b mb,
doo_messages_tl mt,
doo_order_headers_all_int doo
WHERE
mb.msg_request_id = req.msg_request_id
AND mb.message_id = mt.message_id
AND mt.language = 'US'
AND req.active_flag = 'Y'
AND doo.load_request_id = :p_load_request_id