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 /*+ ORDERED USE_NL(adj ldet ql) dynamic_sampling(1) index(LDET QP_PREQ_LDETS_TMP_N1)*/ -- Bug No: 6753550
123: ldet.line_index line_index
124: , ldet.line_detail_index line_detail_index

Line 200: ,qp_npreq_ldets_tmp ldet

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

Line 383: , qp_npreq_ldets_tmp adj

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

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

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

Line 1381: UPDATE qp_npreq_ldets_tmp

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

Line 1408: qp_npreq_ldets_tmp ldet,

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

Line 1428: qp_npreq_ldets_tmp ldet,

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

Line 1604: ,qp_npreq_ldets_tmp adj_pbh

1600: adj.updated_flag,
1601: attr.list_header_id,
1602: adj.list_line_no
1603: FROM qp_npreq_lines_tmp line
1604: ,qp_npreq_ldets_tmp adj_pbh
1605: ,qp_npreq_rltd_lines_tmp ass
1606: ,qp_npreq_ldets_tmp adj
1607: , qp_pricing_attributes attr
1608: -- WHERE p_request_type_code <> 'ONT'

Line 1606: ,qp_npreq_ldets_tmp adj

1602: adj.list_line_no
1603: FROM qp_npreq_lines_tmp line
1604: ,qp_npreq_ldets_tmp adj_pbh
1605: ,qp_npreq_rltd_lines_tmp ass
1606: ,qp_npreq_ldets_tmp adj
1607: , qp_pricing_attributes attr
1608: -- WHERE p_request_type_code <> 'ONT'
1609: --bug 3085453 handle pricing availability UI
1610: -- they pass reqtype ONT and insert adj into ldets

Line 1704: qp_npreq_ldets_tmp adj

1700: UNION
1701: SELECT 'Y'
1702: FROM
1703: qp_npreq_lines_tmp line,
1704: qp_npreq_ldets_tmp adj
1705: -- WHERE p_request_type_code <> 'ONT'
1706: --bug 3085453 handle pricing availability UI
1707: -- they pass reqtype ONT and insert adj into ldets
1708: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG <> QP_PREQ_PUB.G_YES

Line 1905: INSERT INTO qp_npreq_ldets_tmp

