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_JAVA_ENGINE_CACHE_PVT dependencies on QP_LIST_HEADERS_B

Line 52: FROM qp_list_headers_b

48: FROM qp_cache_stats;
49:
50: CURSOR header_csr IS
51: SELECT count(*)
52: FROM qp_list_headers_b
53: WHERE active_flag = 'Y';
54:
55: CURSOR second_price_list_csr IS
56: SELECT count(*)

Line 57: FROM qp_qualifiers qpq, qp_list_headers_b qph1, qp_list_headers_b qph2

53: WHERE active_flag = 'Y';
54:
55: CURSOR second_price_list_csr IS
56: SELECT count(*)
57: FROM qp_qualifiers qpq, qp_list_headers_b qph1, qp_list_headers_b qph2
58: WHERE qualifier_context = 'MODLIST' and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
59: and qph1.active_flag = 'Y' and qph2.active_flag = 'Y'
60: and qph1.list_header_id = qpq.list_header_id
61: and to_char(qph2.list_header_id) = qpq.qualifier_attr_value

Line 67: FROM qp_attribute_groups qp, qp_list_headers_b qph

63:
64: CURSOR header_attr_csr IS
65: SELECT count(*) FROM (
66: SELECT 1
67: FROM qp_attribute_groups qp, qp_list_headers_b qph
68: WHERE qp.list_line_id = -1 and qph.active_flag = 'Y' and qp.list_header_id(+) = qph.list_header_id UNION ALL
69: SELECT 1
70: FROM qp_list_headers_b qp
71: WHERE qp.active_flag = 'Y' and NOT EXISTS (SELECT * FROM qp_attribute_groups qpg WHERE qpg.list_line_id=-1 and qpg.list_header_id = qp.list_header_id));

Line 70: FROM qp_list_headers_b qp

66: SELECT 1
67: FROM qp_attribute_groups qp, qp_list_headers_b qph
68: WHERE qp.list_line_id = -1 and qph.active_flag = 'Y' and qp.list_header_id(+) = qph.list_header_id UNION ALL
69: SELECT 1
70: FROM qp_list_headers_b qp
71: WHERE qp.active_flag = 'Y' and NOT EXISTS (SELECT * FROM qp_attribute_groups qpg WHERE qpg.list_line_id=-1 and qpg.list_header_id = qp.list_header_id));
72:
73: CURSOR header_ph_csr IS
74: SELECT count(*)

