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.OE_SCHEDULE_UTIL dependencies on MTL_SALES_ORDERS

Line 7693: -- Get demand_source_header_id from mtl_sales_orders

7689:
7690: END IF;
7691:
7692:
7693: -- Get demand_source_header_id from mtl_sales_orders
7694:
7695: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.HEADER_ID);
7696:
7697: IF l_debug_level > 0 THEN

Line 11093: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)

11089: END Get_Order_Number;
11090:
11091: /*--------------------------------------------------------------------------
11092: Procedure Name : Get_mtl_sales_order_id
11093: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
11094: for a given heeader_id.
11095: Every header in oe_order_headers_all will have a record
11096: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11097: from mtl_sales_orders is

Line 11096: in MTL_SALES_ORDERS. The unique key to get the sales_order_id

11092: Procedure Name : Get_mtl_sales_order_id
11093: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
11094: for a given heeader_id.
11095: Every header in oe_order_headers_all will have a record
11096: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11097: from mtl_sales_orders is
11098: Order_Number
11099: Order_Type (in base language)
11100: OM:Source Code profile option (stored as ont_source_code).

Line 11097: from mtl_sales_orders is

11093: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
11094: for a given heeader_id.
11095: Every header in oe_order_headers_all will have a record
11096: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11097: from mtl_sales_orders is
11098: Order_Number
11099: Order_Type (in base language)
11100: OM:Source Code profile option (stored as ont_source_code).
11101:

Line 11102: The above values are stored in a flex in MTL_SALES_ORDERS.

11098: Order_Number
11099: Order_Type (in base language)
11100: OM:Source Code profile option (stored as ont_source_code).
11101:
11102: The above values are stored in a flex in MTL_SALES_ORDERS.
11103: SEGMENT1 : stores the order number
11104: SEGMENT2 : stores the order type
11105: SEGMENT3 : stores the ont_source_code value
11106:

Line 11199: FROM MTL_SALES_ORDERS S,

11195: RETURN oe_schedule_util.sch_cached_mtl_sales_order_id;
11196: ELSE
11197: SELECT S.SALES_ORDER_ID
11198: INTO l_sales_order_id
11199: FROM MTL_SALES_ORDERS S,
11200: OE_ORDER_HEADERS_ALL H
11201: WHERE S.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
11202: AND S.SEGMENT2 = l_order_type_name
11203: AND S.SEGMENT3 = l_source_code

Line 11230: Procedure Name : Insert_Into_Mtl_Sales_Orders

11226: END IF;
11227: RETURN 0;
11228: END Get_mtl_sales_order_id;
11229: /*--------------------------------------------------------------------------
11230: Procedure Name : Insert_Into_Mtl_Sales_Orders
11231: Description : This API creates a record in MTL_SALES_ORDERS for a given
11232: order header.
11233: Every header in oe_order_headers_all will have a record
11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id

Line 11231: Description : This API creates a record in MTL_SALES_ORDERS for a given

11227: RETURN 0;
11228: END Get_mtl_sales_order_id;
11229: /*--------------------------------------------------------------------------
11230: Procedure Name : Insert_Into_Mtl_Sales_Orders
11231: Description : This API creates a record in MTL_SALES_ORDERS for a given
11232: order header.
11233: Every header in oe_order_headers_all will have a record
11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11235: from mtl_sales_orders is

Line 11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id

11230: Procedure Name : Insert_Into_Mtl_Sales_Orders
11231: Description : This API creates a record in MTL_SALES_ORDERS for a given
11232: order header.
11233: Every header in oe_order_headers_all will have a record
11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11235: from mtl_sales_orders is
11236: Order_Number
11237: Order_Type (in base language)
11238: OM:Source Code profile option (stored as ont_source_code).

Line 11235: from mtl_sales_orders is

11231: Description : This API creates a record in MTL_SALES_ORDERS for a given
11232: order header.
11233: Every header in oe_order_headers_all will have a record
11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11235: from mtl_sales_orders is
11236: Order_Number
11237: Order_Type (in base language)
11238: OM:Source Code profile option (stored as ont_source_code).
11239:

Line 11240: The above values are stored in a flex in MTL_SALES_ORDERS.

11236: Order_Number
11237: Order_Type (in base language)
11238: OM:Source Code profile option (stored as ont_source_code).
11239:
11240: The above values are stored in a flex in MTL_SALES_ORDERS.
11241: SEGMENT1 : stores the order number
11242: SEGMENT2 : stores the order type
11243: SEGMENT3 : stores the ont_source_code value
11244:

Line 11246: Procedure Insert_Into_Mtl_Sales_Orders

11242: SEGMENT2 : stores the order type
11243: SEGMENT3 : stores the ont_source_code value
11244:
11245: -------------------------------------------------------------------------- */
11246: Procedure Insert_Into_Mtl_Sales_Orders
11247: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
11248: IS
11249: l_order_type_name VARCHAR2(80);
11250: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 11261: oe_debug_pub.add( 'ENTERING INSERT_INTO_MTL_SALES_ORDERS' , 1 ) ;

11257: --
11258: BEGIN
11259:
11260: IF l_debug_level > 0 THEN
11261: oe_debug_pub.add( 'ENTERING INSERT_INTO_MTL_SALES_ORDERS' , 1 ) ;
11262: END IF;
11263:
11264: BEGIN
11265: -- Fix for bug#1078323: the order type name should be selected in

Line 11335: oe_debug_pub.add( 'EXITING INSERT_INTO_MTL_SALES_ORDERS' , 1 ) ;

11331: RAISE FND_API.G_EXC_ERROR;
11332: END IF;
11333:
11334: IF l_debug_level > 0 THEN
11335: oe_debug_pub.add( 'EXITING INSERT_INTO_MTL_SALES_ORDERS' , 1 ) ;
11336: END IF;
11337:
11338: EXCEPTION
11339:

Line 11346: , 'Insert_Into_Mtl_Sales_Orders'

11342: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11343: THEN
11344: OE_MSG_PUB.Add_Exc_Msg
11345: ( G_PKG_NAME
11346: , 'Insert_Into_Mtl_Sales_Orders'
11347: );
11348: END IF;
11349:
11350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 11352: END Insert_Into_Mtl_Sales_Orders;

11348: END IF;
11349:
11350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11351:
11352: END Insert_Into_Mtl_Sales_Orders;
11353:
11354:
11355: /*---------------------------------------------------------------------
11356: Procedure Name : call_process_order

Line 14542: -- Get demand_source_header_id from mtl_sales_orders

14538: -- order entry
14539: END IF;
14540:
14541:
14542: -- Get demand_source_header_id from mtl_sales_orders
14543:
14544: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.HEADER_ID);
14545:
14546: IF l_debug_level > 0 THEN