APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_QUALIFIERS

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