1901: );
1902:
1903: --added this insert for bug 3314259 to insert child break lines to tmp table
1904: FORALL I IN l_line_dtl_index_tbl.FIRST..l_line_dtl_index_tbl.LAST
1905: INSERT INTO qp_npreq_ldets_tmp
1906: (
1907: line_detail_index
1908: ,line_index
1909: ,line_detail_type_code

Line 2266: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet

2262: , line.line_quantity ordered_qty
2263: , ldet.line_detail_type_code line_detail_type_code
2264: , line.line_category
2265: , line.price_flag
2266: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet
2267: where line.line_index = ldet.line_index
2268: --and nvl(line.processed_flag,'N') <> QP_PREQ_PUB.G_FREEGOOD_LINE -- Ravi
2269: and line.process_status in (QP_PREQ_PUB.G_STATUS_UPDATED,
2270: QP_PREQ_PUB.G_STATUS_NEW,

Line 2347: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet

2343: , line.line_quantity ordered_qty
2344: , ldet.line_detail_type_code line_detail_type_code
2345: , line.line_category
2346: , line.price_flag
2347: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2348: , qp_npreq_lines_tmp line
2349: where --line.line_index = p_line_index
2350: ldet.line_index = line1.line_index
2351: --and nvl(line.processed_flag,'N') <> QP_PREQ_PUB.G_FREEGOOD_LINE -- Ravi

Line 2440: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,

2436: , line.line_quantity ordered_qty
2437: , ldet.line_detail_type_code line_detail_type_code
2438: , line.line_category
2439: , line.price_flag
2440: from qp_npreq_lines_tmp line, qp_npreq_ldets_tmp ldet,
2441: qp_list_headers_b qplh
2442: -- where p_request_type_code <> 'ONT'
2443: --bug 3085453 handle pricing availability UI
2444: -- they pass reqtype ONT and insert adj into ldets

Line 2543: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet

2539: , line.line_quantity ordered_qty
2540: , ldet.line_detail_type_code line_detail_type_code
2541: , line.line_category
2542: , line.price_flag
2543: from qp_npreq_lines_tmp line1, qp_npreq_ldets_tmp ldet
2544: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2545: -- where p_request_type_code <> 'ONT'
2546: --bug 3085453 handle pricing availability UI
2547: -- they pass reqtype ONT and insert adj into ldets

Line 2611: FROM qp_npreq_ldets_tmp;

2607:
2608:
2609: CURSOR l_max_dtl_index_cur IS
2610: SELECT max(line_detail_index)
2611: FROM qp_npreq_ldets_tmp;
2612:
2613: Pricing_Exception Exception;
2614:
2615: i Pls_Integer;

Line 2752: UPDATE qp_npreq_ldets_tmp ldet2

2748: END IF;
2749:
2750: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
2751: --fix for bug 2515297 not to check applied_flag in this update
2752: UPDATE qp_npreq_ldets_tmp ldet2
2753: set ldet2.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2754: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2755: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2756: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO

Line 2758: from qp_npreq_ldets_tmp ldet

2754: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2755: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2756: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO
2757: and exists ( select 'X'
2758: from qp_npreq_ldets_tmp ldet
2759: where nvl(ldet.updated_flag,QP_PREQ_PUB.G_NO) =QP_PREQ_PUB.G_YES
2760: and ldet.line_index = ldet2.line_index
2761: and ldet.created_from_list_line_id =
2762: ldet2.created_from_list_line_id);

Line 2774: from qp_npreq_ldets_tmp ldet

2770: set rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
2771: rltd.pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
2772: where rltd.pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
2773: and rltd.line_detail_index in (select ldet.line_detail_index
2774: from qp_npreq_ldets_tmp ldet
2775: where ldet.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
2776: and ldet.CREATED_FROM_LIST_LINE_TYPE = QP_PREQ_PUB.G_BY_PBH);
2777:
2778: IF (l_debug = FND_API.G_TRUE) THEN

Line 3471: UPDATE qp_npreq_ldets_tmp ldet2

3467: x_return_status_text);
3468:
3469: --to eliminate the duplicate manual adjustments in the temp table to prevent cleanup for them bug 2191169
3470: --fix for bug 2515297 not to check applied_flag in this update
3471: UPDATE qp_npreq_ldets_tmp ldet2
3472: set ldet2.pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED,
3473: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
3474: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3475: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO

Line 3477: from qp_npreq_ldets_tmp ldet

3473: pricing_status_text = 'DUPLICATE MANUAL-OVERRIDEABLE'
3474: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3475: and nvl(ldet2.updated_flag,QP_PREQ_PUB.G_NO) = QP_PREQ_PUB.G_NO
3476: and exists ( select 'X'
3477: from qp_npreq_ldets_tmp ldet
3478: where nvl(ldet.updated_flag,QP_PREQ_PUB.G_NO) =QP_PREQ_PUB.G_YES
3479: and ldet.line_index = ldet2.line_index
3480: and ldet.created_from_list_line_id =
3481: ldet2.created_from_list_line_id);

Line 3494: UPDATE qp_npreq_ldets_tmp

3490: -- because they were repriced with a different quantity
3491: IF (QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES and
3492: QP_PREQ_GRP.G_MANUAL_ADJUSTMENTS_CALL_FLAG = QP_PREQ_PUB.G_NO)
3493: THEN
3494: UPDATE qp_npreq_ldets_tmp
3495: SET pricing_status_code = QP_PREQ_PUB.G_STATUS_DELETED
3496: WHERE pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
3497: AND automatic_flag = QP_PREQ_PUB.G_NO
3498: AND applied_flag = QP_PREQ_PUB.G_NO