APPS.OE_DS_PVT dependencies on OE_ORDER_HEADERS

Line 1290: FROM oe_order_headers_all h, oe_order_types_v ot

1286: /* commented for bug 4456817
1287: BEGIN
1288: SELECT h.order_number,ot.name
1289: INTO l_order_number,l_order_type_name
1290: FROM oe_order_headers_all h, oe_order_types_v ot
1291: WHERE h.header_id = p_line_rec.header_id AND
1292: ot.order_type_id = h.order_type_id;
1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN

Line 1688: Every header in oe_order_headers_all will have a record

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
1691: Order_Number
1692: Order_Type (in base language)

Line 1720: FROM oe_order_headers

1716:
1717: BEGIN
1718: SELECT order_type_id
1719: INTO l_order_type_id
1720: FROM oe_order_headers
1721: WHERE header_id = p_header_id;
1722: EXCEPTION
1723: WHEN OTHERS THEN
1724: RAISE;

Line 1755: OE_ORDER_HEADERS H

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
1759: AND H.HEADER_ID = p_header_id;