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_PREQ_PUB

Line 12121: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN

12117: -- if break uom was set up, then get the passed break uom
12118: -- if break_uom is not set up, then no proration and proceed with normal price break evaluation
12119: -- feb 22 toi comment end
12120: -- price book
12121: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
12122: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
12123: engine_debug('call from price book with proration ==> skip this break entirely');
12124: END IF;
12125: EXIT; -- exit big loop to stop processing remaining child lines

Line 19260: IF (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) THEN -- price book

19256: x_status_code := FND_API.G_RET_STS_SUCCESS;
19257:
19258: IF (p_pricing_phase_id <> G_PRICE_LIST_PHASE_ID) THEN -- Only for modifiers ask for list headers/lines
19259:
19260: IF (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) THEN -- price book
19261: -- Validated List Headers / List Lines
19262: FOR J IN L_VALIDATED_CUR LOOP
19263:
19264: IF (J.ATTRIBUTE = G_PROMOTION_ATTRIBUTE) THEN

Line 21734: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

21730: and qpl.list_line_id = qpprod.list_line_id
21731: and (qpl.modifier_level_code = qplines.line_type_code
21732: OR
21733: (qpl.modifier_level_code = G_LINE_GROUP and
21734: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
21735: and qplines.pricing_effective_date BETWEEN
21736: nvl(TRUNC(qpl.start_date_active), qplines.pricing_effective_date)
21737: and nvl(TRUNC(qpl.end_date_active),qplines.pricing_effective_date)
21738: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 21753: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

21749: --and qpq.search_ind = 1
21750: and qplatpr.attribute_type='PRODUCT'
21751: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
21752: -- price book
21753: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
21754: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
21755: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
21756: or
21757: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 21757: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

21753: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
21754: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
21755: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
21756: or
21757: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
21758: union all
21759: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPL) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_n1) l_prod_qual_cur_mod */
21760: qpl.list_header_id,
21761: qpl.list_line_id,

Line 21822: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

