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_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_NPREQ_LDETS_TMP

Line 27: Update qp_npreq_ldets_tmp set price_adjustment_id =

23: IF l_debug = FND_API.G_TRUE THEN
24: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine not Installed ----------');
25: END IF;
26: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
27: Update qp_npreq_ldets_tmp set price_adjustment_id =
28: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
29: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
30: and process_code = QP_PREQ_PUB.G_STATUS_NEW
31: and (automatic_flag = QP_PREQ_PUB.G_YES

Line 120: --[julin/4865213] merged oe_price_adjustments unions, commented qp_npreq_ldets_tmp

116: x_return_status OUT NOCOPY VARCHAR2,
117: x_return_status_text OUT NOCOPY VARCHAR2) IS
118:
119: --the same cursor for unchanged as well
120: --[julin/4865213] merged oe_price_adjustments unions, commented qp_npreq_ldets_tmp
121: CURSOR l_update_cur IS
122: SELECT /*+ USE_NL(adj ldet ql) dynamic_sampling(1) index(LDET QP_PREQ_LDETS_TMP_N1) */ --bug#11925462 -- Bug No: 6753550
123: ldet.line_index line_index
124: , ldet.line_detail_index line_detail_index

Line 203: ,qp_npreq_ldets_tmp ldet

199: FROM qp_npreq_lines_tmp line
200: , oe_price_adjustments adj
201: -- Begin Bug No: 6753550
202: --,qp_ldets_v ldet
203: ,qp_npreq_ldets_tmp ldet
204: ,qp_list_lines ql_det
205: -- End Bug No: 6753550
206: , qp_list_lines ql
207: -- WHERE p_request_type_code = 'ONT'

Line 387: , qp_npreq_ldets_tmp adj

383: , adj.order_qty_adj_amt adj_ord_qty_adjamt
384: , ldet.order_qty_operand ord_qty_operand
385: , adj.order_qty_operand adj_ord_qty_operand
386: FROM qp_npreq_lines_tmp line
387: , qp_npreq_ldets_tmp adj
388: ,qp_ldets_v ldet
389: , qp_list_lines ql
390: -- WHERE p_request_type_code <> 'ONT'
391: --bug 3085453 handle pricing availability UI

Line 415: --[julin/4865213] merged oe_price_adjustments unions, commented qp_npreq_ldets_tmp

411: and ldet.list_line_id = ql.list_line_id;
412: */
413:
414: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
415: --[julin/4865213] merged oe_price_adjustments unions, commented qp_npreq_ldets_tmp
416: CURSOR l_update_int_cur IS
417: SELECT /*+ ORDERED USE_NL(adj ldet ql)*/
418: ldet.line_index line_index
419: , ldet.line_detail_index line_detail_index

Line 1385: UPDATE qp_npreq_ldets_tmp

1381: END IF;
1382: --ADDED BY YANGLI FOR JAVA ENGINE PUB 3086881
1383:
1384: FORALL x IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1385: UPDATE qp_npreq_ldets_tmp
1386: SET process_code = l_process_code_tbl(x)
1387: , price_adjustment_id = l_price_adj_id_tbl(x)
1388: , pricing_status_text = l_pricing_sts_text_tbl(x)
1389: WHERE line_index = l_line_index_tbl(x)

Line 1412: qp_npreq_ldets_tmp ldet,

