DBA Data[Home] [Help]

APPS.INV_CACHE dependencies on MTL_SALES_ORDERS

Line 259: FROM mtl_sales_orders

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

Line 300: FROM mtl_sales_orders

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