APPS.OE_ORDER_SCH_UTIL dependencies on OE_ORDER_HEADERS

Line 2599: from oe_order_headers_all

2595: THEN
2596:
2597: BEGIN
2598: select order_date_type_code into l_order_date_type_code
2599: from oe_order_headers_all
2600: where header_id = p_line_rec.header_id;
2601:
2602: IF l_order_date_type_code = 'ARRIVAL' THEN
2603: RETURN TRUE;

Line 2733: FROM oe_order_types_v ot, oe_order_headers h

2729: END IF;
2730:
2731: SELECT name, scheduling_level_code
2732: INTO l_order_type,l_scheduling_level_code
2733: FROM oe_order_types_v ot, oe_order_headers h
2734: WHERE h.header_id = p_header_id AND
2735: h.order_type_id = ot.order_type_id;
2736:
2737: sch_cached_header_id := p_header_id;

Line 5689: FROM oe_order_headers

5685: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
5686: BEGIN
5687: SELECT order_date_type_code
5688: INTO l_order_date_type_code
5689: FROM oe_order_headers
5690: WHERE header_id = p_header_id;
5691:
5692: G_HEADER_ID := p_header_id;
5693: G_DATE_TYPE := l_order_date_type_code;

Line 5732: from oe_order_headers

5728: THEN
5729: BEGIN
5730: select order_number
5731: into l_order_number
5732: from oe_order_headers
5733: where header_id = p_header_id;
5734: EXCEPTION
5735: WHEN OTHERS THEN
5736: RETURN null;

Line 8134: Every header in oe_order_headers_all will have a record

8130: /*--------------------------------------------------------------------------
8131: Procedure Name : Insert_Into_Mtl_Sales_Orders
8132: Description : This API creates a record in MTL_SALES_ORDERS for a given
8133: order header.
8134: Every header in oe_order_headers_all will have a record
8135: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
8136: from mtl_sales_orders is
8137: Order_Number
8138: Order_Type (in base language)

Line 8231: Every header in oe_order_headers_all will have a record

8227: /*--------------------------------------------------------------------------
8228: Procedure Name : Get_mtl_sales_order_id
8229: Description : This funtion returns the SALES_ORDER_ID (frm mtl_sales_orders)
8230: for a given heeader_id.
8231: Every header in oe_order_headers_all will have a record
8232: in MTL_SALES_ORDERS. The unique key to get the sales_order_id
8233: from mtl_sales_orders is
8234: Order_Number
8235: Order_Type (in base language)