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_DENORMALIZED_PRICING_ATTRS dependencies on QP_PRICING_ATTRIBUTES

Line 94: --Reset the search_ind value for the factor qp_pricing_attributes initially.

90: --Set the format mask for the canonical form of numbers
91: fnd_number.canonical_mask := '00999999999999999999999.99999999999999999999999999999999999999';
92:
93: IF l_list_header_id_tbl.COUNT > 0 THEN
94: --Reset the search_ind value for the factor qp_pricing_attributes initially.
95: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
96: UPDATE qp_pricing_attributes
97: SET search_ind = null
98: WHERE list_header_id = l_list_header_id_tbl(k);

Line 96: UPDATE qp_pricing_attributes

92:
93: IF l_list_header_id_tbl.COUNT > 0 THEN
94: --Reset the search_ind value for the factor qp_pricing_attributes initially.
95: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
96: UPDATE qp_pricing_attributes
97: SET search_ind = null
98: WHERE list_header_id = l_list_header_id_tbl(k);
99: END IF; --If l_list_header_id_tbl.COUNT > 0
100:

Line 101: --Select those rows from qp_pricing_attributes where the distinct_row_count

97: SET search_ind = null
98: WHERE list_header_id = l_list_header_id_tbl(k);
99: END IF; --If l_list_header_id_tbl.COUNT > 0
100:
101: --Select those rows from qp_pricing_attributes where the distinct_row_count
102: --is the lowest value among the pricing attributes for a given list_line_id.
103: --If multiple such pricing_attributes exist, pick any one.
104: SELECT min(a.pricing_attribute_id), a.list_line_id
105: BULK COLLECT INTO l_pricing_attr_id_tbl, l_list_line_id_tbl

Line 106: FROM qp_pricing_attributes a

