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 287: FROM mtl_sales_orders

283: l_order_source);
284:
285: SELECT sales_order_id
286: INTO l_salesorder_id
287: FROM mtl_sales_orders
288: WHERE segment1 = to_char(l_order_number)
289: AND segment2 = l_order_type
290: AND segment3 = l_order_source ;
291:

Line 342: UPDATE mtl_sales_orders

338: (p_original_order_type IS NULL) OR
339: (p_original_source_code IS NULL) ) then
340: return 0 ;
341: ELSE
342: UPDATE mtl_sales_orders
343: SET segment1 = NVL(p_new_order_number,segment1),
344: segment2 = NVL(p_new_order_type, segment2),
345: segment3 = NVL(p_new_order_source, segment3)
346: WHERE segment1 = p_original_order_number

Line 353: UPDATE mtl_sales_orders

349: end if;
350:
351: ELSE
352: --bug4237769
353: UPDATE mtl_sales_orders
354: SET segment1 = NVL(p_new_order_number,segment1),
355: segment2 = NVL(p_new_order_type, segment2),
356: segment3 = NVL(p_new_order_source, segment3)
357: WHERE (p_original_order_number IS NULL OR

Line 411: Procedure create_mtl_sales_orders_bulk (

407: RETURN -1;
408:
409: END Get_Header_Id;
410:
411: Procedure create_mtl_sales_orders_bulk (
412: p_api_version_number IN NUMBER,
413: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
414: p_header_rec IN OE_BULK_ORDER_PVT.HEADER_REC_TYPE,
415: x_message_data OUT NOCOPY VARCHAR2,

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

417: x_return_status OUT NOCOPY VARCHAR2) IS
418:
419: -- Constants
420: c_api_version_number CONSTANT NUMBER := 1.0 ;
421: c_api_name CONSTANT VARCHAR2(50):= 'CREATE_MTL_SALES_ORDERS_BULK';
422:
423: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
424:
425: BEGIN

Line 445: INSERT INTO MTL_SALES_ORDERS

441: x_return_status := fnd_api.g_ret_sts_success;
442:
443:
444: FORALL i IN p_header_rec.order_number.FIRST..p_header_rec.order_number.LAST
445: INSERT INTO MTL_SALES_ORDERS
446: (sales_order_id,
447: segment1,
448: segment2,
449: segment3,

Line 458: mtl_sales_orders_s.nextval,

454: created_by,
455: summary_flag,
456: enabled_flag)
457: Values(
458: mtl_sales_orders_s.nextval,
459: p_header_rec.order_number(i),
460: p_header_rec.order_type_name(i),
461: l_source_code,
462: fnd_global.user_id,

Line 495: END create_mtl_sales_orders_bulk;

491: , p_data => x_message_data
492: , p_encoded => 'F');
493: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
494:
495: END create_mtl_sales_orders_bulk;
496:
497:
498: PROCEDURE delete_mtl_sales_orders_bulk(
499: p_api_version_number IN NUMBER,

Line 498: PROCEDURE delete_mtl_sales_orders_bulk(

494:
495: END create_mtl_sales_orders_bulk;
496:
497:
498: PROCEDURE delete_mtl_sales_orders_bulk(
499: p_api_version_number IN NUMBER,
500: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_error_rec IN OE_BULK_ORDER_PVT.INVALID_HDR_REC_TYPE,
502: x_message_data OUT NOCOPY VARCHAR2,

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

504: x_return_status OUT NOCOPY VARCHAR2) IS
505:
506: -- Constants
507: c_api_version_number CONSTANT NUMBER := 1.0 ;
508: c_api_name CONSTANT VARCHAR2(50):= 'DELETE_MTL_SALES_ORDERS_BULK';
509: BEGIN
510: -- check for api call compatibility
511: if not fnd_api.compatible_api_call(
512: c_api_version_number,

Line 532: DELETE from mtl_sales_orders

528: /*Bug3575085:Changed the sequence of the sub-query from b.name,a.order_number
529: to a.order_number,b.name*/
530: --Bug4237769 Correcting the type mismatch.
531: FORALL i IN 1..P_ERROR_REC.header_id.COUNT
532: DELETE from mtl_sales_orders
533: WHERE (segment1, segment2) IN
534: (select to_char(a.order_number),b.name
535: FROM oe_order_headers a,
536: oe_order_types_v b

Line 551: END delete_mtl_sales_orders_bulk;

547:
548: OE_MSG_PUB.Add_Exc_Msg(g_package_name, c_api_name, x_message_data);
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550:
551: END delete_mtl_sales_orders_bulk;
552:
553: end inv_salesorder ;