[Home] [Help]
1311: /* commented for bug 4456817
1312: BEGIN
1313: SELECT h.order_number,ot.name
1314: INTO l_order_number,l_order_type_name
1315: FROM oe_order_headers_all h, oe_order_types_v ot
1316: WHERE h.header_id = p_line_rec.header_id AND
1317: ot.order_type_id = h.order_type_id;
1318: EXCEPTION
1319: WHEN NO_DATA_FOUND THEN
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
1716: Order_Number
1717: Order_Type (in base language)
1741:
1742: BEGIN
1743: SELECT order_type_id
1744: INTO l_order_type_id
1745: FROM oe_order_headers
1746: WHERE header_id = p_header_id;
1747: EXCEPTION
1748: WHEN OTHERS THEN
1749: RAISE;
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
1784: AND H.HEADER_ID = p_header_id;