How to extract "XML Delivery Status" of "Manage Transactions" Screen in an SQL query
I need to extract the information of the "XML Delivery Status" that is in "Manage Transactions" Screen in SQL for a customised report.
I have not found it in any Oracle documentation, although I have already found many other useful information.
I only found by myself that the possible values of this field are in the lookup called XML_DELIVERY_STATUS.
For example, for the transaction in screenshot, I get some information of the transaction header with :
select * from ra_customer_trx_all where trx_number ='23079714389'.
But this does not provide the "XML Delivery Status".
Can you tell me where this information is stored for a given transaction ?