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 199: FROM qp_npreq_lines_tmp line

195: --, adj.adjusted_amount adj_ord_qty_adjamt --8593826
196: , NVL(adj.adjusted_amount,0) adj_ord_qty_adjamt
197: , ldet.order_qty_operand ord_qty_operand
198: , adj.operand adj_ord_qty_operand
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

Line 302: FROM qp_npreq_lines_tmp line

298: , ldet.order_qty_adj_amt ord_qty_adjamt
299: , adj.adjusted_amount adj_ord_qty_adjamt
300: , ldet.order_qty_operand ord_qty_operand
301: , adj.operand adj_ord_qty_operand
302: FROM qp_npreq_lines_tmp line
303: , oe_price_adjustments adj
304: ,qp_ldets_v ldet
305: , qp_list_lines ql
306: -- WHERE p_request_type_code = 'ONT'

Line 386: FROM qp_npreq_lines_tmp line

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

Line 1411: qp_npreq_lines_tmp line,

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

Line 1431: qp_npreq_lines_tmp line,

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

Line 1545: FROM qp_npreq_lines_tmp line

1541: adj.applied_flag,
1542: adj.updated_flag,
1543: attr.list_header_id,
1544: adj.list_line_no
1545: FROM qp_npreq_lines_tmp line
1546: ,oe_price_adjustments adj_pbh
1547: ,oe_price_adj_assocs ass
1548: ,oe_price_adjustments adj
1549: , qp_pricing_attributes attr

Line 1609: FROM qp_npreq_lines_tmp line

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

Line 1650: qp_npreq_lines_tmp line,

1646:
1647: CURSOR l_pbh_adj_exists_cur IS
1648: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N2) */ 'Y'
1649: FROM
1650: qp_npreq_lines_tmp line,
1651: oe_price_adjustments adj
1652: -- WHERE p_request_type_code = 'ONT'
1653: --bug 3085453 handle pricing availability UI
1654: -- they pass reqtype ONT and insert adj into ldets

Line 1680: qp_npreq_lines_tmp line,

1676: QP_PREQ_PUB.G_YES))))
1677: UNION
1678: SELECT /*+ index(adj OE_PRICE_ADJUSTMENTS_N1) */ 'Y'
1679: FROM
1680: qp_npreq_lines_tmp line,
1681: oe_price_adjustments adj
1682: -- WHERE p_request_type_code = 'ONT'
1683: --bug 3085453 handle pricing availability UI
1684: -- they pass reqtype ONT and insert adj into ldets

Line 1709: qp_npreq_lines_tmp line,

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

Line 2044: from qp_npreq_lines_tmp line, oe_price_adjustments adj,

2040: , line.line_quantity ordered_qty
2041: , NULL line_detail_type_code
2042: , line.line_category
2043: , line.price_flag
2044: from qp_npreq_lines_tmp line, oe_price_adjustments adj,
2045: qp_list_headers_b qplh
2046: -- where p_request_type_code = 'ONT'
2047: --bug 3085453 handle pricing availability UI
2048: -- they pass reqtype ONT and insert adj into ldets

Line 2155: from qp_npreq_lines_tmp line1, oe_price_adjustments adj

2151: , line.line_quantity ordered_qty
2152: , NULL line_detail_type_code
2153: , line.line_category
2154: , line.price_flag
2155: from qp_npreq_lines_tmp line1, oe_price_adjustments adj
2156: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2157: -- where p_request_type_code = 'ONT'
2158: --bug 3085453 handle pricing availability UI
2159: -- they pass reqtype ONT and insert adj into ldets

Line 2156: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh

2152: , NULL line_detail_type_code
2153: , line.line_category
2154: , line.price_flag
2155: from qp_npreq_lines_tmp line1, oe_price_adjustments adj
2156: ,qp_npreq_lines_tmp line, qp_list_headers_b qplh
2157: -- where p_request_type_code = 'ONT'
2158: --bug 3085453 handle pricing availability UI
2159: -- they pass reqtype ONT and insert adj into ldets
2160: where QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

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

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

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

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