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_DS_PVT dependencies on MTL_SALES_ORDERS

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

1707: END Get_Char_of_accts;
1708:
1709: /*--------------------------------------------------------------------------
1710: Procedure Name : Get_mtl_sales_order_id
1711: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1712: for a given heeader_id.
1713: Every header in oe_order_headers_all will have a record
1714: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1715: from mtl_sales_orders is

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

1710: Procedure Name : Get_mtl_sales_order_id
1711: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1712: for a given heeader_id.
1713: Every header in oe_order_headers_all will have a record
1714: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1715: from mtl_sales_orders is
1716: Order_Number
1717: Order_Type (in base language)
1718: OM:Source Code profile option (stored as ont_source_code).

Line 1715: from mtl_sales_orders is

1711: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1712: for a given heeader_id.
1713: Every header in oe_order_headers_all will have a record
1714: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1715: from mtl_sales_orders is
1716: Order_Number
1717: Order_Type (in base language)
1718: OM:Source Code profile option (stored as ont_source_code).
1719:

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

1716: Order_Number
1717: Order_Type (in base language)
1718: OM:Source Code profile option (stored as ont_source_code).
1719:
1720: The above values are stored in a flex in MTL_SALES_ORDERS.
1721: SEGMENT1 : stores the order number
1722: SEGMENT2 : stores the order type
1723: SEGMENT3 : stores the ont_source_code value
1724:

Line 1779: FROM MTL_SALES_ORDERS S,

1775: END IF;
1776:
1777: SELECT S.SALES_ORDER_ID
1778: INTO l_sales_order_id
1779: FROM MTL_SALES_ORDERS S,
1780: OE_ORDER_HEADERS H
1781: WHERE S.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
1782: AND S.SEGMENT2 = l_order_type_name
1783: AND S.SEGMENT3 = l_source_code

Line 2240: -- Get demand_source_header_id from mtl_sales_orders

2236: l_reservation_rec.inventory_item_id := p_line_rec.inventory_item_id;
2237: l_reservation_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
2238: l_reservation_rec.demand_source_name := NULL;
2239:
2240: -- Get demand_source_header_id from mtl_sales_orders
2241:
2242: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.header_id);
2243:
2244: IF l_debug_level > 0 THEN