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_LINES_TMP

Line 196: FROM qp_npreq_lines_tmp line

192: , ldet.order_qty_adj_amt ord_qty_adjamt
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

Line 298: FROM qp_npreq_lines_tmp line

294: , ldet.order_qty_adj_amt ord_qty_adjamt
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'

Line 382: FROM qp_npreq_lines_tmp line

378: , ldet.order_qty_adj_amt ord_qty_adjamt
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'

Line 1407: qp_npreq_lines_tmp line,

1403: UPDATE qp_npreq_line_attrs_tmp lattr
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

Line 1427: qp_npreq_lines_tmp line,

1423: and attr.pricing_attribute = lattr.attribute
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

Line 1541: FROM qp_npreq_lines_tmp line

1537: adj.applied_flag,
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

Line 1603: FROM qp_npreq_lines_tmp line

1599: adj.applied_flag,
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

Line 1644: qp_npreq_lines_tmp line,

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'
1647: --bug 3085453 handle pricing availability UI
1648: -- they pass reqtype ONT and insert adj into ldets

Line 1674: qp_npreq_lines_tmp line,

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'
1677: --bug 3085453 handle pricing availability UI
1678: -- they pass reqtype ONT and insert adj into ldets

Line 1703: qp_npreq_lines_tmp line,

1699: QP_PREQ_PUB.G_YES))))
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

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 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

Line 2150: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

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
2154: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

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 2348: , qp_npreq_lines_tmp line

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
2352: and line1.process_status in (QP_PREQ_PUB.G_STATUS_UPDATED,

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 2544: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

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
2548: where nvl(QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG,QP_PREQ_PUB.G_NO) <> QP_PREQ_PUB.G_YES