[Home] [Help]
533: WHERE pricing_phase_id > 1
534: AND ROWNUM < 7) C,
535: QP_EVENT_PHASES B
536: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
537: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' --bug 12677276 14842950
538: FROM qp_list_lines a
539: WHERE a.pricing_phase_id = b.pricing_phase_id
540: AND a.modifier_level_code=p_mod_level_code
541: AND ROWNUM=1)
534: AND ROWNUM < 7) C,
535: QP_EVENT_PHASES B
536: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
537: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' --bug 12677276 14842950
538: FROM qp_list_lines a
539: WHERE a.pricing_phase_id = b.pricing_phase_id
540: AND a.modifier_level_code=p_mod_level_code
541: AND ROWNUM=1)
542: AND ROWNUM=1;
559: FROM qp_event_phases
560: WHERE pricing_phase_id > 1
561: AND ROWNUM < 7)
562: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
563: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
564: WHERE lhb.pricing_phase_id = b.pricing_phase_id
565: AND qph.list_header_id = lhb.list_header_id
566: AND qph.active_flag = 'Y'
567: AND qprs.request_type_code = p_request_type_code
582: l_pricing_phase_id NUMBER;
583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
588: l_dummy VARCHAR2(1);
589: BEGIN
590: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
750: FROM qp_event_phases
751: WHERE pricing_phase_id > 1
752: AND rownum < 7)
753: AND EXISTS (SELECT 'x'
754: FROM qp_list_lines a
755: WHERE a.pricing_phase_id = b.pricing_phase_id
756: AND a.modifier_level_code=p_mod_level_code
757: AND ROWNUM=1)
758: AND ROWNUM=1;*/
776: WHERE pricing_phase_id > 1
777: AND rownum < 7) C,
778: QP_EVENT_PHASES B
779: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
780: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' -- 14842950
781: FROM qp_list_lines a
782: WHERE a.pricing_phase_id = b.pricing_phase_id
783: AND a.modifier_level_code=p_mod_level_code
784: AND ROWNUM=1)
777: AND rownum < 7) C,
778: QP_EVENT_PHASES B
779: WHERE B.PRICING_EVENT_CODE = C.PRICING_EVENT_CD
780: AND EXISTS (SELECT /*+ no_push_subq no_unnest index(a QP_LIST_LINES_N4) */ 'x' -- 14842950
781: FROM qp_list_lines a
782: WHERE a.pricing_phase_id = b.pricing_phase_id
783: AND a.modifier_level_code=p_mod_level_code
784: AND ROWNUM=1)
785: AND ROWNUM=1;
803: FROM qp_event_phases
804: WHERE pricing_phase_id > 1
805: AND ROWNUM < 7)
806: AND EXISTS (SELECT /*+ ORDERED */ 'x' -- [julin/4261562] added active_flag and PTE/SS filters
807: FROM qp_list_header_phases lhb, qp_list_headers_b qph, qp_price_req_sources_v qprs, qp_list_lines a
808: WHERE lhb.pricing_phase_id = b.pricing_phase_id
809: AND qph.list_header_id = lhb.list_header_id
810: AND qph.active_flag = 'Y'
811: AND qprs.request_type_code = p_request_type_code
826: l_pricing_phase_id NUMBER;
827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
830: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
832: l_dummy VARCHAR2(1);
833: x_pass_all_lines varchar2(1):='Y'; -- 9251187
834: l_QP_CUSTOM_HOOK4_ADV_MOD varchar2(1):=nvl(fnd_profile.value('QP_CUSTOM_HOOK_ADV_MOD'),'N'); -- 9251187
934: Procedure to Determine how many lines to pass to the pricing engine
935: during a manual modifier call. Currently there is no column in
936: qp_pricing_phases that will indicate exclusive presence of a manual
937: linegroup modifier for particular phases.
938: Due to which a query on qp_list_lines was used earlier in
939: GET_MANUAL_ADV_STATUS procedure of OEXVADJB package. That cursor is
940: causing performance issue for some customers.
941: Final fix will be to add such a column in qp_pricing_phases table.
942: Meanwhile, this procedure is written to use manual_modifier_flag and
3072: CURSOR c_check_qpprc_atr IS
3073: SELECT 'X'
3074: FROM
3075: QP_PRICING_ATTRIBUTES A,
3076: QP_LIST_LINES L,
3077: QP_LIST_HEADERS_B QLH
3078: WHERE
3079: A.LIST_HEADER_ID = P_Price_List_Id AND
3080: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
3133: CURSOR c_check_qpprc_atr IS
3134: SELECT 'X'
3135: FROM
3136: QP_PRICING_ATTRIBUTES A,
3137: QP_LIST_LINES L,
3138: QP_LIST_HEADERS_B QLH
3139: WHERE
3140: A.LIST_HEADER_ID = P_Price_List_Id AND
3141: A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM' AND
3190: WHERE list_header_id IN (
3191: SELECT FL.price_modifier_list_id
3192: FROM
3193: QP_PRICING_ATTRIBUTES A,
3194: QP_LIST_LINES L,
3195: QP_LIST_HEADERS_B QLH,
3196: QP_PRICE_FORMULA_LINES FL
3197: WHERE
3198: A.LIST_HEADER_ID = P_Price_List_Id AND
3214: UNION ALL
3215: SELECT DISTINCT FL.pricing_attribute_context, FL.pricing_attribute
3216: FROM
3217: QP_PRICING_ATTRIBUTES A,
3218: QP_LIST_LINES L,
3219: QP_LIST_HEADERS_B QLH,
3220: QP_PRICE_FORMULA_LINES FL
3221: WHERE
3222: A.LIST_HEADER_ID = P_Price_List_Id AND