APPS.OE_BULK_PRICE_PVT dependencies on OE_ORDER_LINES

Line 241: , OE_ORDER_LINES_ALL l -- Changes for SQL Id 14876372

237: FROM OE_PRICE_ADJS_IFACE_ALL a
238: , OE_ORDER_HEADERS h
239: , QP_LIST_HEADERS lh
240: , QP_LIST_LINES ll
241: , OE_ORDER_LINES_ALL l -- Changes for SQL Id 14876372
242: WHERE h.batch_id = p_batch_id
243: AND a.order_source_id = h.order_source_id
244: AND a.orig_sys_document_ref = h.orig_sys_document_ref
245: AND lh.list_header_id = a.list_header_id

Line 312: FROM OE_ORDER_LINES l

308: SELECT line_id
309: ,price_list_id
310: ,unit_list_price
311: ,unit_selling_price
312: FROM OE_ORDER_LINES l
313: WHERE l.header_id = l_header_id;
314: --
315: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
316: --

Line 424: FROM OE_ORDER_LINES l

420:
421: BEGIN
422: SELECT 'Y'
423: INTO l_book_failed
424: FROM OE_ORDER_LINES l
425: WHERE l.header_id = l_header_id
426: AND (l.price_list_id IS NULL
427: OR l.unit_list_price IS NULL
428: OR l.unit_selling_price IS NULL)

Line 779: UPDATE OE_ORDER_LINES

775: IS
776: l_start_index BINARY_INTEGER;
777: BEGIN
778: -- Update DB values
779: UPDATE OE_ORDER_LINES
780: SET booked_flag = 'N'
781: ,flow_status_code = 'ENTERED'
782: WHERE header_id = p_header_rec.header_id(p_index);
783: