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_PRICING_ATTRIBUTES

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 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 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 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