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_PUB dependencies on QP_NPREQ_RLTD_LINES_TMP

Line 2413: /* delete from qp_npreq_rltd_lines_tmp

2409: , x_return_status_text
2410: , l_LIST_LINE_ID
2411: , l_RLTD_LIST_LINE_ID
2412: , l_pricing_status_text);
2413: /* delete from qp_npreq_rltd_lines_tmp
2414: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2415: and relationship_type_code = QP_PREQ_PUB.G_PBH_LINE
2416: and pricing_status_text = G_CALC_INSERT;
2417: */ --need to delete them later

Line 2733: -- in l_calculate_cur to not fetch the child lines as they are already in the qp_npreq_rltd_lines_tmp table

2729: --looks at to evaluate the breaks
2730: --This procedure will be used in the performance code path when
2731: --the public API is called by non-OM applications
2732: -- Ravi -- Added code to update the line detail type code which will be used
2733: -- in l_calculate_cur to not fetch the child lines as they are already in the qp_npreq_rltd_lines_tmp table
2734: -- Bug was adjustment amt was being calculated for child lines where it is not satisfied also
2735: PROCEDURE Update_passed_in_pbh(x_return_status OUT NOCOPY VARCHAR2,
2736: x_return_status_text OUT NOCOPY VARCHAR2) IS
2737:

Line 2744: UPDATE qp_npreq_rltd_lines_tmp rltd

