APPS.OE_BULK_SCHEDULE_UTIL dependencies on OE_ORDER_HEADERS

Line 828: FROM OE_ORDER_HEADERS_ALL

824: --ER#7479609 start
825: BEGIN
826: SELECT order_type_id
827: INTO l_header_rec_for_hold.order_type_id
828: FROM OE_ORDER_HEADERS_ALL
829: WHERE header_id=p_line_rec.header_id(p_line_index);
830: EXCEPTION
831: WHEN OTHERS THEN
832: l_header_rec_for_hold.order_type_id := NULL;

Line 1248: FROM oe_order_headers

1244: IF p_header_id <> nvl(G_HEADER_ID,0) THEN
1245: BEGIN
1246: SELECT order_date_type_code
1247: INTO l_order_date_type_code
1248: FROM oe_order_headers
1249: WHERE header_id = p_header_id;
1250:
1251: G_HEADER_ID := p_header_id;
1252: G_DATE_TYPE := l_order_date_type_code;