APPS.OE_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS

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

11027: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
11028: BEGIN
11029: SELECT order_date_type_code
11030: INTO l_order_date_type_code
11031: FROM oe_order_headers
11032: WHERE header_id = p_header_id;
11033:
11034: G_HEADER_ID := p_header_id;
11035: G_DATE_TYPE := l_order_date_type_code;

Line 11074: from oe_order_headers

11070: THEN
11071: BEGIN
11072: select order_number
11073: into l_order_number
11074: from oe_order_headers
11075: where header_id = p_header_id;
11076: EXCEPTION
11077: WHEN OTHERS THEN
11078: RETURN null;

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)

Line 15028: FROM oe_order_headers

15024: l_line_id := p_line_id;
15025:
15026: SELECT ORDER_NUMBER ,ORDER_DATE_TYPE_CODE
15027: INTO l_order_number,l_order_date_type_code
15028: FROM oe_order_headers
15029: WHERE header_id=l_header_id;
15030:
15031: IF l_order_date_type_code = 'ARRIVAL' THEN
15032: l_requested_arrival_date := l_request_date;