APPS.QP_PREQ_GRP dependencies on QP_NPREQ_PATRN_PHASES_TMP

Line 37593: INSERT INTO qp_npreq_patrn_phases_tmp(pattern_id, segment_id, pricing_phase_id, segment_index, segment_count)

37589:
37590: QP_DEBUG_UTIL.tstart('create_pattern', 'create_pattern');
37591:
37592: QP_DEBUG_UTIL.tstart('insert_patrn_phases', 'insert_patrn_phases');
37593: INSERT INTO qp_npreq_patrn_phases_tmp(pattern_id, segment_id, pricing_phase_id, segment_index, segment_count)
37594: SELECT qp.pattern_id,
37595: qp.segment_id,
37596: p_pricing_phase_id,
37597: qp.segment_index,

Line 37608: FROM qp_npreq_patrn_phases_tmp qp1

37604: AND NVL(qpp.start_date_active, G_MAX_PRICING_DATE) <= G_MAX_PRICING_DATE
37605: AND qpp.active_flag = 'Y'
37606: AND NOT EXISTS (
37607: SELECT pattern_id
37608: FROM qp_npreq_patrn_phases_tmp qp1
37609: WHERE qp.pattern_id = qp1.pattern_id
37610: AND ROWNUM < 2
37611: );
37612:

Line 37617: engine_debug(l_routine || 'inserted ' || SQL%ROWCOUNT || ' rows into qp_npreq_patrn_phases_tmp'

37613: QP_DEBUG_UTIL.tstop('insert_patrn_phases');
37614:
37615: IF l_debug = FND_API.G_TRUE
37616: THEN
37617: engine_debug(l_routine || 'inserted ' || SQL%ROWCOUNT || ' rows into qp_npreq_patrn_phases_tmp'
37618: || ' pricing_phase_id = ' || p_pricing_phase_id);
37619: END IF;
37620: qp_debug_util.tstart('insert_line_patrns', 'insert_line_patrns');
37621:

Line 37636: FROM qp_npreq_patrn_phases_tmp qpp1

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
37640: WHERE line_index BETWEEN lower_limit AND upper_limit) attr

Line 37658: /* FROM qp_npreq_patrn_phases_tmp qpp1

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
37662: AND attr.segment_id IS NOT NULL