DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 180: FROM oe_order_headers_all oh

176:
177: CURSOR Get_order_info(p_so_line_id IN NUMBER) IS
178: SELECT ol.line_number, mtl.segment1,
179: oh.order_number
180: FROM oe_order_headers_all oh
181: ,oe_order_lines_all ol
182: ,oe_transaction_types_all ot
183: ,mtl_system_items mtl
184: WHERE ol.line_id = p_so_line_id