APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_ATTRIBUTE_GROUPS

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

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(*)
75: FROM (select /*+ ordered index(qph qp_list_headers_b_n7) use_nl(qpl) */

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