eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_GRP dependencies on QP_CURRENCY_DETAILS

Line 10956: engine_debug ('get rounding_factor from qp_currency_details table...');

10952: -- cannot use IF G_MCURR_INSTALLED_USED here, it is null
10953: IF G_MULTI_CURRENCY_PROFILE = 'Y' and G_USE_MULTI_CURRENCY = 'Y' THEN
10954:
10955: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10956: engine_debug ('get rounding_factor from qp_currency_details table...');
10957: END IF;
10958:
10959: UPDATE qp_npreq_lines_tmp a
10960: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor

Line 10961: FROM qp_currency_details qcdt, qp_list_headers_b qhdr

10957: END IF;
10958:
10959: UPDATE qp_npreq_lines_tmp a
10960: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor
10961: FROM qp_currency_details qcdt, qp_list_headers_b qhdr
10962: WHERE qhdr.list_header_id = a.price_list_header_id
10963: AND qhdr.currency_header_id = qcdt.currency_header_id
10964: AND qcdt.to_currency_code = a.currency_code
10965: AND a.pricing_effective_date BETWEEN

Line 11775: ,qp_currency_details qcdt /* Vivek */

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
11777: AND qprm.to_rltd_modifier_id = qppa.list_line_id
11778: AND qppa.list_line_id = qpll.list_line_id
11779: AND qplat_pricing.context = G_PRIC_VOLUME_CONTEXT

Line 11799: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

11795: AND ( /* Vivek */
11796: (qcdt.curr_attribute_context is null /* Vivek */
11797: and not exists /* Vivek */
11798: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
11799: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
11800: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
11801: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
11802: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
11803: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 11818: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

11814: OR /* Vivek */
11815: (qcdt.curr_attribute_context is not null /* Vivek */
11816: and qcdt.precedence =
11817: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
11818: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
11819: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
11820: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
11821: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
11822: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15498: QP_CURRENCY_DETAILS QCDT /* Vivek */

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)
15502: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 15551: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

15547: AND ( /* Vivek */
15548: (qcdt.curr_attribute_context is null /* Vivek */
15549: and not exists /* Vivek */
15550: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15551: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15552: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15553: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15554: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15555: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15570: from qp_currency_details qcdt3 /* Vivek */

15566: OR /* Vivek */
15567: (qcdt.curr_attribute_context is not null /* Vivek */
15568: and qcdt.currency_detail_id = /* Vivek */
15569: (select qcdt3.currency_detail_id
15570: from qp_currency_details qcdt3 /* Vivek */
15571: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15572: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15573: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15574: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 15578: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

15574: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15575: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15576: and qcdt3.precedence =
15577: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15578: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15579: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15580: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15581: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15582: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15680: QP_CURRENCY_DETAILS QCDT /* Vivek */

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)
15684: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 15742: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

15738: AND ( /* Vivek */
15739: (qcdt.curr_attribute_context is null /* Vivek */
15740: and not exists /* Vivek */
15741: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15742: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15743: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15744: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15745: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15746: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15761: from qp_currency_details qcdt3 /* Vivek */

15757: OR /* Vivek */
15758: (qcdt.curr_attribute_context is not null /* Vivek */
15759: and qcdt.currency_detail_id = /* Vivek */
15760: (select qcdt3.currency_detail_id
15761: from qp_currency_details qcdt3 /* Vivek */
15762: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15763: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15764: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15765: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 15769: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

15765: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15766: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15767: and qcdt3.precedence =
15768: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15769: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15770: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15771: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15772: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15773: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15868: QP_CURRENCY_DETAILS QCDT /* Vivek */

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)
15872: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 15916: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

15912: AND ( /* Vivek */
15913: (qcdt.curr_attribute_context is null /* Vivek */
15914: and not exists /* Vivek */
15915: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15916: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15917: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15918: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15919: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15920: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15935: from qp_currency_details qcdt3 /* Vivek */

15931: OR /* Vivek */
15932: (qcdt.curr_attribute_context is not null /* Vivek */
15933: and qcdt.currency_detail_id = /* Vivek */
15934: (select qcdt3.currency_detail_id
15935: from qp_currency_details qcdt3 /* Vivek */
15936: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15937: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15938: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15939: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 15943: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

15939: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15940: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15941: and qcdt3.precedence =
15942: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15943: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15944: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15945: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15946: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15947: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 16070: QP_CURRENCY_DETAILS QCDT /* Vivek */

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)
16074: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 16127: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

16123: AND ( /* Vivek */
16124: (qcdt.curr_attribute_context is null /* Vivek */
16125: and not exists /* Vivek */
16126: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
16127: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
16128: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
16129: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
16130: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
16131: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 16146: from qp_currency_details qcdt3 /* Vivek */

16142: OR /* Vivek */
16143: (qcdt.curr_attribute_context is not null /* Vivek */
16144: and qcdt.currency_detail_id = /* Vivek */
16145: (select qcdt3.currency_detail_id
16146: from qp_currency_details qcdt3 /* Vivek */
16147: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
16148: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
16149: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
16150: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 16154: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

16150: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
16151: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
16152: and qcdt3.precedence =
16153: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
16154: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
16155: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
16156: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
16157: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
16158: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 17400: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
17404: AND (QPLINES.PRICE_FLAG = G_YES

Line 17457: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

17453: AND ( /* Vivek */
17454: (qcdt.curr_attribute_context is null /* Vivek */
17455: and not exists /* Vivek */
17456: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
17457: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
17458: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
17459: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
17460: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
17461: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 17476: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

17472: OR /* Vivek */
17473: (qcdt.curr_attribute_context is not null /* Vivek */
17474: and qcdt.precedence =
17475: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
17476: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
17477: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
17478: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
17479: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
17480: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 17558: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
17562: AND (QPLINES.PRICE_FLAG = G_YES

Line 17624: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

17620: AND ( /* Vivek */
17621: (qcdt.curr_attribute_context is null /* Vivek */
17622: and not exists /* Vivek */
17623: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
17624: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
17625: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
17626: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
17627: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
17628: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 17643: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

17639: OR /* Vivek */
17640: (qcdt.curr_attribute_context is not null /* Vivek */
17641: and qcdt.precedence =
17642: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
17643: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
17644: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
17645: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
17646: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
17647: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18261: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
18265: AND (QPLINES.PRICE_FLAG = G_YES

Line 18302: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

18298: AND ( /* Vivek */
18299: (qcdt.curr_attribute_context is null /* Vivek */
18300: and not exists /* Vivek */
18301: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18302: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18303: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18304: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18305: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18306: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18321: from qp_currency_details qcdt3 /* Vivek */

18317: OR /* Vivek */
18318: (qcdt.curr_attribute_context is not null /* Vivek */
18319: and qcdt.currency_detail_id = /* Vivek */
18320: (select qcdt3.currency_detail_id
18321: from qp_currency_details qcdt3 /* Vivek */
18322: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18323: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18324: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18325: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 18329: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

18325: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18326: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18327: and qcdt3.precedence =
18328: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18329: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18330: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18331: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18332: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18333: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18447: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
18451: AND (QPLINES.PRICE_FLAG = G_YES

Line 18491: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

18487: AND ( /* Vivek */
18488: (qcdt.curr_attribute_context is null /* Vivek */
18489: and not exists /* Vivek */
18490: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18491: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18492: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18493: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18494: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18495: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18510: from qp_currency_details qcdt3 /* Vivek */

18506: OR /* Vivek */
18507: (qcdt.curr_attribute_context is not null /* Vivek */
18508: and qcdt.currency_detail_id = /* Vivek */
18509: (select qcdt3.currency_detail_id
18510: from qp_currency_details qcdt3 /* Vivek */
18511: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18512: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18513: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18514: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 18518: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

18514: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18515: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18516: and qcdt3.precedence =
18517: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18518: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18519: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18520: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18521: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18522: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18638: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
18642: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT

Line 18681: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

18677: AND ( /* Vivek */
18678: (qcdt.curr_attribute_context is null /* Vivek */
18679: and not exists /* Vivek */
18680: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18681: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18682: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18683: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18684: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18685: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18700: from qp_currency_details qcdt3 /* Vivek */

18696: OR /* Vivek */
18697: (qcdt.curr_attribute_context is not null /* Vivek */
18698: and qcdt.currency_detail_id = /* Vivek */
18699: (select qcdt3.currency_detail_id
18700: from qp_currency_details qcdt3 /* Vivek */
18701: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18702: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18703: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18704: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 18708: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

18704: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18705: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18706: and qcdt3.precedence =
18707: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18708: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18709: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18710: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18711: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18712: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18802: QP_CURRENCY_DETAILS QCDT /* Vivek */

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
18806: AND (QPLINES.PRICE_FLAG = G_YES

Line 18852: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */

18848: AND ( /* Vivek */
18849: (qcdt.curr_attribute_context is null /* Vivek */
18850: and not exists /* Vivek */
18851: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18852: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18853: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18854: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18855: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18856: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18871: from qp_currency_details qcdt3 /* Vivek */

18867: OR /* Vivek */
18868: (qcdt.curr_attribute_context is not null /* Vivek */
18869: and qcdt.currency_detail_id = /* Vivek */
18870: (select qcdt3.currency_detail_id
18871: from qp_currency_details qcdt3 /* Vivek */
18872: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18873: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18874: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18875: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

Line 18879: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */

18875: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18876: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18877: and qcdt3.precedence =
18878: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18879: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18880: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18881: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18882: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18883: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 21213: /*+ ORDERED index(qcdt QP_CURRENCY_DETAILS_N2)

21209: ORDER BY 1,2;
21210:
21211: CURSOR L_SEC_LST_HDR_P1_QLFY_Y_CURR IS
21212: SELECT
21213: /*+ ORDERED index(qcdt QP_CURRENCY_DETAILS_N2)
21214: index(atrgrps QP_ATTRIBUTE_GROUPS_N3)
21215: index(qplines QP_PREQ_LINES_TMP_U1)
21216: index(qprs qp_pte_source_systems_u2)
21217: L_SEC_LST_HDR_P1_QLFY_Y_CURR */

Line 21253: qp_currency_details qcdt

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
21256: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
21257: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 21291: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

21287: AND NVL(TRUNC(QCDT.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21288: AND (
21289: (qcdt.curr_attribute_context is null
21290: and not exists
21291: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21292: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21293: where qcdt1.curr_attribute_context IS NOT NULL
21294: and qcdt1.curr_attribute_context = pa_tmp.context
21295: and qcdt1.curr_attribute = pa_tmp.attribute

Line 21292: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

21288: AND (
21289: (qcdt.curr_attribute_context is null
21290: and not exists
21291: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21292: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21293: where qcdt1.curr_attribute_context IS NOT NULL
21294: and qcdt1.curr_attribute_context = pa_tmp.context
21295: and qcdt1.curr_attribute = pa_tmp.attribute
21296: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 21311: from qp_currency_details qcdt3

21307: OR
21308: (qcdt.curr_attribute_context is not null
21309: and qcdt.currency_detail_id =
21310: (select qcdt3.currency_detail_id
21311: from qp_currency_details qcdt3
21312: where qcdt3.to_currency_code = qcdt.to_currency_code
21313: and qcdt3.currency_header_id = qcdt.currency_header_id
21314: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21315: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)

Line 21318: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) / min(qcdt2.precedence)

21314: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21315: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21316: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21317: and qcdt3.precedence =
21318: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21319: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21320: where qcdt2.curr_attribute_context IS NOT NULL
21321: and qcdt2.curr_attribute_context = pa_tmp1.context
21322: and qcdt2.curr_attribute = pa_tmp1.attribute

Line 21319: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

21315: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21316: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21317: and qcdt3.precedence =
21318: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21319: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21320: where qcdt2.curr_attribute_context IS NOT NULL
21321: and qcdt2.curr_attribute_context = pa_tmp1.context
21322: and qcdt2.curr_attribute = pa_tmp1.attribute
21323: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 21417: index(qcdt QP_CURRENCY_DETAILS_N2)

21413:
21414: CURSOR L_SEC_LST_HDR_P1_QLFY_N_CURR IS
21415: SELECT
21416: /*+ ORDERED index(qplines QP_PREQ_LINES_TMP_U1)
21417: index(qcdt QP_CURRENCY_DETAILS_N2)
21418: index(qprs qp_pte_source_systems_u2)
21419: L_SEC_LST_HDR_P1_QLFY_N_CURR */
21420: DISTINCT qph.list_header_id,
21421: -1 list_line_id,

Line 21453: qp_currency_details qcdt

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)
21457: AND QPQ.COMPARISON_OPERATOR_CODE = '='

Line 21481: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

21477: AND NVL(TRUNC(QCDT.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21478: AND (
21479: (qcdt.curr_attribute_context is null
21480: and not exists
21481: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21482: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21483: where qcdt1.curr_attribute_context IS NOT NULL
21484: and qcdt1.curr_attribute_context = pa_tmp.context
21485: and qcdt1.curr_attribute = pa_tmp.attribute

Line 21482: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

21478: AND (
21479: (qcdt.curr_attribute_context is null
21480: and not exists
21481: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21482: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21483: where qcdt1.curr_attribute_context IS NOT NULL
21484: and qcdt1.curr_attribute_context = pa_tmp.context
21485: and qcdt1.curr_attribute = pa_tmp.attribute
21486: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 21501: from qp_currency_details qcdt3

21497: OR
21498: (qcdt.curr_attribute_context is not null
21499: and qcdt.currency_detail_id =
21500: (select qcdt3.currency_detail_id
21501: from qp_currency_details qcdt3
21502: where qcdt3.to_currency_code = qcdt.to_currency_code
21503: and qcdt3.currency_header_id = qcdt.currency_header_id
21504: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21505: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)

Line 21508: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) / min(qcdt2.precedence)

21504: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21505: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21506: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21507: and qcdt3.precedence =
21508: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21509: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21510: where qcdt2.curr_attribute_context IS NOT NULL
21511: and qcdt2.curr_attribute_context = pa_tmp1.context
21512: and qcdt2.curr_attribute = pa_tmp1.attribute

Line 21509: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

21505: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21506: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21507: and qcdt3.precedence =
21508: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21509: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21510: where qcdt2.curr_attribute_context IS NOT NULL
21511: and qcdt2.curr_attribute_context = pa_tmp1.context
21512: and qcdt2.curr_attribute = pa_tmp1.attribute
21513: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 21838: index(qcdt QP_CURRENCY_DETAILS_N2)

21834: index(QPQ QP_QUALIFIERS_N4)
21835: index(qpl QP_LIST_LINES_N16)
21836: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
21837: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)
21838: index(qcdt QP_CURRENCY_DETAILS_N2)
21839: index(qprs qp_pte_source_systems_u2)
21840: L_SEC_SRCH_BOTH_P2_QLFY_N_CURR */
21841: DISTINCT
21842: qpl.LIST_HEADER_ID,

Line 21889: QP_CURRENCY_DETAILS QCDT

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
21893: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)

Line 21943: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

21939: AND NVL(TRUNC(QCDT.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21940: AND (
21941: (qcdt.curr_attribute_context is null
21942: and not exists
21943: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21944: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21945: where qcdt1.curr_attribute_context IS NOT NULL
21946: and qcdt1.curr_attribute_context = pa_tmp.context
21947: and qcdt1.curr_attribute = pa_tmp.attribute

Line 21944: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

21940: AND (
21941: (qcdt.curr_attribute_context is null
21942: and not exists
21943: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
21944: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
21945: where qcdt1.curr_attribute_context IS NOT NULL
21946: and qcdt1.curr_attribute_context = pa_tmp.context
21947: and qcdt1.curr_attribute = pa_tmp.attribute
21948: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 21963: from qp_currency_details qcdt3

21959: OR
21960: (qcdt.curr_attribute_context is not null
21961: and qcdt.currency_detail_id =
21962: (select qcdt3.currency_detail_id
21963: from qp_currency_details qcdt3
21964: where qcdt3.to_currency_code = qcdt.to_currency_code
21965: and qcdt3.currency_header_id = qcdt.currency_header_id
21966: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21967: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)

Line 21970: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) / min(qcdt2.precedence)

21966: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN
21967: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21968: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21969: and qcdt3.precedence =
21970: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21971: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21972: where qcdt2.curr_attribute_context IS NOT NULL
21973: and qcdt2.curr_attribute_context = pa_tmp1.context
21974: and qcdt2.curr_attribute = pa_tmp1.attribute

Line 21971: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

21967: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21968: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)
21969: and qcdt3.precedence =
21970: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
21971: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
21972: where qcdt2.curr_attribute_context IS NOT NULL
21973: and qcdt2.curr_attribute_context = pa_tmp1.context
21974: and qcdt2.curr_attribute = pa_tmp1.attribute
21975: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 23709: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)

23705: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0);
23706:
23707: CURSOR l_pat_cache_both_curr IS
23708:
23709: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
23710: index(qplines QP_PREQ_LINES_TMP_N3)
23711: index(qpl QP_LIST_LINES_N16)
23712: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23713: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

Line 23763: QP_CURRENCY_DETAILS QCDT

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
23766: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
23767: AND qplines.list_price_override_flag in ('N', 'O') -- po integration

Line 23801: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

23797: AND TRUNC(NVL(QCDT.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23798: AND (
23799: (qcdt.curr_attribute_context is null
23800: and not exists
23801: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
23802: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
23803: where qcdt1.curr_attribute_context IS NOT NULL
23804: and qcdt1.curr_attribute_context = pa_tmp.context
23805: and qcdt1.curr_attribute = pa_tmp.attribute

Line 23802: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

23798: AND (
23799: (qcdt.curr_attribute_context is null
23800: and not exists
23801: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
23802: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
23803: where qcdt1.curr_attribute_context IS NOT NULL
23804: and qcdt1.curr_attribute_context = pa_tmp.context
23805: and qcdt1.curr_attribute = pa_tmp.attribute
23806: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 23821: from qp_currency_details qcdt3

23817: OR
23818: (qcdt.curr_attribute_context is not null
23819: and qcdt.currency_detail_id =
23820: (select qcdt3.currency_detail_id
23821: from qp_currency_details qcdt3
23822: where qcdt3.to_currency_code = qcdt.to_currency_code
23823: and qcdt3.currency_header_id = qcdt.currency_header_id
23824: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
23825: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))

Line 23828: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) /

23824: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
23825: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23826: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23827: and qcdt3.precedence =
23828: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
23829: min(qcdt2.precedence)
23830: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
23831: where qcdt2.curr_attribute_context IS NOT NULL
23832: and qcdt2.curr_attribute_context = pa_tmp1.context

Line 23830: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

23826: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23827: and qcdt3.precedence =
23828: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
23829: min(qcdt2.precedence)
23830: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
23831: where qcdt2.curr_attribute_context IS NOT NULL
23832: and qcdt2.curr_attribute_context = pa_tmp1.context
23833: and qcdt2.curr_attribute = pa_tmp1.attribute
23834: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 23848: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)

23844: )
23845: )
23846: AND (instr(QPLINES.PROCESS_STATUS,'FREEGOOD')=0)
23847: UNION
23848: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
23849: index(qplines QP_PREQ_LINES_TMP_N3)
23850: index(qpl QP_LIST_LINES_N16)
23851: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
23852: index(qprs qp_pte_source_systems_u2)

Line 23898: QP_CURRENCY_DETAILS QCDT

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
23901: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))
23902: AND qplines.list_price_override_flag in ('N', 'O') -- po integration

Line 23929: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

23925: AND TRUNC(NVL(QCDT.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23926: AND (
23927: (qcdt.curr_attribute_context is null
23928: and not exists
23929: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
23930: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
23931: where qcdt1.curr_attribute_context IS NOT NULL
23932: and qcdt1.curr_attribute_context = pa_tmp.context
23933: and qcdt1.curr_attribute = pa_tmp.attribute

Line 23930: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

23926: AND (
23927: (qcdt.curr_attribute_context is null
23928: and not exists
23929: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
23930: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
23931: where qcdt1.curr_attribute_context IS NOT NULL
23932: and qcdt1.curr_attribute_context = pa_tmp.context
23933: and qcdt1.curr_attribute = pa_tmp.attribute
23934: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 23949: from qp_currency_details qcdt3

23945: OR
23946: (qcdt.curr_attribute_context is not null
23947: and qcdt.currency_detail_id =
23948: (select qcdt3.currency_detail_id
23949: from qp_currency_details qcdt3
23950: where qcdt3.to_currency_code = qcdt.to_currency_code
23951: and qcdt3.currency_header_id = qcdt.currency_header_id
23952: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
23953: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))

Line 23956: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) /

23952: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
23953: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23954: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23955: and qcdt3.precedence =
23956: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
23957: min(qcdt2.precedence)
23958: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
23959: where qcdt2.curr_attribute_context IS NOT NULL
23960: and qcdt2.curr_attribute_context = pa_tmp1.context

Line 23958: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

23954: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
23955: and qcdt3.precedence =
23956: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
23957: min(qcdt2.precedence)
23958: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
23959: where qcdt2.curr_attribute_context IS NOT NULL
23960: and qcdt2.curr_attribute_context = pa_tmp1.context
23961: and qcdt2.curr_attribute = pa_tmp1.attribute
23962: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 29666: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)

29662: -- Selecting all the price list lines which are matching in pattern
29663:
29664: CURSOR l_pat_line_curr_p2 IS
29665:
29666: SELECT /*+ ORDERED index(QCDT QP_CURRENCY_DETAILS_N2)
29667: index(qplines QP_PREQ_LINES_TMP_U1)
29668: index(qpl QP_LIST_LINES_N17)
29669: index(qppattmp1 QP_NPREQ_LINE_PATRNS_T_N2)
29670: index(qpatrgrp QP_ATTRIBUTE_GROUPS_N1)

Line 29724: QP_CURRENCY_DETAILS QCDT

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
29727: AND (qplines.price_flag = G_YES OR
29728: (qplines.price_flag = G_PHASE AND p_freeze_override_flag = G_YES))

Line 29762: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

29758: AND TRUNC(NVL(QCDT.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29759: AND (
29760: (qcdt.curr_attribute_context is null
29761: and not exists
29762: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
29763: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
29764: where qcdt1.curr_attribute_context IS NOT NULL
29765: and qcdt1.curr_attribute_context = pa_tmp.context
29766: and qcdt1.curr_attribute = pa_tmp.attribute

Line 29763: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

29759: AND (
29760: (qcdt.curr_attribute_context is null
29761: and not exists
29762: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
29763: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
29764: where qcdt1.curr_attribute_context IS NOT NULL
29765: and qcdt1.curr_attribute_context = pa_tmp.context
29766: and qcdt1.curr_attribute = pa_tmp.attribute
29767: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 29782: from qp_currency_details qcdt3

29778: OR
29779: (qcdt.curr_attribute_context is not null
29780: and qcdt.currency_detail_id =
29781: (select qcdt3.currency_detail_id
29782: from qp_currency_details qcdt3
29783: where qcdt3.to_currency_code = qcdt.to_currency_code
29784: and qcdt3.currency_header_id = qcdt.currency_header_id
29785: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
29786: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))

Line 29789: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) /

29785: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
29786: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29787: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29788: and qcdt3.precedence =
29789: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
29790: min(qcdt2.precedence)
29791: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
29792: where qcdt2.curr_attribute_context IS NOT NULL
29793: and qcdt2.curr_attribute_context = pa_tmp1.context

Line 29791: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

29787: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29788: and qcdt3.precedence =
29789: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */
29790: min(qcdt2.precedence)
29791: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
29792: where qcdt2.curr_attribute_context IS NOT NULL
29793: and qcdt2.curr_attribute_context = pa_tmp1.context
29794: and qcdt2.curr_attribute = pa_tmp1.attribute
29795: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 29813: index(QCDT QP_CURRENCY_DETAILS_N2)

29809: -- Path -> Header First - Line Next
29810:
29811: CURSOR l_pat_header_cache_curr_p1 IS
29812: SELECT /*+ ORDERED index(atrgrps QP_ATTRIBUTE_GROUPS_N3) index(qppat QP_NPREQ_LINE_PATRNS_T_N2)
29813: index(QCDT QP_CURRENCY_DETAILS_N2)
29814: index(qprs qp_pte_source_systems_u2)
29815: l_pat_header_cache_curr_p1 */
29816: DISTINCT atrgrps.LIST_HEADER_ID,
29817: atrgrps.LIST_LINE_ID,

Line 29852: QP_CURRENCY_DETAILS QCDT

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
29856: AND atrgrps.active_flag = G_YES

Line 29871: (select /+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) / 'x'

29867: AND TRUNC(NVL(QCDT.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29868: AND (
29869: (qcdt.curr_attribute_context is null
29870: and not exists
29871: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
29872: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
29873: where qcdt1.curr_attribute_context IS NOT NULL
29874: and qcdt1.curr_attribute_context = pa_tmp.context
29875: and qcdt1.curr_attribute = pa_tmp.attribute

Line 29872: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

29868: AND (
29869: (qcdt.curr_attribute_context is null
29870: and not exists
29871: (select /*+ use_nl(qcdt1) LEADING(qcdt1) index(qcdt1 QP_CURRENCY_DETAILS_N2) */ 'x'
29872: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
29873: where qcdt1.curr_attribute_context IS NOT NULL
29874: and qcdt1.curr_attribute_context = pa_tmp.context
29875: and qcdt1.curr_attribute = pa_tmp.attribute
29876: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 29891: from qp_currency_details qcdt3

29887: OR
29888: (qcdt.curr_attribute_context is not null
29889: and qcdt.currency_detail_id =
29890: (select qcdt3.currency_detail_id
29891: from qp_currency_details qcdt3
29892: where qcdt3.to_currency_code = qcdt.to_currency_code
29893: and qcdt3.currency_header_id = qcdt.currency_header_id
29894: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
29895: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))

Line 29898: (select /+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) / min(qcdt2.precedence)

29894: AND TRUNC(nvl(qplines.pricing_effective_date,sysdate)) BETWEEN
29895: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29896: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29897: and qcdt3.precedence =
29898: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
29899: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
29900: where qcdt2.curr_attribute_context IS NOT NULL
29901: and qcdt2.curr_attribute_context = pa_tmp1.context
29902: and qcdt2.curr_attribute = pa_tmp1.attribute

Line 29899: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

29895: TRUNC(NVL(QCDT3.START_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29896: AND TRUNC(NVL(QCDT3.END_DATE_ACTIVE,nvl(qplines.pricing_effective_date,sysdate)))
29897: and qcdt3.precedence =
29898: (select /*+ use_nl(qcdt2) LEADING(qcdt2) index(qcdt2 QP_CURRENCY_DETAILS_N2) */ min(qcdt2.precedence)
29899: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
29900: where qcdt2.curr_attribute_context IS NOT NULL
29901: and qcdt2.curr_attribute_context = pa_tmp1.context
29902: and qcdt2.curr_attribute = pa_tmp1.attribute
29903: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 31509: qp_currency_details qcdt

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
31512: --security will be built into qp_list_headers_b
31513: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 31536: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

31532: AND (
31533: (qcdt.curr_attribute_context is null
31534: and not exists
31535: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
31536: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
31537: where qcdt1.curr_attribute_context IS NOT NULL
31538: and qcdt1.curr_attribute_context = pa_tmp.context
31539: and qcdt1.curr_attribute = pa_tmp.attribute
31540: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 31553: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

31549: OR
31550: (qcdt.curr_attribute_context is not null
31551: and qcdt.precedence =
31552: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
31553: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
31554: where qcdt2.curr_attribute_context IS NOT NULL
31555: and qcdt2.curr_attribute_context = pa_tmp1.context
31556: and qcdt2.curr_attribute = pa_tmp1.attribute
31557: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 31666: qp_currency_details qcdt

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
31669: --security will be built into qp_list_headers_b
31670: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 31693: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

31689: AND (
31690: (qcdt.curr_attribute_context is null
31691: and not exists
31692: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
31693: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
31694: where qcdt1.curr_attribute_context IS NOT NULL
31695: and qcdt1.curr_attribute_context = pa_tmp.context
31696: and qcdt1.curr_attribute = pa_tmp.attribute
31697: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 31710: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

31706: OR
31707: (qcdt.curr_attribute_context is not null
31708: and qcdt.precedence =
31709: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
31710: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
31711: where qcdt2.curr_attribute_context IS NOT NULL
31712: and qcdt2.curr_attribute_context = pa_tmp1.context
31713: and qcdt2.curr_attribute = pa_tmp1.attribute
31714: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 31823: qp_currency_details qcdt

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
31826: --security will be built into qp_list_headers_b
31827: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 31850: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

31846: AND (
31847: (qcdt.curr_attribute_context is null
31848: and not exists
31849: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
31850: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
31851: where qcdt1.curr_attribute_context IS NOT NULL
31852: and qcdt1.curr_attribute_context = pa_tmp.context
31853: and qcdt1.curr_attribute = pa_tmp.attribute
31854: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 31867: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

31863: OR
31864: (qcdt.curr_attribute_context is not null
31865: and qcdt.precedence =
31866: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
31867: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
31868: where qcdt2.curr_attribute_context IS NOT NULL
31869: and qcdt2.curr_attribute_context = pa_tmp1.context
31870: and qcdt2.curr_attribute = pa_tmp1.attribute
31871: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 32398: qp_currency_details qcdt

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
32400: -- 3594459, context and attribute OR'd together
32401: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32402: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 32424: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

32420: AND (
32421: (qcdt.curr_attribute_context is null
32422: and not exists
32423: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
32424: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
32425: where qcdt1.curr_attribute_context IS NOT NULL
32426: and qcdt1.curr_attribute_context = pa_tmp.context
32427: and qcdt1.curr_attribute = pa_tmp.attribute
32428: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 32441: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

32437: OR
32438: (qcdt.curr_attribute_context is not null
32439: and qcdt.precedence =
32440: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
32441: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
32442: where qcdt2.curr_attribute_context IS NOT NULL
32443: and qcdt2.curr_attribute_context = pa_tmp1.context
32444: and qcdt2.curr_attribute = pa_tmp1.attribute
32445: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 32573: qp_currency_details qcdt

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
32575: -- 3594459, context and attribute OR'd together
32576: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32577: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 32599: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

32595: AND (
32596: (qcdt.curr_attribute_context is null
32597: and not exists
32598: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
32599: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
32600: where qcdt1.curr_attribute_context IS NOT NULL
32601: and qcdt1.curr_attribute_context = pa_tmp.context
32602: and qcdt1.curr_attribute = pa_tmp.attribute
32603: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 32616: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

32612: OR
32613: (qcdt.curr_attribute_context is not null
32614: and qcdt.precedence =
32615: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
32616: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
32617: where qcdt2.curr_attribute_context IS NOT NULL
32618: and qcdt2.curr_attribute_context = pa_tmp1.context
32619: and qcdt2.curr_attribute = pa_tmp1.attribute
32620: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 32748: qp_currency_details qcdt

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
32750: -- 3594459, context and attribute OR'd together
32751: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
32752: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 32774: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

32770: AND (
32771: (qcdt.curr_attribute_context is null
32772: and not exists
32773: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
32774: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
32775: where qcdt1.curr_attribute_context IS NOT NULL
32776: and qcdt1.curr_attribute_context = pa_tmp.context
32777: and qcdt1.curr_attribute = pa_tmp.attribute
32778: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 32791: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

32787: OR
32788: (qcdt.curr_attribute_context is not null
32789: and qcdt.precedence =
32790: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
32791: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
32792: where qcdt2.curr_attribute_context IS NOT NULL
32793: and qcdt2.curr_attribute_context = pa_tmp1.context
32794: and qcdt2.curr_attribute = pa_tmp1.attribute
32795: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 32989: qp_currency_details qcdt

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
32993: --security will be built into qp_list_headers_b

Line 33013: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

33009: AND (
33010: (qcdt.curr_attribute_context is null
33011: and not exists
33012: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
33013: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
33014: where qcdt1.curr_attribute_context IS NOT NULL
33015: and qcdt1.curr_attribute_context = pa_tmp.context
33016: and qcdt1.curr_attribute = pa_tmp.attribute
33017: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 33030: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

33026: OR
33027: (qcdt.curr_attribute_context is not null
33028: and qcdt.precedence =
33029: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
33030: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
33031: where qcdt2.curr_attribute_context IS NOT NULL
33032: and qcdt2.curr_attribute_context = pa_tmp1.context
33033: and qcdt2.curr_attribute = pa_tmp1.attribute
33034: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 33230: qp_currency_details qcdt

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
33234: --security will be built into qp_list_headers_b

Line 33253: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

33249: AND (
33250: (qcdt.curr_attribute_context is null
33251: and not exists
33252: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
33253: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
33254: where qcdt1.curr_attribute_context IS NOT NULL
33255: and qcdt1.curr_attribute_context = pa_tmp.context
33256: and qcdt1.curr_attribute = pa_tmp.attribute
33257: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 33270: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

33266: OR
33267: (qcdt.curr_attribute_context is not null
33268: and qcdt.precedence =
33269: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
33270: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
33271: where qcdt2.curr_attribute_context IS NOT NULL
33272: and qcdt2.curr_attribute_context = pa_tmp1.context
33273: and qcdt2.curr_attribute = pa_tmp1.attribute
33274: and qcdt2.curr_attribute_value = pa_tmp1.value_from