APPS.QP_PREQ_GRP dependencies on QP_PATTERN_PHASES

Line 37600: qp_pattern_phases qpp

37596: p_pricing_phase_id,
37597: qp.segment_index,
37598: qp.segment_count
37599: FROM qp_patterns qp,
37600: qp_pattern_phases qpp
37601: WHERE qpp.pattern_id = qp.pattern_id
37602: AND qpp.pricing_phase_id = p_pricing_phase_id
37603: AND NVL(qpp.end_date_active,G_MIN_PRICING_DATE) >= G_MIN_PRICING_DATE
37604: AND NVL(qpp.start_date_active, G_MAX_PRICING_DATE) <= G_MAX_PRICING_DATE

Line 37635: FROM (SELECT /*+ index(qpp1 qp_pattern_phases_n1) */ *

37631: SELECT /*+ ORDERED index(attr qp_preq_line_attrs_tmp_n9) */
37632: attr.line_index,
37633: qpp.pattern_id,
37634: sys_connect_by_path(attr.value_from, '|') hash_key
37635: FROM (SELECT /*+ index(qpp1 qp_pattern_phases_n1) */ *
37636: FROM qp_npreq_patrn_phases_tmp qpp1
37637: WHERE qpp1.pricing_phase_id = p_pricing_phase_id) qpp,
37638: (SELECT *
37639: FROM qp_npreq_line_attrs_tmp

Line 37657: FROM (SELECT /*+ index(qpp1 qp_pattern_phases_n1) */ --*

37653: SELECT /*+ ORDERED index(attr qp_preq_line_attrs_tmp_n9) */
37654: /* attr.line_index,
37655: qpp.pattern_id,
37656: sys_connect_by_path(attr.value_from, '|') hash_key
37657: FROM (SELECT /*+ index(qpp1 qp_pattern_phases_n1) */ --*
37658: /* FROM qp_npreq_patrn_phases_tmp qpp1
37659: WHERE qpp1.pricing_phase_id = p_pricing_phase_id) qpp,
37660: qp_npreq_line_attrs_tmp attr
37661: WHERE attr.segment_id = qpp.segment_id