DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 165: FROM oe_order_headers_all oh

161:
162: CURSOR Get_order_info(p_so_line_id IN NUMBER) IS
163: SELECT ol.line_number, mtl.segment1,
164: oh.order_number
165: FROM oe_order_headers_all oh
166: ,oe_order_lines_all ol
167: ,oe_transaction_types_all ot
168: ,mtl_system_items mtl
169: WHERE ol.line_id = p_so_line_id