APPS.AHL_OSP_PO_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 2834: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);

2830: WHERE osp.status_code <> 'CLOSED' AND
2831: osp.oe_header_id IS NOT NULL AND
2832: -- Added by jaramana on April 7, 2008 for bug 6609988
2833: osp.operating_unit_id = MO_GLOBAL.get_current_org_id() AND
2834: NOT EXISTS (SELECT 1 FROM oe_order_headers_all where header_id = osp.oe_header_id);
2835:
2836: CURSOR get_osp_line_dtls_csr(c_osp_order_id IN NUMBER) IS
2837: SELECT ospl.osp_order_line_id,
2838: ospl.object_version_number,