1- To check if POCISO transferred information to Order Entry,  run the following query:

SELECT  transferred_to_oe_flag
FROM po_requisition_headers_all
WHERE segment1= &requisition_number;

If the Value is Y, the  requisition was  processed  by POCISO and data was transferred to OE.

2- Next run the following  queries to determine if the Sales Order is still in the OE Interface tables.
SELECT orig_sys_document_ref
FROM oe_headers_iface_all
WHERE order_source_id = 10
AND orig_sys_document_ref IN( SELECT requisition_header_id
FROM po_requisition_headers_all
WHERE segment1= &requisition_number);

SELECT orig_sys_document_ref
FROM oe_lines_iface_all
WHERE order_source_id = 10
AND orig_sys_document_ref IN( SELECT requisition_header_id
FROM po_requisition_headers_all
WHERE segment1= &requisition_number);

3- To check whether the Sales Order was   imported already, the following query can be used:
SELECT ‘Exists in OM main’
FROM oe_order_headers_all
WHERE order_source_id =10
and source_document_id in ( SELECT requisition_header_id
FROM po_requisition_headers_all
WHERE segment1= &requisition_number);