Query - Check if ITS has successfully interfaced the delivery detail to OM and INV

SELECT 

delivery_detail_id, 

released_status, 

oe_interfaced_flag, 

inv_interfaced_flag
FROM wsh_delivery_details
WHERE source_code = 'OE' 

AND source_line_id = :line_id;

Posted in: Oracle Apps Query,Oracle Notebook,Order Management