Line 75: FROM (select /+ ordered index(qph qp_list_headers_b_n7) use_nl(qpl) /

71: WHERE qp.active_flag = 'Y' and NOT EXISTS (SELECT * FROM qp_attribute_groups qpg WHERE qpg.list_line_id=-1 and qpg.list_header_id = qp.list_header_id));
72:
73: CURSOR header_ph_csr IS
74: SELECT count(*)
75: FROM (select /*+ ordered index(qph qp_list_headers_b_n7) use_nl(qpl) */
76: distinct qpl.pricing_phase_id, qpl.list_header_id, qph.currency_code
77: FROM qp_list_headers_b qph, qp_list_lines qpl
78: WHERE qph.active_flag = 'Y'
79: and qph.ask_for_flag <> 'Y'

Line 77: FROM qp_list_headers_b qph, qp_list_lines qpl

73: CURSOR header_ph_csr IS
74: SELECT count(*)
75: FROM (select /*+ ordered index(qph qp_list_headers_b_n7) use_nl(qpl) */
76: distinct qpl.pricing_phase_id, qpl.list_header_id, qph.currency_code
77: FROM qp_list_headers_b qph, qp_list_lines qpl
78: WHERE qph.active_flag = 'Y'
79: and qph.ask_for_flag <> 'Y'
80: and qph.list_header_id = qpl.list_header_id);
81:

Line 102: FROM qp_list_headers_b qph, qp_list_lines qpl

98: *****************************************************************/
99:
100: CURSOR line_perm_csr IS
101: SELECT count(*)
102: FROM qp_list_headers_b qph, qp_list_lines qpl
103: WHERE qpl.qualification_ind in (0, 2)
104: and qpl.list_header_id = qph.list_header_id
105: and qph.active_flag = 'Y';
106:

Line 118: SELECT /+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) / count(DISTINCT

114: Cursors for cache-keys
115: *****************************************************************/
116:
117: CURSOR modifier_cache_key_cnt_csr IS
118: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ count(DISTINCT
119: qpl.cache_key)
120: FROM qp_list_headers_b qph, qp_list_lines qpl
121: WHERE qph.active_flag = 'Y'
122: and qph.list_type_code not in ('PML', 'PRL', 'AGR')

Line 120: FROM qp_list_headers_b qph, qp_list_lines qpl

116:
117: CURSOR modifier_cache_key_cnt_csr IS
118: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ count(DISTINCT
119: qpl.cache_key)
120: FROM qp_list_headers_b qph, qp_list_lines qpl
121: WHERE qph.active_flag = 'Y'
122: and qph.list_type_code not in ('PML', 'PRL', 'AGR')
123: and qpl.list_header_id = qph.list_header_id;
124:

Line 126: SELECT /+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) / count(DISTINCT

122: and qph.list_type_code not in ('PML', 'PRL', 'AGR')
123: and qpl.list_header_id = qph.list_header_id;
124:
125: CURSOR price_cache_key_cnt_csr IS
126: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ count(DISTINCT
127: qpl.cache_key)
128: FROM qp_list_headers_b qph, qp_list_lines qpl
129: WHERE qph.active_flag = 'Y'
130: and qph.list_type_code = 'PRL'

Line 128: FROM qp_list_headers_b qph, qp_list_lines qpl

124:
125: CURSOR price_cache_key_cnt_csr IS
126: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ count(DISTINCT
127: qpl.cache_key)
128: FROM qp_list_headers_b qph, qp_list_lines qpl
129: WHERE qph.active_flag = 'Y'
130: and qph.list_type_code = 'PRL'
131: and qpl.list_header_id = qph.list_header_id;
132:

Line 139: FROM qp_list_headers_b qlh

135: FROM qp_price_formulas qpf;
136:
137: CURSOR factor_cache_key_cnt_csr IS
138: SELECT count(*)
139: FROM qp_list_headers_b qlh
140: WHERE qlh.list_type_code = 'PML';
141:
142: CURSOR uom_cache_key_cnt_csr IS
143: SELECT count(*)

Line 150: FROM qp_currency_lists_b qpc, qp_list_headers_b qph

146: and inventory_item_id <> 0;
147:
148: CURSOR currency_cache_key_cnt_csr IS
149: SELECT count(DISTINCT qpc.currency_header_id)
150: FROM qp_currency_lists_b qpc, qp_list_headers_b qph
151: WHERE qph.active_flag = 'Y'
152: and qph.currency_code = qpc.base_currency_code;
153:
154: CURSOR modifier_cache_key_csr IS

Line 155: SELECT /+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) / DISTINCT

151: WHERE qph.active_flag = 'Y'
152: and qph.currency_code = qpc.base_currency_code;
153:
154: CURSOR modifier_cache_key_csr IS
155: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ DISTINCT
156: qpl.cache_key
157: FROM qp_list_headers_b qph, qp_list_lines qpl
158: WHERE qph.active_flag = 'Y'
159: and qph.list_type_code not in ('PML', 'PRL', 'AGR')

Line 157: FROM qp_list_headers_b qph, qp_list_lines qpl

153:
154: CURSOR modifier_cache_key_csr IS
155: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ DISTINCT
156: qpl.cache_key
157: FROM qp_list_headers_b qph, qp_list_lines qpl
158: WHERE qph.active_flag = 'Y'
159: and qph.list_type_code not in ('PML', 'PRL', 'AGR')
160: and qpl.list_header_id = qph.list_header_id
161: and ROWNUM < 200;

Line 164: SELECT /+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) / DISTINCT

160: and qpl.list_header_id = qph.list_header_id
161: and ROWNUM < 200;
162:
163: CURSOR price_cache_key_csr IS
164: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ DISTINCT
165: qpl.cache_key
166: FROM qp_list_headers_b qph, qp_list_lines qpl
167: WHERE qph.active_flag = 'Y'
168: and qph.list_type_code = 'PRL'

Line 166: FROM qp_list_headers_b qph, qp_list_lines qpl

