DBA Data[Home] [Help]

APPS.AHL_OSP_PO_PVT dependencies on OE_ORDER_LINES_ALL

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

359: -- Added by jaramana on June 24, 2005 to get the updated Return to Org
360: -- Updated by jaramana on March 20, 2006 to get the Org Location for fixing Bug 5104282
361: CURSOR get_return_to_org_csr(p_osp_line_id IN NUMBER) IS
362: SELECT oola.ship_from_org_id, HAOU.LOCATION_ID
363: FROM oe_order_lines_all oola, ahl_osp_order_lines aool, HR_ALL_ORGANIZATION_UNITS HAOU
364: WHERE oola.line_id = aool.oe_return_line_id and
365: HAOU.ORGANIZATION_ID = oola.ship_from_org_id and
366: aool.osp_order_line_id = p_osp_line_id;
367: