APPS.WMS_DIRECT_SHIP_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 6778: FROM oe_order_headers_all

6774: END IF;
6775:
6776: SELECT order_source_id
6777: INTO l_order_source_id
6778: FROM oe_order_headers_all
6779: WHERE header_id = p_header_id;
6780:
6781: IF l_order_source_id = 10 THEN
6782: l_demand_source_type_id := 8;

Line 9397: FROM oe_order_headers_all

9393: -- get demand source type
9394: BEGIN
9395: SELECT order_source_id
9396: INTO l_order_source_id
9397: FROM oe_order_headers_all
9398: WHERE header_id = p_order_header_id;
9399:
9400: IF l_order_source_id = 10 THEN
9401: l_demand_source_type_id := 8;

Line 10971: FROM oe_order_headers_all

10967: -- get demand source type
10968: BEGIN
10969: SELECT order_source_id
10970: INTO l_order_source_id
10971: FROM oe_order_headers_all
10972: -- WHERE header_id = 64801;
10973: WHERE header_id = l_order_header_id;
10974:
10975: IF l_order_source_id = 10 THEN

Line 11266: FROM oe_order_headers_all

11262: -- get demand source type
11263: BEGIN
11264: SELECT order_source_id
11265: INTO l_order_source_id
11266: FROM oe_order_headers_all
11267: WHERE header_id = l_loaded_lines_rec.order_header_id;
11268:
11269: IF l_order_source_id = 10 THEN
11270: l_demand_source_type_id := 8;