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 10677: engine_debug ('get rounding_factor from qp_currency_details table...');

10673: -- cannot use IF G_MCURR_INSTALLED_USED here, it is null
10674: IF G_MULTI_CURRENCY_PROFILE = 'Y' and G_USE_MULTI_CURRENCY = 'Y' THEN
10675:
10676: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
10677: engine_debug ('get rounding_factor from qp_currency_details table...');
10678: END IF;
10679:
10680: UPDATE qp_npreq_lines_tmp a
10681: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor

Line 10682: FROM qp_currency_details qcdt, qp_list_headers_b qhdr

10678: END IF;
10679:
10680: UPDATE qp_npreq_lines_tmp a
10681: SET ROUNDING_FACTOR = (SELECT qcdt.selling_rounding_factor
10682: FROM qp_currency_details qcdt, qp_list_headers_b qhdr
10683: WHERE qhdr.list_header_id = a.price_list_header_id
10684: AND qhdr.currency_header_id = qcdt.currency_header_id
10685: AND qcdt.to_currency_code = a.currency_code
10686: AND a.pricing_effective_date BETWEEN

Line 11493: ,qp_currency_details qcdt /* Vivek */

11489: qp_rltd_modifiers qprm,
11490: qp_pricing_attributes qppa,
11491: qp_list_lines qpll
11492: ,qp_list_headers_b qph /* Vivek */
11493: ,qp_currency_details qcdt /* Vivek */
11494: WHERE qprm.from_rltd_modifier_id = p_list_line_id
11495: AND qprm.to_rltd_modifier_id = qppa.list_line_id
11496: AND qppa.list_line_id = qpll.list_line_id
11497: AND qplat_pricing.context = G_PRIC_VOLUME_CONTEXT

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

11513: AND ( /* Vivek */
11514: (qcdt.curr_attribute_context is null /* Vivek */
11515: and not exists /* Vivek */
11516: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
11517: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
11518: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
11519: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
11520: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
11521: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

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

11532: OR /* Vivek */
11533: (qcdt.curr_attribute_context is not null /* Vivek */
11534: and qcdt.precedence =
11535: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
11536: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
11537: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
11538: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
11539: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
11540: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15201: QP_CURRENCY_DETAILS QCDT /* Vivek */

15197: QP_LIST_LINES QPL,
15198: QP_LIST_HEADERS_B QPH,
15199: --QP_PRICE_REQ_SOURCES QPRS,
15200: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15201: QP_CURRENCY_DETAILS QCDT /* Vivek */
15202: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15203: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15204: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15205: AND QPQ.COMPARISON_OPERATOR_CODE = '='

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

15250: AND ( /* Vivek */
15251: (qcdt.curr_attribute_context is null /* Vivek */
15252: and not exists /* Vivek */
15253: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15254: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15255: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15256: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15257: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15258: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15273: from qp_currency_details qcdt3 /* Vivek */

15269: OR /* Vivek */
15270: (qcdt.curr_attribute_context is not null /* Vivek */
15271: and qcdt.currency_detail_id = /* Vivek */
15272: (select qcdt3.currency_detail_id
15273: from qp_currency_details qcdt3 /* Vivek */
15274: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15275: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15276: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15277: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

15277: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15278: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15279: and qcdt3.precedence =
15280: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15281: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15282: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15283: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15284: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15285: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15383: QP_CURRENCY_DETAILS QCDT /* Vivek */

15379: QP_LIST_LINES qpl,
15380: QP_LIST_HEADERS_B qph,
15381: --QP_PRICE_REQ_SOURCES qprs,
15382: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15383: QP_CURRENCY_DETAILS QCDT /* Vivek */
15384: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15385: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15386: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15387: AND QPQ.COMPARISON_OPERATOR_CODE = '='

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

15441: AND ( /* Vivek */
15442: (qcdt.curr_attribute_context is null /* Vivek */
15443: and not exists /* Vivek */
15444: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15445: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15446: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15447: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15448: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15449: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15464: from qp_currency_details qcdt3 /* Vivek */

15460: OR /* Vivek */
15461: (qcdt.curr_attribute_context is not null /* Vivek */
15462: and qcdt.currency_detail_id = /* Vivek */
15463: (select qcdt3.currency_detail_id
15464: from qp_currency_details qcdt3 /* Vivek */
15465: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15466: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15467: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15468: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

15468: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15469: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15470: and qcdt3.precedence =
15471: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15472: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15473: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15474: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15475: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15476: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15571: QP_CURRENCY_DETAILS QCDT /* Vivek */

15567: QP_LIST_LINES QPL,
15568: QP_LIST_HEADERS_B QPH,
15569: --QP_PRICE_REQ_SOURCES QPRS,
15570: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
15571: QP_CURRENCY_DETAILS QCDT /* Vivek */
15572: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15573: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15574: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15575: AND QPQ.COMPARISON_OPERATOR_CODE = '='

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

15615: AND ( /* Vivek */
15616: (qcdt.curr_attribute_context is null /* Vivek */
15617: and not exists /* Vivek */
15618: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15619: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15620: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15621: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15622: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15623: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15638: from qp_currency_details qcdt3 /* Vivek */

15634: OR /* Vivek */
15635: (qcdt.curr_attribute_context is not null /* Vivek */
15636: and qcdt.currency_detail_id = /* Vivek */
15637: (select qcdt3.currency_detail_id
15638: from qp_currency_details qcdt3 /* Vivek */
15639: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15640: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15641: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15642: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

15642: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15643: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15644: and qcdt3.precedence =
15645: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15646: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15647: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15648: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15649: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15650: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 15773: QP_CURRENCY_DETAILS QCDT /* Vivek */

15769: QP_LIST_LINES qpl,
15770: QP_LIST_HEADERS_B qph,
15771: --QP_PRICE_REQ_SOURCES qprs,
15772: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
15773: QP_CURRENCY_DETAILS QCDT /* Vivek */
15774: WHERE QPQ.QUALIFIER_CONTEXT = G_LIST_HEADER_CONTEXT
15775: AND QPQ.QUALIFIER_ATTRIBUTE = G_PRICELIST_ATTRIBUTE
15776: AND QPQ.QUALIFIER_ATTR_VALUE = to_char(QPLINES.PRICE_LIST_HEADER_ID)
15777: AND QPQ.COMPARISON_OPERATOR_CODE = '='

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

15826: AND ( /* Vivek */
15827: (qcdt.curr_attribute_context is null /* Vivek */
15828: and not exists /* Vivek */
15829: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
15830: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
15831: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
15832: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
15833: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
15834: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 15849: from qp_currency_details qcdt3 /* Vivek */

15845: OR /* Vivek */
15846: (qcdt.curr_attribute_context is not null /* Vivek */
15847: and qcdt.currency_detail_id = /* Vivek */
15848: (select qcdt3.currency_detail_id
15849: from qp_currency_details qcdt3 /* Vivek */
15850: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
15851: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
15852: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
15853: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

15853: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15854: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
15855: and qcdt3.precedence =
15856: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
15857: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
15858: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
15859: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
15860: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
15861: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 17093: QP_CURRENCY_DETAILS QCDT /* Vivek */

17089: QP_LIST_LINES QPL,
17090: QP_LIST_HEADERS_B QPH,
17091: --QP_PRICE_REQ_SOURCES qprs,
17092: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17093: QP_CURRENCY_DETAILS QCDT /* Vivek */
17094: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17095: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
17096: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17097: AND (QPLINES.PRICE_FLAG = G_YES

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

17146: AND ( /* Vivek */
17147: (qcdt.curr_attribute_context is null /* Vivek */
17148: and not exists /* Vivek */
17149: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
17150: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
17151: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
17152: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
17153: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
17154: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

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

17165: OR /* Vivek */
17166: (qcdt.curr_attribute_context is not null /* Vivek */
17167: and qcdt.precedence =
17168: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
17169: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
17170: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
17171: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
17172: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
17173: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 17251: QP_CURRENCY_DETAILS QCDT /* Vivek */

17247: QP_LIST_LINES qpl,
17248: QP_LIST_HEADERS_B qph,
17249: --QP_PRICE_REQ_SOURCES qprs,
17250: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
17251: QP_CURRENCY_DETAILS QCDT /* Vivek */
17252: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17253: AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND,QP_PREQ_GRP.G_YES_PROD_PRIC_IND)
17254: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17255: AND (QPLINES.PRICE_FLAG = G_YES

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

17313: AND ( /* Vivek */
17314: (qcdt.curr_attribute_context is null /* Vivek */
17315: and not exists /* Vivek */
17316: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
17317: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
17318: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
17319: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
17320: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
17321: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

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

17332: OR /* Vivek */
17333: (qcdt.curr_attribute_context is not null /* Vivek */
17334: and qcdt.precedence =
17335: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
17336: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
17337: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
17338: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
17339: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
17340: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 17954: QP_CURRENCY_DETAILS QCDT /* Vivek */

17950: QP_LIST_LINES QPL,
17951: QP_LIST_HEADERS_B QPH,
17952: --QP_PRICE_REQ_SOURCES QPRS,
17953: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
17954: QP_CURRENCY_DETAILS QCDT /* Vivek */
17955: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
17956: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND
17957: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
17958: AND (QPLINES.PRICE_FLAG = G_YES

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

17991: AND ( /* Vivek */
17992: (qcdt.curr_attribute_context is null /* Vivek */
17993: and not exists /* Vivek */
17994: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
17995: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
17996: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
17997: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
17998: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
17999: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18014: from qp_currency_details qcdt3 /* Vivek */

18010: OR /* Vivek */
18011: (qcdt.curr_attribute_context is not null /* Vivek */
18012: and qcdt.currency_detail_id = /* Vivek */
18013: (select qcdt3.currency_detail_id
18014: from qp_currency_details qcdt3 /* Vivek */
18015: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18016: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18017: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18018: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

18018: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18019: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18020: and qcdt3.precedence =
18021: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18022: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18023: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18024: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18025: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18026: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18140: QP_CURRENCY_DETAILS QCDT /* Vivek */

18136: QP_LIST_LINES QPL,
18137: QP_LIST_HEADERS_B QPH,
18138: --QP_PRICE_REQ_SOURCES QPRS,
18139: QP_PRICE_REQ_SOURCES_V QPRS, /* yangli */
18140: QP_CURRENCY_DETAILS QCDT /* Vivek */
18141: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18142: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_HDR_QUAL_IND
18143: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18144: AND (QPLINES.PRICE_FLAG = G_YES

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

18180: AND ( /* Vivek */
18181: (qcdt.curr_attribute_context is null /* Vivek */
18182: and not exists /* Vivek */
18183: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18184: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18185: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18186: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18187: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18188: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18203: from qp_currency_details qcdt3 /* Vivek */

18199: OR /* Vivek */
18200: (qcdt.curr_attribute_context is not null /* Vivek */
18201: and qcdt.currency_detail_id = /* Vivek */
18202: (select qcdt3.currency_detail_id
18203: from qp_currency_details qcdt3 /* Vivek */
18204: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18205: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18206: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18207: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

18207: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18208: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18209: and qcdt3.precedence =
18210: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18211: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18212: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18213: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18214: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18215: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18331: QP_CURRENCY_DETAILS QCDT /* Vivek */

18327: QP_LIST_LINES QPL,
18328: QP_LIST_HEADERS_B QPH,
18329: --QP_PRICE_REQ_SOURCES qprs,
18330: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18331: QP_CURRENCY_DETAILS QCDT /* Vivek */
18332: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18333: --AND QPA.QUALIFICATION_IND IN (QP_PREQ_GRP.G_YES_PROD_HDR_QUAL_IND, QP_PREQ_GRP.G_YES_PROD_IND)
18334: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_IND
18335: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT

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

18370: AND ( /* Vivek */
18371: (qcdt.curr_attribute_context is null /* Vivek */
18372: and not exists /* Vivek */
18373: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18374: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18375: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18376: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18377: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18378: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18393: from qp_currency_details qcdt3 /* Vivek */

18389: OR /* Vivek */
18390: (qcdt.curr_attribute_context is not null /* Vivek */
18391: and qcdt.currency_detail_id = /* Vivek */
18392: (select qcdt3.currency_detail_id
18393: from qp_currency_details qcdt3 /* Vivek */
18394: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18395: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18396: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18397: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

18397: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18398: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18399: and qcdt3.precedence =
18400: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18401: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18402: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18403: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18404: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18405: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 18495: QP_CURRENCY_DETAILS QCDT /* Vivek */

18491: QP_LIST_LINES qpl,
18492: QP_LIST_HEADERS_B qph,
18493: --QP_PRICE_REQ_SOURCES qprs,
18494: QP_PRICE_REQ_SOURCES_V qprs, /* yangli */
18495: QP_CURRENCY_DETAILS QCDT /* Vivek */
18496: WHERE QPA.PRICING_PHASE_ID = G_PRICE_LIST_PHASE_ID
18497: AND QPA.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_PROD_PRIC_IND
18498: AND QPLAT_PROD.CONTEXT = QPA.PRODUCT_ATTRIBUTE_CONTEXT
18499: AND (QPLINES.PRICE_FLAG = G_YES

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

18541: AND ( /* Vivek */
18542: (qcdt.curr_attribute_context is null /* Vivek */
18543: and not exists /* Vivek */
18544: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
18545: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1 /* Vivek */
18546: where qcdt1.curr_attribute_context IS NOT NULL /* Vivek */
18547: and qcdt1.curr_attribute_context = pa_tmp.context /* Vivek */
18548: and qcdt1.curr_attribute = pa_tmp.attribute /* Vivek */
18549: and qcdt1.curr_attribute_value = pa_tmp.value_from /* Vivek */

Line 18564: from qp_currency_details qcdt3 /* Vivek */

18560: OR /* Vivek */
18561: (qcdt.curr_attribute_context is not null /* Vivek */
18562: and qcdt.currency_detail_id = /* Vivek */
18563: (select qcdt3.currency_detail_id
18564: from qp_currency_details qcdt3 /* Vivek */
18565: where qcdt3.to_currency_code = qcdt.to_currency_code /* Vivek */
18566: and qcdt3.currency_header_id = qcdt.currency_header_id /* Vivek */
18567: AND QPLINES.PRICING_EFFECTIVE_DATE BETWEEN /* Vivek */
18568: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */

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

18568: NVL(TRUNC(QCDT3.START_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18569: AND NVL(TRUNC(QCDT3.END_DATE_ACTIVE),QPLINES.PRICING_EFFECTIVE_DATE)/* Vivek */
18570: and qcdt3.precedence =
18571: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
18572: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2 /* Vivek */
18573: where qcdt2.curr_attribute_context IS NOT NULL /* Vivek */
18574: and qcdt2.curr_attribute_context = pa_tmp1.context /* Vivek */
18575: and qcdt2.curr_attribute = pa_tmp1.attribute /* Vivek */
18576: and qcdt2.curr_attribute_value = pa_tmp1.value_from /* Vivek */

Line 25956: qp_currency_details qcdt

25952: qp_price_req_sources_v qprs,
25953: qp_npreq_line_attrs_tmp qplatpr,
25954: qp_pricing_attributes qpprod,
25955: qp_list_lines qpl,
25956: qp_currency_details qcdt
25957: WHERE qph.list_header_id = qpl.list_header_id
25958: --added for moac -- commented references to security profile
25959: --security will be built into qp_list_headers_b
25960: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 25983: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

25979: AND (
25980: (qcdt.curr_attribute_context is null
25981: and not exists
25982: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
25983: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
25984: where qcdt1.curr_attribute_context IS NOT NULL
25985: and qcdt1.curr_attribute_context = pa_tmp.context
25986: and qcdt1.curr_attribute = pa_tmp.attribute
25987: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 26000: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

25996: OR
25997: (qcdt.curr_attribute_context is not null
25998: and qcdt.precedence =
25999: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
26000: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
26001: where qcdt2.curr_attribute_context IS NOT NULL
26002: and qcdt2.curr_attribute_context = pa_tmp1.context
26003: and qcdt2.curr_attribute = pa_tmp1.attribute
26004: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 26111: qp_currency_details qcdt

26107: qp_price_req_sources_v qprs,
26108: qp_npreq_line_attrs_tmp qplatpr,
26109: qp_pricing_attributes qpprod,
26110: qp_list_lines qpl,
26111: qp_currency_details qcdt
26112: WHERE qph.list_header_id = qpl.list_header_id
26113: --added for moac -- commented references to security profile
26114: --security will be built into qp_list_headers_b
26115: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 26138: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

26134: AND (
26135: (qcdt.curr_attribute_context is null
26136: and not exists
26137: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
26138: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
26139: where qcdt1.curr_attribute_context IS NOT NULL
26140: and qcdt1.curr_attribute_context = pa_tmp.context
26141: and qcdt1.curr_attribute = pa_tmp.attribute
26142: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 26155: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

26151: OR
26152: (qcdt.curr_attribute_context is not null
26153: and qcdt.precedence =
26154: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
26155: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
26156: where qcdt2.curr_attribute_context IS NOT NULL
26157: and qcdt2.curr_attribute_context = pa_tmp1.context
26158: and qcdt2.curr_attribute = pa_tmp1.attribute
26159: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 26266: qp_currency_details qcdt

26262: qp_price_req_sources_v qprs,
26263: qp_npreq_line_attrs_tmp qplatpr,
26264: qp_pricing_attributes qpprod,
26265: qp_list_lines qpl,
26266: qp_currency_details qcdt
26267: WHERE qph.list_header_id = qpl.list_header_id
26268: --added for moac -- commented references to security profile
26269: --security will be built into qp_list_headers_b
26270: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 26293: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

26289: AND (
26290: (qcdt.curr_attribute_context is null
26291: and not exists
26292: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
26293: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
26294: where qcdt1.curr_attribute_context IS NOT NULL
26295: and qcdt1.curr_attribute_context = pa_tmp.context
26296: and qcdt1.curr_attribute = pa_tmp.attribute
26297: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 26310: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

26306: OR
26307: (qcdt.curr_attribute_context is not null
26308: and qcdt.precedence =
26309: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
26310: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
26311: where qcdt2.curr_attribute_context IS NOT NULL
26312: and qcdt2.curr_attribute_context = pa_tmp1.context
26313: and qcdt2.curr_attribute = pa_tmp1.attribute
26314: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 26841: qp_currency_details qcdt

26837: qp_npreq_line_attrs_tmp qplatpr,
26838: qp_pricing_attributes qpprod ,
26839: qp_npreq_line_attrs_tmp qplatpc,
26840: qp_list_lines qpl,
26841: qp_currency_details qcdt
26842: WHERE qph.list_header_id = qpq.list_header_id
26843: -- 3594459, context and attribute OR'd together
26844: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
26845: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 26867: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

26863: AND (
26864: (qcdt.curr_attribute_context is null
26865: and not exists
26866: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
26867: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
26868: where qcdt1.curr_attribute_context IS NOT NULL
26869: and qcdt1.curr_attribute_context = pa_tmp.context
26870: and qcdt1.curr_attribute = pa_tmp.attribute
26871: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 26884: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

26880: OR
26881: (qcdt.curr_attribute_context is not null
26882: and qcdt.precedence =
26883: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
26884: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
26885: where qcdt2.curr_attribute_context IS NOT NULL
26886: and qcdt2.curr_attribute_context = pa_tmp1.context
26887: and qcdt2.curr_attribute = pa_tmp1.attribute
26888: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 27016: qp_currency_details qcdt

27012: qp_npreq_line_attrs_tmp qplatpr,
27013: qp_pricing_attributes qpprod ,
27014: qp_npreq_line_attrs_tmp qplatpc,
27015: qp_list_lines qpl,
27016: qp_currency_details qcdt
27017: WHERE qph.list_header_id = qpq.list_header_id
27018: -- 3594459, context and attribute OR'd together
27019: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
27020: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 27042: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

27038: AND (
27039: (qcdt.curr_attribute_context is null
27040: and not exists
27041: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
27042: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
27043: where qcdt1.curr_attribute_context IS NOT NULL
27044: and qcdt1.curr_attribute_context = pa_tmp.context
27045: and qcdt1.curr_attribute = pa_tmp.attribute
27046: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 27059: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

27055: OR
27056: (qcdt.curr_attribute_context is not null
27057: and qcdt.precedence =
27058: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
27059: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
27060: where qcdt2.curr_attribute_context IS NOT NULL
27061: and qcdt2.curr_attribute_context = pa_tmp1.context
27062: and qcdt2.curr_attribute = pa_tmp1.attribute
27063: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 27191: qp_currency_details qcdt

27187: qp_npreq_line_attrs_tmp qplatpr,
27188: qp_pricing_attributes qpprod ,
27189: qp_npreq_line_attrs_tmp qplatpc,
27190: qp_list_lines qpl,
27191: qp_currency_details qcdt
27192: WHERE qph.list_header_id = qpq.list_header_id
27193: -- 3594459, context and attribute OR'd together
27194: AND (qpq.qualifier_context <> G_LIST_HEADER_CONTEXT --bug 2799670
27195: OR qpq.qualifier_attribute <> G_PRICELIST_ATTRIBUTE) --bug 2799670

Line 27217: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

27213: AND (
27214: (qcdt.curr_attribute_context is null
27215: and not exists
27216: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
27217: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
27218: where qcdt1.curr_attribute_context IS NOT NULL
27219: and qcdt1.curr_attribute_context = pa_tmp.context
27220: and qcdt1.curr_attribute = pa_tmp.attribute
27221: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 27234: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

27230: OR
27231: (qcdt.curr_attribute_context is not null
27232: and qcdt.precedence =
27233: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
27234: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
27235: where qcdt2.curr_attribute_context IS NOT NULL
27236: and qcdt2.curr_attribute_context = pa_tmp1.context
27237: and qcdt2.curr_attribute = pa_tmp1.attribute
27238: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 27431: qp_currency_details qcdt

27427: qp_pricing_attributes qpprod,
27428: qp_list_lines qpl,
27429: qp_list_headers_b qph,
27430: qp_price_req_sources_v qprs,
27431: qp_currency_details qcdt
27432: WHERE qph.list_header_id = qpl.list_header_id
27433: --added for moac -- commented references to security profile
27434: --security will be built into qp_list_headers_b
27435: --AND ((nvl(G_SECURITY_CONTROL, 'OFF') = 'ON' AND G_CURRENT_USER_OP_UNIT = QPH.orig_org_id) OR -- begin security

Line 27453: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

27449: AND (
27450: (qcdt.curr_attribute_context is null
27451: and not exists
27452: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
27453: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
27454: where qcdt1.curr_attribute_context IS NOT NULL
27455: and qcdt1.curr_attribute_context = pa_tmp.context
27456: and qcdt1.curr_attribute = pa_tmp.attribute
27457: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 27470: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

27466: OR
27467: (qcdt.curr_attribute_context is not null
27468: and qcdt.precedence =
27469: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
27470: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
27471: where qcdt2.curr_attribute_context IS NOT NULL
27472: and qcdt2.curr_attribute_context = pa_tmp1.context
27473: and qcdt2.curr_attribute = pa_tmp1.attribute
27474: and qcdt2.curr_attribute_value = pa_tmp1.value_from

Line 27669: qp_currency_details qcdt

27665: qp_npreq_line_attrs_tmp qplatpc,
27666: qp_list_lines qpl ,
27667: qp_list_headers_b qph,
27668: qp_price_req_sources_v qprs,
27669: qp_currency_details qcdt
27670: WHERE
27671: qph.list_header_id = qpl.list_header_id
27672: --added for moac -- commented references to security profile
27673: --security will be built into qp_list_headers_b

Line 27691: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1

27687: AND (
27688: (qcdt.curr_attribute_context is null
27689: and not exists
27690: (select /*+ ORDERED use_nl(qcdt1) index(pa_tmp QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/5139512/4744915]
27691: from qp_npreq_line_attrs_tmp pa_tmp, qp_currency_details qcdt1
27692: where qcdt1.curr_attribute_context IS NOT NULL
27693: and qcdt1.curr_attribute_context = pa_tmp.context
27694: and qcdt1.curr_attribute = pa_tmp.attribute
27695: and qcdt1.curr_attribute_value = pa_tmp.value_from

Line 27708: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2

27704: OR
27705: (qcdt.curr_attribute_context is not null
27706: and qcdt.precedence =
27707: (select /*+ ORDERED use_nl(qcdt2) index(pa_tmp1 QP_PREQ_LINE_ATTRS_TMP_N1) */ min(qcdt2.precedence) --[julin/5139512/4744915]
27708: from qp_npreq_line_attrs_tmp pa_tmp1, qp_currency_details qcdt2
27709: where qcdt2.curr_attribute_context IS NOT NULL
27710: and qcdt2.curr_attribute_context = pa_tmp1.context
27711: and qcdt2.curr_attribute = pa_tmp1.attribute
27712: and qcdt2.curr_attribute_value = pa_tmp1.value_from