1408: SET lattr.pricing_status_code = QP_PREQ_PUB.G_STATUS_UNCHANGED
1409: WHERE lattr.attribute_type = QP_PREQ_PUB.G_PRICING_TYPE
1410: and EXISTS ( SELECT 'X' FROM
1411: qp_npreq_lines_tmp line,
1412: qp_npreq_ldets_tmp ldet,
1413: oe_price_adjustments adj,
1414: oe_price_adj_attribs_v attr
1415: WHERE line.price_flag in
1416: (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE)

Line 1432: qp_npreq_ldets_tmp ldet,

1428: and attr.pricing_attr_value_from = lattr.value_from
1429: UNION
1430: SELECT 'X' FROM
1431: qp_npreq_lines_tmp line,
1432: qp_npreq_ldets_tmp ldet,
1433: oe_price_adjustments adj,
1434: oe_price_adj_attribs_v attr
1435: WHERE line.price_flag in
1436: (QP_PREQ_PUB.G_YES, QP_PREQ_PUB.G_PHASE)

Line 1610: ,qp_npreq_ldets_tmp adj_pbh

1606: adj.updated_flag,
1607: attr.list_header_id,
1608: adj.list_line_no
1609: FROM qp_npreq_lines_tmp line
1610: ,qp_npreq_ldets_tmp adj_pbh
1611: ,qp_npreq_rltd_lines_tmp ass
1612: ,qp_npreq_ldets_tmp adj
1613: , qp_pricing_attributes attr
1614: -- WHERE p_request_type_code <> 'ONT'

Line 1612: ,qp_npreq_ldets_tmp adj

1608: adj.list_line_no
1609: FROM qp_npreq_lines_tmp line
1610: ,qp_npreq_ldets_tmp adj_pbh
1611: ,qp_npreq_rltd_lines_tmp ass
1612: ,qp_npreq_ldets_tmp adj
1613: , qp_pricing_attributes attr
1614: -- WHERE p_request_type_code <> 'ONT'
1615: --bug 3085453 handle pricing availability UI
1616: -- they pass reqtype ONT and insert adj into ldets

Line 1710: qp_npreq_ldets_tmp adj

1706: UNION
1707: SELECT 'Y'
1708: FROM
1709: qp_npreq_lines_tmp line,
1710: qp_npreq_ldets_tmp adj
1711: -- WHERE p_request_type_code <> 'ONT'
1712: --bug 3085453 handle pricing availability UI
1713: -- they pass reqtype ONT and insert adj into ldets
1714: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 1911: INSERT INTO qp_npreq_ldets_tmp

1907: );
1908:
1909: --added this insert for bug 3314259 to insert child break lines to tmp table
1910: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1911: INSERT INTO qp_npreq_ldets_tmp
1912: (
1913: line_detail_index
1914: ,line_index
1915: ,line_detail_type_code

Line 2272: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet

2268: , line.line_quantity ordered_qty
2269: , ldet.line_detail_type_code line_detail_type_code
2270: , line.line_category
2271: , line.price_flag
2272: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet
2273: where line.line_index = ldet.line_index
2274: --and nvl(line.processed_flag,'N') <> QP_PREQ_PUB.G_FREEGOOD_LINE -- Ravi
2275: and line.process_status in (QP_PREQ_PUB.G_STATUS_UPDATED,
2276: QP_PREQ_PUB.G_STATUS_NEW,

Line 2353: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet

2349: , line.line_quantity ordered_qty
2350: , ldet.line_detail_type_code line_detail_type_code
2351: , line.line_category
2352: , line.price_flag
2353: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2354: , qp_npreq_lines_tmp line
2355: where --line.line_index = p_line_index
2356: ldet.line_index = line1.line_index
2357: --and nvl(line.processed_flag,'N') <> QP_PREQ_PUB.G_FREEGOOD_LINE -- Ravi

Line 2446: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,

2442: , line.line_quantity ordered_qty
2443: , ldet.line_detail_type_code line_detail_type_code
2444: , line.line_category
2445: , line.price_flag
2446: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,
2447: qp_list_headers_b qplh
2448: -- where p_request_type_code <> 'ONT'
2449: --bug 3085453 handle pricing availability UI
2450: -- they pass reqtype ONT and insert adj into ldets

Line 2549: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet

2545: , line.line_quantity ordered_qty
2546: , ldet.line_detail_type_code line_detail_type_code
2547: , line.line_category
2548: , line.price_flag
2549: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2550: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2551: -- where p_request_type_code <> 'ONT'
2552: --bug 3085453 handle pricing availability UI
2553: -- they pass reqtype ONT and insert adj into ldets

Line 2617: FROM qp_npreq_ldets_tmp;

2613:
2614:
2615: CURSOR l_max_dtl_index_cur IS
2616: SELECT max(line_detail_index)
2617: FROM qp_npreq_ldets_tmp;
2618:
2619: --added new cursor 9679930
2620: cursor check_manual_modifiers is
2621: SELECT /*+ leading(ldets2)

Line 2625: FROM qp_npreq_ldets_tmp ldets1,

2621: SELECT /*+ leading(ldets2)
2622: index(ldets2 qp_preq_ldets_tmp_n7)
2623: index(ldets1 qp_preq_ldets_tmp_n1) */
2624: ldets1.line_detail_index
2625: FROM qp_npreq_ldets_tmp ldets1,
2626: qp_npreq_ldets_tmp ldets2
2627: WHERE ldets1.line_index = ldets2.line_index
2628: AND ldets1.pricing_phase_id =ldets2.pricing_phase_id
2629: AND ldets1.created_from_list_header_id = ldets2.created_from_list_header_id

Line 2626: qp_npreq_ldets_tmp ldets2

2622: index(ldets2 qp_preq_ldets_tmp_n7)
2623: index(ldets1 qp_preq_ldets_tmp_n1) */
2624: ldets1.line_detail_index
2625: FROM qp_npreq_ldets_tmp ldets1,
2626: qp_npreq_ldets_tmp ldets2
2627: WHERE ldets1.line_index = ldets2.line_index
2628: AND ldets1.pricing_phase_id =ldets2.pricing_phase_id
2629: AND ldets1.created_from_list_header_id = ldets2.created_from_list_header_id
2630: AND ldets1.created_from_list_line_id = ldets2.created_from_list_line_id

Line 2777: /* UPDATE qp_npreq_ldets_tmp ldet2

2773: END IF;
2774:
2775: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
2776: --fix for bug 2515297 not to check applied_flag in this update
2777: /* UPDATE qp_npreq_ldets_tmp ldet2
2778: set ldet2.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2779: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2780: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2781: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO

Line 2783: from qp_npreq_ldets_tmp ldet

2779: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2780: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2781: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO
2782: and exists ( select 'X'
2783: from qp_npreq_ldets_tmp ldet
2784: where nvl(ldet.updated_flag,QP_PREQ_PUB.G_NO) =QP_PREQ_PUB.G_YES
2785: and ldet.line_index = ldet2.line_index
2786: and ldet.created_from_list_line_id =
2787: ldet2.created_from_list_line_id);

Line 2802: UPDATE qp_npreq_ldets_tmp

2798: QP_PREQ_GRP.engine_debug('Duplicate manual override modifier count: '|| l_manual_line_details_tbl.COUNT);
2799: END IF;
2800:
2801: FORALL y IN l_manual_line_details_tbl.FIRST..l_manual_line_details_tbl.LAST
2802: UPDATE qp_npreq_ldets_tmp
2803: set pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2804: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2805: WHERE line_detail_index = l_manual_line_details_tbl(y);
2806: END loop;

Line 2820: from qp_npreq_ldets_tmp ldet

2816: set rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2817: rltd.pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2818: where rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2819: and rltd.line_detail_index in (select ldet.line_detail_index
2820: from qp_npreq_ldets_tmp ldet
2821: where ldet.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
2822: and ldet.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_PUB.G_BY_PBH);
2823:
2824: IF (l_debug = FND_API.G_TRUE) THEN

Line 3525: /* UPDATE qp_npreq_ldets_tmp ldet2

3521: x_return_status_text);
3522:
3523: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
3524: --fix for bug 2515297 not to check applied_flag in this update
3525: /* UPDATE qp_npreq_ldets_tmp ldet2
3526: set ldet2.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
3527: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
3528: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3529: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO

Line 3531: from qp_npreq_ldets_tmp ldet

3527: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
3528: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3529: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO
3530: and exists ( select 'X'
3531: from qp_npreq_ldets_tmp ldet
3532: where nvl(ldet.updated_flag,QP_PREQ_PUB.G_NO) =QP_PREQ_PUB.G_YES
3533: and ldet.line_index = ldet2.line_index
3534: and ldet.created_from_list_line_id =
3535: ldet2.created_from_list_line_id);

Line 3550: UPDATE qp_npreq_ldets_tmp

3546: QP_PREQ_GRP.engine_debug('Duplicate manual override modifier count: '|| l_manual_line_details_tbl.COUNT);
3547: END IF;
3548:
3549: FORALL y IN l_manual_line_details_tbl.FIRST..l_manual_line_details_tbl.LAST
3550: UPDATE qp_npreq_ldets_tmp
3551: set pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
3552: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
3553: WHERE line_detail_index = l_manual_line_details_tbl(y);
3554: END loop;

Line 3569: UPDATE qp_npreq_ldets_tmp

3565: -- because they were repriced with a different quantity
3566: IF (QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES and
3567: QP_PREQ_GRP.G_MANUAL_ADJUSTMENTS_CALL_FLAG = QP_PREQ_PUB.G_NO)
3568: THEN
3569: UPDATE qp_npreq_ldets_tmp
3570: SET pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
3571: WHERE pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3572: AND automatic_flag = QP_PREQ_PUB.G_NO
3573: AND applied_flag = QP_PREQ_PUB.G_NO