[Home] [Help]
1759:
1760: INDX,QP_PREQ_GRP.cache_line_qualifiers.l_outer_qual_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
1761: */
1762: -- Changed the cursor l_outer_qual_cur for bug#3002632
1763: -- [julin/4396043/4471795] perform header filter before prod check, go to qp_pricing_attributes
1764: -- before qp_npreq_line_attrs_tmp during prod check.
1765: CURSOR l_OUTER_QUAL_CUR IS
1766: -- Qualifier Only
1767: select /*+ ORDERED USE_NL(qpq qplh qph) index(qpq qp_qualifiers_n4) index(qph qp_list_headers_b_n7) index(qplatq qp_preq_line_attrs_tmp_n2) l_outer_qual_cur_mod */
1834: WHERE pricing_phase_id = p_pricing_phase_id
1835: AND pricing_status_code = G_STATUS_UNCHANGED)
1836: or
1837: qpq.header_quals_exist_flag = G_NO) -- Pure line level qualifiers
1838: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */'x' --added hint 8579312 --3520634 start
1839: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1840: where qp_pa.list_line_id = qpq.list_line_id
1841: and rownum = 1)
1842: OR -- If product defined on line level,select headers for which product matches.
1835: AND pricing_status_code = G_STATUS_UNCHANGED)
1836: or
1837: qpq.header_quals_exist_flag = G_NO) -- Pure line level qualifiers
1838: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */'x' --added hint 8579312 --3520634 start
1839: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1840: where qp_pa.list_line_id = qpq.list_line_id
1841: and rownum = 1)
1842: OR -- If product defined on line level,select headers for which product matches.
1843: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1839: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1840: where qp_pa.list_line_id = qpq.list_line_id
1841: and rownum = 1)
1842: OR -- If product defined on line level,select headers for which product matches.
1843: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1844: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
1845: WHERE c.list_header_id = qpq.list_header_id
1846: AND c.list_line_id = qpq.list_line_id
1847: AND c.pricing_phase_id = p_pricing_phase_id
1840: where qp_pa.list_line_id = qpq.list_line_id
1841: and rownum = 1)
1842: OR -- If product defined on line level,select headers for which product matches.
1843: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1844: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
1845: WHERE c.list_header_id = qpq.list_header_id
1846: AND c.list_line_id = qpq.list_line_id
1847: AND c.pricing_phase_id = p_pricing_phase_id
1848: AND qpprod.context = c.product_attribute_context
1956: WHERE pricing_phase_id = p_pricing_phase_id
1957: AND pricing_status_code = G_STATUS_UNCHANGED)
1958: or
1959: qpq.header_quals_exist_flag = G_NO)
1960: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */'x' --added hint 8579312 --3520634 start
1961: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1962: where qp_pa.list_line_id = qpq.list_line_id
1963: and rownum = 1)
1964: OR -- If product defined on line level,select headers for which product matches.
1957: AND pricing_status_code = G_STATUS_UNCHANGED)
1958: or
1959: qpq.header_quals_exist_flag = G_NO)
1960: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */'x' --added hint 8579312 --3520634 start
1961: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1962: where qp_pa.list_line_id = qpq.list_line_id
1963: and rownum = 1)
1964: OR -- If product defined on line level,select headers for which product matches.
1965: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1961: from qp_pricing_attributes qp_pa -- if no product defined,select the header
1962: where qp_pa.list_line_id = qpq.list_line_id
1963: and rownum = 1)
1964: OR -- If product defined on line level,select headers for which product matches.
1965: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1966: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
1967: WHERE c.list_header_id = qpq.list_header_id
1968: AND c.list_line_id = qpq.list_line_id
1969: AND c.pricing_phase_id = p_pricing_phase_id
1962: where qp_pa.list_line_id = qpq.list_line_id
1963: and rownum = 1)
1964: OR -- If product defined on line level,select headers for which product matches.
1965: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
1966: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
1967: WHERE c.list_header_id = qpq.list_header_id
1968: AND c.list_line_id = qpq.list_line_id
1969: AND c.pricing_phase_id = p_pricing_phase_id
1970: AND qpprod.context = c.product_attribute_context
2079: WHERE pricing_phase_id = p_pricing_phase_id
2080: AND pricing_status_code = G_STATUS_UNCHANGED)
2081: or
2082: qpq.header_quals_exist_flag = G_NO)
2083: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312 --3520634 start
2084: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2085: where qp_pa.list_line_id = qpq.list_line_id
2086: and rownum = 1)
2087: OR -- If product defined on line level,select headers for which product matches.
2080: AND pricing_status_code = G_STATUS_UNCHANGED)
2081: or
2082: qpq.header_quals_exist_flag = G_NO)
2083: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312 --3520634 start
2084: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2085: where qp_pa.list_line_id = qpq.list_line_id
2086: and rownum = 1)
2087: OR -- If product defined on line level,select headers for which product matches.
2088: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2084: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2085: where qp_pa.list_line_id = qpq.list_line_id
2086: and rownum = 1)
2087: OR -- If product defined on line level,select headers for which product matches.
2088: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2089: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
2090: WHERE c.list_header_id = qpq.list_header_id
2091: AND c.list_line_id = qpq.list_line_id
2092: AND c.pricing_phase_id = p_pricing_phase_id
2085: where qp_pa.list_line_id = qpq.list_line_id
2086: and rownum = 1)
2087: OR -- If product defined on line level,select headers for which product matches.
2088: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2089: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
2090: WHERE c.list_header_id = qpq.list_header_id
2091: AND c.list_line_id = qpq.list_line_id
2092: AND c.pricing_phase_id = p_pricing_phase_id
2093: AND qpprod.context = c.product_attribute_context
2205: WHERE pricing_phase_id = p_pricing_phase_id
2206: AND pricing_status_code = G_STATUS_UNCHANGED)
2207: or
2208: qpq.header_quals_exist_flag = G_NO)
2209: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312 --3520634 start
2210: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2211: where qp_pa.list_line_id = qpq.list_line_id
2212: and rownum = 1)
2213: OR -- If product defined on line level,select headers for which product matches.
2206: AND pricing_status_code = G_STATUS_UNCHANGED)
2207: or
2208: qpq.header_quals_exist_flag = G_NO)
2209: and (not exists (select /*+ INDEX (qp_pa,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312 --3520634 start
2210: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2211: where qp_pa.list_line_id = qpq.list_line_id
2212: and rownum = 1)
2213: OR -- If product defined on line level,select headers for which product matches.
2214: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2210: from qp_pricing_attributes qp_pa -- if no product defined,select the header
2211: where qp_pa.list_line_id = qpq.list_line_id
2212: and rownum = 1)
2213: OR -- If product defined on line level,select headers for which product matches.
2214: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2215: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
2216: WHERE c.list_header_id = qpq.list_header_id
2217: AND c.list_line_id = qpq.list_line_id
2218: AND c.pricing_phase_id = p_pricing_phase_id
2211: where qp_pa.list_line_id = qpq.list_line_id
2212: and rownum = 1)
2213: OR -- If product defined on line level,select headers for which product matches.
2214: exists (select /*+ ORDERED USE_NL(qpprod) INDEX (c,QP_PRICING_ATTRIBUTES_N2) */ 'x' --added hint 8579312
2215: FROM qp_pricing_attributes c, qp_npreq_line_attrs_tmp qpprod
2216: WHERE c.list_header_id = qpq.list_header_id
2217: AND c.list_line_id = qpq.list_line_id
2218: AND c.pricing_phase_id = p_pricing_phase_id
2219: AND qpprod.context = c.product_attribute_context
8114: AND NOT EXISTS (select /*+ NO_UNNEST
8115: leading (c)
8116: use_nl (c qpprod)
8117: index (qpprod, QP_PREQ_LINE_ATTRS_TMP_N6)
8118: index(c qp_pricing_attributes_n13) */
8119: 'x'
8120: FROM qp_npreq_line_attrs_tmp qpprod, qp_pricing_attributes c
8121: WHERE c.list_header_id = a.list_header_id -- delete header for which product does
8122: AND c.pricing_phase_id = p_pricing_phase_id -- not match
8116: use_nl (c qpprod)
8117: index (qpprod, QP_PREQ_LINE_ATTRS_TMP_N6)
8118: index(c qp_pricing_attributes_n13) */
8119: 'x'
8120: FROM qp_npreq_line_attrs_tmp qpprod, qp_pricing_attributes c
8121: WHERE c.list_header_id = a.list_header_id -- delete header for which product does
8122: AND c.pricing_phase_id = p_pricing_phase_id -- not match
8123: AND qpprod.context = c.product_attribute_context
8124: AND qpprod.attribute = c.product_attribute
8129: AND qpprod.attribute_type = G_PRODUCT_TYPE
8130: AND c.excluder_flag = G_NO
8131: AND rownum = 1
8132: --UNION
8133: --SELECT /*+ ORDERED USE_NL(d qppric) index(d qp_pricing_attributes_n5) */ 'x'
8134: /*FROM qp_npreq_line_attrs_tmp qpprod,
8135: qp_pricing_attributes d,
8136: qp_preq_line_attrs_tmp qppric
8137: WHERE d.list_header_id = a.list_header_id -- delete header for which product and
8131: AND rownum = 1
8132: --UNION
8133: --SELECT /*+ ORDERED USE_NL(d qppric) index(d qp_pricing_attributes_n5) */ 'x'
8134: /*FROM qp_npreq_line_attrs_tmp qpprod,
8135: qp_pricing_attributes d,
8136: qp_preq_line_attrs_tmp qppric
8137: WHERE d.list_header_id = a.list_header_id -- delete header for which product and
8138: AND d.pricing_phase_id = p_pricing_phase_id -- pricing attrbutes do not match
8139: AND d.QUALIFICATION_IND in (G_YES_PROD_PRIC_HDR_QUAL_IND, G_YES_PRIC_HDR_LINE_QUAL_IND)
10560:
10561: l_routine VARCHAR2(30) := 'Process_Line_Group';
10562:
10563: CURSOR line_grp_cur IS
10564: select /*+ ORDERED USE_NL(c a ) index(a qp_pricing_attributes_n2) line_grp_cur */
10565: b.created_from_list_line_id list_line_id , c.context , c.attribute ,
10566: sum(qp_number.canonical_to_number(c.value_from)) group_value
10567: from
10568: qp_npreq_ldets_tmp b , qp_npreq_line_attrs_tmp c , qp_pricing_attributes a
10564: select /*+ ORDERED USE_NL(c a ) index(a qp_pricing_attributes_n2) line_grp_cur */
10565: b.created_from_list_line_id list_line_id , c.context , c.attribute ,
10566: sum(qp_number.canonical_to_number(c.value_from)) group_value
10567: from
10568: qp_npreq_ldets_tmp b , qp_npreq_line_attrs_tmp c , qp_pricing_attributes a
10569: where
10570: b.modifier_level_code = G_LINE_GROUP
10571: and b.pricing_phase_id = p_pricing_phase_id
10572: and c.pricing_status_code = G_STATUS_UNCHANGED
11707: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
11708:
11709: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
11710:
11711: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE_CONTEXT,1
11712: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE,2
11713:
11714: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
11715: */
11708:
11709: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
11710:
11711: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE_CONTEXT,1
11712: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE,2
11713:
11714: INDX,QP_PREQ_GRP.handle_break.l_price_break_detail_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
11715: */
11716:
11768: FROM
11769: qp_npreq_line_attrs_tmp qplat_pricing,
11770: qp_npreq_lines_tmp qplines,
11771: qp_rltd_modifiers qprm,
11772: qp_pricing_attributes qppa,
11773: qp_list_lines qpll
11774: ,qp_list_headers_b qph /* Vivek */
11775: ,qp_currency_details qcdt /* Vivek */
11776: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11901: FROM
11902: qp_npreq_line_attrs_tmp qplat_pricing,
11903: qp_npreq_lines_tmp qplines,
11904: qp_rltd_modifiers qprm,
11905: qp_pricing_attributes qppa,
11906: qp_list_lines qpll
11907: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11908: AND qprm.to_rltd_modifier_id = qppa.list_line_id
11909: AND qppa.list_line_id = qpll.list_line_id
13608: and b.rltd_modifier_grp_type <> 'COUPON') -- 5439022
13609: GROUP BY a.LIST_HEADER_ID , a.LIST_LINE_ID,a.LINE_INDEX;
13610:
13611: /*
13612: INDX,QP_PREQ_GRP.perform_grouping.product_level_setup_attrs_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
13613: INDX,QP_PREQ_GRP.perform_grouping.product_level_setup_attrs_cur,QP_PRICING_ATTRIBUTES_N2,EXCLUDER_FLAG,2
13614: */
13615: CURSOR product_level_setup_attrs_cur(p_list_line_id NUMBER) IS
13616: SELECT COUNT(*) NO_OF_PATTS_IN_GRP
13609: GROUP BY a.LIST_HEADER_ID , a.LIST_LINE_ID,a.LINE_INDEX;
13610:
13611: /*
13612: INDX,QP_PREQ_GRP.perform_grouping.product_level_setup_attrs_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
13613: INDX,QP_PREQ_GRP.perform_grouping.product_level_setup_attrs_cur,QP_PRICING_ATTRIBUTES_N2,EXCLUDER_FLAG,2
13614: */
13615: CURSOR product_level_setup_attrs_cur(p_list_line_id NUMBER) IS
13616: SELECT COUNT(*) NO_OF_PATTS_IN_GRP
13617: FROM QP_PRICING_ATTRIBUTES a
13613: INDX,QP_PREQ_GRP.perform_grouping.product_level_setup_attrs_cur,QP_PRICING_ATTRIBUTES_N2,EXCLUDER_FLAG,2
13614: */
13615: CURSOR product_level_setup_attrs_cur(p_list_line_id NUMBER) IS
13616: SELECT COUNT(*) NO_OF_PATTS_IN_GRP
13617: FROM QP_PRICING_ATTRIBUTES a
13618: WHERE a.LIST_LINE_ID = p_list_line_id
13619: AND a.EXCLUDER_FLAG <> G_YES;
13620: --AND a.PRICING_ATTRIBUTE_CONTEXT IS NOT NULL
13621: --GROUP BY LIST_LINE_ID,ATTRIBUTE_GROUPING_NO;
14707: AND QUALIFIER_CONTEXT <> 'MODLIST'
14708: AND QUALIFIER_ATTRIBUTE <> 'QUALIFIER_ATTRIBUTE4'
14709: AND ROWNUM = 1);
14710: /*
14711: INDX,QP_PREQ_GRP.update_price_list_information.update_price_list_information_sel4,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
14712: INDX,QP_PREQ_GRP.update_price_list_information.update_price_list_information_sel4,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
14713: */
14714:
14715: UPDATE qp_npreq_lines_tmp a
14708: AND QUALIFIER_ATTRIBUTE <> 'QUALIFIER_ATTRIBUTE4'
14709: AND ROWNUM = 1);
14710: /*
14711: INDX,QP_PREQ_GRP.update_price_list_information.update_price_list_information_sel4,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
14712: INDX,QP_PREQ_GRP.update_price_list_information.update_price_list_information_sel4,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
14713: */
14714:
14715: UPDATE qp_npreq_lines_tmp a
14716: SET pricing_attrs_exist_flag = G_YES
14716: SET pricing_attrs_exist_flag = G_YES
14717: WHERE price_list_header_id IS NOT NULL
14718: AND EXISTS
14719: (SELECT 'x'
14720: FROM QP_PRICING_ATTRIBUTES
14721: WHERE LIST_HEADER_ID = a.PRICE_LIST_HEADER_ID
14722: AND QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
14723: AND ROWNUM = 1) ;
14724: END IF;
14861: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
14862: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
14863: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
14864:
14865: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14862: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
14863: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
14864:
14865: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14863: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
14864:
14865: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14864:
14865: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14865: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14873:
14866: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14873:
14874: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
14867: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14873:
14874: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
14875:
14868: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
14869: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
14870: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
14871: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
14872: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
14873:
14874: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
14875:
14876: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
14886: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
14887: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
14888: */
14889: CURSOR L_SEC_LIST_CUR IS
14890: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) l_sec_list_cur */
14891: QPLAT_PROD.LINE_INDEX,
14892: QPL.LIST_LINE_ID,
14893: QPL.ARITHMETIC_OPERATOR,
14894: QPL.OPERAND,
14942: FROM
14943: qp_npreq_lines_tmp QPLINES,
14944: QP_QUALIFIERS QPQ,
14945: qp_npreq_line_attrs_tmp QPLAT_PROD,
14946: QP_PRICING_ATTRIBUTES QPA,
14947: QP_LIST_LINES QPL,
14948: QP_LIST_HEADERS_B QPH,
14949: --QP_PRICE_REQ_SOURCES QPRS
14950: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
15007: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
15008: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15009: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15010: UNION ALL
15011: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15012: QPLAT_PROD.LINE_INDEX,
15013: QPL.LIST_LINE_ID,
15014: QPL.ARITHMETIC_OPERATOR,
15015: QPL.OPERAND,
15063: FROM
15064: qp_npreq_lines_tmp qplines,
15065: QP_QUALIFIERS qpq,
15066: qp_npreq_line_attrs_tmp qplat_prod,
15067: QP_PRICING_ATTRIBUTES qpa,
15068: qp_npreq_line_attrs_tmp qplat_pric,
15069: QP_LIST_LINES qpl,
15070: QP_LIST_HEADERS_B qph,
15071: --QP_PRICE_REQ_SOURCES qprs
15134: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
15135: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15136: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15137: UNION ALL
15138: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) l_sec_list_cur */
15139: QPLAT_PROD.LINE_INDEX,
15140: QPL.LIST_LINE_ID,
15141: QPL.ARITHMETIC_OPERATOR,
15142: QPL.OPERAND,
15192: QP_QUALIFIERS QPQ,
15193: QP_QUALIFIERS QPSQ,
15194: qp_npreq_line_attrs_tmp QPLAT_PROD,
15195: qp_npreq_line_attrs_tmp QPLAT_Q,
15196: QP_PRICING_ATTRIBUTES QPA,
15197: QP_LIST_LINES QPL,
15198: QP_LIST_HEADERS_B QPH,
15199: --QP_PRICE_REQ_SOURCES QPRS
15200: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
15275: AND G_QUALIFY_SECONDARY = G_YES
15276: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
15277: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15278: UNION ALL
15279: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n2) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15280: QPLAT_PROD.LINE_INDEX,
15281: QPL.LIST_LINE_ID,
15282: QPL.ARITHMETIC_OPERATOR,
15283: QPL.OPERAND,
15332: qp_npreq_lines_tmp qplines,
15333: QP_QUALIFIERS qpq,
15334: QP_QUALIFIERS qpsq,
15335: qp_npreq_line_attrs_tmp qplat_prod,
15336: QP_PRICING_ATTRIBUTES qpa,
15337: qp_npreq_line_attrs_tmp qplat_pric,
15338: qp_npreq_line_attrs_tmp qplat_q,
15339: QP_LIST_LINES qpl,
15340: QP_LIST_HEADERS_B qph,
15426:
15427: -- vivek
15428: --[julin/4865213] using qp_list_headers_b_n7 instead of qp_list_headers_b_n2
15429: CURSOR L_SEC_LIST_CUR_CURRENCY IS
15430: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_sec_list_cur */
15431: QPLAT_PROD.LINE_INDEX,
15432: QPL.LIST_LINE_ID,
15433: QPL.ARITHMETIC_OPERATOR,
15434: QPL.OPERAND,
15489: FROM
15490: qp_npreq_lines_tmp QPLINES,
15491: QP_QUALIFIERS QPQ,
15492: qp_npreq_line_attrs_tmp QPLAT_PROD,
15493: QP_PRICING_ATTRIBUTES QPA,
15494: QP_LIST_LINES QPL,
15495: QP_LIST_HEADERS_B QPH,
15496: --QP_PRICE_REQ_SOURCES QPRS,
15497: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15607: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
15608: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15609: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15610: UNION ALL
15611: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
15612: QPLAT_PROD.LINE_INDEX,
15613: QPL.LIST_LINE_ID,
15614: QPL.ARITHMETIC_OPERATOR,
15615: QPL.OPERAND,
15670: FROM
15671: qp_npreq_lines_tmp qplines,
15672: QP_QUALIFIERS qpq,
15673: qp_npreq_line_attrs_tmp qplat_prod,
15674: QP_PRICING_ATTRIBUTES qpa,
15675: qp_npreq_line_attrs_tmp qplat_pric,
15676: QP_LIST_LINES qpl,
15677: QP_LIST_HEADERS_B qph,
15678: --QP_PRICE_REQ_SOURCES qprs,
15794: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
15795: AND QPLINES.PROCESSED_CODE = G_STS_LHS_NOT_FOUND
15796: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
15797: UNION ALL
15798: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPL QPH) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_sec_list_cur */
15799: QPLAT_PROD.LINE_INDEX,
15800: QPL.LIST_LINE_ID,
15801: QPL.ARITHMETIC_OPERATOR,
15802: QPL.OPERAND,
15859: QP_QUALIFIERS QPQ,
15860: QP_QUALIFIERS QPSQ,
15861: qp_npreq_line_attrs_tmp QPLAT_PROD,
15862: qp_npreq_line_attrs_tmp QPLAT_Q,
15863: QP_PRICING_ATTRIBUTES QPA,
15864: QP_LIST_LINES QPL,
15865: QP_LIST_HEADERS_B QPH,
15866: --QP_PRICE_REQ_SOURCES QPRS,
15867: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15995: AND G_QUALIFY_SECONDARY = G_YES
15996: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
15997: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPSQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
15998: UNION ALL
15999: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) index(qplat_pric qp_preq_line_attrs_tmp_n2) l_sec_list_cur */
16000: QPLAT_PROD.LINE_INDEX,
16001: QPL.LIST_LINE_ID,
16002: QPL.ARITHMETIC_OPERATOR,
16003: QPL.OPERAND,
16059: qp_npreq_lines_tmp qplines,
16060: QP_QUALIFIERS qpq,
16061: QP_QUALIFIERS qpsq,
16062: qp_npreq_line_attrs_tmp qplat_prod,
16063: QP_PRICING_ATTRIBUTES qpa,
16064: qp_npreq_line_attrs_tmp qplat_pric,
16065: qp_npreq_line_attrs_tmp qplat_q,
16066: QP_LIST_LINES qpl,
16067: QP_LIST_HEADERS_B qph,
17101: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
17102: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
17103: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17104:
17105: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17102: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
17103: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17104:
17105: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17103: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17104:
17105: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17104:
17105: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17105: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17113:
17106: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17113:
17114: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17107: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17113:
17114: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17115:
17108: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17109: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17110: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17111: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17112: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17113:
17114: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17115:
17116: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17118: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17119: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17120: */
17121: CURSOR L_LIST_CUR IS
17122: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_cur */
17123: QPLAT_PROD.LINE_INDEX,
17124: QPL.LIST_LINE_ID,
17125: QPL.ARITHMETIC_OPERATOR,
17126: QPL.OPERAND,
17160: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
17161: FROM
17162: qp_npreq_lines_tmp QPLINES,
17163: qp_npreq_line_attrs_tmp qplat_prod,
17164: QP_PRICING_ATTRIBUTES QPA,
17165: QP_LIST_LINES QPL,
17166: QP_LIST_HEADERS_B QPH,
17167: --QP_PRICE_REQ_SOURCES qprs
17168: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17223: AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX
17224: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17225: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
17226: UNION ALL
17227: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) dynamic_sampling(1) l_list_cur */
17228: QPLAT_PROD.LINE_INDEX,
17229: QPL.LIST_LINE_ID,
17230: QPL.ARITHMETIC_OPERATOR,
17231: QPL.OPERAND,
17265: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
17266: FROM
17267: qp_npreq_lines_tmp qplines,
17268: qp_npreq_line_attrs_tmp qplat_prod,
17269: QP_PRICING_ATTRIBUTES qpa,
17270: qp_npreq_line_attrs_tmp qplat_pric,
17271: QP_LIST_LINES qpl,
17272: QP_LIST_HEADERS_B qph,
17273: --QP_PRICE_REQ_SOURCES qprs
17341: ORDER BY 1,2; --ORDER BY LINE_INDEX AND LIST LINE ID
17342:
17343: -- vivek
17344: CURSOR L_LIST_CUR_CURRENCY IS
17345: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5)
17346: index(qplat_prod qp_preq_line_attrs_tmp_n1) index(QPLINES QP_PREQ_LINES_TMP_N2) l_list_cur */ -- 9362867
17347: QPLAT_PROD.LINE_INDEX,
17348: QPL.LIST_LINE_ID,
17349: QPL.ARITHMETIC_OPERATOR,
17391: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
17392: FROM
17393: qp_npreq_lines_tmp QPLINES,
17394: qp_npreq_line_attrs_tmp qplat_prod,
17395: QP_PRICING_ATTRIBUTES QPA,
17396: QP_LIST_LINES QPL,
17397: QP_LIST_HEADERS_B QPH,
17398: --QP_PRICE_REQ_SOURCES qprs,
17399: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17499: AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX
17500: AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17501: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
17502: UNION ALL
17503: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) l_list_cur */
17504: QPLAT_PROD.LINE_INDEX,
17505: QPL.LIST_LINE_ID,
17506: QPL.ARITHMETIC_OPERATOR,
17507: QPL.OPERAND,
17548: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
17549: FROM
17550: qp_npreq_lines_tmp qplines,
17551: qp_npreq_line_attrs_tmp qplat_prod,
17552: QP_PRICING_ATTRIBUTES qpa,
17553: qp_npreq_line_attrs_tmp qplat_pric,
17554: QP_LIST_LINES qpl,
17555: QP_LIST_HEADERS_B qph,
17556: --QP_PRICE_REQ_SOURCES qprs,
17684: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
17685: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
17686: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
17687:
17688: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
17689: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
17690: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,PRICING_PHASE_ID,3
17691: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_LINE_ID,4
17692:
17685: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
17686: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
17687:
17688: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
17689: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
17690: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,PRICING_PHASE_ID,3
17691: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_LINE_ID,4
17692:
17693: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
17686: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
17687:
17688: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
17689: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
17690: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,PRICING_PHASE_ID,3
17691: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_LINE_ID,4
17692:
17693: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
17694: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
17687:
17688: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_HEADER_ID,1
17689: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,QUALIFICATION_IND,2
17690: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,PRICING_PHASE_ID,3
17691: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N6,LIST_LINE_ID,4
17692:
17693: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
17694: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
17695: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
17700:
17701: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17702: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17703:
17704: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17701: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17702: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17703:
17704: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17702: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17703:
17704: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17703:
17704: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17704: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17712: */
17705: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17712: */
17713: CURSOR L_LIST_QUAL_CUR IS
17706: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17712: */
17713: CURSOR L_LIST_QUAL_CUR IS
17714: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_qual_cur */
17707: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
17708: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
17709: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17712: */
17713: CURSOR L_LIST_QUAL_CUR IS
17714: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_qual_cur */
17715: QPLAT_PROD.LINE_INDEX,
17710: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
17711: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
17712: */
17713: CURSOR L_LIST_QUAL_CUR IS
17714: SELECT /*+ ORDERED USE_NL(QPQ QPLAT_Q QPLAT_PROD QPA QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_qual_cur */
17715: QPLAT_PROD.LINE_INDEX,
17716: QPL.LIST_LINE_ID,
17717: QPL.ARITHMETIC_OPERATOR,
17718: QPL.OPERAND,
17766: qp_npreq_lines_tmp QPLINES,
17767: QP_QUALIFIERS QPQ,
17768: qp_npreq_line_attrs_tmp QPLAT_Q,
17769: qp_npreq_line_attrs_tmp QPLAT_PROD,
17770: QP_PRICING_ATTRIBUTES QPA,
17771: QP_LIST_LINES QPL,
17772: QP_LIST_HEADERS_B QPH,
17773: --QP_PRICE_REQ_SOURCES QPRS
17774: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17837: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
17838: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
17839: UNION ALL
17840: SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2)
17841: INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) dynamic_sampling(1) l_list_qual_cur */
17842: QPLAT_PROD.LINE_INDEX,
17843: QPL.LIST_LINE_ID,
17844: QPL.ARITHMETIC_OPERATOR,
17845: QPL.OPERAND,
17893: qp_npreq_lines_tmp QPLINES,
17894: QP_QUALIFIERS QPQ,
17895: qp_npreq_line_attrs_tmp QPLAT_Q,
17896: qp_npreq_line_attrs_tmp QPLAT_PROD,
17897: QP_PRICING_ATTRIBUTES QPA,
17898: qp_npreq_line_attrs_tmp QPLAT_PRIC,
17899: QP_LIST_LINES QPL,
17900: QP_LIST_HEADERS_B QPH,
17901: --QP_PRICE_REQ_SOURCES QPRS
17973: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
17974: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
17975: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
17976: UNION ALL
17977: SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_cur */
17978: QPLAT_PROD.LINE_INDEX,
17979: QPL.LIST_LINE_ID,
17980: QPL.ARITHMETIC_OPERATOR,
17981: QPL.OPERAND,
18027: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
18028: FROM
18029: qp_npreq_lines_tmp QPLINES,
18030: qp_npreq_line_attrs_tmp qplat_prod,
18031: QP_PRICING_ATTRIBUTES QPA,
18032: QP_LIST_LINES QPL,
18033: QP_LIST_HEADERS_B QPH,
18034: --QP_PRICE_REQ_SOURCES qprs
18035: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
18075: AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX
18076: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18077: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
18078: UNION ALL
18079: SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) dynamic_sampling(1) l_list_cur */
18080: QPLAT_PROD.LINE_INDEX,
18081: QPL.LIST_LINE_ID,
18082: QPL.ARITHMETIC_OPERATOR,
18083: QPL.OPERAND,
18129: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
18130: FROM
18131: qp_npreq_lines_tmp qplines,
18132: qp_npreq_line_attrs_tmp qplat_prod,
18133: QP_PRICING_ATTRIBUTES qpa,
18134: qp_npreq_line_attrs_tmp qplat_pric,
18135: QP_LIST_LINES qpl,
18136: QP_LIST_HEADERS_B qph,
18137: --QP_PRICE_REQ_SOURCES qprs
18252: qp_npreq_lines_tmp QPLINES,
18253: QP_QUALIFIERS QPQ,
18254: qp_npreq_line_attrs_tmp QPLAT_Q,
18255: qp_npreq_line_attrs_tmp QPLAT_PROD,
18256: QP_PRICING_ATTRIBUTES QPA,
18257: QP_LIST_LINES QPL,
18258: QP_LIST_HEADERS_B QPH,
18259: --QP_PRICE_REQ_SOURCES QPRS,
18260: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18374: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
18375: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
18376: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
18377: UNION ALL
18378: SELECT /*+ ORDERED USE_NL(QPLINES QPQ QPLAT_Q QPLAT_PROD QPA QPLAT_PRIC QPL QPH) INDEX(QPQ QP_QUALIFIERS_N1) INDEX(QPLAT_Q qp_preq_line_attrs_tmp_N2) INDEX(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_qual_cur */
18379: QPLAT_PROD.LINE_INDEX,
18380: QPL.LIST_LINE_ID,
18381: QPL.ARITHMETIC_OPERATOR,
18382: QPL.OPERAND,
18437: qp_npreq_lines_tmp QPLINES,
18438: QP_QUALIFIERS QPQ,
18439: qp_npreq_line_attrs_tmp QPLAT_Q,
18440: qp_npreq_line_attrs_tmp QPLAT_PROD,
18441: QP_PRICING_ATTRIBUTES QPA,
18442: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18443: QP_LIST_LINES QPL,
18444: QP_LIST_HEADERS_B QPH,
18445: --QP_PRICE_REQ_SOURCES QPRS,
18568: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
18569: AND ((nvl(QPLAT_Q.DERIVED_QUALIFIER_FLAG,'N')='N')
18570: OR (QPLAT_Q.DERIVED_QUALIFIER_FLAG = 'Y' AND QPQ.QUALIFY_HIER_DESCENDENTS_FLAG = 'Y')) -- Added for TCA
18571: UNION ALL
18572: SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) l_list_cur */
18573: QPLAT_PROD.LINE_INDEX,
18574: QPL.LIST_LINE_ID,
18575: QPL.ARITHMETIC_OPERATOR,
18576: QPL.OPERAND,
18629: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
18630: FROM
18631: qp_npreq_lines_tmp QPLINES,
18632: qp_npreq_line_attrs_tmp qplat_prod,
18633: QP_PRICING_ATTRIBUTES QPA,
18634: QP_LIST_LINES QPL,
18635: QP_LIST_HEADERS_B QPH,
18636: --QP_PRICE_REQ_SOURCES qprs,
18637: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18731: AND QPLAT_PROD.LINE_INDEX = QPLINES.LINE_INDEX
18732: --AND QPL.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18733: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
18734: UNION ALL
18735: SELECT /*+ ORDERED USE_NL(QPLINES QPLAT_PROD QPA QPLAT_PRIC QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) INDEX(QPLAT_PRIC qp_preq_line_attrs_tmp_N2) l_list_cur */
18736: QPLAT_PROD.LINE_INDEX,
18737: QPL.LIST_LINE_ID,
18738: QPL.ARITHMETIC_OPERATOR,
18739: QPL.OPERAND,
18792: ,QPL.PRICE_BREAK_TYPE_CODE --[julin] for price book
18793: FROM
18794: qp_npreq_lines_tmp qplines,
18795: qp_npreq_line_attrs_tmp qplat_prod,
18796: QP_PRICING_ATTRIBUTES qpa,
18797: qp_npreq_line_attrs_tmp qplat_pric,
18798: QP_LIST_LINES qpl,
18799: QP_LIST_HEADERS_B qph,
18800: --QP_PRICE_REQ_SOURCES qprs,
18955:
18956: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
18957: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
18958:
18959: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18956: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
18957: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
18958:
18959: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18957: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
18958:
18959: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18965: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18958:
18959: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18965: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18966:
18959: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18965: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18966:
18967: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
18960: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18965: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18966:
18967: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
18968: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
18961: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
18962: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
18963: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18964: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18965: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18966:
18967: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
18968: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
18969:
18968: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
18969:
18970: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
18971:
18972: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE_CONTEXT,1
18973: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE,2
18974: */
18975:
18976: CURSOR L_OTHER_LIST_CUR (L_LINE_INDEX PLS_INTEGER,
18969:
18970: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
18971:
18972: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE_CONTEXT,1
18973: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE,2
18974: */
18975:
18976: CURSOR L_OTHER_LIST_CUR (L_LINE_INDEX PLS_INTEGER,
18977: L_LIST_HEADER_ID NUMBER,
18975:
18976: CURSOR L_OTHER_LIST_CUR (L_LINE_INDEX PLS_INTEGER,
18977: L_LIST_HEADER_ID NUMBER,
18978: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
18979: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_other_list_cur */
18980: QPLINES.LINE_INDEX,
18981: QPL.LIST_LINE_ID,
18982: QPL.ARITHMETIC_OPERATOR,
18983: QPL.OPERAND,
19030: NULL PRICING_ATTRIBUTE_DATATYPE
19031: FROM
19032: qp_npreq_lines_tmp QPLINES,
19033: qp_npreq_line_attrs_tmp QPLAT_PROD,
19034: QP_PRICING_ATTRIBUTES QPA,
19035: QP_LIST_HEADERS_B QPH,
19036: QP_LIST_LINES QPL,
19037: QP_PRICE_REQ_SOURCES_V QPRS
19038: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
19092: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
19093: AND QPH.ACTIVE_FLAG = G_YES
19094: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19095: UNION ALL
19096: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPLAT_PRIC QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_other_list_cur */
19097: QPLINES.LINE_INDEX,
19098: QPL.LIST_LINE_ID,
19099: QPL.ARITHMETIC_OPERATOR,
19100: QPL.OPERAND,
19147: QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE
19148: FROM
19149: qp_npreq_lines_tmp QPLINES,
19150: qp_npreq_line_attrs_tmp QPLAT_PROD,
19151: QP_PRICING_ATTRIBUTES QPA,
19152: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19153: QP_LIST_HEADERS_B QPH,
19154: QP_LIST_LINES QPL,
19155: QP_PRICE_REQ_SOURCES QPRS
19223:
19224: CURSOR L_OTHER_LIST_LINE_CUR (L_LINE_INDEX PLS_INTEGER,
19225: L_LIST_LINE_ID NUMBER,
19226: P_FREEZE_OVERRIDE_FLAG VARCHAR2)IS
19227: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH ) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_other_list_line_cur */
19228: QPLINES.LINE_INDEX,
19229: QPL.LIST_LINE_ID,
19230: QPL.ARITHMETIC_OPERATOR,
19231: QPL.OPERAND,
19278: NULL PRICING_ATTRIBUTE_DATATYPE
19279: FROM
19280: qp_npreq_lines_tmp QPLINES,
19281: qp_npreq_line_attrs_tmp QPLAT_PROD,
19282: QP_PRICING_ATTRIBUTES QPA,
19283: QP_LIST_HEADERS_B QPH,
19284: QP_LIST_LINES QPL,
19285: QP_PRICE_REQ_SOURCES QPRS
19286: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
19340: AND QPLINES.REQUEST_TYPE_CODE = QPRS.REQUEST_TYPE_CODE
19341: AND QPH.ACTIVE_FLAG = G_YES
19342: AND QPLAT_PROD.PRICING_STATUS_CODE = G_STATUS_UNCHANGED
19343: UNION ALL
19344: SELECT /*+ ORDERED USE_NL(QPLATP_PROD QPA QPLAT_PRIC QPH QPL QPRS) index(QPA QP_PRICING_ATTRIBUTES_N5) index(qplat_pric qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_other_list_line_cur */
19345: QPLINES.LINE_INDEX,
19346: QPL.LIST_LINE_ID,
19347: QPL.ARITHMETIC_OPERATOR,
19348: QPL.OPERAND,
19395: QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE
19396: FROM
19397: qp_npreq_lines_tmp QPLINES,
19398: qp_npreq_line_attrs_tmp QPLAT_PROD,
19399: QP_PRICING_ATTRIBUTES QPA,
19400: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19401: QP_LIST_HEADERS_B QPH,
19402: QP_LIST_LINES QPL,
19403: QP_PRICE_REQ_SOURCES QPRS
25468: /*
25469: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25474: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25475: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25476:
25469: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25474: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25475: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25476:
25477: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25470: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25474: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25475: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25476:
25477: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25478: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
25471:
25472: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25473: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25474: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25475: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25476:
25477: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25478: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
25479: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_cur,qp_npreq_line_attrs_tmp_N2,CONTEXT,3
25487: */
25488:
25489: CURSOR l_prod_qual_cur (p_pricing_phase_id NUMBER, p_list_header_id NUMBER, p_list_line_id NUMBER, p_line_index NUMBER) IS
25490: -- Product and Qualifier Only. No pricing
25491: select /*+ ORDERED USE_NL(QPPROD QPLATPR QPL ) index(QPPROD QP_PRICING_ATTRIBUTES_N7) index(qplatpr qp_preq_line_attrs_tmp_n2) l_prod_qual_cur_mod */
25492: qpl.list_header_id,
25493: qpl.list_line_id,
25494: qpl.list_line_type_code,
25495: qplatpr.line_index,
25542: where pricing_status_code = G_STATUS_UNCHANGED
25543: and pricing_phase_id = p_pricing_phase_id
25544: and search_ind = 1
25545: and list_line_id > 0 ) qpq,
25546: qp_pricing_attributes qpprod,
25547: qp_npreq_line_attrs_tmp qplatpr,
25548: qp_list_lines qpl,
25549: qp_npreq_lines_tmp qplines
25550: where
25578: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25579: or
25580: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25581: union all
25582: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPL) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_n1) l_prod_qual_cur_mod */
25583: qpl.list_header_id,
25584: qpl.list_line_id,
25585: qpl.list_line_type_code,
25586: qplatpr.line_index,
25634: and pricing_phase_id = p_pricing_phase_id
25635: and search_ind = 1
25636: and list_line_id < 0 ) qpq,
25637: qp_npreq_line_attrs_tmp qplatpr,
25638: qp_pricing_attributes qpprod,
25639: qp_list_lines qpl,
25640: qp_npreq_lines_tmp qplines
25641: where
25642: qpprod.list_header_id = qpq.list_header_id
25669: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25670: order by 4,2;
25671:
25672: /*
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25670: order by 4,2;
25671:
25672: /*
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25671:
25672: /*
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25672: /*
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25673: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25674: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25675: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25676: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
25677: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
25678: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
25679: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
25680: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
25681:
25682: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25683: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25684: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PREQ_QUAL_TMP_N5,LIST_HEADER_ID,3
25701: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1
25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25707: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25708: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25709:
25702: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,SEARCH_IND,2
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25707: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25708: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25709:
25710: -- Used for qplatpr and qplatpc
25703: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PREQ_QUAL_TMP_N5,LINE_INDEX,5
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25707: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25708: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25709:
25710: -- Used for qplatpr and qplatpc
25711: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25704:
25705: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_HEADER_ID,1
25706: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,QUALIFICATION_IND,2
25707: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,PRICING_PHASE_ID,3
25708: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel2,QP_PRICING_ATTRIBUTES_N7,LIST_LINE_ID,4
25709:
25710: -- Used for qplatpr and qplatpc
25711: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
25712: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
25722: */
25723: CURSOR l_prod_qual_pric_cur(p_pricing_phase_id NUMBER, p_list_header_id NUMBER, p_list_line_id NUMBER,
25724: p_line_index NUMBER) IS
25725: --Product+Qualifiers+Pricing
25726: select /*+ ORDERED USE_NL(QPPROD QPLATPR QPLATPC QPL ) index(QPPROD QP_PRICING_ATTRIBUTES_N7) index(qplatpr qp_preq_line_attrs_tmp_N2) index(qplatpc qp_preq_line_attrs_tmp_N2) l_prod_qual_pric_cur_mod */
25727: qpl.list_header_id,
25728: qpl.list_line_id,
25729: qpl.list_line_type_code,
25730: qplatpr.line_index,
25788: where pricing_status_code = G_STATUS_UNCHANGED
25789: and pricing_phase_id = p_pricing_phase_id
25790: and search_ind = 1
25791: and list_line_id > 0 ) qpq,
25792: QP_PRICING_ATTRIBUTES qpprod ,
25793: qp_npreq_line_attrs_tmp qplatpr,
25794: qp_npreq_line_attrs_tmp qplatpc,
25795: qp_list_lines qpl ,
25796: qp_npreq_lines_tmp qplines
25837: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
25838: or
25839: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
25840: union all
25841: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPL ) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_N1) index(qplatpc qp_preq_line_attrs_tmp_N2) l_prod_qual_pric_cur_mod */
25842: qpl.list_header_id,
25843: qpl.list_line_id,
25844: qpl.list_line_type_code,
25845: qplatpr.line_index,
25904: and pricing_phase_id = p_pricing_phase_id
25905: and search_ind = 1
25906: and list_line_id < 0 ) qpq,
25907: qp_npreq_line_attrs_tmp qplatpr,
25908: QP_PRICING_ATTRIBUTES qpprod ,
25909: qp_npreq_line_attrs_tmp qplatpc,
25910: qp_list_lines qpl ,
25911: qp_npreq_lines_tmp qplines
25912: where
26113: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
26114: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26115: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26116:
26117: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26114: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26115: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26116:
26117: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26115: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26116:
26117: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26123:
26116:
26117: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26123:
26124: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
26117: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26123:
26124: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
26125:
26118: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26119: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26120: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26121: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26122: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26123:
26124: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
26125:
26126: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
26130: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
26131: */
26132: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
26133: -- Only Product attributes
26134: select /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ --5658579
26135: /* ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_prod_cur_mod */
26136: qpl.list_header_id,
26137: qpl.list_line_id,
26138: qpl.list_line_type_code,
26131: */
26132: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
26133: -- Only Product attributes
26134: select /*+ NO_EXPAND ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) INDEX(QPLINES) INDEX(QPLATPR) index(QPPROD QP_PRICING_ATTRIBUTES_N5 ) index(qph QP_LIST_HEADERS_B_N7) */ --5658579
26135: /* ORDERED USE_NL(QPLATPR QPPROD QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qph qp_list_headers_b_n7) l_prod_cur_mod */
26136: qpl.list_header_id,
26137: qpl.list_line_id,
26138: qpl.list_line_type_code,
26139: qplatpr.line_index,
26184: qpl.accum_attr_run_src_flag -- accum range break
26185: FROM
26186: qp_npreq_lines_tmp QPLINES,
26187: qp_npreq_line_attrs_tmp qplatpr,
26188: QP_PRICING_ATTRIBUTES QPPROD ,
26189: QP_LIST_HEADERS_B QPH ,
26190: QP_LIST_LINES QPL ,
26191: --QP_PRICE_REQ_SOURCES QPRS
26192: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
26273: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
26274: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26275: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26276:
26277: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26274: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26275: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26276:
26277: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26282: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26275: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
26276:
26277: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26282: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26283:
26276:
26277: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26282: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26283:
26284: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26277: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26282: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26283:
26284: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26285: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
26278: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26279: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26280: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26281: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26282: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26283:
26284: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26285: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
26286: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
26295: */
26296:
26297: CURSOR l_PROD_PRIC_CUR (p_pricing_phase_id NUMBER) IS
26298: --PRODUCT and PRICING attributes
26299: SELECT /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPH QPL QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpc qp_preq_line_attrs_tmp_N2) index(qph qp_list_headers_b_n7) l_prod_pric_cur_mod */
26300: qpl.list_header_id,
26301: qpl.list_line_id,
26302: qpl.list_line_type_code,
26303: qplatpr.line_index,
26358: qpl.accum_attr_run_src_flag -- accum range break
26359: FROM
26360: qp_npreq_lines_tmp QPLINES,
26361: qp_npreq_line_attrs_tmp qplatpr,
26362: QP_PRICING_ATTRIBUTES QPPROD ,
26363: qp_npreq_line_attrs_tmp qplatpc,
26364: QP_LIST_HEADERS_B QPH ,
26365: QP_LIST_LINES QPL ,
26366: --QP_PRICE_REQ_SOURCES qprs
26565: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
26566: order by 4,2;
26567:
26568: /*
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26566: order by 4,2;
26567:
26568: /*
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26574: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26567:
26568: /*
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26574: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26575:
26568: /*
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26574: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26575:
26576: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26569: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26574: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26575:
26576: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26577: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
26570: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
26571: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
26572: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE,4
26573: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
26574: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,EXCLUDER_FLAG,6
26575:
26576: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1
26577: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE_TYPE,2
26578:
26585:
26586:
26587: -- Pricing Phase Change
26588: CURSOR l_get_excluded_prods_cur(p_pricing_phase_id NUMBER) IS
26589: SELECT /+ ORDERED USE_NL(b a) INDEX(c qp_preq_line_attrs_tmp_N2) index(b qp_pricing_attributes_n5) l_get_excluded_prods_cur /
26590: b.list_header_id,
26591: b.list_line_id,
26592: c.line_index,
26593: c.validated_flag,
26604: -1 qualifier_precedence,
26605: a.line_detail_index
26606: FROM
26607: qp_npreq_line_attrs_tmp c,
26608: qp_pricing_attributes b,
26609: qp_npreq_line_attrs_tmp a
26610: WHERE b.pricing_phase_id = p_pricing_phase_id
26611: AND b.qualification_ind in (G_YES_PROD_IND,G_YES_PROD_HDR_QUAL_IND,G_YES_PROD_LINE_QUAL_IND,G_YES_PROD_HDR_LINE_QUAL_IND)
26612: AND b.product_attribute_context = c.context
29249: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_line_attrs_tmp_N2,ATTRIBUTE,4
29250: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
29251: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
29252:
29253: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
29254: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,QP_PRICING_ATTRIBUTES_N2,EXCLUDER_FLAG,2
29255:
29256: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
29257: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
29250: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_line_attrs_tmp_N2,LINE_INDEX,5
29251: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_line_attrs_tmp_N2,VALUE_FROM,6
29252:
29253: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
29254: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,QP_PRICING_ATTRIBUTES_N2,EXCLUDER_FLAG,2
29255:
29256: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_ldets_tmp_N2,PRICING_PHASE_ID,1
29257: INDX,QP_PREQ_GRP.select_modifiers.l_excl_cur,qp_npreq_ldets_tmp_N2,PRICING_STATUS_CODE,2
29258:
29264: UPDATE qp_npreq_ldets_tmp a
29265: SET pricing_status_code = 'D_EXCLUDER'
29266: WHERE pricing_phase_id = p_pricing_phase_id
29267: AND pricing_status_code = G_STATUS_NEW
29268: AND EXISTS ( SELECT/*+ ORDERED USE_NL(c) index(c qp_preq_line_attrs_tmp_N2) index(b QP_PRICING_ATTRIBUTES_N2) l_excl_cur */
29269: 'x'
29270: FROM qp_pricing_attributes b,
29271: qp_npreq_line_attrs_tmp c
29272: WHERE b.list_line_id = a.created_from_list_line_id
29266: WHERE pricing_phase_id = p_pricing_phase_id
29267: AND pricing_status_code = G_STATUS_NEW
29268: AND EXISTS ( SELECT/*+ ORDERED USE_NL(c) index(c qp_preq_line_attrs_tmp_N2) index(b QP_PRICING_ATTRIBUTES_N2) l_excl_cur */
29269: 'x'
29270: FROM qp_pricing_attributes b,
29271: qp_npreq_line_attrs_tmp c
29272: WHERE b.list_line_id = a.created_from_list_line_id
29273: AND b.excluder_flag = G_YES
29274: AND b.product_attribute_context = c.context
31102: -- Product and Qualifier Only. No pricing
31103: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31104: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31105: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31106: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31107: INDEX(QPQ QP_QUALIFIERS_N4)
31108: INDEX(QPL QP_LIST_LINES_PK)
31109: l_prod_qual_cur_pl */
31110: qpl.list_header_id,
31154: qp_qualifiers qpq,
31155: qp_list_headers_b qph,
31156: qp_price_req_sources_v qprs,
31157: qp_npreq_line_attrs_tmp qplatpr,
31158: qp_pricing_attributes qpprod,
31159: qp_list_lines qpl
31160: WHERE qph.list_header_id = qpl.list_header_id
31161: --added for moac -- commented references to security profile
31162: --security will be built into qp_list_headers_b
31212: UNION ALL
31213: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31214: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31215: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31216: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31217: INDEX(QPQ QP_QUALIFIERS_N5)
31218: INDEX(QPL QP_LIST_LINES_PK)
31219: l_prod_qual_cur_pl */
31220: qpl.list_header_id,
31264: qp_qualifiers qpq,
31265: qp_list_headers_b qph,
31266: qp_price_req_sources_v qprs,
31267: qp_npreq_line_attrs_tmp qplatpr,
31268: qp_pricing_attributes qpprod,
31269: qp_list_lines qpl
31270: WHERE qph.list_header_id = qpl.list_header_id
31271: --added for moac -- commented references to security profile
31272: --security will be built into qp_list_headers_b
31322: UNION ALL
31323: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31324: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31325: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31326: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31327: INDEX(QPQ QP_QUALIFIERS_N6)
31328: INDEX(QPL QP_LIST_LINES_PK)
31329: l_prod_qual_cur_pl */
31330: qpl.list_header_id,
31374: qp_qualifiers qpq,
31375: qp_list_headers_b qph,
31376: qp_price_req_sources_v qprs,
31377: qp_npreq_line_attrs_tmp qplatpr,
31378: qp_pricing_attributes qpprod,
31379: qp_list_lines qpl
31380: WHERE qph.list_header_id = qpl.list_header_id
31381: --added for moac -- commented references to security profile
31382: --security will be built into qp_list_headers_b
31445: -- Product and Qualifier Only. No pricing
31446: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31447: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31448: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31449: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31450: INDEX(QPQ QP_QUALIFIERS_N4)
31451: INDEX(QPL QP_LIST_LINES_PK)
31452: l_prod_qual_cur_pl */
31453: qpl.list_header_id,
31503: qp_qualifiers qpq,
31504: qp_list_headers_b qph,
31505: qp_price_req_sources_v qprs,
31506: qp_npreq_line_attrs_tmp qplatpr,
31507: qp_pricing_attributes qpprod,
31508: qp_list_lines qpl,
31509: qp_currency_details qcdt
31510: WHERE qph.list_header_id = qpl.list_header_id
31511: --added for moac -- commented references to security profile
31602: UNION ALL
31603: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31604: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31605: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31606: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31607: INDEX(QPQ QP_QUALIFIERS_N5)
31608: INDEX(QPL QP_LIST_LINES_PK)
31609: l_prod_qual_cur_pl */
31610: qpl.list_header_id,
31660: qp_qualifiers qpq,
31661: qp_list_headers_b qph,
31662: qp_price_req_sources_v qprs,
31663: qp_npreq_line_attrs_tmp qplatpr,
31664: qp_pricing_attributes qpprod,
31665: qp_list_lines qpl,
31666: qp_currency_details qcdt
31667: WHERE qph.list_header_id = qpl.list_header_id
31668: --added for moac -- commented references to security profile
31759: UNION ALL
31760: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPL)
31761: INDEX(QPLATQ QP_PREQ_LINE_ATTRS_TMP_N1)
31762: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31763: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31764: INDEX(QPQ QP_QUALIFIERS_N6)
31765: INDEX(QPL QP_LIST_LINES_PK)
31766: l_prod_qual_cur_pl */
31767: qpl.list_header_id,
31817: qp_qualifiers qpq,
31818: qp_list_headers_b qph,
31819: qp_price_req_sources_v qprs,
31820: qp_npreq_line_attrs_tmp qplatpr,
31821: qp_pricing_attributes qpprod,
31822: qp_list_lines qpl,
31823: qp_currency_details qcdt
31824: WHERE qph.list_header_id = qpl.list_header_id
31825: --added for moac -- commented references to security profile
31919: AND ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') ='N' )
31920: OR (qplatq.DERIVED_QUALIFIER_FLAG ='Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG ='Y')) -- Added for TCA
31921: ORDER BY 4,2;
31922:
31923: --Added INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) for 3259932
31924: --[julin/4708044] added index(qplapr QP_PREQ_LINE_ATTRS_TMP_N1), use_nl(qprs)
31925: CURSOR l_prod_qual_pric_cur(p_pricing_phase_id NUMBER) IS
31926: --Product+Qualifiers+Pricing
31927: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
31927: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
31928: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
31929: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
31930: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
31931: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
31932: INDEX(QPQ QP_QUALIFIERS_N4)
31933: l_prod_qual_pric_cur_pl */
31934: qpl.list_header_id,
31935: qpl.list_line_id,
31987: qp_qualifiers qpq ,
31988: qp_list_headers_b qph,
31989: qp_price_req_sources_v qprs,
31990: qp_npreq_line_attrs_tmp qplatpr,
31991: qp_pricing_attributes qpprod ,
31992: qp_npreq_line_attrs_tmp qplatpc,
31993: qp_list_lines qpl
31994: WHERE qph.list_header_id = qpq.list_header_id
31995: -- 3594459, context and attribute OR'd together
32055: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
32056: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
32057: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
32058: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
32059: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
32060: INDEX(QPQ QP_QUALIFIERS_N5)
32061: l_prod_qual_pric_cur_pl */
32062: qpl.list_header_id,
32063: qpl.list_line_id,
32115: qp_qualifiers qpq ,
32116: qp_list_headers_b qph,
32117: qp_price_req_sources_v qprs,
32118: qp_npreq_line_attrs_tmp qplatpr,
32119: qp_pricing_attributes qpprod ,
32120: qp_npreq_line_attrs_tmp qplatpc,
32121: qp_list_lines qpl
32122: WHERE qph.list_header_id = qpq.list_header_id
32123: -- 3594459, context and attribute OR'd together
32183: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
32184: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
32185: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
32186: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
32187: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
32188: INDEX(QPQ QP_QUALIFIERS_N6)
32189: l_prod_qual_pric_cur_pl */
32190: qpl.list_header_id,
32191: qpl.list_line_id,
32243: qp_qualifiers qpq ,
32244: qp_list_headers_b qph,
32245: qp_price_req_sources_v qprs,
32246: qp_npreq_line_attrs_tmp qplatpr,
32247: qp_pricing_attributes qpprod ,
32248: qp_npreq_line_attrs_tmp qplatpc,
32249: qp_list_lines qpl
32250: WHERE qph.list_header_id = qpq.list_header_id
32251: -- 3594459, context and attribute OR'd together
32313: AND ((nvl(qplatq.DERIVED_QUALIFIER_FLAG,'N') ='N' )
32314: OR (qplatq.DERIVED_QUALIFIER_FLAG ='Y' AND qpq.QUALIFY_HIER_DESCENDENTS_FLAG ='Y')) -- Added for TCA
32315: ORDER BY 4,2;
32316:
32317: --Added INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) for 3259932
32318: --[julin/4708044] added index(qplapr QP_PREQ_LINE_ATTRS_TMP_N1), use_nl(qprs)
32319: --[julin/5007789]
32320: -- 1. Performing line filter first.
32321: -- 2. Performing qualifier filter before product filter
32325: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
32326: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
32327: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
32328: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
32329: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
32330: INDEX(QPQ QP_QUALIFIERS_N4)
32331: l_prod_qual_pric_cur_pl */
32332: qpl.list_header_id,
32333: qpl.list_line_id,
32391: qp_qualifiers qpq ,
32392: qp_list_headers_b qph,
32393: qp_price_req_sources_v qprs,
32394: qp_npreq_line_attrs_tmp qplatpr,
32395: qp_pricing_attributes qpprod ,
32396: qp_npreq_line_attrs_tmp qplatpc,
32397: qp_list_lines qpl,
32398: qp_currency_details qcdt
32399: WHERE qph.list_header_id = qpq.list_header_id
32500: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
32501: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
32502: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
32503: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
32504: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
32505: INDEX(QPQ QP_QUALIFIERS_N5)
32506: l_prod_qual_pric_cur_pl */
32507: qpl.list_header_id,
32508: qpl.list_line_id,
32566: qp_qualifiers qpq ,
32567: qp_list_headers_b qph,
32568: qp_price_req_sources_v qprs,
32569: qp_npreq_line_attrs_tmp qplatpr,
32570: qp_pricing_attributes qpprod ,
32571: qp_npreq_line_attrs_tmp qplatpc,
32572: qp_list_lines qpl,
32573: qp_currency_details qcdt
32574: WHERE qph.list_header_id = qpq.list_header_id
32675: SELECT /*+ ORDERED USE_NL(QPLATQ QPQ QPH QPRS QPLATPR QPPROD QPLATPC QPL)
32676: index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2)
32677: index(qplatq QP_PREQ_LINE_ATTRS_TMP_N1)
32678: INDEX(QPLAPR QP_PREQ_LINE_ATTRS_TMP_N1)
32679: INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5)
32680: INDEX(QPQ QP_QUALIFIERS_N6)
32681: l_prod_qual_pric_cur_pl */
32682: qpl.list_header_id,
32683: qpl.list_line_id,
32741: qp_qualifiers qpq ,
32742: qp_list_headers_b qph,
32743: qp_price_req_sources_v qprs,
32744: qp_npreq_line_attrs_tmp qplatpr,
32745: qp_pricing_attributes qpprod ,
32746: qp_npreq_line_attrs_tmp qplatpc,
32747: qp_list_lines qpl,
32748: qp_currency_details qcdt
32749: WHERE qph.list_header_id = qpq.list_header_id
32894: FROM qp_npreq_lines_tmp
32895: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
32896: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32897: qp_npreq_line_attrs_tmp qplatpr,
32898: qp_pricing_attributes qpprod ,
32899: qp_list_lines qpl ,
32900: qp_list_headers_b qph ,
32901: qp_price_req_sources_v qprs
32902: WHERE
32981: FROM qp_npreq_lines_tmp
32982: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
32983: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32984: qp_npreq_line_attrs_tmp qplatpr,
32985: qp_pricing_attributes qpprod,
32986: qp_list_lines qpl,
32987: qp_list_headers_b qph,
32988: qp_price_req_sources_v qprs,
32989: qp_currency_details qcdt
33063: AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX -- 4331801/4365538
33064: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
33065: ORDER BY 4,2;
33066:
33067: --Added INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) for 3259932
33068: --[julin/5007789] Tuned query as follows:
33069: -- 1. Performing line filter first.
33070: -- 2. Merged qplatpr subquery conditions into main where clause.
33071: -- 3. Merged qplatpc subquery conditions into main where clause.
33070: -- 2. Merged qplatpr subquery conditions into main where clause.
33071: -- 3. Merged qplatpc subquery conditions into main where clause.
33072: CURSOR l_prod_pric_cur (p_pricing_phase_id NUMBER) IS
33073: --PRODUCT and PRICING attributes
33074: SELECT /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPL QPH QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2) l_prod_pric_cur_pl */
33075: qpl.list_header_id,
33076: qpl.list_line_id,
33077: qpl.list_line_type_code,
33078: qplatpr.line_index,
33115: FROM qp_npreq_lines_tmp
33116: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
33117: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
33118: qp_npreq_line_attrs_tmp qplatpr,
33119: qp_pricing_attributes qpprod,
33120: qp_npreq_line_attrs_tmp qplatpc,
33121: qp_list_lines qpl,
33122: qp_list_headers_b qph,
33123: qp_price_req_sources_v QPRS
33165: --AND qplatpc.pricing_attr_flag = G_YES --[julin/4708044] currently not reliable value, not used in index
33166: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0) -- bug 2693700
33167: ORDER BY 4,2;
33168:
33169: --Added INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) for 3259932
33170: --[julin/5007789] Tuned query as follows:
33171: -- 1. Performing line filter first.
33172: CURSOR l_prod_pric_cur_currency(p_pricing_phase_id NUMBER) IS
33173: --Product+Pricing
33170: --[julin/5007789] Tuned query as follows:
33171: -- 1. Performing line filter first.
33172: CURSOR l_prod_pric_cur_currency(p_pricing_phase_id NUMBER) IS
33173: --Product+Pricing
33174: SELECT /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPL QPH QPRS) index(qplatpr QP_PREQ_LINE_ATTRS_TMP_N1) INDEX(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpc QP_PREQ_LINE_ATTRS_TMP_N2) l_prod_pric_cur_pl */
33175: qpl.list_header_id,
33176: qpl.list_line_id,
33177: qpl.list_line_type_code,
33178: qplatpr.line_index,
33221: FROM qp_npreq_lines_tmp
33222: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
33223: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
33224: qp_npreq_line_attrs_tmp qplatpr,
33225: qp_pricing_attributes qpprod ,
33226: qp_npreq_line_attrs_tmp qplatpc,
33227: qp_list_lines qpl ,
33228: qp_list_headers_b qph,
33229: qp_price_req_sources_v qprs,
35488: WHERE line_detail_index = l_line_detail_index
35489: AND ATTRIBUTE_LEVEL = G_DETAIL_LEVEL;
35490:
35491: /*
35492: INDX,QP_PREQ_GRP.call_calculation_engine.l_list_line_attribute_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
35493: */
35494: CURSOR l_list_line_attribute_cur(p_list_line_id PLS_INTEGER) IS
35495: SELECT /*+ index(qpp qp_pricing_attributes_n2) l_list_line_attribute_cur */ PRICING_ATTRIBUTE
35496: FROM QP_PRICING_ATTRIBUTES qpp
35491: /*
35492: INDX,QP_PREQ_GRP.call_calculation_engine.l_list_line_attribute_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
35493: */
35494: CURSOR l_list_line_attribute_cur(p_list_line_id PLS_INTEGER) IS
35495: SELECT /*+ index(qpp qp_pricing_attributes_n2) l_list_line_attribute_cur */ PRICING_ATTRIBUTE
35496: FROM QP_PRICING_ATTRIBUTES qpp
35497: WHERE LIST_LINE_ID = p_list_line_id
35498: AND PRICING_ATTRIBUTE_CONTEXT = G_PRIC_VOLUME_CONTEXT;
35499:
35492: INDX,QP_PREQ_GRP.call_calculation_engine.l_list_line_attribute_cur,QP_PRICING_ATTRIBUTES_N2,LIST_LINE_ID,1
35493: */
35494: CURSOR l_list_line_attribute_cur(p_list_line_id PLS_INTEGER) IS
35495: SELECT /*+ index(qpp qp_pricing_attributes_n2) l_list_line_attribute_cur */ PRICING_ATTRIBUTE
35496: FROM QP_PRICING_ATTRIBUTES qpp
35497: WHERE LIST_LINE_ID = p_list_line_id
35498: AND PRICING_ATTRIBUTE_CONTEXT = G_PRIC_VOLUME_CONTEXT;
35499:
35500: -- Cursor for getting the related line index for the line index
39165: WHERE pricing_phase_id = p_pricing_phase_id
39166: AND pricing_status_code = qp_preq_grp.g_status_unchanged
39167: AND EXISTS
39168: (SELECT
39169: /*+ ORDERED USE_NL(c) index(c qp_preq_line_attrs_tmp_N2) index(b QP_PRICING_ATTRIBUTES_N2) l_excl_cur */ 'x'
39170: FROM qp_pricing_attributes b,
39171: qp_npreq_line_attrs_tmp c
39172: WHERE b.list_line_id = a.list_line_id
39173: AND b.excluder_flag = qp_preq_grp.g_yes
39166: AND pricing_status_code = qp_preq_grp.g_status_unchanged
39167: AND EXISTS
39168: (SELECT
39169: /*+ ORDERED USE_NL(c) index(c qp_preq_line_attrs_tmp_N2) index(b QP_PRICING_ATTRIBUTES_N2) l_excl_cur */ 'x'
39170: FROM qp_pricing_attributes b,
39171: qp_npreq_line_attrs_tmp c
39172: WHERE b.list_line_id = a.list_line_id
39173: AND b.excluder_flag = qp_preq_grp.g_yes
39174: AND b.product_attribute_context = c.context
39698: qpldets.PRIMARY_UOM_FLAG, --PRIMARY_UOM_FLAG
39699: --qppatr.PRODUCT_SEGMENT_ID, --SEGMENT_ID
39700: qplaptr.derived_qualifier_flag
39701: FROM qp_npreq_ldets_tmp qpldets,
39702: QP_PRICING_ATTRIBUTES qppatr,
39703: qp_npreq_line_attrs_tmp qplaptr
39704: WHERE qpldets.pricing_phase_id = p_pricing_phase_id
39705: AND qpldets.line_index BETWEEN l_start_line_index AND l_end_line_index
39706: AND qpldets.CREATED_FROM_SQL = p_stage
39747: qpldets.PRIMARY_UOM_FLAG, --PRIMARY_UOM_FLAG
39748: --qppatr.PRICING_SEGMENT_ID, --SEGMENT_ID
39749: qplaptr.derived_qualifier_flag
39750: FROM qp_npreq_ldets_tmp qpldets,
39751: QP_PRICING_ATTRIBUTES qppatr,
39752: qp_npreq_line_attrs_tmp qplaptr
39753: WHERE qpldets.pricing_phase_id = p_pricing_phase_id
39754: AND qpldets.line_index BETWEEN l_start_line_index AND l_end_line_index
39755: AND qpldets.CREATED_FROM_SQL = p_stage
40429: eq_flag, MODIFIER_LEVEL_CODE
40430: FROM QP_PREQ_PATRN_QUAL_TMP
40431: WHERE stage = p_stage
40432: )qppat,
40433: QP_PRICING_ATTRIBUTES qppatr,
40434: qp_npreq_line_attrs_tmp qplaptr
40435: WHERE qppat.pricing_phase_id = p_pricing_phase_id
40436: AND qppatr.list_line_id = qppat.list_line_id
40437: AND qppatr.excluder_flag = G_NO