[Home] [Help]
804: and pricing_phase_id = p_pricing_phase_id) qptq,
805: qp_qualifiers qpq ,
806: qp_npreq_line_attrs_tmp qplatq,
807: qp_list_headers_b qph,
808: qp_price_req_sources_v qprs
809: where
810: qpq.list_header_id = qptq.list_header_id
811: and qpq.list_line_id = qptq.list_line_id
812: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
905: and pricing_phase_id = p_pricing_phase_id) qptq,
906: qp_qualifiers qpq ,
907: qp_npreq_line_attrs_tmp qplatq,
908: qp_list_headers_b qph,
909: qp_price_req_sources_v qprs
910: where
911: qpq.list_header_id = qptq.list_header_id
912: and qpq.list_line_id = qptq.list_line_id
913: and qpq.qualifier_grouping_no = -1
1004: and pricing_phase_id = p_pricing_phase_id) qptq,
1005: qp_qualifiers qpq ,
1006: qp_npreq_line_attrs_tmp qplatq,
1007: qp_list_headers_b qph,
1008: qp_price_req_sources_v qprs
1009: where
1010: qpq.list_header_id = qptq.list_header_id
1011: and qpq.list_line_id = qptq.list_line_id
1012: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1107: and pricing_phase_id = p_pricing_phase_id) qptq,
1108: qp_qualifiers qpq ,
1109: qp_npreq_line_attrs_tmp qplatq,
1110: qp_list_headers_b qph,
1111: qp_price_req_sources_v qprs
1112: where
1113: qpq.list_header_id = qptq.list_header_id
1114: and qpq.list_line_id = qptq.list_line_id
1115: and qpq.qualifier_grouping_no = -1
1207: and pricing_phase_id = p_pricing_phase_id) qptq,
1208: qp_qualifiers qpq ,
1209: qp_npreq_line_attrs_tmp qplatq,
1210: qp_list_headers_b qph,
1211: qp_price_req_sources_v qprs
1212: where
1213: qpq.list_header_id = qptq.list_header_id
1214: and qpq.list_line_id = qptq.list_line_id
1215: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1311: and pricing_phase_id = p_pricing_phase_id) qptq,
1312: qp_qualifiers qpq ,
1313: qp_npreq_line_attrs_tmp qplatq,
1314: qp_list_headers_b qph,
1315: qp_price_req_sources_v qprs
1316: where
1317: qpq.list_header_id = qptq.list_header_id
1318: and qpq.list_line_id = qptq.list_line_id
1319: and qpq.qualifier_grouping_no = -1
1413: and pricing_phase_id = p_pricing_phase_id) qptq,
1414: qp_qualifiers qpq ,
1415: qp_npreq_line_attrs_tmp qplatq,
1416: qp_list_headers_b qph,
1417: qp_price_req_sources_v qprs
1418: where
1419: qpq.list_header_id = qptq.list_header_id
1420: and qpq.list_line_id = qptq.list_line_id
1421: and qpq.qualifier_grouping_no = qptq.qualifier_grouping_no
1514: and pricing_phase_id = p_pricing_phase_id) qptq,
1515: qp_qualifiers qpq ,
1516: qp_npreq_line_attrs_tmp qplatq,
1517: qp_list_headers_b qph,
1518: qp_price_req_sources_v qprs
1519: where
1520: qpq.list_header_id = qptq.list_header_id
1521: and qpq.list_line_id = qptq.list_line_id
1522: and qpq.qualifier_grouping_no = -1
1810: qp_npreq_line_attrs_tmp qplatq,
1811: qp_qualifiers qpq ,
1812: qp_list_header_phases qplh,
1813: qp_list_headers_b qph,
1814: qp_price_req_sources_v qprs
1815: where
1816: qpq.list_header_id = qplh.list_header_id
1817: and qplh.list_header_id = qph.list_header_id
1818: -- bug 2799120
1932: qp_npreq_line_attrs_tmp qplatq,
1933: qp_qualifiers qpq ,
1934: qp_list_header_phases qplh,
1935: qp_list_headers_b qph,
1936: qp_price_req_sources_v qprs
1937: where
1938: qpq.list_header_id = qplh.list_header_id
1939: and qplh.list_header_id = qph.list_header_id
1940: -- bug 2799120
2056: qp_npreq_line_attrs_tmp qplatq,
2057: qp_qualifiers qpq ,
2058: qp_list_header_phases qplh,
2059: qp_list_headers_b qph,
2060: qp_price_req_sources_v qprs
2061: where
2062: qpq.list_header_id = qplh.list_header_id
2063: and qplh.list_header_id = qph.list_header_id
2064: -- bug 2799120
2181: qp_npreq_line_attrs_tmp qplatq,
2182: qp_qualifiers qpq ,
2183: qp_list_header_phases qplh,
2184: qp_list_headers_b qph,
2185: qp_price_req_sources_v qprs
2186: where
2187: qpq.list_header_id = qplh.list_header_id
2188: and qplh.list_header_id = qph.list_header_id
2189: -- bug 2799120
2530: qp_npreq_line_attrs_tmp qplatq,
2531: qp_qualifiers qpq ,
2532: qp_list_header_phases qplh,
2533: qp_list_headers_b qph,
2534: qp_price_req_sources_v qprs
2535: where
2536: qpq.list_header_id = qplh.list_header_id
2537: and qplh.list_header_id = qph.list_header_id
2538: -- bug 2799120
2633: qp_npreq_line_attrs_tmp qplatq,
2634: qp_qualifiers qpq ,
2635: qp_list_header_phases qplh,
2636: qp_list_headers_b qph,
2637: qp_price_req_sources_v qprs
2638: where
2639: qpq.list_header_id = qplh.list_header_id
2640: and qplh.list_header_id = qph.list_header_id
2641: -- bug 2799120
2739: qp_npreq_line_attrs_tmp qplatq,
2740: qp_qualifiers qpq ,
2741: qp_list_header_phases qplh,
2742: qp_list_headers_b qph,
2743: qp_price_req_sources_v qprs
2744: where
2745: qpq.list_header_id = qplh.list_header_id
2746: and qplh.list_header_id = qph.list_header_id
2747: -- bug 2799120
2846: qp_npreq_line_attrs_tmp qplatq,
2847: qp_qualifiers qpq ,
2848: qp_list_header_phases qplh,
2849: qp_list_headers_b qph,
2850: qp_price_req_sources_v qprs
2851: where
2852: qpq.list_header_id = qplh.list_header_id
2853: and qplh.list_header_id = qph.list_header_id
2854: -- bug 2799120
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*/
14951: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
14952: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
14953: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
14954: AND QPQ.COMPARISON_OPERATOR_CODE = '='
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
15072: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15073: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15074: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15075: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15076: AND QPQ.COMPARISON_OPERATOR_CODE = '='
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: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15202: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15203: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15204: AND QPQ.COMPARISON_OPERATOR_CODE = '='
15338: qp_npreq_line_attrs_tmp qplat_q,
15339: QP_LIST_LINES qpl,
15340: QP_LIST_HEADERS_B qph,
15341: --QP_PRICE_REQ_SOURCES qprs
15342: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
15343: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15344: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15345: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15346: AND QPQ.COMPARISON_OPERATOR_CODE = '='
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 */
15498: QP_CURRENCY_DETAILS QCDT /* Vivek */
15499: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15500: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15501: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
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,
15679: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15680: QP_CURRENCY_DETAILS QCDT /* Vivek */
15681: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15682: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15683: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
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 */
15868: QP_CURRENCY_DETAILS QCDT /* Vivek */
15869: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15870: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15871: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
16065: qp_npreq_line_attrs_tmp qplat_q,
16066: QP_LIST_LINES qpl,
16067: QP_LIST_HEADERS_B qph,
16068: --QP_PRICE_REQ_SOURCES qprs,
16069: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
16070: QP_CURRENCY_DETAILS QCDT /* Vivek */
16071: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
16072: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
16073: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
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 */
17169: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17170: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17171: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17172: AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') --po integration
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
17274: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
17275: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17276: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17277: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17278: AND QPLINES.LIST_PRICE_OVERRIDE_FLAG IN ('N', 'O') --po integration
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 */
17400: QP_CURRENCY_DETAILS QCDT /* Vivek */
17401: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17402: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17403: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
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,
17557: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17558: QP_CURRENCY_DETAILS QCDT /* Vivek */
17559: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17560: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17561: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
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 */
17775: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17776: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17777: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17778: AND (QPLINES.PRICE_FLAG = G_YES
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
17902: QP_PRICE_REQ_SOURCES_V QPRS /* yangli */
17903: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17904: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
17905: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17906: AND (QPLINES.PRICE_FLAG = G_YES
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 */
18036: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18037: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
18038: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18039: AND (QPLINES.PRICE_FLAG = G_YES
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
18138: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
18139: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18140: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18141: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18142: AND (QPLINES.PRICE_FLAG = G_YES
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 */
18261: QP_CURRENCY_DETAILS QCDT /* Vivek */
18262: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18263: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
18264: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
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,
18446: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18447: QP_CURRENCY_DETAILS QCDT /* Vivek */
18448: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18449: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
18450: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
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 */
18638: QP_CURRENCY_DETAILS QCDT /* Vivek */
18639: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18640: --AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
18641: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
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,
18801: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18802: QP_CURRENCY_DETAILS QCDT /* Vivek */
18803: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18804: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18805: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
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
19039: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_IND, QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND,
19040: QP_PREQ_GRP.G_YES_PROD_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_HDR_LINE_QUAL_IND)
19041: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
21100: qp_npreq_line_patrns_tmp qppattmp,
21101: QP_QUALIFIERS qpq,
21102: qp_secu_attr_groups_v atrgrps,
21103: --qp_attribute_groups atrgrps,
21104: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21105: qp_pte_source_systems qprs
21106: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21107: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21108: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21247: qp_npreq_line_patrns_tmp qppattmp,
21248: QP_QUALIFIERS qpq,
21249: qp_secu_attr_groups_v atrgrps,
21250: --qp_attribute_groups atrgrps,
21251: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21252: qp_pte_source_systems qprs,
21253: qp_currency_details qcdt
21254: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21255: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21448: qp_npreq_lines_tmp qplines,
21449: QP_QUALIFIERS qpq,
21450: qp_list_headers_b qph,
21451: qp_pte_source_systems qprs,
21452: --QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
21453: qp_currency_details qcdt
21454: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21455: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21456: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21632: qp_npreq_lines_tmp qplines,
21633: QP_QUALIFIERS qpq,
21634: qp_list_headers_b qph,
21635: qp_pte_source_systems qprs
21636: --QP_PRICE_REQ_SOURCES_V qprs /* yangli */
21637: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21638: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21639: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21640: AND QPQ.COMPARISON_OPERATOR_CODE = '='
21779: qp_list_lines qpl,
21780: qp_secu_attr_groups_v qpatrgrp,
21781: --qp_attribute_groups qpatrgrp,
21782: qp_pte_source_systems qprs
21783: --qp_price_req_sources_v qprs
21784: WHERE qppattmp1.line_index = qplines.line_index
21785: AND QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21786: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
21787: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21884: qp_list_lines qpl,
21885: qp_secu_attr_groups_v qpatrgrp,
21886: --qp_attribute_groups qpatrgrp,
21887: qp_pte_source_systems qprs,
21888: --qp_price_req_sources_v qprs,
21889: QP_CURRENCY_DETAILS QCDT
21890: WHERE qppattmp1.line_index = qplines.line_index
21891: AND QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
21892: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
23596: qp_list_lines qpl,
23597: qp_secu_attr_groups_v qpatrgrp,
23598: --qp_attribute_groups qpatrgrp,
23599: qp_pte_source_systems qprs,
23600: --qp_price_req_sources_v qprs,
23601: qp_npreq_line_patrns_tmp qppattmp2
23602: WHERE QPLINES.VALIDATED_FLAG = G_NO
23603: AND (qplines.price_flag = G_YES OR
23604: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
23677: qp_npreq_line_patrns_tmp qppattmp1,
23678: qp_list_lines qpl,
23679: qp_list_headers_b qph,
23680: qp_pte_source_systems qprs
23681: --qp_price_req_sources_v qprs
23682: WHERE QPLINES.VALIDATED_FLAG = G_YES
23683: AND (qplines.price_flag = G_YES OR
23684: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
23685: AND qplines.list_price_override_flag in ('N', 'O') -- po integration
23757: qp_list_lines qpl,
23758: qp_secu_attr_groups_v qpatrgrp,
23759: --qp_attribute_groups qpatrgrp,
23760: qp_pte_source_systems qprs,
23761: --qp_price_req_sources_v qprs,
23762: qp_npreq_line_patrns_tmp qppattmp2,
23763: QP_CURRENCY_DETAILS QCDT
23764: WHERE QPLINES.VALIDATED_FLAG = G_NO
23765: AND (qplines.price_flag = G_YES OR
23892: FROM qp_npreq_lines_tmp qplines,
23893: qp_npreq_line_patrns_tmp qppattmp1,
23894: qp_list_lines qpl,
23895: qp_list_headers_b qph,
23896: --qp_price_req_sources_v qprs,
23897: qp_pte_source_systems qprs,
23898: QP_CURRENCY_DETAILS QCDT
23899: WHERE QPLINES.VALIDATED_FLAG = G_YES
23900: AND (qplines.price_flag = G_YES OR
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 */
26193: WHERE
26194: (qplines.price_flag = G_YES
26195: OR
26196: (qplines.price_flag = G_PHASE
26363: qp_npreq_line_attrs_tmp qplatpc,
26364: QP_LIST_HEADERS_B QPH ,
26365: QP_LIST_LINES QPL ,
26366: --QP_PRICE_REQ_SOURCES qprs
26367: QP_PRICE_REQ_SOURCES_V qprs /* yangli */
26368: WHERE
26369: (qplines.price_flag = G_YES
26370: OR
26371: (qplines.price_flag = G_PHASE
26500: qp_npreq_lines_tmp qplines,
26501: qp_list_lines qpl,
26502: qp_list_headers_b qph,
26503: --qp_price_req_sources qprs
26504: qp_price_req_sources_v qprs /* yangli */
26505: where qph.list_header_id = qpl.list_header_id
26506: --added for moac -- commented references to security profile
26507: --security will be built into qp_list_headers_b
26508: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security
29478: qp_npreq_line_patrns_tmp qppattmp,
29479: qp_secu_attr_groups_v atrgrps,
29480: --qp_attribute_groups atrgrps,
29481: qp_pte_source_systems qprs
29482: --qp_price_req_sources_v qprs
29483: WHERE qppattmp.line_index = qplines.line_index
29484: AND atrgrps.pricing_phase_id = p_pricing_phase_id
29485: AND atrgrps.list_line_id = -1
29486: AND atrgrps.active_flag = G_YES
29620: qp_list_lines qpl,
29621: qp_secu_attr_groups_v qpatrgrp,
29622: --qp_attribute_groups qpatrgrp,
29623: qp_pte_source_systems qprs,
29624: --qp_price_req_sources_v qprs,
29625: qp_npreq_line_patrns_tmp qppattmp2
29626: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29627: AND nvl(qplines.validated_flag,G_NO) = G_NO
29628: AND (qplines.price_flag = G_YES OR
29718: qp_list_lines qpl,
29719: qp_secu_attr_groups_v qpatrgrp,
29720: --qp_attribute_groups qpatrgrp,
29721: qp_pte_source_systems qprs,
29722: --qp_price_req_sources_v qprs,
29723: qp_npreq_line_patrns_tmp qppattmp2,
29724: QP_CURRENCY_DETAILS QCDT
29725: WHERE qplines.processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED) --check this condition
29726: AND nvl(qplines.validated_flag,G_NO) = G_NO
29847: qp_npreq_line_patrns_tmp qppattmp,
29848: qp_secu_attr_groups_v atrgrps,
29849: --qp_attribute_groups atrgrps,
29850: qp_pte_source_systems qprs,
29851: --qp_price_req_sources_v qprs,
29852: QP_CURRENCY_DETAILS QCDT
29853: WHERE qppattmp.line_index = qplines.line_index
29854: AND atrgrps.pricing_phase_id = p_pricing_phase_id
29855: AND atrgrps.list_line_id = -1
31152: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31153: qp_npreq_line_attrs_tmp qplatq,
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
31262: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31263: qp_npreq_line_attrs_tmp qplatq,
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
31372: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31373: qp_npreq_line_attrs_tmp qplatq,
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
31501: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31502: qp_npreq_line_attrs_tmp qplatq,
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
31658: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31659: qp_npreq_line_attrs_tmp qplatq,
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
31815: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31816: qp_npreq_line_attrs_tmp qplatq,
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
31985: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
31986: qp_npreq_line_attrs_tmp qplatq,
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
32113: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32114: qp_npreq_line_attrs_tmp qplatq,
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
32241: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32242: qp_npreq_line_attrs_tmp qplatq,
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
32389: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32390: qp_npreq_line_attrs_tmp qplatq,
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,
32564: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32565: qp_npreq_line_attrs_tmp qplatq,
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,
32739: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
32740: qp_npreq_line_attrs_tmp qplatq,
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,
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
32903: qph.list_header_id = qpprod.list_header_id
32904: --added for moac -- commented references to security profile
32905: --security will be built into qp_list_headers_b
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
32990: WHERE qph.list_header_id = qpl.list_header_id
32991: AND qph.list_header_id = qpprod.list_header_id
32992: --added for moac -- commented references to security profile
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
33124: WHERE
33125: qph.list_header_id = qpl.list_header_id
33126: --added for moac -- commented references to security profile
33127: --security will be built into qp_list_headers_b
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,
33230: qp_currency_details qcdt
33231: WHERE
33232: qph.list_header_id = qpl.list_header_id
33233: --added for moac -- commented references to security profile
37770: --qp_attribute_groups atrgrps,
37771: qp_npreq_line_patrns_tmp qppattmp,
37772: qp_npreq_lines_tmp qplines,
37773: qp_pte_source_systems qprs
37774: --qp_price_req_sources_v qprs
37775: WHERE qplhp.pricing_phase_id = p_pricing_phase_id
37776: AND atrgrps.list_header_id = qplhp.list_header_id
37777: AND atrgrps.list_line_id = -1 -- Filter
37778: AND atrgrps.pte_code = G_PTE_CODE
38169: qp_npreq_line_patrns_tmp qppattmp_l,
38170: qp_attribute_groups atrgrps_l,
38171: qp_attribute_groups atrgrps_h,
38172: qp_npreq_line_patrns_tmp qppattmp_h,
38173: qp_price_req_sources_v qprs
38174: WHERE atrgrps_l.list_line_id <> -1 -- Filter
38175: AND atrgrps_h.list_line_id = -1 -- Filter
38176: AND atrgrps_l.list_header_id = atrgrps_h.list_header_id -- Filter
38177: AND qppattmp_l.pattern_id = atrgrps_l.pattern_id -- Match
40952: FROM dual
40953: WHERE EXISTS
40954: (Select 'X'
40955: --From QP_PRICE_REQ_SOURCES
40956: From QP_PRICE_REQ_SOURCES_V /* yangli */
40957: Where REQUEST_TYPE_CODE
40958: In (SELECT REQUEST_TYPE_CODE
40959: FROM qp_npreq_lines_tmp));
40960: