APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on MTL_SALES_ORDERS

Line 226: from oe_order_headers_all oe, mtl_sales_orders mtl

222:
223: -- 5601081
224: CURSOR get_sales_order_id(p_header_id IN number) IS
225: select sales_order_id
226: from oe_order_headers_all oe, mtl_sales_orders mtl
227: where oe.header_id = p_header_id and mtl.segment1 = oe.order_number;
228:
229:
230: BEGIN

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

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