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 OE_PRICE_ADJUSTMENTS

Line 16: --sequence OE_PRICE_ADJUSTMENTS_S

12:
13: l_debug VARCHAR2(3);
14: --to populate the price_adjustment_id for modifiers applied by the
15: --pricing engine. The price_adjustment_id is queried from the
16: --sequence OE_PRICE_ADJUSTMENTS_S
17: PROCEDURE Populate_Price_Adj_ID(x_return_status OUT NOCOPY VARCHAR2,
18: x_return_status_text OUT NOCOPY VARCHAR2) IS
19:
20: BEGIN

Line 28: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

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
32: or created_from_list_line_type = QP_PREQ_PUB.G_FREIGHT_CHARGE)

Line 42: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

38: QP_PREQ_GRP.ENGINE_DEBUG('Populate_Price_Adj_ID: Java Engine is Installed ----------');
39: END IF;
40: IF (QP_UTIL_PUB.HVOP_Pricing_ON = 'Y') THEN
41: Update qp_int_ldets set price_adjustment_id =
42: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
43: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
44: and process_code = QP_PREQ_PUB.G_STATUS_NEW
45: and (applied_flag = QP_PREQ_PUB.G_YES
46: or automatic_flag = QP_PREQ_PUB.G_YES)

Line 54: OE_PRICE_ADJUSTMENTS_S.NEXTVAL

50:
51: ELSE
52:
53: Update qp_int_ldets set price_adjustment_id =
54: OE_PRICE_ADJUSTMENTS_S.NEXTVAL
55: where pricing_status_code = QP_PREQ_PUB.G_STATUS_NEW
56: and process_code = QP_PREQ_PUB.G_STATUS_NEW
57: and (automatic_flag = QP_PREQ_PUB.G_YES)
58: -- or created_from_list_line_type = QP_PREQ_PUB.G_FREIGHT_CHARGE)

Line 81: from oe_price_adjustments adj

77: BEGIN
78:
79: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
80: select sum(operand) into l_adj_sum_operand
81: from oe_price_adjustments adj
82: where adj.header_id = p_header_id
83: and adj.line_id is null
84: and adj.modifier_level_code = QP_PREQ_PUB.G_ORDER_LEVEL
85: and adj.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 197: , oe_price_adjustments adj

193: , adj.adjusted_amount adj_ord_qty_adjamt
194: , ldet.order_qty_operand ord_qty_operand
195: , adj.operand adj_ord_qty_operand
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

Line 299: , oe_price_adjustments adj

295: , adj.adjusted_amount adj_ord_qty_adjamt
296: , ldet.order_qty_operand ord_qty_operand
297: , adj.operand adj_ord_qty_operand
298: FROM qp_npreq_lines_tmp line
299: , oe_price_adjustments adj
300: ,qp_ldets_v ldet
301: , qp_list_lines ql
302: -- WHERE p_request_type_code = 'ONT'
303: --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 474: , oe_price_adjustments adj

470: , adj.adjusted_amount adj_ord_qty_adjamt
471: , ldet.order_qty_operand ord_qty_operand
472: , adj.operand adj_ord_qty_operand
473: FROM qp_int_lines line
474: , oe_price_adjustments adj
475: ,qp_ldets_v ldet
476: , qp_list_lines ql
477: -- WHERE p_request_type_code = 'ONT'
478: --bug 3085453 handle pricing availability UI

Line 565: , oe_price_adjustments adj

561: , adj.adjusted_amount adj_ord_qty_adjamt
562: , ldet.order_qty_operand ord_qty_operand
563: , adj.operand adj_ord_qty_operand
564: FROM qp_int_lines line
565: , oe_price_adjustments adj
566: ,qp_ldets_v ldet
567: , qp_list_lines ql
568: -- WHERE p_request_type_code = 'ONT'
569: --bug 3085453 handle pricing availability UI

Line 1409: oe_price_adjustments adj,

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)
1413: and line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL

Line 1429: oe_price_adjustments adj,

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)
1433: and line.line_type_code = QP_PREQ_PUB.G_ORDER_LEVEL

Line 1542: ,oe_price_adjustments adj_pbh

1538: adj.updated_flag,
1539: attr.list_header_id,
1540: adj.list_line_no
1541: FROM qp_npreq_lines_tmp line
1542: ,oe_price_adjustments adj_pbh
1543: ,oe_price_adj_assocs ass
1544: ,oe_price_adjustments adj
1545: , qp_pricing_attributes attr
1546: -- WHERE p_request_type_code = 'ONT'

Line 1544: ,oe_price_adjustments adj