162:
163: CURSOR price_cache_key_csr IS
164: SELECT /*+ ordered use_nl(qpl) index(qph qp_list_headers_b_n7) */ DISTINCT
165: qpl.cache_key
166: FROM qp_list_headers_b qph, qp_list_lines qpl
167: WHERE qph.active_flag = 'Y'
168: and qph.list_type_code = 'PRL'
169: and qpl.list_header_id = qph.list_header_id
170: and ROWNUM < 200;

Line 181: FROM qp_list_headers_b qlh

177:
178: CURSOR factor_cache_key_csr IS
179: SELECT
180: qlh.list_header_id
181: FROM qp_list_headers_b qlh
182: WHERE qlh.list_type_code = 'PML'
183: and ROWNUM < 200;
184:
185: CURSOR uom_cache_key_csr IS

Line 196: FROM qp_currency_lists_b qpc, qp_list_headers_b qph

192:
193: CURSOR currency_cache_key_csr IS
194: SELECT DISTINCT
195: qpc.currency_header_id
196: FROM qp_currency_lists_b qpc, qp_list_headers_b qph
197: WHERE qph.active_flag = 'Y'
198: and qph.currency_code = qpc.base_currency_code
199: and ROWNUM < 200;
200:

Line 207: SELECT /+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) / count(*) c

203: *****************************************************************/
204:
205: CURSOR line_csr(p_cache_key varchar2) IS
206: SELECT sum(c) FROM (
207: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
208: FROM qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
209: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl.cache_key = p_cache_key and qpl.list_line_id = qpa.list_line_id(+)
210: UNION ALL
211: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c

Line 208: FROM qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa

204:
205: CURSOR line_csr(p_cache_key varchar2) IS
206: SELECT sum(c) FROM (
207: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
208: FROM qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
209: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl.cache_key = p_cache_key and qpl.list_line_id = qpa.list_line_id(+)
210: UNION ALL
211: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
212: FROM qp_list_lines qpl2, qp_rltd_modifiers qpr, qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa

Line 211: SELECT /+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) / count(*) c

207: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
208: FROM qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
209: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl.cache_key = p_cache_key and qpl.list_line_id = qpa.list_line_id(+)
210: UNION ALL
211: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
212: FROM qp_list_lines qpl2, qp_rltd_modifiers qpr, qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
213: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl2.cache_key = p_cache_key and qpl2.list_line_id = qpr.from_rltd_modifier_id and qpl.list_line_id = qpr.to_rltd_modifier_id and qpl.list_line_id = qpa.list_line_id(+)
214: );
215:

Line 212: FROM qp_list_lines qpl2, qp_rltd_modifiers qpr, qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa

208: FROM qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
209: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl.cache_key = p_cache_key and qpl.list_line_id = qpa.list_line_id(+)
210: UNION ALL
211: SELECT /*+ ordered use_nl(qph, qpr) index(qph qp_list_headers_b_pk) index(qpa qp_pricing_attributes_n2) */ count(*) c
212: FROM qp_list_lines qpl2, qp_rltd_modifiers qpr, qp_list_lines qpl, qp_list_headers_b qph, qp_pricing_attributes qpa
213: WHERE qph.active_flag = 'Y' and qpl.list_header_id = qph.list_header_id and qpl2.cache_key = p_cache_key and qpl2.list_line_id = qpr.from_rltd_modifier_id and qpl.list_line_id = qpr.to_rltd_modifier_id and qpl.list_line_id = qpa.list_line_id(+)
214: );
215:
216: CURSOR line_attr_grp_csr(p_cache_key varchar2) IS

Line 219: FROM qp_attribute_groups qp, qp_list_headers_b qph

215:
216: CURSOR line_attr_grp_csr(p_cache_key varchar2) IS
217: SELECT sum(c) FROM (
218: SELECT count(*) c
219: FROM qp_attribute_groups qp, qp_list_headers_b qph
220: WHERE qp.pricing_phase_id <> -1 and qph.active_flag = 'Y' and qp.cache_key = p_cache_key and qp.list_header_id = qph.list_header_id
221: UNION ALL
222: SELECT /*+ ordered use_nl(qph) */ count(*) c
223: FROM qp_list_lines qp, qp_list_headers_b qph

Line 223: FROM qp_list_lines qp, qp_list_headers_b qph

219: FROM qp_attribute_groups qp, qp_list_headers_b qph
220: WHERE qp.pricing_phase_id <> -1 and qph.active_flag = 'Y' and qp.cache_key = p_cache_key and qp.list_header_id = qph.list_header_id
221: UNION ALL
222: SELECT /*+ ordered use_nl(qph) */ count(*) c
223: FROM qp_list_lines qp, qp_list_headers_b qph
224: WHERE qph.active_flag = 'Y' and qp.cache_key = p_cache_key and (qp.pattern_id IS not null or (qp.pattern_id is null and qp.qualification_ind in (0, 2))) and qp.list_header_id = qph.list_header_id
225: );
226:
227: CURSOR non_eq_attr_csr(p_cache_key varchar2) IS

Line 230: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq

226:
227: CURSOR non_eq_attr_csr(p_cache_key varchar2) IS
228: SELECT sum(c) FROM (
229: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
230: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq
231: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.pricing_segment_id is not null and qplag.cache_key = p_cache_key and qpaq.comparison_operator_code <> '='
232: UNION ALL
233: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
234: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq

Line 234: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq

230: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq
231: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.pricing_segment_id is not null and qplag.cache_key = p_cache_key and qpaq.comparison_operator_code <> '='
232: UNION ALL
233: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
234: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq
235: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.segment_id is not null and qplag.cache_key = p_cache_key and qpaq.comparison_operator_code <> '='
236: UNION ALL
237: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
238: FROM qp_list_lines qpl, qp_rltd_modifiers qpr, qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq

Line 238: FROM qp_list_lines qpl, qp_rltd_modifiers qpr, qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq

234: FROM qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq
235: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.segment_id is not null and qplag.cache_key = p_cache_key and qpaq.comparison_operator_code <> '='
236: UNION ALL
237: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
238: FROM qp_list_lines qpl, qp_rltd_modifiers qpr, qp_list_lines qplag, qp_list_headers_b qph, qp_pricing_attributes qpaq
239: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.pricing_segment_id is not null and qpl.cache_key = p_cache_key
240: and qpl.list_line_id = qpr.from_rltd_modifier_id and qplag.list_line_id = qpr.to_rltd_modifier_id and qpaq.comparison_operator_code <> '='
241: UNION ALL
242: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c

Line 243: FROM qp_list_lines qpl, qp_rltd_modifiers qpr, qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq

239: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.pricing_segment_id is not null and qpl.cache_key = p_cache_key
240: and qpl.list_line_id = qpr.from_rltd_modifier_id and qplag.list_line_id = qpr.to_rltd_modifier_id and qpaq.comparison_operator_code <> '='
241: UNION ALL
242: SELECT /*+ ordered use_nl(qpr, qph, qpaq) */ count(*) c
243: FROM qp_list_lines qpl, qp_rltd_modifiers qpr, qp_list_lines qplag, qp_list_headers_b qph, qp_qualifiers qpaq
244: WHERE qph.active_flag = 'Y' and qph.list_header_id = qplag.list_header_id and qpaq.list_line_id = qplag.list_line_id and qpaq.segment_id is not null and qpl.cache_key = p_cache_key
245: and qpl.list_line_id = qpr.from_rltd_modifier_id and qplag.list_line_id = qpr.to_rltd_modifier_id and qpaq.comparison_operator_code <> '='
246: );
247:

Line 270: FROM qp_list_headers_b qph, qp_currency_lists_b qpc

266: WHERE price_formula_id = p_cache_key;
267:
268: CURSOR currency_csr(p_cache_key varchar2) IS
269: SELECT count(*)
270: FROM qp_list_headers_b qph, qp_currency_lists_b qpc
271: WHERE qph.active_flag = 'Y' and qpc.currency_header_id = p_cache_key and qph.currency_code = qpc.base_currency_code;
272:
273: -- cursor rewritten for sql repository exercise
274: CURSOR currency_line_csr(p_cache_key varchar2) IS

Line 278: (select 'X' from qp_list_headers_b

274: CURSOR currency_line_csr(p_cache_key varchar2) IS
275: SELECT count(*)
276: FROM qp_currency_details qpd
277: WHERE exists
278: (select 'X' from qp_list_headers_b
279: where list_type_code in ('AGR', 'PRL')
280: and active_flag = 'Y'
281: and currency_header_id = p_cache_key)
282: AND qpd.currency_header_id = p_cache_key;