2740: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
2741:
2742: --when any changes are made to this, the similar updated stmt
2743: --in Update_Related_Line_Info procedure in this file also needs to be changed
2744: UPDATE qp_npreq_rltd_lines_tmp rltd
2745: SET (setup_value_from,
2746: setup_value_to,
2747: relationship_type_detail,
2748: list_line_id,

Line 2800: FROM qp_npreq_rltd_lines_tmp

2796:
2797: UPDATE qp_npreq_ldets_tmp
2798: SET line_detail_type_code = QP_PREQ_PUB.G_CHILD_DETAIL_TYPE
2799: WHERE line_detail_index IN (SELECT related_line_detail_index
2800: FROM qp_npreq_rltd_lines_tmp
2801: WHERE relationship_type_code = G_PBH_LINE
2802: AND pricing_status_code = G_STATUS_NEW);
2803:
2804: IF (l_debug = FND_API.G_TRUE) THEN

Line 3123: FROM qp_npreq_rltd_lines_tmp rltd

3119: AND ldet.override_flag = G_YES
3120: AND ldet.pricing_group_sequence IS NULL --only return null bucket manual modifiers
3121: AND ldet.line_detail_index NOT IN
3122: (SELECT rltd.related_line_detail_index
3123: FROM qp_npreq_rltd_lines_tmp rltd
3124: WHERE rltd.relationship_type_code = G_PBH_LINE
3125: AND rltd.pricing_status_code = G_STATUS_NEW)
3126: --ORDER BY ldet.calculation_code,ldet.created_from_list_line_type,ldet.applied_flag desc;
3127: --ORDER BY ldet.created_from_list_line_type, precedence desc , ldet.applied_flag desc;

Line 4199: FROM qp_npreq_rltd_lines_tmp

4195: pricing_group_sequence,
4196: setup_value_from,
4197: setup_value_to,
4198: qualifier_value
4199: FROM qp_npreq_rltd_lines_tmp
4200: WHERE pricing_status_code = G_STATUS_NEW;
4201:
4202: CURSOR l_net_amount_flag_cur (p_list_line_id NUMBER) IS
4203: SELECT net_amount_flag

Line 7187: FROM qp_npreq_rltd_lines_tmp rltd

7183: AND nvl(ldet.created_from_list_type_code, 'NULL') NOT IN
7184: (G_PRICE_LIST_HEADER, G_AGR_LIST_HEADER)
7185: AND ldet.line_detail_index NOT IN
7186: (SELECT rltd.related_line_detail_index
7187: FROM qp_npreq_rltd_lines_tmp rltd
7188: WHERE rltd.pricing_status_code = G_STATUS_NEW
7189: AND rltd.relationship_type_code = G_PBH_LINE)
7190: -- next 4 conditions added for 3435240
7191: AND line.line_type_code = G_LINE_LEVEL

Line 7249: FROM qp_npreq_rltd_lines_tmp rltd

7245: AND nvl(ldet.created_from_list_type_code, 'NULL') NOT IN
7246: (G_PRICE_LIST_HEADER, G_AGR_LIST_HEADER)
7247: AND ldet.line_detail_index NOT IN
7248: (SELECT rltd.related_line_detail_index
7249: FROM qp_npreq_rltd_lines_tmp rltd
7250: WHERE rltd.pricing_status_code = G_STATUS_NEW
7251: AND rltd.relationship_type_code = G_PBH_LINE)
7252: -- next 4 conditions added for 3435240
7253: AND line.price_flag IN (G_YES, G_PHASE, G_CALCULATE_ONLY)

Line 9288: FROM qp_npreq_rltd_lines_tmp rltd

9284: rltd.related_line_detail_index,
9285: rltd.list_line_id,
9286: rltd.related_list_line_id,
9287: rltd.pricing_status_code
9288: FROM qp_npreq_rltd_lines_tmp rltd
9289: WHERE rltd.relationship_type_code = G_PBH_LINE;
9290: BEGIN
9291: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
9292: IF l_debug = FND_API.G_TRUE

Line 9307: UPDATE qp_npreq_rltd_lines_tmp SET pricing_status_code = G_STATUS_DELETED

9303: END IF;
9304:
9305: --mark the engine passed relationships of manual PBH as deleted
9306: --if the parent PBH line is deleted
9307: UPDATE qp_npreq_rltd_lines_tmp SET pricing_status_code = G_STATUS_DELETED
9308: WHERE line_detail_index IN (SELECT line_detail_index
9309: FROM qp_npreq_ldets_tmp ldet
9310: WHERE (ldet.process_code = G_STATUS_DELETED
9311: OR ldet.pricing_status_code = G_STATUS_DELETED))

Line 9321: FROM qp_npreq_rltd_lines_tmp rltd

9317: --mark the engine returned manual child PBH lines as deleted
9318: UPDATE qp_npreq_ldets_tmp ldet SET pricing_status_code = G_STATUS_DELETED
9319: WHERE ldet.line_detail_index IN
9320: (SELECT rltd.related_line_detail_index
9321: FROM qp_npreq_rltd_lines_tmp rltd
9322: WHERE rltd.relationship_type_code = G_PBH_LINE
9323: AND rltd.pricing_status_code = G_STATUS_DELETED);
9324:
9325: IF l_debug = FND_API.G_TRUE THEN

Line 9365: qp_npreq_rltd_lines_tmp rltd,

9361: nvl(ldet.line_quantity,
9362: nvl(line.priced_quantity, line.line_quantity))
9363: qualifier_value
9364: FROM
9365: qp_npreq_rltd_lines_tmp rltd,
9366: qp_npreq_lines_tmp line,
9367: qp_npreq_ldets_tmp ldet,
9368: qp_npreq_ldets_tmp ldet_pbh,
9369: qp_pricing_attributes qpa

Line 9393: FROM qp_npreq_rltd_lines_tmp rltd

9389: operand_calculation_code,
9390: operand,
9391: pricing_group_sequence,
9392: qualifier_value
9393: FROM qp_npreq_rltd_lines_tmp rltd
9394: WHERE rltd.pricing_status_code = G_STATUS_NEW
9395: AND rltd.relationship_type_code = G_PBH_LINE;
9396:
9397: BEGIN

Line 9419: UPDATE qp_npreq_rltd_lines_tmp rltd

9415: END IF;
9416:
9417: --when any changes are made to this, the similar updated stmt
9418: --in update_passed_in_pbh procedure in this file also needs to be changed
9419: UPDATE qp_npreq_rltd_lines_tmp rltd
9420: SET (setup_value_from,
9421: setup_value_to,
9422: relationship_type_detail,
9423: list_line_id,

Line 9653: -- from qp_npreq_rltd_lines_tmp rltd

9649: -- or (ldet.updated_flag = G_YES
9650: -- and nvl(ldet.automatic_flag, G_NO) = G_NO
9651: -- and ldet.line_detail_index in
9652: -- (select rltd.related_line_detail_index
9653: -- from qp_npreq_rltd_lines_tmp rltd
9654: -- where rltd.relationship_type_code = G_PBH_LINE)));
9655:
9656: IF l_debug = FND_API.G_TRUE THEN
9657: QP_PREQ_GRP.ENGINE_DEBUG('PROCESS ADJUSTMENTS: Step1.5');

Line 9909: UPDATE qp_npreq_rltd_lines_tmp rltd

9905: IF l_debug = FND_API.G_TRUE THEN
9906: QP_PREQ_GRP.engine_debug('Begin UPDATE_QUALIFIER_VALUE routine');
9907:
9908: END IF;
9909: UPDATE qp_npreq_rltd_lines_tmp rltd
9910: SET rltd.qualifier_value = (SELECT
9911: decode(qpa.pricing_attribute,
9912: G_LINE_AMT_ATTRIBUTE,
9913: (nvl(line.priced_quantity, line.line_quantity)

Line 9951: FROM qp_npreq_rltd_lines_tmp rltd,

9947: --[julin/pbperf] tuned to use QP_PREQ_LDETS_TMP_U1
9948: CURSOR l_child_break_cur IS
9949: SELECT /*+ ORDERED index(ldet QP_PREQ_LDETS_TMP_U1) */ldet.process_code,
9950: rltd.related_line_detail_index
9951: FROM qp_npreq_rltd_lines_tmp rltd,
9952: -- qp_npreq_ldets_tmp ldet1,
9953: qp_npreq_ldets_tmp ldet
9954: WHERE rltd.relationship_type_code = G_PBH_LINE
9955: AND rltd.pricing_status_code = G_STATUS_NEW

Line 10071: qp_npreq_rltd_lines_tmp rltd,

10067: ldet.operand_value,
10068: ldet.group_amount,
10069: line.parent_price
10070: FROM qp_npreq_lines_tmp line,
10071: qp_npreq_rltd_lines_tmp rltd,
10072: qp_npreq_ldets_tmp ldet,
10073: qp_pricing_attributes qpa,
10074: qp_npreq_line_attrs_tmp attr
10075: WHERE line.pricing_status_code IN (G_STATUS_UNCHANGED, G_STATUS_UPDATED)

Line 10437: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

10433: rltd.related_line_index,
10434: line.unit_price,
10435: line.priced_quantity,
10436: line.priced_uom_code
10437: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
10438: WHERE rltd.line_index IS NOT NULL
10439: AND rltd.related_line_index IS NOT NULL
10440: AND rltd.relationship_type_code = G_SERVICE_LINE
10441: AND line.line_index = rltd.line_index;

Line 10936: , qp_npreq_rltd_lines_tmp oldrltd

10932: FROM qp_npreq_lines_tmp buyline
10933: , qp_event_phases ev
10934: , qp_pricing_phases ph
10935: , qp_npreq_ldets_tmp oldprg
10936: , qp_npreq_rltd_lines_tmp oldrltd
10937: , qp_npreq_ldets_tmp oldfgdis
10938: , qp_npreq_lines_tmp oldfreeline
10939: --where G_REQUEST_TYPE_CODE <> 'ONT'
10940: --bug 3085453 handle pricing availability UI

Line 11159: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line

11155: PROCEDURE Update_prg_pricing_status(x_return_status OUT NOCOPY VARCHAR2,
11156: x_return_status_text OUT NOCOPY VARCHAR2) IS
11157: CURSOR l_mark_prg_delete_cur IS
11158: SELECT rltd.line_detail_index, rltd.related_line_detail_index
11159: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp line
11160: WHERE rltd.pricing_status_code = G_STATUS_NEW
11161: AND rltd.relationship_type_code = G_GENERATED_LINE
11162: AND line.line_index = rltd.related_line_index
11163: AND line.process_status IN (G_NOT_VALID, G_STATUS_DELETED); --bug 3126969

Line 11352: , qp_npreq_rltd_lines_tmp newrltd

11348: oldfreeline.process_status old_list_line_id,
11349: newfgdis.created_from_list_line_id newfgdis_list_line_id,
11350: newfgdis.operand_value || newfgdis.operand_calculation_code newfgdis_operand
11351: FROM qp_npreq_lines_tmp oldfreeline
11352: , qp_npreq_rltd_lines_tmp newrltd
11353: , qp_npreq_ldets_tmp newfgdis
11354: , qp_npreq_lines_tmp newfgline
11355: , qp_npreq_line_attrs_tmp oldfreeitem
11356: , qp_npreq_line_attrs_tmp newfgitem

Line 11472: , qp_npreq_rltd_lines_tmp newrltd

11468: oldfreeline.process_status old_list_line_id,
11469: newfgdis.created_from_list_line_id newfgdis_list_line_id,
11470: newfgdis.operand_value || newfgdis.operand_calculation_code newfgdis_operand
11471: FROM qp_npreq_lines_tmp oldfreeline
11472: , qp_npreq_rltd_lines_tmp newrltd
11473: , qp_npreq_ldets_tmp newfgdis
11474: , qp_npreq_lines_tmp newfgline
11475: , qp_npreq_line_attrs_tmp newfgitem
11476: , qp_npreq_line_attrs_tmp oldfreeitem

Line 11503: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd

11499:
11500: CURSOR l_updated_prg_fg_cur IS
11501: SELECT /*+ INDEX(prg OE_PRICE_ADJUSTMENTS_N2) */ rltd.related_line_index
11502: FROM qp_npreq_lines_tmp buyline, oe_price_adjustments prg,
11503: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd
11504: --WHERE G_REQUEST_TYPE_CODE = 'ONT'
11505: --bug 3085453 handle pricing availability UI
11506: -- they pass reqtype ONT and insert adj into ldets
11507: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = G_YES

Line 11522: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd

11518: AND rltd.pricing_status_code = G_STATUS_NEW
11519: UNION
11520: SELECT /*+ INDEX(prg OE_PRICE_ADJUSTMENTS_N1) */ rltd.related_line_index
11521: FROM qp_npreq_lines_tmp buyline, oe_price_adjustments prg,
11522: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd
11523: --WHERE G_REQUEST_TYPE_CODE = 'ONT'
11524: --bug 3085453 handle pricing availability UI
11525: -- they pass reqtype ONT and insert adj into ldets
11526: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = G_YES

Line 11543: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd

11539: UNION
11540: -- hint added for 5575718
11541: SELECT /*+ ORDERED */ rltd.related_line_index
11542: FROM qp_npreq_lines_tmp buyline, qp_npreq_ldets_tmp prg,
11543: qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd
11544: --WHERE G_REQUEST_TYPE_CODE <> 'ONT'
11545: --bug 3085453 handle pricing availability UI
11546: -- they pass reqtype ONT and insert adj into ldets
11547: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> G_YES

Line 11703: FROM qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd

11699: ||'prg listlineid '|| cl.list_line_id ||' updatedflag '|| cl.updated_flag
11700: ||' buylineid '|| cl.line_id ||' prgphaseid '|| cl.pricing_phase_id);
11701: FOR fg IN
11702: (SELECT rltd.related_line_index, ldet.created_from_list_line_id
11703: FROM qp_npreq_ldets_tmp ldet, qp_npreq_rltd_lines_tmp rltd
11704: WHERE ldet.line_index = cl.line_index
11705: AND ldet.pricing_status_code = G_STATUS_NEW
11706: AND ldet.applied_flag = G_YES
11707: AND ldet.created_from_list_line_id = cl.list_line_id

Line 12120: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp buyline

12116: -- 3493716: added prg.line_detail_index to cursor
12117: CURSOR l_buyline_price_flag_cur IS
12118: SELECT /*+ ORDERED USE_NL(buyline prg dis)*/
12119: dis.created_from_list_line_id, prg.line_detail_index, buyline.price_flag, 'Y' is_ldet, dis.line_index
12120: FROM qp_npreq_rltd_lines_tmp rltd, qp_npreq_lines_tmp buyline
12121: , qp_npreq_ldets_tmp prg, qp_npreq_ldets_tmp dis
12122: WHERE rltd.pricing_status_code = G_STATUS_NEW
12123: AND rltd.relationship_type_code = G_GENERATED_LINE
12124: AND buyline.line_index = rltd.line_index

Line 12144: FROM qp_npreq_rltd_lines_tmp WHERE pricing_status_code = G_STATUS_NEW

12140: G_BUYLINE_INDEXES_FOR_LINE_ID.DELETE;
12141:
12142: IF l_debug = FND_API.G_TRUE THEN
12143: FOR c1 IN (SELECT line_detail_index, related_line_detail_index, line_index
12144: FROM qp_npreq_rltd_lines_tmp WHERE pricing_status_code = G_STATUS_NEW
12145: AND relationship_type_code = G_GENERATED_LINE)
12146: LOOP
12147: IF l_debug = FND_API.G_TRUE THEN
12148: QP_PREQ_GRP.engine_debug('loop linedtl '|| c1.line_detail_index ||' rltddtl '

Line 12200: from qp_npreq_rltd_lines_tmp rl, qp_npreq_lines_tmp buyline

12196: G_buyline_list_line_id, G_buyline_price_flag;
12197: CLOSE l_buyline_price_flag_cur;
12198: UPDATE qp_npreq_ldets_tmp freegood_dis set buy_line_price_flag =
12199: (select buyline.price_flag
12200: from qp_npreq_rltd_lines_tmp rl, qp_npreq_lines_tmp buyline
12201: where rl.pricing_status_code = G_STATUS_NEW
12202: and rl.relationship_type_code = G_GENERATED_LINE
12203: and rl.related_line_detail_index = freegood_dis.line_detail_index
12204: and buyline.line_index = rl.line_index)

Line 12210: from qp_npreq_rltd_lines_tmp rltd

12206: and freegood_dis.applied_flag = G_YES
12207: and freegood_dis.created_from_list_line_type in (G_OTHER_ITEM_DISCOUNT,
12208: G_PROMO_GOODS_DISCOUNT)
12209: and freegood_dis.line_detail_index in (select rltd.related_line_detail_index
12210: from qp_npreq_rltd_lines_tmp rltd
12211: where rltd.pricing_status_code = G_STATUS_NEW
12212: and rltd.relationship_type_code = G_GENERATED_LINE
12213: and rltd.line_detail_index = freegood_dis.line_detail_index);
12214: */

Line 13859: FROM qp_npreq_rltd_lines_tmp

13855: pricing_group_sequence,
13856: setup_value_from,
13857: setup_value_to,
13858: qualifier_value
13859: FROM qp_npreq_rltd_lines_tmp
13860: WHERE pricing_status_code = G_STATUS_NEW)
13861: LOOP
13862: IF l_debug = FND_API.G_TRUE THEN
13863: QP_PREQ_GRP.engine_debug('related records with status N '