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_LINES

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 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 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 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 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 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 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 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 888: FROM qp_pricing_attributes pa, qp_list_lines ll

884: CURSOR cat_no_prod_mod_csr IS
885: SELECT DISTINCT 'M', category_id
886: FROM mtl_item_categories ic
887: WHERE NOT EXISTS (SELECT 1
888: FROM qp_pricing_attributes pa, qp_list_lines ll
889: WHERE pa.product_attribute_context = 'ITEM' and
890: pa.product_attribute = 'PRICING_ATTRIBUTE1' and
891: pa.product_attr_value = to_char(ic.inventory_item_id) and
892: ll.list_line_id = pa.list_line_id and

Line 899: FROM qp_pricing_attributes pa, qp_list_lines ll

895: CURSOR cat_no_prod_price_csr IS
896: SELECT DISTINCT 'P', category_id
897: FROM mtl_item_categories ic
898: WHERE NOT EXISTS (SELECT 1
899: FROM qp_pricing_attributes pa, qp_list_lines ll
900: WHERE pa.product_attribute_context = 'ITEM' and
901: pa.product_attribute = 'PRICING_ATTRIBUTE1' and
902: pa.product_attr_value = to_char(ic.inventory_item_id) and
903: ll.list_line_id = pa.list_line_id and