[Home] [Help]
769: and pricing_phase_id = p_pricing_phase_id) qptq,
770: qp_qualifiers qpq ,
771: qp_npreq_line_attrs_tmp qplatq,
772: qp_list_headers_b qph,
773: qp_price_req_sources_v qprs
774: where
775: qpq.list_header_id = qptq.list_header_id
776: and qpq.list_line_id = qptq.list_line_id
777: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
864: and pricing_phase_id = p_pricing_phase_id) qptq,
865: qp_qualifiers qpq ,
866: qp_npreq_line_attrs_tmp qplatq,
867: qp_list_headers_b qph,
868: qp_price_req_sources_v qprs
869: where
870: qpq.list_header_id = qptq.list_header_id
871: and qpq.list_line_id = qptq.list_line_id
872: and qpq.qualifier_grouping_no = -1
956: and pricing_phase_id = p_pricing_phase_id) qptq,
957: qp_qualifiers qpq ,
958: qp_npreq_line_attrs_tmp qplatq,
959: qp_list_headers_b qph,
960: qp_price_req_sources_v qprs
961: where
962: qpq.list_header_id = qptq.list_header_id
963: and qpq.list_line_id = qptq.list_line_id
964: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1053: and pricing_phase_id = p_pricing_phase_id) qptq,
1054: qp_qualifiers qpq ,
1055: qp_npreq_line_attrs_tmp qplatq,
1056: qp_list_headers_b qph,
1057: qp_price_req_sources_v qprs
1058: where
1059: qpq.list_header_id = qptq.list_header_id
1060: and qpq.list_line_id = qptq.list_line_id
1061: and qpq.qualifier_grouping_no = -1
1147: and pricing_phase_id = p_pricing_phase_id) qptq,
1148: qp_qualifiers qpq ,
1149: qp_npreq_line_attrs_tmp qplatq,
1150: qp_list_headers_b qph,
1151: qp_price_req_sources_v qprs
1152: where
1153: qpq.list_header_id = qptq.list_header_id
1154: and qpq.list_line_id = qptq.list_line_id
1155: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1245: and pricing_phase_id = p_pricing_phase_id) qptq,
1246: qp_qualifiers qpq ,
1247: qp_npreq_line_attrs_tmp qplatq,
1248: qp_list_headers_b qph,
1249: qp_price_req_sources_v qprs
1250: where
1251: qpq.list_header_id = qptq.list_header_id
1252: and qpq.list_line_id = qptq.list_line_id
1253: and qpq.qualifier_grouping_no = -1
1341: and pricing_phase_id = p_pricing_phase_id) qptq,
1342: qp_qualifiers qpq ,
1343: qp_npreq_line_attrs_tmp qplatq,
1344: qp_list_headers_b qph,
1345: qp_price_req_sources_v qprs
1346: where
1347: qpq.list_header_id = qptq.list_header_id
1348: and qpq.list_line_id = qptq.list_line_id
1349: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1436: and pricing_phase_id = p_pricing_phase_id) qptq,
1437: qp_qualifiers qpq ,
1438: qp_npreq_line_attrs_tmp qplatq,
1439: qp_list_headers_b qph,
1440: qp_price_req_sources_v qprs
1441: where
1442: qpq.list_header_id = qptq.list_header_id
1443: and qpq.list_line_id = qptq.list_line_id
1444: and qpq.qualifier_grouping_no = -1
1726: qp_npreq_line_attrs_tmp qplatq,
1727: qp_qualifiers qpq ,
1728: qp_list_header_phases qplh,
1729: qp_list_headers_b qph,
1730: qp_price_req_sources_v qprs
1731: where
1732: qpq.list_header_id = qplh.list_header_id
1733: and qplh.list_header_id = qph.list_header_id
1734: -- bug 2799120
1841: qp_npreq_line_attrs_tmp qplatq,
1842: qp_qualifiers qpq ,
1843: qp_list_header_phases qplh,
1844: qp_list_headers_b qph,
1845: qp_price_req_sources_v qprs
1846: where
1847: qpq.list_header_id = qplh.list_header_id
1848: and qplh.list_header_id = qph.list_header_id
1849: -- bug 2799120
1958: qp_npreq_line_attrs_tmp qplatq,
1959: qp_qualifiers qpq ,
1960: qp_list_header_phases qplh,
1961: qp_list_headers_b qph,
1962: qp_price_req_sources_v qprs
1963: where
1964: qpq.list_header_id = qplh.list_header_id
1965: and qplh.list_header_id = qph.list_header_id
1966: -- bug 2799120
2076: qp_npreq_line_attrs_tmp qplatq,
2077: qp_qualifiers qpq ,
2078: qp_list_header_phases qplh,
2079: qp_list_headers_b qph,
2080: qp_price_req_sources_v qprs
2081: where
2082: qpq.list_header_id = qplh.list_header_id
2083: and qplh.list_header_id = qph.list_header_id
2084: -- bug 2799120
2418: qp_npreq_line_attrs_tmp qplatq,
2419: qp_qualifiers qpq ,
2420: qp_list_header_phases qplh,
2421: qp_list_headers_b qph,
2422: qp_price_req_sources_v qprs
2423: where
2424: qpq.list_header_id = qplh.list_header_id
2425: and qplh.list_header_id = qph.list_header_id
2426: -- bug 2799120
2514: qp_npreq_line_attrs_tmp qplatq,
2515: qp_qualifiers qpq ,
2516: qp_list_header_phases qplh,
2517: qp_list_headers_b qph,
2518: qp_price_req_sources_v qprs
2519: where
2520: qpq.list_header_id = qplh.list_header_id
2521: and qplh.list_header_id = qph.list_header_id
2522: -- bug 2799120
2613: qp_npreq_line_attrs_tmp qplatq,
2614: qp_qualifiers qpq ,
2615: qp_list_header_phases qplh,
2616: qp_list_headers_b qph,
2617: qp_price_req_sources_v qprs
2618: where
2619: qpq.list_header_id = qplh.list_header_id
2620: and qplh.list_header_id = qph.list_header_id
2621: -- bug 2799120
2713: qp_npreq_line_attrs_tmp qplatq,
2714: qp_qualifiers qpq ,
2715: qp_list_header_phases qplh,
2716: qp_list_headers_b qph,
2717: qp_price_req_sources_v qprs
2718: where
2719: qpq.list_header_id = qplh.list_header_id
2720: and qplh.list_header_id = qph.list_header_id
2721: -- bug 2799120
14581: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
14582:
14583: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14584:
14585: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14586: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14587:
14588: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
14589: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
14582:
14583: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_LIST_HEADERS_B_PK,LINE_TYPE_CODE,2
14584:
14585: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
14586: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
14587:
14588: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,LINE_INDEX,1
14589: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,ATTRIBUTE_TYPE,2
14590: INDX,QP_PREQ_GRP.perform_secondary_search.l_sec_list_cur,qp_npreq_line_attrs_tmp_N1,PRICING_STATUS_CODE,3
14648: qp_npreq_line_attrs_tmp QPLAT_PROD,
14649: QP_PRICING_ATTRIBUTES QPA,
14650: QP_LIST_LINES QPL,
14651: QP_LIST_HEADERS_B QPH,
14652: --QP_PRICE_REQ_SOURCES QPRS
14653: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14654: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14655: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14656: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14649: QP_PRICING_ATTRIBUTES QPA,
14650: QP_LIST_LINES QPL,
14651: QP_LIST_HEADERS_B QPH,
14652: --QP_PRICE_REQ_SOURCES QPRS
14653: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14654: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14655: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14656: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14657: AND QPQ.COMPARISON_OPERATOR_CODE = '='
14770: QP_PRICING_ATTRIBUTES qpa,
14771: qp_npreq_line_attrs_tmp qplat_pric,
14772: QP_LIST_LINES qpl,
14773: QP_LIST_HEADERS_B qph,
14774: --QP_PRICE_REQ_SOURCES qprs
14775: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
14776: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14777: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14778: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14771: qp_npreq_line_attrs_tmp qplat_pric,
14772: QP_LIST_LINES qpl,
14773: QP_LIST_HEADERS_B qph,
14774: --QP_PRICE_REQ_SOURCES qprs
14775: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
14776: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14777: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14778: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14779: AND QPQ.COMPARISON_OPERATOR_CODE = '='
14898: qp_npreq_line_attrs_tmp QPLAT_Q,
14899: QP_PRICING_ATTRIBUTES QPA,
14900: QP_LIST_LINES QPL,
14901: QP_LIST_HEADERS_B QPH,
14902: --QP_PRICE_REQ_SOURCES QPRS
14903: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14904: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14905: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14906: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14899: QP_PRICING_ATTRIBUTES QPA,
14900: QP_LIST_LINES QPL,
14901: QP_LIST_HEADERS_B QPH,
14902: --QP_PRICE_REQ_SOURCES QPRS
14903: QP_PRICE_REQ_SOURCES_V QPRS /*yangli*/
14904: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14905: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14906: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14907: AND QPQ.COMPARISON_OPERATOR_CODE = '='
15040: qp_npreq_line_attrs_tmp qplat_pric,
15041: qp_npreq_line_attrs_tmp qplat_q,
15042: QP_LIST_LINES qpl,
15043: QP_LIST_HEADERS_B qph,
15044: --QP_PRICE_REQ_SOURCES qprs
15045: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15046: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15047: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15048: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15041: qp_npreq_line_attrs_tmp qplat_q,
15042: QP_LIST_LINES qpl,
15043: QP_LIST_HEADERS_B qph,
15044: --QP_PRICE_REQ_SOURCES qprs
15045: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15046: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15047: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15048: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15049: AND QPQ.COMPARISON_OPERATOR_CODE = '='
15195: qp_npreq_line_attrs_tmp QPLAT_PROD,
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 */
15201: QP_CURRENCY_DETAILS QCDT /* Vivek */
15202: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15203: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
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 */
15201: QP_CURRENCY_DETAILS QCDT /* Vivek */
15202: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15203: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15204: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15377: QP_PRICING_ATTRIBUTES qpa,
15378: qp_npreq_line_attrs_tmp qplat_pric,
15379: QP_LIST_LINES qpl,
15380: QP_LIST_HEADERS_B qph,
15381: --QP_PRICE_REQ_SOURCES qprs,
15382: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15383: QP_CURRENCY_DETAILS QCDT /* Vivek */
15384: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15385: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15378: qp_npreq_line_attrs_tmp qplat_pric,
15379: QP_LIST_LINES qpl,
15380: QP_LIST_HEADERS_B qph,
15381: --QP_PRICE_REQ_SOURCES qprs,
15382: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15383: QP_CURRENCY_DETAILS QCDT /* Vivek */
15384: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15385: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15386: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15565: qp_npreq_line_attrs_tmp QPLAT_Q,
15566: QP_PRICING_ATTRIBUTES QPA,
15567: QP_LIST_LINES QPL,
15568: QP_LIST_HEADERS_B QPH,
15569: --QP_PRICE_REQ_SOURCES QPRS,
15570: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15571: QP_CURRENCY_DETAILS QCDT /* Vivek */
15572: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15573: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15566: QP_PRICING_ATTRIBUTES QPA,
15567: QP_LIST_LINES QPL,
15568: QP_LIST_HEADERS_B QPH,
15569: --QP_PRICE_REQ_SOURCES QPRS,
15570: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15571: QP_CURRENCY_DETAILS QCDT /* Vivek */
15572: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15573: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15574: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15767: qp_npreq_line_attrs_tmp qplat_pric,
15768: qp_npreq_line_attrs_tmp qplat_q,
15769: QP_LIST_LINES qpl,
15770: QP_LIST_HEADERS_B qph,
15771: --QP_PRICE_REQ_SOURCES qprs,
15772: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15773: QP_CURRENCY_DETAILS QCDT /* Vivek */
15774: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15775: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15768: qp_npreq_line_attrs_tmp qplat_q,
15769: QP_LIST_LINES qpl,
15770: QP_LIST_HEADERS_B qph,
15771: --QP_PRICE_REQ_SOURCES qprs,
15772: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15773: QP_CURRENCY_DETAILS QCDT /* Vivek */
15774: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15775: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15776: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
16808: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
16809:
16810: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
16811:
16812: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
16813: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
16814: */
16815: CURSOR L_LIST_CUR IS
16816: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_cur */
16809:
16810: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
16811:
16812: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
16813: INDX,QP_PREQ_GRP.list_header_search.l_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
16814: */
16815: CURSOR L_LIST_CUR IS
16816: SELECT /*+ ORDERED USE_NL(QPLAT_PROD QPA QPL QPH) index(QPA QP_PRICING_ATTRIBUTES_N5) dynamic_sampling(1) l_list_cur */
16817: QPLAT_PROD.LINE_INDEX,
16857: qp_npreq_line_attrs_tmp qplat_prod,
16858: QP_PRICING_ATTRIBUTES QPA,
16859: QP_LIST_LINES QPL,
16860: QP_LIST_HEADERS_B QPH,
16861: --QP_PRICE_REQ_SOURCES qprs
16862: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16863: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16864: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
16865: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
16858: QP_PRICING_ATTRIBUTES QPA,
16859: QP_LIST_LINES QPL,
16860: QP_LIST_HEADERS_B QPH,
16861: --QP_PRICE_REQ_SOURCES qprs
16862: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16863: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16864: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
16865: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
16866: AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') --po integration
16963: QP_PRICING_ATTRIBUTES qpa,
16964: qp_npreq_line_attrs_tmp qplat_pric,
16965: QP_LIST_LINES qpl,
16966: QP_LIST_HEADERS_B qph,
16967: --QP_PRICE_REQ_SOURCES qprs
16968: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16969: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16970: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
16971: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
16964: qp_npreq_line_attrs_tmp qplat_pric,
16965: QP_LIST_LINES qpl,
16966: QP_LIST_HEADERS_B qph,
16967: --QP_PRICE_REQ_SOURCES qprs
16968: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
16969: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
16970: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
16971: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
16972: AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') --po integration
17087: qp_npreq_line_attrs_tmp qplat_prod,
17088: QP_PRICING_ATTRIBUTES QPA,
17089: QP_LIST_LINES QPL,
17090: QP_LIST_HEADERS_B QPH,
17091: --QP_PRICE_REQ_SOURCES qprs,
17092: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17093: QP_CURRENCY_DETAILS QCDT /* Vivek */
17094: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17095: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17088: QP_PRICING_ATTRIBUTES QPA,
17089: QP_LIST_LINES QPL,
17090: QP_LIST_HEADERS_B QPH,
17091: --QP_PRICE_REQ_SOURCES qprs,
17092: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17093: QP_CURRENCY_DETAILS QCDT /* Vivek */
17094: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17095: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17096: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17245: QP_PRICING_ATTRIBUTES qpa,
17246: qp_npreq_line_attrs_tmp qplat_pric,
17247: QP_LIST_LINES qpl,
17248: QP_LIST_HEADERS_B qph,
17249: --QP_PRICE_REQ_SOURCES qprs,
17250: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17251: QP_CURRENCY_DETAILS QCDT /* Vivek */
17252: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17253: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17246: qp_npreq_line_attrs_tmp qplat_pric,
17247: QP_LIST_LINES qpl,
17248: QP_LIST_HEADERS_B qph,
17249: --QP_PRICE_REQ_SOURCES qprs,
17250: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17251: QP_CURRENCY_DETAILS QCDT /* Vivek */
17252: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17253: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17254: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17390: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
17391:
17392: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17393:
17394: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17395: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17396:
17397: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17398: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17391:
17392: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_LIST_HEADERS_B_PK,LIST_HEADER_ID,1
17393:
17394: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
17395: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
17396:
17397: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1
17398: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,QUALIFICATION_IND,2
17399: INDX,QP_PREQ_GRP.list_header_search.l_list_qual_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTRIBUTE_CONTEXT,3
17462: qp_npreq_line_attrs_tmp QPLAT_PROD,
17463: QP_PRICING_ATTRIBUTES QPA,
17464: QP_LIST_LINES QPL,
17465: QP_LIST_HEADERS_B QPH,
17466: --QP_PRICE_REQ_SOURCES QPRS
17467: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17468: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17469: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17470: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17463: QP_PRICING_ATTRIBUTES QPA,
17464: QP_LIST_LINES QPL,
17465: QP_LIST_HEADERS_B QPH,
17466: --QP_PRICE_REQ_SOURCES QPRS
17467: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17468: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17469: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17470: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17471: AND (QPLINES.PRICE_FLAG = G_YES
17590: QP_PRICING_ATTRIBUTES QPA,
17591: qp_npreq_line_attrs_tmp QPLAT_PRIC,
17592: QP_LIST_LINES QPL,
17593: QP_LIST_HEADERS_B QPH,
17594: --QP_PRICE_REQ_SOURCES QPRS
17595: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17596: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17597: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17598: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17591: qp_npreq_line_attrs_tmp QPLAT_PRIC,
17592: QP_LIST_LINES QPL,
17593: QP_LIST_HEADERS_B QPH,
17594: --QP_PRICE_REQ_SOURCES QPRS
17595: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17596: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17597: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17598: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17599: AND (QPLINES.PRICE_FLAG = G_YES
17723: qp_npreq_line_attrs_tmp qplat_prod,
17724: QP_PRICING_ATTRIBUTES QPA,
17725: QP_LIST_LINES QPL,
17726: QP_LIST_HEADERS_B QPH,
17727: --QP_PRICE_REQ_SOURCES qprs
17728: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17729: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17730: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
17731: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17724: QP_PRICING_ATTRIBUTES QPA,
17725: QP_LIST_LINES QPL,
17726: QP_LIST_HEADERS_B QPH,
17727: --QP_PRICE_REQ_SOURCES qprs
17728: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17729: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17730: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
17731: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17732: AND (QPLINES.PRICE_FLAG = G_YES
17826: QP_PRICING_ATTRIBUTES qpa,
17827: qp_npreq_line_attrs_tmp qplat_pric,
17828: QP_LIST_LINES qpl,
17829: QP_LIST_HEADERS_B qph,
17830: --QP_PRICE_REQ_SOURCES qprs
17831: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17832: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17833: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
17834: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17827: qp_npreq_line_attrs_tmp qplat_pric,
17828: QP_LIST_LINES qpl,
17829: QP_LIST_HEADERS_B qph,
17830: --QP_PRICE_REQ_SOURCES qprs
17831: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17832: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17833: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
17834: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17835: AND (QPLINES.PRICE_FLAG = G_YES
17948: qp_npreq_line_attrs_tmp QPLAT_PROD,
17949: QP_PRICING_ATTRIBUTES QPA,
17950: QP_LIST_LINES QPL,
17951: QP_LIST_HEADERS_B QPH,
17952: --QP_PRICE_REQ_SOURCES QPRS,
17953: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
17954: QP_CURRENCY_DETAILS QCDT /* Vivek */
17955: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17956: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17949: QP_PRICING_ATTRIBUTES QPA,
17950: QP_LIST_LINES QPL,
17951: QP_LIST_HEADERS_B QPH,
17952: --QP_PRICE_REQ_SOURCES QPRS,
17953: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
17954: QP_CURRENCY_DETAILS QCDT /* Vivek */
17955: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17956: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17957: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18134: QP_PRICING_ATTRIBUTES QPA,
18135: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18136: QP_LIST_LINES QPL,
18137: QP_LIST_HEADERS_B QPH,
18138: --QP_PRICE_REQ_SOURCES QPRS,
18139: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18140: QP_CURRENCY_DETAILS QCDT /* Vivek */
18141: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18142: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
18135: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18136: QP_LIST_LINES QPL,
18137: QP_LIST_HEADERS_B QPH,
18138: --QP_PRICE_REQ_SOURCES QPRS,
18139: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18140: QP_CURRENCY_DETAILS QCDT /* Vivek */
18141: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18142: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
18143: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18325: qp_npreq_line_attrs_tmp qplat_prod,
18326: QP_PRICING_ATTRIBUTES QPA,
18327: QP_LIST_LINES QPL,
18328: QP_LIST_HEADERS_B QPH,
18329: --QP_PRICE_REQ_SOURCES qprs,
18330: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18331: QP_CURRENCY_DETAILS QCDT /* Vivek */
18332: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18333: --AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
18326: QP_PRICING_ATTRIBUTES QPA,
18327: QP_LIST_LINES QPL,
18328: QP_LIST_HEADERS_B QPH,
18329: --QP_PRICE_REQ_SOURCES qprs,
18330: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18331: QP_CURRENCY_DETAILS QCDT /* Vivek */
18332: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18333: --AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
18334: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
18489: QP_PRICING_ATTRIBUTES qpa,
18490: qp_npreq_line_attrs_tmp qplat_pric,
18491: QP_LIST_LINES qpl,
18492: QP_LIST_HEADERS_B qph,
18493: --QP_PRICE_REQ_SOURCES qprs,
18494: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18495: QP_CURRENCY_DETAILS QCDT /* Vivek */
18496: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18497: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18490: qp_npreq_line_attrs_tmp qplat_pric,
18491: QP_LIST_LINES qpl,
18492: QP_LIST_HEADERS_B qph,
18493: --QP_PRICE_REQ_SOURCES qprs,
18494: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18495: QP_CURRENCY_DETAILS QCDT /* Vivek */
18496: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18497: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18498: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18656: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,PRODUCT_ATTR_VALUE,5
18657: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18658: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18659:
18660: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
18661: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
18662:
18663: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
18664:
18657: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_HEADER_ID,7
18658: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N5,LIST_LINE_ID,8
18659:
18660: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
18661: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
18662:
18663: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_LIST_LINES_PK,LIST_LINE_ID,1
18664:
18665: INDX,QP_PREQ_GRP.list_header_search.l_other_list_cur,QP_PRICING_ATTRIBUTES_N4,PRICING_ATTRIBUTE_CONTEXT,1
18724: qp_npreq_line_attrs_tmp QPLAT_PROD,
18725: QP_PRICING_ATTRIBUTES QPA,
18726: QP_LIST_HEADERS_B QPH,
18727: QP_LIST_LINES QPL,
18728: QP_PRICE_REQ_SOURCES_V QPRS
18729: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
18730: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
18731: QP_PREQ_GRP.G_YES_PROD_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_HDR_LINE_QUAL_IND)
18732: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18840: QP_PRICING_ATTRIBUTES QPA,
18841: qp_npreq_line_attrs_tmp QPLAT_PRIC,
18842: QP_LIST_HEADERS_B QPH,
18843: QP_LIST_LINES QPL,
18844: QP_PRICE_REQ_SOURCES QPRS
18845: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
18846: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
18847: QP_PREQ_GRP.G_YES_PROD_PRIC_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_PRIC_HDR_LINE_QUAL_IND)
18848: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18968: qp_npreq_line_attrs_tmp QPLAT_PROD,
18969: QP_PRICING_ATTRIBUTES QPA,
18970: QP_LIST_HEADERS_B QPH,
18971: QP_LIST_LINES QPL,
18972: QP_PRICE_REQ_SOURCES QPRS
18973: WHERE QPA.PRICING_PHASE_ID = P_PRICING_PHASE_ID
18974: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
18975: QP_PREQ_GRP.G_YES_PROD_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_HDR_LINE_QUAL_IND)
18976: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
19084: QP_PRICING_ATTRIBUTES QPA,
19085: qp_npreq_line_attrs_tmp QPLAT_PRIC,
19086: QP_LIST_HEADERS_B QPH,
19087: QP_LIST_LINES QPL,
19088: QP_PRICE_REQ_SOURCES QPRS
19089: WHERE QPA.PRICING_PHASE_ID = p_pricing_phase_id
19090: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_IND, QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,
19091: QP_PREQ_GRP.G_YES_PROD_PRIC_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_PRIC_HDR_LINE_QUAL_IND)
19092: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
22292:
22293: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22294: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22295:
22296: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22297: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22298: */
22299: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
22300: -- Only Product attributes
22293: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22294: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22295:
22296: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22297: INDX,QP_PREQ_GRP.select_modifiers.l_prod_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22298: */
22299: CURSOR l_PROD_CUR (p_pricing_phase_id NUMBER) IS
22300: -- Only Product attributes
22301: 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
22352: qp_npreq_line_attrs_tmp qplatpr,
22353: QP_PRICING_ATTRIBUTES QPPROD ,
22354: QP_LIST_HEADERS_B QPH ,
22355: QP_LIST_LINES QPL ,
22356: --QP_PRICE_REQ_SOURCES QPRS
22357: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
22358: WHERE
22359: (qplines.price_flag = G_YES
22360: OR
22353: QP_PRICING_ATTRIBUTES QPPROD ,
22354: QP_LIST_HEADERS_B QPH ,
22355: QP_LIST_LINES QPL ,
22356: --QP_PRICE_REQ_SOURCES QPRS
22357: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
22358: WHERE
22359: (qplines.price_flag = G_YES
22360: OR
22361: (qplines.price_flag = G_PHASE
22454:
22455: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22456: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22457:
22458: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22459: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22460: */
22461:
22462: CURSOR l_PROD_PRIC_CUR (p_pricing_phase_id NUMBER) IS
22455: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_INDEX,1
22456: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_lines_tmp_N1,LINE_TYPE_CODE,2
22457:
22458: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22459: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22460: */
22461:
22462: CURSOR l_PROD_PRIC_CUR (p_pricing_phase_id NUMBER) IS
22463: --PRODUCT and PRICING attributes
22525: QP_PRICING_ATTRIBUTES QPPROD ,
22526: qp_npreq_line_attrs_tmp qplatpc,
22527: QP_LIST_HEADERS_B QPH ,
22528: QP_LIST_LINES QPL ,
22529: --QP_PRICE_REQ_SOURCES qprs
22530: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
22531: WHERE
22532: (qplines.price_flag = G_YES
22533: OR
22526: qp_npreq_line_attrs_tmp qplatpc,
22527: QP_LIST_HEADERS_B QPH ,
22528: QP_LIST_LINES QPL ,
22529: --QP_PRICE_REQ_SOURCES qprs
22530: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
22531: WHERE
22532: (qplines.price_flag = G_YES
22533: OR
22534: (qplines.price_flag = G_PHASE
22618: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,LIST_HEADER_ID,1
22619: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
22620: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
22621:
22622: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22623: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22624: */
22625: cursor l_CUR (p_pricing_phase_id NUMBER) IS
22626: -- NO PRODUCTS AND NO QUALIFIERS
22619: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,ACTIVE_FLAG,2
22620: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_HEADERS_B_N2,CURRENCY_CODE,3
22621:
22622: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
22623: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_PRICE_REQ_SOURCES_PK,SOURCE_SYSTEM_CODE,2
22624: */
22625: cursor l_CUR (p_pricing_phase_id NUMBER) IS
22626: -- NO PRODUCTS AND NO QUALIFIERS
22627: SELECT /*+ NO_EXPAND ORDERED USE_NL(QPL QPH QPRS) index(QPL QP_LIST_LINES_N5) index(qph qp_list_headers_b_n7) l_cur_mod */
22660: from
22661: qp_npreq_lines_tmp qplines,
22662: qp_list_lines qpl,
22663: qp_list_headers_b qph,
22664: --qp_price_req_sources qprs
22665: qp_price_req_sources_v qprs /* yangli */
22666: where qph.list_header_id = qpl.list_header_id
22667: --added for moac -- commented references to security profile
22668: --security will be built into qp_list_headers_b
22661: qp_npreq_lines_tmp qplines,
22662: qp_list_lines qpl,
22663: qp_list_headers_b qph,
22664: --qp_price_req_sources qprs
22665: qp_price_req_sources_v qprs /* yangli */
22666: where qph.list_header_id = qpl.list_header_id
22667: --added for moac -- commented references to security profile
22668: --security will be built into qp_list_headers_b
22669: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
25605: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25606: qp_npreq_line_attrs_tmp qplatq,
25607: qp_qualifiers qpq,
25608: qp_list_headers_b qph,
25609: qp_price_req_sources_v qprs,
25610: qp_npreq_line_attrs_tmp qplatpr,
25611: qp_pricing_attributes qpprod,
25612: qp_list_lines qpl
25613: WHERE qph.list_header_id = qpl.list_header_id
25713: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25714: qp_npreq_line_attrs_tmp qplatq,
25715: qp_qualifiers qpq,
25716: qp_list_headers_b qph,
25717: qp_price_req_sources_v qprs,
25718: qp_npreq_line_attrs_tmp qplatpr,
25719: qp_pricing_attributes qpprod,
25720: qp_list_lines qpl
25721: WHERE qph.list_header_id = qpl.list_header_id
25821: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25822: qp_npreq_line_attrs_tmp qplatq,
25823: qp_qualifiers qpq,
25824: qp_list_headers_b qph,
25825: qp_price_req_sources_v qprs,
25826: qp_npreq_line_attrs_tmp qplatpr,
25827: qp_pricing_attributes qpprod,
25828: qp_list_lines qpl
25829: WHERE qph.list_header_id = qpl.list_header_id
25948: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25949: qp_npreq_line_attrs_tmp qplatq,
25950: qp_qualifiers qpq,
25951: qp_list_headers_b qph,
25952: qp_price_req_sources_v qprs,
25953: qp_npreq_line_attrs_tmp qplatpr,
25954: qp_pricing_attributes qpprod,
25955: qp_list_lines qpl,
25956: qp_currency_details qcdt
26103: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26104: qp_npreq_line_attrs_tmp qplatq,
26105: qp_qualifiers qpq,
26106: qp_list_headers_b qph,
26107: qp_price_req_sources_v qprs,
26108: qp_npreq_line_attrs_tmp qplatpr,
26109: qp_pricing_attributes qpprod,
26110: qp_list_lines qpl,
26111: qp_currency_details qcdt
26258: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26259: qp_npreq_line_attrs_tmp qplatq,
26260: qp_qualifiers qpq,
26261: qp_list_headers_b qph,
26262: qp_price_req_sources_v qprs,
26263: qp_npreq_line_attrs_tmp qplatpr,
26264: qp_pricing_attributes qpprod,
26265: qp_list_lines qpl,
26266: qp_currency_details qcdt
26428: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26429: qp_npreq_line_attrs_tmp qplatq,
26430: qp_qualifiers qpq ,
26431: qp_list_headers_b qph,
26432: qp_price_req_sources_v qprs,
26433: qp_npreq_line_attrs_tmp qplatpr,
26434: qp_pricing_attributes qpprod ,
26435: qp_npreq_line_attrs_tmp qplatpc,
26436: qp_list_lines qpl
26556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26557: qp_npreq_line_attrs_tmp qplatq,
26558: qp_qualifiers qpq ,
26559: qp_list_headers_b qph,
26560: qp_price_req_sources_v qprs,
26561: qp_npreq_line_attrs_tmp qplatpr,
26562: qp_pricing_attributes qpprod ,
26563: qp_npreq_line_attrs_tmp qplatpc,
26564: qp_list_lines qpl
26684: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26685: qp_npreq_line_attrs_tmp qplatq,
26686: qp_qualifiers qpq ,
26687: qp_list_headers_b qph,
26688: qp_price_req_sources_v qprs,
26689: qp_npreq_line_attrs_tmp qplatpr,
26690: qp_pricing_attributes qpprod ,
26691: qp_npreq_line_attrs_tmp qplatpc,
26692: qp_list_lines qpl
26832: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26833: qp_npreq_line_attrs_tmp qplatq,
26834: qp_qualifiers qpq ,
26835: qp_list_headers_b qph,
26836: qp_price_req_sources_v qprs,
26837: qp_npreq_line_attrs_tmp qplatpr,
26838: qp_pricing_attributes qpprod ,
26839: qp_npreq_line_attrs_tmp qplatpc,
26840: qp_list_lines qpl,
27007: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27008: qp_npreq_line_attrs_tmp qplatq,
27009: qp_qualifiers qpq ,
27010: qp_list_headers_b qph,
27011: qp_price_req_sources_v qprs,
27012: qp_npreq_line_attrs_tmp qplatpr,
27013: qp_pricing_attributes qpprod ,
27014: qp_npreq_line_attrs_tmp qplatpc,
27015: qp_list_lines qpl,
27182: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27183: qp_npreq_line_attrs_tmp qplatq,
27184: qp_qualifiers qpq ,
27185: qp_list_headers_b qph,
27186: qp_price_req_sources_v qprs,
27187: qp_npreq_line_attrs_tmp qplatpr,
27188: qp_pricing_attributes qpprod ,
27189: qp_npreq_line_attrs_tmp qplatpc,
27190: qp_list_lines qpl,
27339: qp_npreq_line_attrs_tmp qplatpr,
27340: qp_pricing_attributes qpprod ,
27341: qp_list_lines qpl ,
27342: qp_list_headers_b qph ,
27343: qp_price_req_sources_v qprs
27344: WHERE
27345: qph.list_header_id = qpprod.list_header_id
27346: --added for moac -- commented references to security profile
27347: --security will be built into qp_list_headers_b
27426: qp_npreq_line_attrs_tmp qplatpr,
27427: qp_pricing_attributes qpprod,
27428: qp_list_lines qpl,
27429: qp_list_headers_b qph,
27430: qp_price_req_sources_v qprs,
27431: qp_currency_details qcdt
27432: WHERE qph.list_header_id = qpl.list_header_id
27433: --added for moac -- commented references to security profile
27434: --security will be built into qp_list_headers_b
27558: qp_pricing_attributes qpprod,
27559: qp_npreq_line_attrs_tmp qplatpc,
27560: qp_list_lines qpl,
27561: qp_list_headers_b qph,
27562: qp_price_req_sources_v QPRS
27563: WHERE
27564: qph.list_header_id = qpl.list_header_id
27565: --added for moac -- commented references to security profile
27566: --security will be built into qp_list_headers_b
27664: qp_pricing_attributes qpprod ,
27665: qp_npreq_line_attrs_tmp qplatpc,
27666: qp_list_lines qpl ,
27667: qp_list_headers_b qph,
27668: qp_price_req_sources_v qprs,
27669: qp_currency_details qcdt
27670: WHERE
27671: qph.list_header_id = qpl.list_header_id
27672: --added for moac -- commented references to security profile
32203: WHERE LINE_INDEX = p_line_index;
32204: --FOR UPDATE OF ROUNDING_FACTOR;
32205:
32206: /*
32207: INDX,QP_PREQ_GRP.price_request.get_source_system_cur,QP_PRICE_REQ_SOURCES_PK,REQUEST_TYPE_CODE,1
32208: */
32209: CURSOR get_source_system_cur IS
32210: SELECT 'X'
32211: FROM dual
32210: SELECT 'X'
32211: FROM dual
32212: WHERE EXISTS
32213: (Select 'X'
32214: --From QP_PRICE_REQ_SOURCES
32215: From QP_PRICE_REQ_SOURCES_V /* yangli */
32216: Where REQUEST_TYPE_CODE
32217: In (SELECT REQUEST_TYPE_CODE
32218: FROM qp_npreq_lines_tmp));
32211: FROM dual
32212: WHERE EXISTS
32213: (Select 'X'
32214: --From QP_PRICE_REQ_SOURCES
32215: From QP_PRICE_REQ_SOURCES_V /* yangli */
32216: Where REQUEST_TYPE_CODE
32217: In (SELECT REQUEST_TYPE_CODE
32218: FROM qp_npreq_lines_tmp));
32219: