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 258: FROM qp_pricing_attributes a, qp_list_headers_b b

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

Line 316: UPDATE qp_pricing_attributes

312: IF l_list_header_id_tbl.COUNT > 0 THEN
313: --When pricing attribute datatype is 'N', operator is between and both
314: --pricing_attr_value_from and pricing_attr_value_to are negative.
315: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
316: UPDATE qp_pricing_attributes
317: SET pattern_value_from_negative =
318: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
319: qp_number.number_to_canonical(pricing_attr_value_to_number)),
320: pattern_value_to_negative =

Line 335: UPDATE qp_pricing_attributes

331:
332: --When pricing attribute datatype is 'N', operator is between and both
333: --pricing_attr_value_from and pricing_attr_value_to are positive.
334: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
335: UPDATE qp_pricing_attributes
336: SET pattern_value_from_positive =
337: LEAST(qp_number.number_to_canonical(pricing_attr_value_from_number),
338: qp_number.number_to_canonical(pricing_attr_value_to_number)),
339: pattern_value_to_positive =

Line 354: UPDATE qp_pricing_attributes

350:
351: --When pricing_attr_value_from is negative,pricing_attr_value_to is 0,
352: --operator is between and pricing attribute datatype is 'N'.
353: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
354: UPDATE qp_pricing_attributes
355: SET pattern_value_from_negative =
356: '-' || LTRIM(qp_number.number_to_canonical(0)),
357: pattern_value_to_negative =
358: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 370: UPDATE qp_pricing_attributes

366:
367: --When pricing_attr_value_from is negative,pricing_attr_value_to is
368: --positive, operator is between and pricing attribute datatype is 'N'.
369: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
370: UPDATE qp_pricing_attributes
371: SET pattern_value_from_negative =
372: '-' || LTRIM(qp_number.number_to_canonical(0)),
373: pattern_value_to_negative =
374: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 387: UPDATE qp_pricing_attributes

383:
384: --When operator is '=' and pricing attribute datatype is 'N' and
385: --pricing_attr_value_from is positive.
386: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
387: UPDATE qp_pricing_attributes
388: SET pattern_value_from_positive =
389: qp_number.number_to_canonical(pricing_attr_value_from_number),
390: pattern_value_to_positive =
391: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 402: UPDATE qp_pricing_attributes

398:
399: --When operator is '=' and pricing attribute datatype is 'N' and
400: --pricing_attr_value_from is negative.
401: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
402: UPDATE qp_pricing_attributes
403: SET pattern_value_from_negative =
404: qp_number.number_to_canonical(pricing_attr_value_from_number),
405: pattern_value_to_negative =
406: qp_number.number_to_canonical(pricing_attr_value_from_number),

Line 416: UPDATE qp_pricing_attributes

412: AND pricing_attr_value_from_number < 0;
413:
414: --When pricing attribute datatype is 'X', 'Y' or 'C' and operator is between
415: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
416: UPDATE qp_pricing_attributes
417: SET pattern_value_from_positive =
418: LEAST(pricing_attr_value_from, pricing_attr_value_to),
419: pattern_value_to_positive =
420: GREATEST(pricing_attr_value_from, pricing_attr_value_to),

Line 429: UPDATE qp_pricing_attributes

425: AND list_header_id = l_list_header_id_tbl(k);
426:
427: --When pricing attribute datatype is 'X', 'Y' or 'C' and operator is '='.
428: FORALL k IN l_list_header_id_tbl.FIRST..l_list_header_id_tbl.LAST
429: UPDATE qp_pricing_attributes
430: SET pattern_value_from_positive = pricing_attr_value_from,
431: pattern_value_to_positive = pricing_attr_value_from,
432: pattern_value_from_negative = null,
433: pattern_value_to_negative = null