DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_SALES_ORDERS

Line 258: FROM mtl_sales_orders

254: l_order_source);
255:
256: SELECT *
257: INTO mso_rec
258: FROM mtl_sales_orders
259: WHERE segment1 = l_order_number
260: AND segment2 = l_order_type
261: AND segment3 = l_order_source ;
262: g_oe_header_id := p_oe_header_id;

Line 299: FROM mtl_sales_orders

295:
296: -- now select segment 2 for the given sales order id
297: SELECT *
298: INTO mso_rec
299: FROM mtl_sales_orders
300: WHERE sales_order_id = p_salesorder_id ;
301:
302:
303: /*g_oe_header_id := inv_sales_order.get_header_id(to_number(mso_rec.segment1),