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 9035: -- Get demand_source_header_id from mtl_sales_orders

9031:
9032: END IF;
9033:
9034:
9035: -- Get demand_source_header_id from mtl_sales_orders
9036:
9037: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.HEADER_ID);
9038:
9039: IF l_debug_level > 0 THEN

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

12696: END Get_Order_Number;
12697:
12698: /*--------------------------------------------------------------------------
12699: Procedure Name : Get_mtl_sales_order_id
12700: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
12701: for a given heeader_id.
12702: Every header in oe_order_headers_all will have a record
12703: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12704: from mtl_sales_orders is

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

12699: Procedure Name : Get_mtl_sales_order_id
12700: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
12701: for a given heeader_id.
12702: Every header in oe_order_headers_all will have a record
12703: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12704: from mtl_sales_orders is
12705: Order_Number
12706: Order_Type (in base language)
12707: OM:Source Code profile option (stored as ont_source_code).

Line 12704: from mtl_sales_orders is

12700: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
12701: for a given heeader_id.
12702: Every header in oe_order_headers_all will have a record
12703: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12704: from mtl_sales_orders is
12705: Order_Number
12706: Order_Type (in base language)
12707: OM:Source Code profile option (stored as ont_source_code).
12708:

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

12705: Order_Number
12706: Order_Type (in base language)
12707: OM:Source Code profile option (stored as ont_source_code).
12708:
12709: The above values are stored in a flex in MTL_SALES_ORDERS.
12710: SEGMENT1 : stores the order number
12711: SEGMENT2 : stores the order type
12712: SEGMENT3 : stores the ont_source_code value
12713:

Line 12806: FROM MTL_SALES_ORDERS S,

12802: RETURN oe_schedule_util.sch_cached_mtl_sales_order_id;
12803: ELSE
12804: SELECT S.SALES_ORDER_ID
12805: INTO l_sales_order_id
12806: FROM MTL_SALES_ORDERS S,
12807: OE_ORDER_HEADERS_ALL H
12808: WHERE S.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
12809: AND S.SEGMENT2 = l_order_type_name
12810: AND S.SEGMENT3 = l_source_code

Line 12837: Procedure Name : Insert_Into_Mtl_Sales_Orders

12833: END IF;
12834: RETURN 0;
12835: END Get_mtl_sales_order_id;
12836: /*--------------------------------------------------------------------------
12837: Procedure Name : Insert_Into_Mtl_Sales_Orders
12838: Description : This API creates a record in MTL_SALES_ORDERS for a given
12839: order header.
12840: Every header in oe_order_headers_all will have a record
12841: in MTL_SALES_ORDERS. The unique key to get the sales_order_id

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

12834: RETURN 0;
12835: END Get_mtl_sales_order_id;
12836: /*--------------------------------------------------------------------------
12837: Procedure Name : Insert_Into_Mtl_Sales_Orders
12838: Description : This API creates a record in MTL_SALES_ORDERS for a given
12839: order header.
12840: Every header in oe_order_headers_all will have a record
12841: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12842: from mtl_sales_orders is

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

12837: Procedure Name : Insert_Into_Mtl_Sales_Orders
12838: Description : This API creates a record in MTL_SALES_ORDERS for a given
12839: order header.
12840: Every header in oe_order_headers_all will have a record
12841: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12842: from mtl_sales_orders is
12843: Order_Number
12844: Order_Type (in base language)
12845: OM:Source Code profile option (stored as ont_source_code).

Line 12842: from mtl_sales_orders is

12838: Description : This API creates a record in MTL_SALES_ORDERS for a given
12839: order header.
12840: Every header in oe_order_headers_all will have a record
12841: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
12842: from mtl_sales_orders is
12843: Order_Number
12844: Order_Type (in base language)
12845: OM:Source Code profile option (stored as ont_source_code).
12846:

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

12843: Order_Number
12844: Order_Type (in base language)
12845: OM:Source Code profile option (stored as ont_source_code).
12846:
12847: The above values are stored in a flex in MTL_SALES_ORDERS.
12848: SEGMENT1 : stores the order number
12849: SEGMENT2 : stores the order type
12850: SEGMENT3 : stores the ont_source_code value
12851:

Line 12853: Procedure Insert_Into_Mtl_Sales_Orders

12849: SEGMENT2 : stores the order type
12850: SEGMENT3 : stores the ont_source_code value
12851:
12852: -------------------------------------------------------------------------- */
12853: Procedure Insert_Into_Mtl_Sales_Orders
12854: ( p_header_rec IN OE_ORDER_PUB.header_rec_type)
12855: IS
12856: l_order_type_name VARCHAR2(80);
12857: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 12868: oe_debug_pub.add( 'ENTERING INSERT_INTO_MTL_SALES_ORDERS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

12864: --
12865: BEGIN
12866:
12867: IF l_debug_level > 0 THEN
12868: oe_debug_pub.add( 'ENTERING INSERT_INTO_MTL_SALES_ORDERS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
12869: END IF;
12870:
12871: BEGIN
12872: -- Fix for bug#1078323: the order type name should be selected in

Line 12942: oe_debug_pub.add( 'EXITING INSERT_INTO_MTL_SALES_ORDERS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459

12938: RAISE FND_API.G_EXC_ERROR;
12939: END IF;
12940:
12941: IF l_debug_level > 0 THEN
12942: oe_debug_pub.add( 'EXITING INSERT_INTO_MTL_SALES_ORDERS' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
12943: END IF;
12944:
12945: EXCEPTION
12946:

Line 12953: , 'Insert_Into_Mtl_Sales_Orders'

12949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12950: THEN
12951: OE_MSG_PUB.Add_Exc_Msg
12952: ( G_PKG_NAME
12953: , 'Insert_Into_Mtl_Sales_Orders'
12954: );
12955: END IF;
12956:
12957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 12959: END Insert_Into_Mtl_Sales_Orders;

12955: END IF;
12956:
12957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12958:
12959: END Insert_Into_Mtl_Sales_Orders;
12960:
12961:
12962: /*---------------------------------------------------------------------
12963: Procedure Name : call_process_order

Line 17029: -- Get demand_source_header_id from mtl_sales_orders

17025: -- order entry
17026: END IF;
17027:
17028:
17029: -- Get demand_source_header_id from mtl_sales_orders
17030:
17031: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.HEADER_ID);
17032:
17033: IF l_debug_level > 0 THEN