APPS.OE_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 7848: FROM oe_order_types_v ot, oe_order_headers_all h

7844:
7845: END IF;
7846: SELECT /* MOAC_SQL_CHANGE*/ name, scheduling_level_code
7847: INTO l_order_type,l_scheduling_level_code
7848: FROM oe_order_types_v ot, oe_order_headers_all h
7849: WHERE h.header_id = p_header_id AND
7850: h.order_type_id = ot.order_type_id;
7851:
7852: sch_cached_header_id := p_header_id;

Line 9143: from oe_order_headers_all

9139: THEN
9140: BEGIN
9141: select order_date_type_code
9142: into l_order_date_type_code
9143: from oe_order_headers_all
9144: where header_id = p_line_rec.header_id;
9145:
9146: IF l_order_date_type_code = 'ARRIVAL' THEN
9147: IF l_debug_level > 0 THEN

Line 11095: Every header in oe_order_headers_all will have a record

11091: /*--------------------------------------------------------------------------
11092: Procedure Name : Get_mtl_sales_order_id
11093: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
11094: for a given heeader_id.
11095: Every header in oe_order_headers_all will have a record
11096: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11097: from mtl_sales_orders is
11098: Order_Number
11099: Order_Type (in base language)

Line 11139: FROM oe_order_headers_all

11135:
11136: BEGIN
11137: SELECT order_type_id
11138: INTO l_order_type_id
11139: FROM oe_order_headers_all
11140: WHERE header_id = p_header_id;
11141: EXCEPTION
11142: WHEN OTHERS THEN
11143: RAISE;

Line 11200: OE_ORDER_HEADERS_ALL H

11196: ELSE
11197: SELECT S.SALES_ORDER_ID
11198: INTO l_sales_order_id
11199: FROM MTL_SALES_ORDERS S,
11200: OE_ORDER_HEADERS_ALL H
11201: WHERE S.SEGMENT1 = TO_CHAR(H.ORDER_NUMBER)
11202: AND S.SEGMENT2 = l_order_type_name
11203: AND S.SEGMENT3 = l_source_code
11204: AND H.HEADER_ID = p_header_id;

Line 11233: Every header in oe_order_headers_all will have a record

11229: /*--------------------------------------------------------------------------
11230: Procedure Name : Insert_Into_Mtl_Sales_Orders
11231: Description : This API creates a record in MTL_SALES_ORDERS for a given
11232: order header.
11233: Every header in oe_order_headers_all will have a record
11234: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
11235: from mtl_sales_orders is
11236: Order_Number
11237: Order_Type (in base language)