APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on MTL_SALES_ORDERS

Line 229: from oe_order_headers_all oe, mtl_sales_orders mtl

225: --
226:
227: CURSOR get_sales_order_id(p_header_id IN number) IS
228: select sales_order_id
229: from oe_order_headers_all oe, mtl_sales_orders mtl
230: where oe.header_id = p_header_id
231: and to_char(mtl.segment1) = to_char(oe.order_number);
232:
233:

Line 872: -- need to get sales_order_id from mtl_sales_orders for this order to populate field txn_source_id -- 5601081

868: GMI_RESERVATION_UTIL.PrintLn('grade_code : '|| move_order_line_rec.qc_grade);
869: GMI_RESERVATION_UTIL.PrintLn('secondary_quantity_delivered : '|| move_order_line_rec.secondary_quantity_delivered);
870: GMI_RESERVATION_UTIL.PrintLn('secondary_quantity_detailed : '|| move_order_line_rec.secondary_quantity_detailed);
871:
872: -- need to get sales_order_id from mtl_sales_orders for this order to populate field txn_source_id -- 5601081
873:
874: OPEN get_sales_order_id (open_order_line_rec.header_id);
875: FETCH get_sales_order_id INTO l_sales_order_id;
876: CLOSE get_sales_order_id;