APPS.OE_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 9190: FROM oe_order_types_v ot, oe_order_headers_all h

9186:
9187: END IF;
9188: SELECT /* MOAC_SQL_CHANGE*/ name, scheduling_level_code
9189: INTO l_order_type,l_scheduling_level_code
9190: FROM oe_order_types_v ot, oe_order_headers_all h
9191: WHERE h.header_id = p_header_id AND
9192: h.order_type_id = ot.order_type_id;
9193:
9194: sch_cached_header_id := p_header_id;

Line 10663: from oe_order_headers_all

10659: THEN
10660: BEGIN
10661: select order_date_type_code
10662: into l_order_date_type_code
10663: from oe_order_headers_all
10664: where header_id = p_line_rec.header_id;
10665:
10666: IF l_order_date_type_code = 'ARRIVAL' THEN
10667: IF l_debug_level > 0 THEN

Line 12702: Every header in oe_order_headers_all will have a record

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

Line 12746: FROM oe_order_headers_all

12742:
12743: BEGIN
12744: SELECT order_type_id
12745: INTO l_order_type_id
12746: FROM oe_order_headers_all
12747: WHERE header_id = p_header_id;
12748: EXCEPTION
12749: WHEN OTHERS THEN
12750: RAISE;

Line 12807: OE_ORDER_HEADERS_ALL H

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

Line 12840: Every header in oe_order_headers_all will have a record

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