21818: and qpl.list_line_id = qpprod.list_line_id
21819: and (qpl.modifier_level_code = qplines.line_type_code
21820: OR
21821: (qpl.modifier_level_code = G_LINE_GROUP and
21822: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
21823: and qplines.pricing_effective_date BETWEEN
21824: nvl(TRUNC(qpl.start_date_active), qplines.pricing_effective_date)
21825: and nvl(TRUNC(qpl.end_date_active),qplines.pricing_effective_date)
21826: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 21840: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

21836: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
21837: --and qpq.pricing_status_code=G_STATUS_UNCHANGED
21838: --and qpq.search_ind = 1
21839: -- price book
21840: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
21841: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
21842: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
21843: or
21844: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 21844: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

21840: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
21841: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
21842: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
21843: or
21844: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
21845: order by 4,2;
21846:
21847: /*
21848: INDX,QP_PREQ_GRP.select_modifiers.l_prod_qual_pric_cur_sel1,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1

Line 21977: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

21973: and qpl.list_line_id = qpprod.list_line_id
21974: and (qpl.modifier_level_code = qplines.line_type_code
21975: OR
21976: (qpl.modifier_level_code = G_LINE_GROUP and
21977: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
21978: and qplines.pricing_effective_date BETWEEN
21979: nvl(TRUNC(qpl.start_date_active), qplines.pricing_effective_date)
21980: AND nvl(TRUNC(qpl.end_date_active),qplines.pricing_effective_date)
21981: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 22008: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22004: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
22005: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
22006: --and qpq.search_ind = 1
22007: -- price book
22008: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22009: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22010: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22011: or
22012: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22012: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22008: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22009: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22010: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22011: or
22012: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22013: union all
22014: select /*+ ORDERED USE_NL(QPLATPR QPPROD QPLATPC QPL ) index(QPPROD QP_PRICING_ATTRIBUTES_N5) index(qplatpr qp_preq_line_attrs_tmp_N1) index(qplatpc qp_preq_line_attrs_tmp_N2) l_prod_qual_pric_cur_mod */
22015: qpl.list_header_id,
22016: qpl.list_line_id,

Line 22089: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22085: and qpl.list_line_id = qpprod.list_line_id
22086: and (qpl.modifier_level_code = qplines.line_type_code
22087: OR
22088: (qpl.modifier_level_code = G_LINE_GROUP and
22089: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22090: and qplines.pricing_effective_date BETWEEN
22091: nvl(TRUNC(qpl.start_date_active), qplines.pricing_effective_date)
22092: AND nvl(TRUNC(qpl.end_date_active),qplines.pricing_effective_date)
22093: and qplines.priced_uom_code = nvl(qpprod.product_uom_code,qplines.priced_uom_code)

Line 22117: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22113: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
22114: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
22115: --and qpq.search_ind = 1
22116: -- price book
22117: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22118: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22119: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22120: or
22121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22117: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22118: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22119: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22120: or
22121: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22122: order by 4,2;
22123:
22124: /*
22125: INDX,QP_PREQ_GRP.select_modifiers.l_inner_qual_cur,QP_PREQ_QUAL_TMP_N5,PRICING_STATUS_CODE,1

Line 22193: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22189: and qpl.list_line_id = qpq.list_line_id
22190: and (qpl.modifier_level_code = qpq.line_type_code
22191: OR
22192: (qpl.modifier_level_code = G_LINE_GROUP and
22193: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22194: and qpq.pricing_effective_date BETWEEN
22195: nvl(TRUNC(qpl.start_date_active), qpq.pricing_effective_date)
22196: AND nvl(TRUNC(qpl.end_date_active),qpq.pricing_effective_date)
22197: and qpl.QUALIFICATION_IND in (QP_PREQ_GRP.G_YES_LINE_QUAL_IND,QP_PREQ_GRP.G_YES_HDR_LINE_QUAL_IND)

Line 22203: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22199: and qpl.pricing_phase_id = p_pricing_phase_id
22200: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
22201: --and qpq.search_ind = 1
22202: -- price book
22203: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22204: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22205: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22206: or
22207: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22207: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22203: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22204: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22205: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22206: or
22207: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22208: union all
22209: select /*+ ORDERED INDEX(qpl,QP_LIST_LINES_N5) l_inner_qual_cur */
22210: qpl.list_header_id,
22211: qpl.list_line_id,

Line 22258: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22254: qpl.list_header_id = qpq.list_header_id
22255: and (qpl.modifier_level_code = qpq.line_type_code
22256: OR
22257: (qpl.modifier_level_code = G_LINE_GROUP and
22258: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22259: and qpq.pricing_effective_date BETWEEN
22260: nvl(TRUNC(qpl.start_date_active), qpq.pricing_effective_date)
22261: AND nvl(TRUNC(qpl.end_date_active),qpq.pricing_effective_date)
22262: and qpl.QUALIFICATION_IND = QP_PREQ_GRP.G_YES_HDR_QUAL_IND

Line 22268: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22264: and qpl.pricing_phase_id = p_pricing_phase_id
22265: --and qpq.pricing_status_code = G_STATUS_UNCHANGED
22266: --and qpq.search_ind = 1
22267: -- price book
22268: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22269: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22270: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22271: or
22272: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22272: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22268: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22269: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22270: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22271: or
22272: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22273: order by 4,2;
22274:
22275:
22276: /*

Line 22382: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22378: qplines.line_type_code = G_ORDER_LEVEL)
22379: and (qpl.modifier_level_code = qplines.line_type_code
22380: OR
22381: (qpl.modifier_level_code = G_LINE_GROUP and
22382: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22383: and qph.active_flag = G_YES
22384: AND ((qph.ASK_FOR_FLAG = G_YES and exists (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/pricebook]
22385: FROM qp_npreq_line_attrs_tmp la
22386: WHERE attribute_type = 'QUALIFIER'

Line 22427: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22423: AND QPLATPR.LINE_INDEX = QPLINES.LINE_INDEX
22424: and qplatpr.attribute_type='PRODUCT'
22425: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
22426: -- price book
22427: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22428: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22429: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22430: or
22431: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22431: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22427: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22428: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22429: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22430: or
22431: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22432: order by 4,2;
22433:
22434: /*
22435: INDX,QP_PREQ_GRP.select_modifiers.l_prod_pric_cur,qp_npreq_line_attrs_tmp_N2,PRICING_STATUS_CODE,1

Line 22549: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22545: qplines.line_type_code = G_ORDER_LEVEL)
22546: and (qpl.modifier_level_code = qplines.line_type_code
22547: OR
22548: (qpl.modifier_level_code = G_LINE_GROUP and
22549: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22550: and qph.active_flag = G_YES
22551: AND ((qph.ASK_FOR_FLAG = G_YES and exists (SELECT /*+ index(la QP_PREQ_LINE_ATTRS_TMP_N1) */ 'x' --[julin/pricebook]
22552: FROM qp_npreq_line_attrs_tmp la
22553: WHERE attribute_type = 'QUALIFIER'

Line 22607: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22603: and qplatpr.pricing_status_code=G_STATUS_UNCHANGED
22604: and qplatpc.attribute_type = 'PRICING'
22605: and qplatpc.pricing_status_code = G_STATUS_UNCHANGED
22606: -- price book
22607: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22608: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22609: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22610: or
22611: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22611: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22607: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22608: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22609: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22610: or
22611: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22612: order by 4,2;
22613:
22614: /*
22615: INDX,QP_PREQ_GRP.select_modifiers.l_cur,QP_LIST_LINES_N5,PRICING_PHASE_ID,1

Line 22700: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book

22696: qplines.line_type_code = G_ORDER_LEVEL)
22697: and (qpl.modifier_level_code = qplines.line_type_code
22698: OR
22699: (qpl.modifier_level_code = G_LINE_GROUP and
22700: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)) -- price book
22701: and nvl(qplines.pricing_effective_date,TRUNC(SYSDATE)) BETWEEN
22702: nvl(qph.start_date_active,nvl(qplines.pricing_effective_date,TRUNC(SYSDATE))) AND
22703: nvl(qph.end_date_active,nvl(qplines.pricing_effective_date,TRUNC(SYSDATE)))
22704: and nvl(qplines.start_date_active_first,TRUNC(SYSDATE)) BETWEEN

Line 22722: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and

22718: AND nvl(TRUNC(qpl.end_date_active),qplines.pricing_effective_date)
22719: and qph.source_system_code = qprs.source_system_code
22720: and qplines.request_type_code = qprs.request_type_code
22721: -- price book
22722: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22723: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22724: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22725: or
22726: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

Line 22726: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)

22722: and (nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES and
22723: qpl.list_line_type_code not in (G_PROMO_GOODS_DISCOUNT,G_OTHER_ITEM_DISCOUNT,
22724: G_COUPON_ISSUE,G_TERMS_SUBSTITUTION,G_ITEM_UPGRADE)
22725: or
22726: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES)
22727: order by 4,2;
22728:
22729: /*
22730: INDX,QP_PREQ_GRP.select_modifiers.l_get_excluded_prods_cur,QP_PRICING_ATTRIBUTES_N5,PRICING_PHASE_ID,1

Line 23233: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN

23229: END IF;
23230: --hw
23231: l_satis_quals_opt := nvl(fnd_profile.value('QP_SATIS_QUALS_OPT'), 'Y');
23232: --[julin/pricebook]
23233: IF nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES THEN
23234: l_satis_quals_opt := 'N';
23235: END IF;
23236:
23237: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 25605: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

25601: FROM --[julin/5007789]
25602: (SELECT /*+ dynamic_sampling(1) */ *
25603: FROM qp_npreq_lines_tmp
25604: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25605: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25606: qp_npreq_line_attrs_tmp qplatq,
25607: qp_qualifiers qpq,
25608: qp_list_headers_b qph,
25609: qp_price_req_sources_v qprs,

Line 25713: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

25709: FROM --[julin/5007789]
25710: (SELECT /*+ dynamic_sampling(1) */ *
25711: FROM qp_npreq_lines_tmp
25712: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25713: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25714: qp_npreq_line_attrs_tmp qplatq,
25715: qp_qualifiers qpq,
25716: qp_list_headers_b qph,
25717: qp_price_req_sources_v qprs,

Line 25821: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

25817: FROM --[julin/5007789]
25818: (SELECT /*+ dynamic_sampling(1) */ *
25819: FROM qp_npreq_lines_tmp
25820: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25821: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25822: qp_npreq_line_attrs_tmp qplatq,
25823: qp_qualifiers qpq,
25824: qp_list_headers_b qph,
25825: qp_price_req_sources_v qprs,

Line 25948: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

25944: FROM --[julin/5007789]
25945: (SELECT /*+ dynamic_sampling(1) */ *
25946: FROM qp_npreq_lines_tmp
25947: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
25948: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
25949: qp_npreq_line_attrs_tmp qplatq,
25950: qp_qualifiers qpq,
25951: qp_list_headers_b qph,
25952: qp_price_req_sources_v qprs,

Line 26103: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26099: FROM --[julin/5007789]
26100: (SELECT /*+ dynamic_sampling(1) */ *
26101: FROM qp_npreq_lines_tmp
26102: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26103: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26104: qp_npreq_line_attrs_tmp qplatq,
26105: qp_qualifiers qpq,
26106: qp_list_headers_b qph,
26107: qp_price_req_sources_v qprs,

Line 26258: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26254: FROM --[julin/5007789]
26255: (SELECT /*+ dynamic_sampling(1) */ *
26256: FROM qp_npreq_lines_tmp
26257: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26258: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26259: qp_npreq_line_attrs_tmp qplatq,
26260: qp_qualifiers qpq,
26261: qp_list_headers_b qph,
26262: qp_price_req_sources_v qprs,

Line 26428: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26424: FROM --[julin/5007789]
26425: (SELECT /*+ dynamic_sampling(1) */ *
26426: FROM qp_npreq_lines_tmp
26427: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26428: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26429: qp_npreq_line_attrs_tmp qplatq,
26430: qp_qualifiers qpq ,
26431: qp_list_headers_b qph,
26432: qp_price_req_sources_v qprs,

Line 26556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26552: FROM --[julin/5007789]
26553: (SELECT /*+ dynamic_sampling(1) */ *
26554: FROM qp_npreq_lines_tmp
26555: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26557: qp_npreq_line_attrs_tmp qplatq,
26558: qp_qualifiers qpq ,
26559: qp_list_headers_b qph,
26560: qp_price_req_sources_v qprs,

Line 26684: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26680: FROM --[julin/5007789]
26681: (SELECT /*+ dynamic_sampling(1) */ *
26682: FROM qp_npreq_lines_tmp
26683: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26684: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26685: qp_npreq_line_attrs_tmp qplatq,
26686: qp_qualifiers qpq ,
26687: qp_list_headers_b qph,
26688: qp_price_req_sources_v qprs,

Line 26832: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

26828: FROM --[julin/5007789]
26829: (SELECT /*+ dynamic_sampling(1) */ *
26830: FROM qp_npreq_lines_tmp
26831: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
26832: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
26833: qp_npreq_line_attrs_tmp qplatq,
26834: qp_qualifiers qpq ,
26835: qp_list_headers_b qph,
26836: qp_price_req_sources_v qprs,

Line 27007: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27003: FROM --[julin/5007789]
27004: (SELECT /*+ dynamic_sampling(1) */ *
27005: FROM qp_npreq_lines_tmp
27006: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
27007: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27008: qp_npreq_line_attrs_tmp qplatq,
27009: qp_qualifiers qpq ,
27010: qp_list_headers_b qph,
27011: qp_price_req_sources_v qprs,

Line 27182: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27178: FROM --[julin/5007789]
27179: (SELECT /*+ dynamic_sampling(1) */ *
27180: FROM qp_npreq_lines_tmp
27181: WHERE processed_code IN (G_STS_LHS_NOT_FOUND, G_NO_LIST_PASSED)
27182: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27183: qp_npreq_line_attrs_tmp qplatq,
27184: qp_qualifiers qpq ,
27185: qp_list_headers_b qph,
27186: qp_price_req_sources_v qprs,

Line 27338: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27334: FROM --[julin/5000789]
27335: (SELECT /*+ dynamic_sampling(1) */ *
27336: FROM qp_npreq_lines_tmp
27337: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
27338: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27339: qp_npreq_line_attrs_tmp qplatpr,
27340: qp_pricing_attributes qpprod ,
27341: qp_list_lines qpl ,
27342: qp_list_headers_b qph ,

Line 27425: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27421: FROM --[julin/5007789]
27422: (SELECT /*+ dynamic_sampling(1) */ *
27423: FROM qp_npreq_lines_tmp
27424: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
27425: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27426: qp_npreq_line_attrs_tmp qplatpr,
27427: qp_pricing_attributes qpprod,
27428: qp_list_lines qpl,
27429: qp_list_headers_b qph,

Line 27556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27552: FROM --[julin/5007789]
27553: (SELECT /*+ dynamic_sampling(1) */ *
27554: FROM qp_npreq_lines_tmp
27555: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
27556: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27557: qp_npreq_line_attrs_tmp qplatpr,
27558: qp_pricing_attributes qpprod,
27559: qp_npreq_line_attrs_tmp qplatpc,
27560: qp_list_lines qpl,

Line 27662: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,

27658: FROM --[julin/5007789]
27659: (SELECT /*+ dynamic_sampling(1) */ *
27660: FROM qp_npreq_lines_tmp
27661: WHERE processed_code IN (G_STS_LHS_NOT_FOUND,G_NO_LIST_PASSED)
27662: AND (nvl(validated_flag,G_NO) = G_NO or nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) qplines,
27663: qp_npreq_line_attrs_tmp qplatpr,
27664: qp_pricing_attributes qpprod ,
27665: qp_npreq_line_attrs_tmp qplatpc,
27666: qp_list_lines qpl ,

Line 32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;

32797: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
32798: engine_debug('Calling application inserted into temp tables');
32799:
32800: END IF;
32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;

Line 32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;

32798: engine_debug('Calling application inserted into temp tables');
32799:
32800: END IF;
32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;

Line 32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;

32799:
32800: END IF;
32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
32807:

Line 32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;

32800: END IF;
32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
32807:
32808: l_price_flag_yes_only := NULL; -- reset, default

Line 32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;

32801: G_CURRENCY_CODE := QP_PREQ_PUB.G_CURRENCY_CODE;
32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
32807:
32808: l_price_flag_yes_only := NULL; -- reset, default
32809: -- Check if atleast there is one line with price_flag = 'Y'

Line 32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;

32802: G_PRICE_PHASE_FLAG := QP_PREQ_PUB.G_PRICE_PHASE_FLAG;
32803: G_PRICE_LIST_SEQUENCE := QP_PREQ_PUB.G_PRICE_LIST_SEQUENCE;
32804: G_PRICE_LIST_PHASE_ID := QP_PREQ_PUB.G_PRICE_LIST_PHASE_ID;
32805: G_MIN_PRICING_DATE := QP_PREQ_PUB.G_MIN_PRICING_DATE;
32806: G_MAX_PRICING_DATE := QP_PREQ_PUB.G_MAX_PRICING_DATE;
32807:
32808: l_price_flag_yes_only := NULL; -- reset, default
32809: -- Check if atleast there is one line with price_flag = 'Y'
32810: -- shu, begin bug 2437534 fix

Line 33222: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) -- price book

33218: -- Do further search only if asked for using I.SEARCH_FLAG on the price list phase
33219: -- Bug# 1367546
33220:
33221: IF (l_further_search = G_YES and (I.SEARCH_FLAG = G_YES or
33222: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) = G_YES)) -- price book
33223: THEN
33224: qp_debug_util.tstart('SELECT_PRICE_LIST_LINES','Select Price List Lines(Search Flag on) - SELECT_PRICE_LIST_LINES API');
33225:
33226: SELECT_PRICE_LIST_LINES(p_pricing_phase_id => I.pricing_phase_id,

Line 33720: QP_PREQ_PUB.Determine_svc_item_quantity;

33716:
33717: END IF;
33718: --4900095
33719: IF QP_PREQ_GRP.G_Service_line_qty_tbl.COUNT = 0 THEN
33720: QP_PREQ_PUB.Determine_svc_item_quantity;
33721: END IF;
33722: -- Reset
33723: -- This global variable is used to not calculate the Recurring Qty routine and update the Operand
33724: -- if Limits Code is called to avoid second time calculation of the OPERAND value from the Calculation Engine

Line 33731: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book

33727:
33728: -- If advanced pricing and limits profile option = 'Y' call calc engine for limits
33729: IF (l_install_status = 'I' and l_limits_installed = G_YES and
33730: UPPER(p_control_rec.simulation_flag) = 'N' and
33731: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book
33732: THEN
33733: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
33734: engine_debug('------Advanced Pricing and Limits Profile is Set-----------');
33735: END IF;

Line 33757: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book

33753:
33754:
33755: IF (l_install_status = 'I' and l_limits_installed = G_YES and
33756: UPPER(p_control_rec.simulation_flag) = 'N' and
33757: nvl(QP_PREQ_PUB.G_CALL_FROM_PRICE_BOOK, G_NO) <> G_YES) -- price book
33758: THEN
33759: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
33760: engine_debug('------Advanced Pricing and Limits Profile is Set 2 -----------');
33761: