APPS.QP_UTIL_PUB dependencies on QP_LIST_LINES

Line 470: FROM qp_list_lines a

466: FROM qp_event_phases
467: WHERE pricing_phase_id > 1
468: AND ROWNUM < 7)
469: AND EXISTS (SELECT 'x'
470: FROM qp_list_lines a
471: WHERE a.pricing_phase_id = b.pricing_phase_id
472: AND a.modifier_level_code=p_mod_level_code
473: AND ROWNUM=1)
474: AND ROWNUM=1;

Line 495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a

491: FROM qp_event_phases
492: WHERE pricing_phase_id > 1
493: AND ROWNUM < 7)
494: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
495: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
496: WHERE lhb.pricing_phase_id = b.pricing_phase_id
497: AND qph.list_header_id = lhb.list_header_id
498: AND qph.active_flag = 'Y'
499: AND qprs.request_type_code = p_request_type_code

Line 518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';

514: l_pricing_phase_id NUMBER;
515: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
516: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
517: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
520: l_dummy VARCHAR2(1);
521: BEGIN
522: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;

Line 613: Due to which a query on qp_list_lines was used earlier in

609: Procedure to Determine how many lines to pass to the pricing engine
610: during a manual modifier call. Currently there is no column in
611: qp_pricing_phases that will indicate exclusive presence of a manual
612: linegroup modifier for particular phases.
613: Due to which a query on qp_list_lines was used earlier in
614: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
615: causing performance issue for some customers.
616: Final fix will be to add such a column in qp_pricing_phases table.
617: Meanwhile, this procedure is written to use manual_modifier_flag and

Line 2746: QP_LIST_LINES L,

2742: CURSOR c_check_qpprc_atr IS
2743: SELECT 'X'
2744: FROM
2745: QP_PRICING_ATTRIBUTES A,
2746: QP_LIST_LINES L,
2747: QP_LIST_HEADERS_B QLH
2748: WHERE
2749: A.LIST_HEADER_ID = P_Price_List_Id AND
2750: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND

Line 2807: QP_LIST_LINES L,

2803: CURSOR c_check_qpprc_atr IS
2804: SELECT 'X'
2805: FROM
2806: QP_PRICING_ATTRIBUTES A,
2807: QP_LIST_LINES L,
2808: QP_LIST_HEADERS_B QLH
2809: WHERE
2810: A.LIST_HEADER_ID = P_Price_List_Id AND
2811: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND

Line 2864: QP_LIST_LINES L,

2860: WHERE list_header_id IN (
2861: SELECT FL.price_modifier_list_id
2862: FROM
2863: QP_PRICING_ATTRIBUTES A,
2864: QP_LIST_LINES L,
2865: QP_LIST_HEADERS_B QLH,
2866: QP_PRICE_FORMULA_LINES FL
2867: WHERE
2868: A.LIST_HEADER_ID = P_Price_List_Id AND

Line 2888: QP_LIST_LINES L,

2884: UNION ALL
2885: SELECT DISTINCT FL.pricing_attribute_context, FL.pricing_attribute
2886: FROM
2887: QP_PRICING_ATTRIBUTES A,
2888: QP_LIST_LINES L,
2889: QP_LIST_HEADERS_B QLH,
2890: QP_PRICE_FORMULA_LINES FL
2891: WHERE
2892: A.LIST_HEADER_ID = P_Price_List_Id AND