1540: adj.list_line_no
1541: FROM qp_npreq_lines_tmp line
1542: ,oe_price_adjustments adj_pbh
1543: ,oe_price_adj_assocs ass
1544: ,oe_price_adjustments adj
1545: , qp_pricing_attributes attr
1546: -- WHERE p_request_type_code = 'ONT'
1547: --bug 3085453 handle pricing availability UI
1548: -- they pass reqtype ONT and insert adj into ldets

Line 1642: SELECT /+ index(adj OE_PRICE_ADJUSTMENTS_N2) / 'Y'

1638: and attr.pricing_attribute_context = QP_PREQ_PUB.G_PRIC_VOLUME_CONTEXT;
1639:
1640:
1641: CURSOR l_pbh_adj_exists_cur IS
1642: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N2) */ 'Y'
1643: FROM
1644: qp_npreq_lines_tmp line,
1645: oe_price_adjustments adj
1646: -- WHERE p_request_type_code = 'ONT'

Line 1645: oe_price_adjustments adj

1641: CURSOR l_pbh_adj_exists_cur IS
1642: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N2) */ 'Y'
1643: FROM
1644: qp_npreq_lines_tmp line,
1645: oe_price_adjustments adj
1646: -- WHERE p_request_type_code = 'ONT'
1647: --bug 3085453 handle pricing availability UI
1648: -- they pass reqtype ONT and insert adj into ldets
1649: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 1672: SELECT /+ index(adj OE_PRICE_ADJUSTMENTS_N1) / 'Y'

1668: or (nvl(QP_PREQ_PUB.Get_buy_line_price_flag(adj.list_line_id, line.line_index),line.price_flag) = QP_PREQ_PUB.G_PHASE
1669: and nvl(ph.user_freeze_override_flag,ph.freeze_override_flag) =
1670: QP_PREQ_PUB.G_YES))))
1671: UNION
1672: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N1) */ 'Y'
1673: FROM
1674: qp_npreq_lines_tmp line,
1675: oe_price_adjustments adj
1676: -- WHERE p_request_type_code = 'ONT'

Line 1675: oe_price_adjustments adj

1671: UNION
1672: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N1) */ 'Y'
1673: FROM
1674: qp_npreq_lines_tmp line,
1675: oe_price_adjustments adj
1676: -- WHERE p_request_type_code = 'ONT'
1677: --bug 3085453 handle pricing availability UI
1678: -- they pass reqtype ONT and insert adj into ldets
1679: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 2038: from qp_npreq_lines_tmp line, oe_price_adjustments adj,

2034: , line.line_quantity ordered_qty
2035: , NULL line_detail_type_code
2036: , line.line_category
2037: , line.price_flag
2038: from qp_npreq_lines_tmp line, oe_price_adjustments adj,
2039: qp_list_headers_b qplh
2040: -- where p_request_type_code = 'ONT'
2041: --bug 3085453 handle pricing availability UI
2042: -- they pass reqtype ONT and insert adj into ldets

Line 2093: from oe_price_adj_assocs a, oe_price_adjustments b

2089: and qplh.list_header_id = adj.list_header_id
2090: and qplh.list_type_code not in (QP_PREQ_PUB.G_PRICE_LIST_HEADER,
2091: QP_PREQ_PUB.G_AGR_LIST_HEADER)
2092: and not exists (select 'x'
2093: from oe_price_adj_assocs a, oe_price_adjustments b
2094: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2095: and b.price_adjustment_id = a.price_adjustment_id
2096: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2097: UNION

Line 2098: select /+ ORDERED USE_NL(adj line qplh) index(adj OE_PRICE_ADJUSTMENTS_N1) dynamic_sampling(1) / -- Bug No: 6753550

2094: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2095: and b.price_adjustment_id = a.price_adjustment_id
2096: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2097: UNION
2098: select /*+ ORDERED USE_NL(adj line qplh) index(adj OE_PRICE_ADJUSTMENTS_N1) dynamic_sampling(1) */ -- Bug No: 6753550
2099: adj.list_line_id created_from_list_line_id
2100: , line.line_index line_ind
2101: , line.line_index curr_line_index
2102: , line.line_id line_id

Line 2149: from qp_npreq_lines_tmp line1, oe_price_adjustments adj

2145: , line.line_quantity ordered_qty
2146: , NULL line_detail_type_code
2147: , line.line_category
2148: , line.price_flag
2149: from qp_npreq_lines_tmp line1, oe_price_adjustments adj
2150: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2151: -- where p_request_type_code = 'ONT'
2152: --bug 3085453 handle pricing availability UI
2153: -- they pass reqtype ONT and insert adj into ldets