102: --is the lowest value among the pricing attributes for a given list_line_id.
103: --If multiple such pricing_attributes exist, pick any one.
104: SELECT min(a.pricing_attribute_id), a.list_line_id
105: BULK COLLECT INTO l_pricing_attr_id_tbl, l_list_line_id_tbl
106: FROM qp_pricing_attributes a
107: WHERE a.distinct_row_count = (SELECT min(b.distinct_row_count)
108: FROM qp_pricing_attributes b
109: WHERE b.list_line_id = a.list_line_id)
110: AND a.list_header_id IN (SELECT list_header_id

Line 108: FROM qp_pricing_attributes b

104: SELECT min(a.pricing_attribute_id), a.list_line_id
105: BULK COLLECT INTO l_pricing_attr_id_tbl, l_list_line_id_tbl
106: FROM qp_pricing_attributes a
107: WHERE a.distinct_row_count = (SELECT min(b.distinct_row_count)
108: FROM qp_pricing_attributes b
109: WHERE b.list_line_id = a.list_line_id)
110: AND a.list_header_id IN (SELECT list_header_id
111: FROM qp_list_headers_b
112: WHERE list_type_code = 'PML'

Line 120: UPDATE qp_pricing_attributes

116:
117: IF l_pricing_attr_id_tbl.COUNT > 0 THEN
118: --For rows selected above update the search_ind to 1.
119: FORALL i IN l_pricing_attr_id_tbl.FIRST..l_pricing_attr_id_tbl.LAST
120: UPDATE qp_pricing_attributes
121: SET search_ind = 1
122: WHERE pricing_attribute_id = l_pricing_attr_id_tbl(i);
123: END IF; --If l_pricing_attr_id_tbl.COUNT > 0
124:

Line 131: UPDATE qp_pricing_attributes

127:
128: IF l_list_line_id_tbl.COUNT > 0 THEN
129: --Update the search_ind to 2 for the remaining rows with 'BETWEEN' operator
130: FORALL j IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
131: UPDATE qp_pricing_attributes
132: SET search_ind = 2
133: WHERE (search_ind <> 1 or search_ind IS NULL)
134: AND list_line_id = l_list_line_id_tbl(j);
135: END IF; --If l_list_line_id_tbl.COUNT > 0

Line 146: from qp_pricing_attributes a

142: --pricing attributes which have search_ind = 2 for each list_line_id
143: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
144: UPDATE qp_list_lines l
145: SET l.group_count = (select count(*)
146: from qp_pricing_attributes a
147: where a.list_line_id = l.list_line_id
148: and a.search_ind = 2)
149: WHERE l.list_header_id = l_list_header_id_tbl(k);
150: END IF; --If l_list_header_id_tbl.COUNT > 0

Line 191: UPDATE qp_pricing_attributes a

187: BEGIN
188: OE_DEBUG_PUB.ADD('Inside QP_Denormalized_Pricing_Attrs :Update_Row_Count');
189: --Do this only for factor list attributes
190: -- Added the hint inside the subquery for bug#3993301
191: UPDATE qp_pricing_attributes a
192: SET a.distinct_row_count =
193: (SELECT /*+ INDEX(aa QP_PRICING_ATTRIBUTES_N6) */ count(*)
194: FROM qp_pricing_attributes aa
195: WHERE aa.pricing_attribute_context = a.pricing_attribute_context

Line 193: (SELECT /+ INDEX(aa QP_PRICING_ATTRIBUTES_N6) / count(*)

189: --Do this only for factor list attributes
190: -- Added the hint inside the subquery for bug#3993301
191: UPDATE qp_pricing_attributes a
192: SET a.distinct_row_count =
193: (SELECT /*+ INDEX(aa QP_PRICING_ATTRIBUTES_N6) */ count(*)
194: FROM qp_pricing_attributes aa
195: WHERE aa.pricing_attribute_context = a.pricing_attribute_context
196: AND aa.pricing_attribute = a.pricing_attribute
197: AND aa.pricing_attr_value_from = a.pricing_attr_value_from

Line 194: FROM qp_pricing_attributes aa

190: -- Added the hint inside the subquery for bug#3993301
191: UPDATE qp_pricing_attributes a
192: SET a.distinct_row_count =
193: (SELECT /*+ INDEX(aa QP_PRICING_ATTRIBUTES_N6) */ count(*)
194: FROM qp_pricing_attributes aa
195: WHERE aa.pricing_attribute_context = a.pricing_attribute_context
196: AND aa.pricing_attribute = a.pricing_attribute
197: AND aa.pricing_attr_value_from = a.pricing_attr_value_from
198: AND nvl(aa.pricing_attr_value_to,'-x') =

Line 256: FROM qp_pricing_attributes a, qp_list_headers_b b

252:
253: INSERT INTO qp_factor_list_attrs
254: (SELECT DISTINCT a.list_header_id,
255: a.pricing_attribute_context, a.pricing_attribute
256: FROM qp_pricing_attributes a, qp_list_headers_b b
257: WHERE a.list_header_id = b.list_header_id
258: AND b.list_type_code = 'PML'
259: AND b.list_header_id BETWEEN
260: l_list_header_id_low AND l_list_header_id_high);

Line 310: UPDATE qp_pricing_attributes

306: IF l_list_header_id_tbl.COUNT > 0 THEN
307: --When pricing attribute datatype is 'N', operator is between and both
308: --pricing_attr_value_from and pricing_attr_value_to are negative.
309: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
310: UPDATE qp_pricing_attributes
311: SET pattern_value_from_negative =
312: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
313: qp_number.number_to_canonical(pricing_attr_value_to_number)),
314: pattern_value_to_negative =

Line 329: UPDATE qp_pricing_attributes

325:
326: --When pricing attribute datatype is 'N', operator is between and both
327: --pricing_attr_value_from and pricing_attr_value_to are positive.
328: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
329: UPDATE qp_pricing_attributes
330: SET pattern_value_from_positive =
331: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
332: qp_number.number_to_canonical(pricing_attr_value_to_number)),
333: pattern_value_to_positive =

Line 348: UPDATE qp_pricing_attributes

344:
345: --When pricing_attr_value_from is negative,pricing_attr_value_to is 0,
346: --operator is between and pricing attribute datatype is 'N'.
347: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
348: UPDATE qp_pricing_attributes
349: SET pattern_value_from_negative =
350: '-' || LTRIM(qp_number.number_to_canonical(0)),
351: pattern_value_to_negative =
352: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 364: UPDATE qp_pricing_attributes

360:
361: --When pricing_attr_value_from is negative,pricing_attr_value_to is
362: --positive, operator is between and pricing attribute datatype is 'N'.
363: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
364: UPDATE qp_pricing_attributes
365: SET pattern_value_from_negative =
366: '-' || LTRIM(qp_number.number_to_canonical(0)),
367: pattern_value_to_negative =
368: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 381: UPDATE qp_pricing_attributes

377:
378: --When operator is '=' and pricing attribute datatype is 'N' and
379: --pricing_attr_value_from is positive.
380: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
381: UPDATE qp_pricing_attributes
382: SET pattern_value_from_positive =
383: qp_number.number_to_canonical(pricing_attr_value_from_number),
384: pattern_value_to_positive =
385: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 396: UPDATE qp_pricing_attributes

392:
393: --When operator is '=' and pricing attribute datatype is 'N' and
394: --pricing_attr_value_from is negative.
395: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
396: UPDATE qp_pricing_attributes
397: SET pattern_value_from_negative =
398: qp_number.number_to_canonical(pricing_attr_value_from_number),
399: pattern_value_to_negative =
400: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 410: UPDATE qp_pricing_attributes

406: AND pricing_attr_value_from_number < 0;
407:
408: --When pricing attribute datatype is 'X', 'Y' or 'C' and operator is between
409: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
410: UPDATE qp_pricing_attributes
411: SET pattern_value_from_positive =
412: LEAST(pricing_attr_value_from, pricing_attr_value_to),
413: pattern_value_to_positive =
414: GREATEST(pricing_attr_value_from, pricing_attr_value_to),

Line 423: UPDATE qp_pricing_attributes

419: AND list_header_id = l_list_header_id_tbl(k);
420:
421: --When pricing attribute datatype is 'X', 'Y' or 'C' and operator is '='.
422: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
423: UPDATE qp_pricing_attributes
424: SET pattern_value_from_positive = pricing_attr_value_from,
425: pattern_value_to_positive = pricing_attr_value_from,
426: pattern_value_from_negative = null,
427: pattern_value_to_negative = null