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 1686: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)

1682: END Get_Char_of_accts;
1683:
1684: /*--------------------------------------------------------------------------
1685: Procedure Name : Get_mtl_sales_order_id
1686: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1687: for a given heeader_id.
1688: Every header in oe_order_headers_all will have a record
1689: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1690: from mtl_sales_orders is

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

1685: Procedure Name : Get_mtl_sales_order_id
1686: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1687: for a given heeader_id.
1688: Every header in oe_order_headers_all will have a record
1689: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1690: from mtl_sales_orders is
1691: Order_Number
1692: Order_Type (in base language)
1693: OM:Source Code profile option (stored as ont_source_code).

Line 1690: from mtl_sales_orders is

1686: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
1687: for a given heeader_id.
1688: Every header in oe_order_headers_all will have a record
1689: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
1690: from mtl_sales_orders is
1691: Order_Number
1692: Order_Type (in base language)
1693: OM:Source Code profile option (stored as ont_source_code).
1694:

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

1691: Order_Number
1692: Order_Type (in base language)
1693: OM:Source Code profile option (stored as ont_source_code).
1694:
1695: The above values are stored in a flex in MTL_SALES_ORDERS.
1696: SEGMENT1 : stores the order number
1697: SEGMENT2 : stores the order type
1698: SEGMENT3 : stores the ont_source_code value
1699:

Line 1754: FROM MTL_SALES_ORDERS S,

1750: END IF;
1751:
1752: SELECT S.SALES_ORDER_ID
1753: INTO l_sales_order_id
1754: FROM MTL_SALES_ORDERS S,
1755: OE_ORDER_HEADERS H
1756: WHERE S.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
1757: AND S.SEGMENT2 = l_order_type_name
1758: AND S.SEGMENT3 = l_source_code

Line 2214: -- Get demand_source_header_id from mtl_sales_orders

2210: l_reservation_rec.inventory_item_id := p_line_rec.inventory_item_id;
2211: l_reservation_rec.demand_source_type_id := INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
2212: l_reservation_rec.demand_source_name := NULL;
2213:
2214: -- Get demand_source_header_id from mtl_sales_orders
2215:
2216: l_sales_order_id := Get_mtl_sales_order_id(p_line_rec.header_id);
2217:
2218: IF l_debug_level > 0 THEN