eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SALESORDER dependencies on MTL_SALES_ORDERS

Line 130: FROM MTL_SALES_ORDERS

126: -- check if sales order already exists
127: BEGIN
128: SELECT sales_order_id
129: INTO l_so_id
130: FROM MTL_SALES_ORDERS
131: WHERE segment1 = l_segment1
132: AND segment2 = l_segment2
133: AND segment3 = l_segment3 ;
134:

Line 141: SELECT mtl_sales_orders_s.nextval into l_so_id from dual ;

137: EXCEPTION
138: WHEN NO_DATA_FOUND THEN
139: -- sales order does not exist, create a new one
140:
141: SELECT mtl_sales_orders_s.nextval into l_so_id from dual ;
142:
143: INSERT into MTL_SALES_ORDERS (sales_order_id, segment1, segment2, segment3, last_updated_by,
144: last_update_date, last_update_login, creation_date, created_by,
145: summary_flag, enabled_flag) values

Line 143: INSERT into MTL_SALES_ORDERS (sales_order_id, segment1, segment2, segment3, last_updated_by,

139: -- sales order does not exist, create a new one
140:
141: SELECT mtl_sales_orders_s.nextval into l_so_id from dual ;
142:
143: INSERT into MTL_SALES_ORDERS (sales_order_id, segment1, segment2, segment3, last_updated_by,
144: last_update_date, last_update_login, creation_date, created_by,
145: summary_flag, enabled_flag) values
146: (l_so_id, l_segment1, l_segment2, l_segment3, fnd_global.user_id, sysdate,
147: fnd_global.login_id, sysdate, fnd_global.user_id, 'N', 'Y') ;

Line 193: | in mtl_sales_orders may be created by Order Management. |

189: /*-------------------------------------------------------------------------------------+
190: | get_oe_header_for_salesorder returns the order management order header id given a |
191: | sales order id. If the sales order id does not have a matching order managemnet |
192: | order header id, then a value (-1) is returned. This is possible since not all rows |
193: | in mtl_sales_orders may be created by Order Management. |
194: +-------------------------------------------------------------------------------------*/
195:
196: Procedure get_oeheader_for_salesorder(
197: p_salesorder_id IN NUMBER,

Line 230: FROM mtl_sales_orders

226:
227: -- now select segment 2 for the given sales order id
228: SELECT segment1,segment2,segment3
229: INTO l_order_number, l_order_type, l_order_source
230: FROM mtl_sales_orders
231: WHERE sales_order_id = p_salesorder_id ;
232:
233:
234: x_oe_header_id := get_header_id(to_number(l_order_number),

Line 300: FROM mtl_sales_orders

296: l_order_source);
297:
298: SELECT sales_order_id
299: INTO l_salesorder_id
300: FROM mtl_sales_orders
301: WHERE segment1 = to_char(l_order_number)
302: AND segment2 = l_order_type
303: AND segment3 = l_order_source ;
304:

Line 355: UPDATE mtl_sales_orders

351: (p_original_order_type IS NULL) OR
352: (p_original_source_code IS NULL) ) then
353: return 0 ;
354: ELSE
355: UPDATE mtl_sales_orders
356: SET segment1 = NVL(p_new_order_number,segment1),
357: segment2 = NVL(p_new_order_type, segment2),
358: segment3 = NVL(p_new_order_source, segment3)
359: WHERE segment1 = p_original_order_number

Line 366: UPDATE mtl_sales_orders

362: end if;
363:
364: ELSE
365: --bug4237769
366: UPDATE mtl_sales_orders
367: SET segment1 = NVL(p_new_order_number,segment1),
368: segment2 = NVL(p_new_order_type, segment2),
369: segment3 = NVL(p_new_order_source, segment3)
370: WHERE (p_original_order_number IS NULL OR

Line 424: Procedure create_mtl_sales_orders_bulk (

420: RETURN -1;
421:
422: END Get_Header_Id;
423:
424: Procedure create_mtl_sales_orders_bulk (
425: p_api_version_number IN NUMBER,
426: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
427: p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE,
428: x_message_data OUT NOCOPY VARCHAR2,

Line 434: c_api_name CONSTANT VARCHAR2(50):= 'CREATE_MTL_SALES_ORDERS_BULK';

430: x_return_status OUT NOCOPY VARCHAR2) IS
431:
432: -- Constants
433: c_api_version_number CONSTANT NUMBER := 1.0 ;
434: c_api_name CONSTANT VARCHAR2(50):= 'CREATE_MTL_SALES_ORDERS_BULK';
435:
436: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
437:
438: BEGIN

Line 458: INSERT INTO MTL_SALES_ORDERS

454: x_return_status := fnd_api.g_ret_sts_success;
455:
456:
457: FORALL i IN p_header_rec.order_number.FIRST..p_header_rec.order_number.LAST
458: INSERT INTO MTL_SALES_ORDERS
459: (sales_order_id,
460: segment1,
461: segment2,
462: segment3,

Line 471: mtl_sales_orders_s.nextval,

467: created_by,
468: summary_flag,
469: enabled_flag)
470: Values(
471: mtl_sales_orders_s.nextval,
472: p_header_rec.order_number(i),
473: p_header_rec.order_type_name(i),
474: l_source_code,
475: fnd_global.user_id,

Line 508: END create_mtl_sales_orders_bulk;

504: , p_data => x_message_data
505: , p_encoded => 'F');
506: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
507:
508: END create_mtl_sales_orders_bulk;
509:
510:
511: PROCEDURE delete_mtl_sales_orders_bulk(
512: p_api_version_number IN NUMBER,

Line 511: PROCEDURE delete_mtl_sales_orders_bulk(

507:
508: END create_mtl_sales_orders_bulk;
509:
510:
511: PROCEDURE delete_mtl_sales_orders_bulk(
512: p_api_version_number IN NUMBER,
513: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
514: p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE,
515: x_message_data OUT NOCOPY VARCHAR2,

Line 521: c_api_name CONSTANT VARCHAR2(50):= 'DELETE_MTL_SALES_ORDERS_BULK';

517: x_return_status OUT NOCOPY VARCHAR2) IS
518:
519: -- Constants
520: c_api_version_number CONSTANT NUMBER := 1.0 ;
521: c_api_name CONSTANT VARCHAR2(50):= 'DELETE_MTL_SALES_ORDERS_BULK';
522: BEGIN
523: -- check for api call compatibility
524: if not fnd_api.compatible_api_call(
525: c_api_version_number,

Line 545: DELETE from mtl_sales_orders

541: /*Bug3575085:Changed the sequence of the sub-query from b.name,a.order_number
542: to a.order_number,b.name*/
543: --Bug4237769 Correcting the type mismatch.
544: FORALL i IN 1..P_ERROR_REC.header_id.COUNT
545: DELETE from mtl_sales_orders
546: WHERE (segment1, segment2) IN
547: (select to_char(a.order_number),b.name
548: FROM oe_order_headers a,
549: oe_order_types_v b

Line 564: END delete_mtl_sales_orders_bulk;

560:
561: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: END delete_mtl_sales_orders_bulk;
565:
566: end inv_salesorder ;