Hi.

Here are a couple of scripts -

select * 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 = '&req_number');

select * FROM OE_ORDER_HEADERS_ALL

WHERE order_source_id = 10

AND to_char(orig_sys_document_ref) IN( SELECT REQUISITION_HEADER_ID

                               FROM PO_REQUISITION_HEADERS_ALL

                               where segment1 = '&req_number');

select * FROM OE_ORDER_LINES_ALL

WHERE order_source_id = 10

AND to_char(orig_sys_document_ref) IN( SELECT REQUISITION_HEADER_ID

                               FROM PO_REQUISITION_HEADERS_ALL

                                where segment1 = '&req_number');

select * 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 = '&req_number');

In Order Management - Orders - Import Orders - Corrections - the correction form can usually be used to query back the requisition and then delete it.

The key is to let the user's know to delete all lines first - then the header.  If you delete the header first it leaves the lines stranded.

The only way to remove them is through sql plus.