APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on QP_RLTD_MODIFIERS

Line 132: from qp_rltd_modifiers rltd, qp_list_lines ql, qp_list_headers_b qlh

128: insert into qp_adv_mod_products
129: (pricing_phase_id, product_attribute, product_attr_value)
130: (select
131: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
132: from qp_rltd_modifiers rltd, qp_list_lines ql, qp_list_headers_b qlh
133: ,qp_pricing_attributes qpa
134: where rltd.rltd_modifier_grp_type = 'BENEFIT'
135: and ql.list_line_id = rltd.to_rltd_modifier_id
136: --and ql.list_line_type_code = 'DIS'

Line 272: from qp_list_lines LL, qp_rltd_modifiers RLT, qp_list_headers_b LH

268: /*update qp_pricing_phases PH
269: --at least 1 PRG modifier exists with rltd line
270: set rltd_exists = (
271: select /*+ ordered use_nl(rlt lh) index(ll QP_LIST_LINES_N5) * / 'Y'
272: from qp_list_lines LL, qp_rltd_modifiers RLT, qp_list_headers_b LH
273: where LH.active_flag = 'Y'
274: and LH.list_type_code = 'PRO'
275: and LL.pricing_phase_id = PH.pricing_phase_id
276: and LL.list_header_id = LH.list_header_id

Line 319: --[julin/4698834] removed qp_rltd_modifiers RLT; per bug, needs to be 'Y' if PRG simply exists

315: if (nvl(p_pricing_phase_id,2) > 1)
316: and (p_call_from is null or p_call_from = 1)then
317: update qp_pricing_phases PH
318: --at least 1 PRG modifier exists with rltd line
319: --[julin/4698834] removed qp_rltd_modifiers RLT; per bug, needs to be 'Y' if PRG simply exists
320: set rltd_exists = (
321: select 'Y'
322: from qp_list_lines LL, qp_list_headers_b LH
323: where LH.active_flag = 'Y'

Line 964: from qp_rltd_modifiers

960: select 1
961: into l_count
962: from dual where exists
963: (select 'x'
964: from qp_rltd_modifiers
965: where to_rltd_modifier_id = l_list_line_id_tbl(i)
966: and rltd_modifier_grp_type <> 'COUPON');
967: EXCEPTION
968: WHEN NO_DATA_FOUND THEN