APPS.QP_UPG_OE_PVT dependencies on QP_DISCOUNT_MAPPING

Line 14: select /* + Ordered index(dmap QP_DISCOUNT_MAPPING_T1) */

10: x_output OUT NOCOPY /* file.sql.39 change */ PRICE_ADJ_REC_TYPE )
11: IS
12:
13: cursor oepadj is
14: select /* + Ordered index(dmap QP_DISCOUNT_MAPPING_T1) */
15: dmap.new_list_header_id,
16: dmap.new_list_line_id,
17: dmap.new_type,
18: dmap.old_price_break_lines_low,

Line 35: qp_discount_mapping dmap, qp_list_lines ll, qp_list_headers_b lh

31: ll.benefit_uom_code,
32: ll.print_on_invoice_flag,
33: ll.expiration_date
34: from
35: qp_discount_mapping dmap, qp_list_lines ll, qp_list_headers_b lh
36: where p_discount_id = dmap.old_discount_id
37: and (p_discount_line_id = dmap.old_discount_line_id or
38: p_discount_line_id is null or p_discount_line_id = -1)
39: and dmap.new_list_header_id = ll.list_header_id

Line 58: qp_discount_mapping dmap, oe_order_lines_all oeordl, qp_list_lines ll

54: ll.list_line_type_code,
55: ll.override_flag,
56: oeordl.ordered_quantity
57: from
58: qp_discount_mapping dmap, oe_order_lines_all oeordl, qp_list_lines ll
59: where
60: ( dmap.old_discount_id = p_discount_id and
61: oeordl.line_id = p_line_id and
62: dmap.new_list_line_id = ll.list_line_id and