APPS.AHL_OSP_PO_REQ_PVT dependencies on OE_ORDER_LINES_ALL

Line 268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU

264: ORDER BY OL.OSP_LINE_NUMBER;
265:
266: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
267: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
268: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
269: WHERE oola.line_id = aool.oe_return_line_id and
270: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
271: aool.osp_order_line_id = p_osp_line_id;
272: