eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on QP_LIST_HEADERS_B

Line 32: FROM qp_list_headers_b qh,

28: Cursor l_basic_modifiers_cur Is
29: SELECT 'N' FROM dual WHERE
30: EXISTS(
31: SELECT 'Y'
32: FROM qp_list_headers_b qh,
33: qp_list_lines ql
34: WHERE qh.list_type_code = 'PRO'
35: and qh.active_flag = 'Y'
36: and ql.list_header_id = qh.list_header_id

Line 43: FROM qp_list_headers_b qh

39: );
40:
41: Cursor l_limits_cur IS
42: SELECT 'N'
43: FROM qp_list_headers_b qh
44: WHERE qh.active_flag = 'Y'
45: and qh.list_type_code in ('PRO','DLT','SLT','DEL','CHARGES')
46: and exists (select 'Y'
47: from qp_limits qlim

Line 111: from qp_list_lines ql, qp_list_headers_b qlh

107:
108: insert into qp_adv_mod_products
109: (pricing_phase_id, product_attribute, product_attr_value)
110: (select /*+ ORDERED USE_NL(qlh) */ ql.pricing_phase_id, 'PRICING_ATTRIBUTE3', 'ALL_ITEMS'
111: from qp_list_lines ql, qp_list_headers_b qlh
112: where ql.qualification_ind = 0
113: and ql.pricing_phase_id <> 1
114: and ql.modifier_level_code = 'LINEGROUP'
115: --added for bug 5237249

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 155: , qp_list_headers_b qlh

151: UNION
152: select
153: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
154: from qp_list_lines ql
155: , qp_list_headers_b qlh
156: , qp_pricing_attributes qpa
157: where ql.pricing_phase_id > 1
158: and ql.qualification_ind > 0
159: and ql.list_line_type_code in ('OID', 'PRG', 'RLTD')

Line 178: , qp_list_headers_b qlh

174: UNION
175: select
176: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
177: from qp_list_lines ql
178: , qp_list_headers_b qlh
179: , qp_pricing_attributes qpa
180: where ql.modifier_level_code = 'LINEGROUP'
181: and ql.pricing_phase_id > 1
182: and qpa.list_line_id = ql.list_line_id

Line 217: FROM qp_list_headers_b qh,

213: CURSOR l_basic_modifiers_cur IS
214: SELECT 'Y' FROM DUAL WHERE
215: EXISTS(
216: SELECT 'Y'
217: FROM qp_list_headers_b qh,
218: qp_list_lines ql
219: WHERE qh.list_type_code = 'PRO'
220: and qh.active_flag = 'Y'
221: and ql.list_header_id = qh.list_header_id

Line 228: FROM qp_list_headers_b qh

224: );
225:
226: CURSOR l_limits_exist_cur IS
227: SELECT 'Y'
228: FROM qp_list_headers_b qh
229: WHERE qh.active_flag = 'Y'
230: and qh.list_type_code in ('PRO','DLT','SLT','DEL','CHARGES')
231: and exists (select 'Y'
232: from qp_limits qlim

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 284: from qp_list_lines LL, qp_list_headers_b LH

280: and rownum = 1)
281: --atleast 1 modifier of type OID exist
282: , oid_exists = (
283: SELECT /*+ ordered use_nl(lh) index(ll QP_LIST_LINES_N5) * / 'Y'
284: from qp_list_lines LL, qp_list_headers_b LH
285: where LH.list_type_code = 'PRO'
286: and LH.active_flag = 'Y'
287: and LL.pricing_phase_id = PH.pricing_phase_id
288: and LL.list_line_type_code = 'OID'

Line 294: from qp_list_lines LL, qp_list_headers_b LH

290: and rownum = 1)
291: --at least 1 modifier of level line_group exist
292: , line_group_exists = (
293: SELECT /*+ ordered use_nl(lh) index(ll QP_LIST_LINES_N4) * / 'Y'
294: from qp_list_lines LL, qp_list_headers_b LH
295: where LH.list_type_code in ('DLT','DEL','SLT','PRO','CHARGES')
296: and LH.active_flag = 'Y'
297: and LL.list_header_id = LH.list_header_id
298: and LL.pricing_phase_id = PH.pricing_phase_id

Line 304: from qp_list_lines LL, qp_list_headers_b LH

300: and rownum = 1)
301: --at least 1 freight charge modifier exist
302: , freight_exists = (
303: SELECT /*+ ordered use_nl(lh) index(ll QP_LIST_LINES_N5) * / 'Y'
304: from qp_list_lines LL, qp_list_headers_b LH
305: where LH.list_type_code = 'CHARGES'
306: and LH.active_flag = 'Y'
307: and LL.list_header_id = LH.list_header_id
308: and LL.pricing_phase_id = PH.pricing_phase_id

Line 322: from qp_list_lines LL, qp_list_headers_b LH

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'
324: and LH.list_type_code = 'PRO'
325: and LL.pricing_phase_id = PH.pricing_phase_id
326: and LL.list_header_id = LH.list_header_id

Line 338: from qp_list_lines LL, qp_list_headers_b LH

334: --atleast 1 modifier of type OID exist
335: update qp_pricing_phases PH
336: set oid_exists = (
337: SELECT 'Y'
338: from qp_list_lines LL, qp_list_headers_b LH
339: where LH.list_type_code = 'PRO'
340: and LH.active_flag = 'Y'
341: and LL.pricing_phase_id = PH.pricing_phase_id
342: and LL.list_line_type_code = 'OID'

Line 353: from qp_list_lines LL, qp_list_headers_b LH

349: if (nvl(p_pricing_phase_id,3) >2) then
350: update qp_pricing_phases PH
351: set line_group_exists = (
352: SELECT /*+ ordered use_nl(lh) index(ll QP_LIST_LINES_N4) */ 'Y'
353: from qp_list_lines LL, qp_list_headers_b LH
354: where LH.list_type_code in ('DLT','DEL','SLT','PRO','CHARGES')
355: and LH.active_flag = 'Y'
356: and LL.list_header_id = LH.list_header_id
357: and LL.pricing_phase_id = PH.pricing_phase_id

Line 369: from qp_list_lines LL, qp_list_headers_b LH

365: --at least 1 freight charge modifier exist
366: update qp_pricing_phases PH
367: set freight_exists = (
368: SELECT 'Y'
369: from qp_list_lines LL, qp_list_headers_b LH
370: where LH.list_type_code = 'CHARGES'
371: and LH.active_flag = 'Y'
372: and LL.list_header_id = LH.list_header_id
373: and LL.pricing_phase_id = PH.pricing_phase_id

Line 425: from qp_list_lines l, qp_list_headers_b h

421:
422: begin
423: /*
424: select 'Y' into l_automatic_exists
425: from qp_list_lines l, qp_list_headers_b h
426: where l.automatic_flag = 'Y'
427: and l.pricing_phase_id = I.pricing_phase_id
428: and l.list_header_id = h.list_header_id
429: and l.modifier_level_code in ('LINE', 'LINEGROUP', 'ORDER')

Line 438: and exists (select 'x' from qp_list_headers_b h

434: select 'Y' into l_automatic_exists from dual
435: where exists (select 1 from qp_list_lines l
436: where l.automatic_flag = 'Y'
437: and l.pricing_phase_id = I.pricing_phase_id
438: and exists (select 'x' from qp_list_headers_b h
439: where l.list_header_id = h.list_header_id
440: and h.active_flag = 'Y'));
441: exception
442: WHEN no_data_found THEN

Line 449: from qp_list_lines l, qp_list_headers_b h

445:
446: begin
447: /*
448: select 'Y' into l_manual_exists
449: from qp_list_lines l, qp_list_headers_b h
450: where l.automatic_flag = 'N'
451: and l.pricing_phase_id = I.pricing_phase_id
452: and l.list_header_id = h.list_header_id
453: and l.modifier_level_code in ('LINE', 'LINEGROUP', 'ORDER')

Line 462: and exists (select 'x' from qp_list_headers_b h

458: select 'Y' into l_manual_exists from dual
459: where exists (select 1 from qp_list_lines l
460: where l.automatic_flag = 'N'
461: and l.pricing_phase_id = I.pricing_phase_id
462: and exists (select 'x' from qp_list_headers_b h
463: where l.list_header_id = h.list_header_id
464: and h.active_flag = 'Y'));
465: exception
466: WHEN no_data_found THEN

Line 498: from qp_list_lines l, qp_list_headers_b h

494: /* update qp_pricing_phases I
495: set manual_modifier_flag =
496: (select /*+ ordered use_nl(h) index(l QP_LIST_LINES_N5)
497: decode(min(l.automatic_flag)||max(l.automatic_flag),'YY','A','NN','M','B')
498: from qp_list_lines l, qp_list_headers_b h
499: where l.pricing_phase_id = I.pricing_phase_id
500: and l.list_header_id = h.list_header_id
501: and h.active_flag = 'Y')
502: where pricing_phase_id = nvl(p_pricing_phase_id, pricing_phase_id)

Line 746: from qp_list_lines l, qp_list_headers_b h

742:
743: cursor list_lines_cur(a_list_header_id number,b_list_header_id NUMBER)
744: is
745: select l.list_line_id, l.qualification_ind, h.list_type_code, h.list_header_id
746: from qp_list_lines l, qp_list_headers_b h
747: where l.list_header_id = h.list_header_id
748: and h.active_flag = 'Y'
749: and (h.list_header_id between a_list_header_id and b_list_header_id)
750: order by h.list_header_id; --7321919

Line 756: from qp_list_headers_b

752:
753: cursor list_headers_cur(a_list_header_id NUMBER, b_list_header_id NUMBER)
754: is
755: select list_header_id
756: from qp_list_headers_b
757: where list_header_id between a_list_header_id and b_list_header_id
758: and list_type_code not in ('PRL', 'AGR', 'PML');
759:
760: Phase_Exception Exception;