APPS.OE_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS

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 12638: FROM oe_order_headers

12634: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
12635: BEGIN
12636: SELECT order_date_type_code
12637: INTO l_order_date_type_code
12638: FROM oe_order_headers
12639: WHERE header_id = p_header_id;
12640:
12641: G_HEADER_ID := p_header_id;
12642: G_DATE_TYPE := l_order_date_type_code;

Line 12681: from oe_order_headers

12677: THEN
12678: BEGIN
12679: select order_number
12680: into l_order_number
12681: from oe_order_headers
12682: where header_id = p_header_id;
12683: EXCEPTION
12684: WHEN OTHERS THEN
12685: RETURN null;

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)

Line 17575: FROM oe_order_headers

17571: l_line_id := p_line_id;
17572:
17573: SELECT ORDER_NUMBER ,ORDER_DATE_TYPE_CODE
17574: INTO l_order_number,l_order_date_type_code
17575: FROM oe_order_headers
17576: WHERE header_id=l_header_id;
17577:
17578: IF l_order_date_type_code = 'ARRIVAL' THEN
17579: l_requested_arrival_date := l_request_date;